Do you use Excel to prepare financial projections? Ever wish your forecasts had greater impact on business decisions in your organisation? You can take charge of these spreadsheets and offer your clients and colleagues a clearer, more accurate and insightful business tool. (more…)
When you take over and start using a financial model that someone else has built, not only are you inheriting the original modellers’ inputs, assumptions and calculations, but you may also be inheriting their mistakes! Using someone else’s model involves taking responsibility for their work and you want to be confident it’s working correctly. Hear from financial modelling specialist, Danielle Stein Fairhurst during the Financial Modelling Summit as she draws from the second edition of her book, Financial Modelling in Excel for Dummies, to learn some simple ways to check, audit, validate and, if necessary, correct legacy models so that you can be confident of the model’s results. (more…)
Ever been guilty of using Excel as a fancy calculator? If so, you’d just be using a formula in Excel. If you entered a calculation such as =A1+A2 or =452*12, then that’s just a formula. If a formula is all you need, then that’s fine. But Excel can do so much more!
You may hear the two words function and formula used interchangeably, but they’re not technically the same. So, what’s the difference? A formula is an expression that uses cell references or hard-coded numbers to calculate the value of a cell. Sometimes a simple formula is all you need to get the right answer, but you can do so much more using functions.
I’ve been consulting, writing, training and speaking about the use of Excel for analysis, building financial models, budgets and dashboards for many years now and I’ve lost count of the times I’ve been contacted by software providers who’d like “my opinion” on their new software or add-in to Excel which is so much better than plain or, as I like to call it, “vanilla” Excel. Seriously, I get messages about this All. The. Time. So I thought I’d sit down and explain my views on why I stick to Excel.
Having written several books on the subject and hence committed a large part of my career to the use of Excel, I’ve had to seriously consider that perhaps I’m too stuck in my ways to consider any of these new tools. The title of my first Wiley Finance book which has been revised and published three times and sold thousands of copies was “Using Excel for Business Analysis,” so I guess you could say I’m pretty invested in the success of the software.(more…)
The Financial Modeling World Cup is a brand new competition where modellers from all over the world and different backgrounds come together to learn, train and compete. To celebrate the launch of this new initiative, we’ve hosted an Exhibition Round where two expert modellers Dmitrijs Lukaševičs and Dan Mayoh pit their skills against each other and you’ve got front row seats! (more…)
Who doesn’t love a shortcut? With all the hours we Excel users spend on the computer, a huge amount of time can be saved every day by learning the keyboard shortcut commands. Did you know that for every mouse click on your computer, it takes several times longer than the equivalent keyboard shortcut? (If you don’t believe me, try creating a new document with the mouse versus the shortcut Control-N!)
It’s hard to pick formula favourites but we’re going to give it a go. Excel trainer Alan Murray streaming live from London explains what he loves about the SUMPRODUCT, SUMIFS and INDEX functions (and maybe a few more!)
Alan is an Excel trainer, YouTuber and freelance writer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. (more…)
As 2020 is a leap year, this month we have an extra day in the calendar. Those who are on a fixed monthly salary are complaining that they are not getting paid for working the extra day, but I do hope you are enjoying your day anyway, as this is something that only happens once every four years!
If you work in financial modelling or analysis you’ll know that the uneven number of days in each month causes quite a headache for financial calculations and reporting, especially with calculating interest payments, salaries or anything time-based. Excel does handle date-based calculations very well with handy functions such as =TODAY() or =NOW() which will always give you the current date, or date and time.