Can you fill this chair in the sunshine? A large North Brisbane-based enterprise is seeking a Business Improvement Analyst who can utilise Excel 2013 in an advanced capacity underpinned with cost accounting knowledge to be able to extract source table data from Ellipse and create operational reports and dashboards. They also need to be able to read an existing model and be able to maintain and build upon it.
Waterfall charts, also called bridge or stepped charts, have become popular in recent years, particularly when displaying the output of a financial model. A waterfall chart displays very effectively the incremental impact of each period of time, or unit. It is a type of bar chart where the value of the second bar generally begins where the first one finished.
Some of you will know that ever since Indian Excel guru and blogging sensation Chandoo visited Australia in 2012 to run his extremely popular Advanced Excel and Dashboard courses, I've been trying to convince him to come back Down Under and run another series. We are hoping that he'll find time to make another visit in 2015 and we'll certainly keep you posted and hope to announce it soon. He hasn't agreed to come just yet, but as we were chatting last week, he did talk me to into joining
Extracted from Using Excel for Business Analysis, Chapter 12
Many analysts and modellers would agree that public speaking is not their favourite part of the job and whilst it might be fun to imagine your senior management in their underwear, it's probably more helpful to be prepared by following these basic tips.
We often hear it said that Excel is the “second-best solution” to a problem. There is usually a better, more efficient piece of software that will also provide a solution but we usually default to the “Swiss army knife” of software, Excel, to get the job done.
If you're interested in how the new deficit levy will impact your tax in the new financial year, then take a look at our latest Excel Income Deficit Levy Tax Calculator. Our tax calculators have always been our most downloaded posts on the site and I'm not sure if it's because you're all so interested in financial modelling tax tier calculations, or you just want to know how much of your salary goes in tax!
If you have sluggish Excel models, it might not just be the file size that is slowing things down. Often it’s the memory being used and when things get really bad, you might even get a “Not enough Memory” or “Not enough system resources to display completely” error message. When you get this frustrating message, the only solution is to close Excel and restart it, so let’s look at some ways to improve the performance of your Excel models.
Since the introduction of Excel 2010 two versions ago, Excel is now available in 64-bit and this has become a topic of discussion and interest for many Excel users. With all the buzz around 64-bit version, many of us are wondering – is 64-bit Excel better than 32-bit Excel? Should I make the switch? Is 64-bit MS Excel the solution to slow Excel performance?
What does 32-bit and 64-bit really mean?
We are constantly being told that we are living in the Information Age. The Industrial Revolution marked the beginning of the Industrial Age and similarly, the Digital Revolution started the Information Age.
Have you even been on a training course and found you were completely out of your depth? Or have you been on a "advanced" course and discovered that half the participants haven't a clue and the instructor spends most of the day on the basics? We want to make sure that this doesn't happen to you!
Yes, you heard correctly - there is indeed a Financial Modelling World Championships! The finals of Modeloff 2013 were held last weekend, and we now have a new world champion, Hilary Smart, who was the only female to make it to through to the final round.
As I was scrolling through the index for my book recently, I noticed the #REF error jump out at me. Why is it that the #REF strikes such fear into a modeller’s heart? Probably because out of all common Excel errors, it is the one which is the most difficult to fix. It means that your formula is referring to a cell that doesn’t exist anymore! If someone has saved a model with
Error values such as #REF!, #NA! or #VALUE! are Excel’s irritating but necessary way of telling us that something’s not quite right with your formula or function. Although they can be frustrating and time-consuming to rectify, dealing with them is an obligatory part of modelling. Instead of being ignored, supressed or yelled at, Excel errors should be heeded, taken care of and according to a recent article, perhaps even celebrated!
by Liam Bastick, FCA, FCMA, CGMA, Excel MVP and Director of SumProduct
Imagine analysing your monthly results in real time without an army of management accountants / consultants spending valuable time and money constructing delayed, unfathomable reports. Did we say “imagine”? You might be doing this already. How useful would it be for you and your colleagues to produce key analysis in seconds from automated reports talking to your existing management information systems?
A common problem modellers have is that of file size and calculation speed. In fact, it is one of the most commonly posted topics in our popular Financial Modelling in Excel LinkedIn forum. Since writing the article Excel Model File Size Getting out of Hand a few years ago, I have since come to appreciate the role that volatile functions can also play in slowing down the performance of models.
What's all the fuss about PowerPivot? Well, I could go on and on about the wonders of Excel – it’s really the tool of choice for business users who need to very quickly analyse data, create reports and share them with other users. Wonderful as it is, however, Excel stops being quite so wonderful when your data is more than 1,048,576 records long, or if the data needs to be consolidated from multiple sources.
Why do they keep changing my Excel? As we all rely on Excel every day for our financial modeling and analysis work, it’s only natural that any new release will generate a lot of excitement as well as anxiety amongst users.
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!)
If you have attended one of our Plum Solutions Intermediate Financial Modelling in Excel courses, either online or as a workshop you might remember that we used population projection data to index our customer forecast for our new product business case.