Working in Excel is great because by default it assumes you are working with numbers and as such does its best to display numbers correctly (neatly aligned). However, mostly when moving numbers out of Excel, you may experience that strange occurance of trying to align numbers. You spend hours adding and deleting spaces and yet the numbers never seem to align properly.
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Hyperlink Code to create navigation list April 17, 2017
We are big fans of using Hyperlinks when navigating through large spreadsheets. One of the big problems is creating the hyperlinks. It is easy enough to create but very manual. As a result we recommend you look at this link to see some code that creates a reusable macro that you can run on a workbook.
REMOVE current selection from data filter April 13, 2017
When using the Data Filter in the newer versions of Excel, you have the ability to search for items that contain some characters. You can then, in one step choose to add the items to the existing filter using the 'Add Current Selection to filter' tick box. However it is not as obvious how to 'REMOVE current selection from data filter'.
Alternative to multiple if statements April 4, 2017
Once you learn how to build an IF statement you may think that this is the best way to build complex formula. However, there are often better ways. One example is how to avoid multiple IF statements. Commonly these are referred to as nested IF's and are a source of confusion (in building and reviewing) and errors. So is there an alternative to multiple IF statements.
Date Axis in Excel Chart is wrong April 3, 2017
You've built your chart, it all makes sense and suddenly you look at your horizontal axis, and the date axis is wrong. This happens a lot. You expect to see the dates you have in the data but different dates are showing, normally the beginning of month date instead of the end of month date.
Make Excel charts primary and secondary axis the same scale March 21, 2017
Once you have mastered some of the tools in charts (secondary axis, change series chart type etc), you may encounter some problems that need to be addressed. One of the more common issues is how to make Excel charts primary and secondary axis the same scale.
Pin your regularly used excel files March 20, 2017
If there are Excel files that you regularly use, it can be useful to always have them visible in the recently used list. Unfortunately, if you haven’t recently used them, they won’t be there and you will need to search for them again. From Excel 2007 upwards you can now ‘pin’ these commonly used files in your recent list.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."