Blog entries covering the latest Excel tricks and tips based on queries from clients and new learning from our excel consultants.
As financial models become more sophisticated users are starting to look at discounting the cash flows with multiple discount rates. However, we have noticed during our financial modelling training courses that this is often done incorrectly.
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 first sheet or the very last sheet.
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.
Great article on why spreadsheets are great and why they will never be completely replaced. There are risks in using spreadsheets but they are no worse than using people in a business.
The traditional way to turn a formula into a value is to use the Paste Special option. If you are not aware how to do it, you can copy a cell, click on Paste Special (under the Home tab, on the left with the Paste button) or on the relevant icon. Another way to do this is to use the 'F' keys.
Advanced Excel Course - June 2013 in South Africa. Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 days or break it down into a 3 day Advanced Excel and 2 day Financial Modelling course
Explaining why in some cases Excel sorts numbers as if they are words e.g. 1, 10, 11, 2 etc
How to apply the group and ungroup for pivot tables with a focus on grouping text, dates and numbers
How to create a waterfall chart in excel by using the stock charts which already allow for changes in colour depending on whether the movement is up or down.
Discounting cash flows with multiple discount rates As financial models become more sophisticated users are starting to look at discounting the cash flows with multiple discount rates. However, we have noticed during our financial modelling training courses that this is … Continue reading
Advanced Excel and Financial Modeling Training in July and August 2013 Over the next 2 months we will be running a number of Excel related courses. In particular we will be covering Advanced Excel and Financial Modeling training. The dates … Continue reading
It was most interesting and filled with very useful and relevant tricks and tools that one can start to use immediately. The course was well constructed with a logical flow to be able to reference information easily in the take home materials, with exercises covering many different scenarios.– Hyatt Hotels