SPECIALISTS IN FINANCIAL MODELLING
0 item(s) \$0.00 AUD + GST

# Financial Modelling Articles

23 February, 2014

## Using Excel in the Age of Big Data

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.

12 February, 2014

## Is a Power Pivot Training Course Right for Me?

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!

19 December, 2013

## New Female Financial Modelling World Champion

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.

02 September, 2013

## Learn to Love your Excel Errors

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

04 August, 2013

## Get to Know your Excel Error Values

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!

24 June, 2013

## Which Office 2013 for PowerPivot?

by Liam Bastick, FCA, FCMA, CGMA, Excel MVP and Director of SumProduct

11 June, 2013

## Have you Considered PowerPivot?

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?

04 June, 2013

## Are Volatile Functions Slowing you down?

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.

03 April, 2013

## The Power of PowerPivot

### PowerPivot: The Next Big thing in Business Intelligence?

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.

06 March, 2013

## What’s New in Excel 2013

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.

07 February, 2013

## Everybody Loves a Shortcut

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!)

15 November, 2012

## What’s so great about a Census?

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.

03 October, 2012

## Using Excel on a Mac for Financial Modelling & Analysis

The usage of Excel on a Mac is increasing and according to an online poll we ran last month on Linked In, more people are using Excel on a Mac than are still using the old Excel 2003, a gap which is likely to widen. Windows Excel 2013 is being released soon and is already available for preview, although this is unlikely to have much effect on the Windows vs.

21 September, 2012

## Modeloff - The 2012 Financial Modeling World Championships

So you think you can model, hey?  Challenge your friends and colleagues to the very first Financial Modeling World Championships.  Plum Solutions is very proud to support this inauguaral event.

Register here

11 September, 2012

## Which Version of Excel are you Using? Poll Results 2012

Now that Excel 2013 preview is available, I thought it was time to do another poll to see what version of Excel business users are on now.  It's been around 18 months since the last poll on Excel Version Usage, and I was interested to see if there had been more of a shift towards the new versions of Excel.

28 August, 2012

## Using Excel for Business Analysis Book Launch

Using Excel for Business Analysis, the new book by Danielle Stein Fairhurst and part of the Wiley Finance Series was officially launched last week at the book launch party, hosted by Plum Solutions.  The launch took place in a room upstairs at the Exchange Hotel, a quaintly decorated old pub in Balmain.

07 August, 2012

## Sydney Book Launch

We're having a launch party in Sydney to celebrate the release of Using Excel for Business Analysis. and we need your help to celebrate this achievement!  OK, Amazon have not released it yet but it's here in Australia and being used on our worksho

25 July, 2012

If you've been following me on Twitter, or on Facebook you'll have heard about my recent escapades in Singapore and Hong Kong.  You'll also have heard that my new book Using Excel for Business Analysis; a Guide to Financial Modelling Fundamentals has now finally been published!  Although I was delayed 12 hours in Singapore, I finally staggered through customs prou

04 June, 2012

## 2012/13 Excel Income Tax Calculator

If you're interested in how to calculate tax tiers in Excel, how to model the impact of changes in tax rates and brackets - or heck, if you just want to know how the tax tier changes affect your pay packet - take a look at the latest Excel Income Tax Calculator from Plum Solutions.

26 April, 2012

## Invitation - Drinks with Chandoo

2015 UPDATE: For the latest schedule of Chandoo's Australian classes, please see www.plumsolutions.com.au/chandoo

-------------------------------------------------------

Chandoo's Excel Dashboard course in Sydney, Melbourne and Brisbane have been immensely popular.  If you have not been able to make his workshop or have missed out on a place, never mind you still have a chance to meet the man himself!  He has arranged to meet up for casual drinks at the following venues: