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

Financial Modelling Articles

13 April, 2015

Quick Dashboards in Excel - Video Tutorial

Using Sparklines, Slicers, Conditional formatting & coffee

Dashboards are in-vogue now. Chances are your boss is asking for one right now. Traditionally dashboards are associated with a six week development lead time or big budgets, which means critical business decisions that should be taken yesterday are now delayed by two months. But we can create quick, powerful and awesome dashboards using Microsoft Excel in less than two hours (ok, maybe three).

Download the workbook

Read more Comments (0)

30 March, 2015

Last few spots for Chandoo Masterclass - Sydney, Melbourne & Brisbane

A word from Chandoo.....

Oh, we must talk about cricket first.

What a week it has been for Australian Cricket. First a very comprehensive win against India in semi-finals and then a clinical display of bowling & fielding that led to winning your fifth cricket world cup. Congratulations.

Don't worry, I am still going to talk about Excel. I just can't help but admire Australian team's success.

Read more Comments (0)

05 March, 2015

Using Excel for Business Analysis, Revised Edition

Using Excel for Business Analysis provides practical guidance for anyone looking to build financial models. Whether for business proposals, opportunity evaluation, financial reports, or any other business finance application, this book shows you how to design, create, and test your model, then present your results effectively using Excel 2013. The book opens with a general guide to financial modelling, with each subsequent chapter building skill upon skill until you have a real, working model of your own.

Read more Comments (0)

27 January, 2015

Performing Break-Even Analysis in Excel

In this informative webinar, financial modelling expert, Danielle Stein Fairhurst recording in Dubai for Informa, discusses and demonstrates the various ways of calculating the break-even point using Excel.

The webinar covers determining the break-even point as part of the financial modelling process which can be a critical decision-making tool in determining the profitability and pricing potential for a new or existing business.

Read more Comments (1)

27 January, 2015

Financial Modelling & Excel Resource Links - Updated

I wrote a blog article a while ago with links to some good Excel and Financial Modelling online resources.  Due to its popularity at the time, and the fast moving pace of the online world, I thought it was time to update it!  www.plumsolutions.com.au/free-stuff is a good place to start, but there are a lot of other online resources available as well.

Read more Comments (10)

12 January, 2015

Job Opportunity - Brisbane Based Analyst

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.

Read more Comments (0)

09 December, 2014

Creating a Splash with Simple Waterfall Charts

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.

Read more Comments (0)

04 September, 2014

Podcast - Excel Tips for Best Practice Modelling

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

Read more Comments (0)

02 September, 2014

Tips for Preparing an Oral Presentation for Model Results

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.

Read more Comments (1)

18 August, 2014

Tool Selection: Why do we Use Excel?

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.

Read more Comments (1)

01 July, 2014

Deficit Levy Tax Calculator

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!

Read more Comments (0)

26 June, 2014

Improving Excel Memory and File Performance

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.

Read more Comments (11)

24 June, 2014

32-bit vs 64-bit Excel

 

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?

Read more Comments (13)

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.

Read more Comments (0)

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! 

Read more Comments (0)

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.

Read more Comments (1)

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

Read more Comments (0)

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!

Read more Comments (0)

24 June, 2013

Which Office 2013 for PowerPivot?

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

Read more Comments (1)

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?

Read more Comments (0)

Subscribe to our Newsletter

Enter your details below to keep up to date with the latest Financial Modelling Articles

* indicates required