Here are some tips and tricks that may make your life easier. If you have any questions, or maybe you have some tricks you would like to share with the world, please feel free to get in touch with us.
As a rule we believe that most problems can be solved WITHOUT making use of macros. So look here first before you are tempted to go the macro and VBA route.
Use the RATE function to calculate the CAGR
A shortcut which allows you to show either the results in all cells or the underlying formula in the cells.
Filling in the blank cells quickly and easily
There are occasions when you would like to fill in all blank cells with a formula. This is a quick and easy way to achieve this. Use is made of the GoTo Special command so it may be worthwhile learning about it.
Excel is often used as a means of cleaning up data and produces reports. Often the most time consuming aspect is the data cleanup. Using the Data AutoFilter it is possible to achieve more in less time.
In Excel it is possible to change a number of worksheets at the same time. Extremely useful but don’t forget to switch it off once you are done!
Rank a list of numbers and then automatically (without macros) have the numbers sort themselves into your preferred order (and pull other information with it if necessary). Can be used to generate sport league tables e.g. English Premiership log or the World Cup Soccer logs.
You need to know the workings of the VLOOKUP and RANK functions.
Sheet Navigation in Excel 2013 Sheet navigation in Excel 2013 is slightly changed and on initial viewing you may wonder where some of the buttons have gone. In particular, you might want to know how you get to the very … Continue reading
Comparison Chart using radar charts One of the most common Excel chart requests is how to compare items against each other to assess where the problems are. A comparison chart that may work is the radar chart. So for example … Continue reading
Just a quick note to say your blog is brilliant. Full of useful bits of info. After your courses, I am by far the best modeller in our office, and we regularly get comments from our business partners on the quality of our models. Thanks for all the help,– Mike