jrobson@accessanalytic.com.au

/Jeff Robson

About Jeff Robson

This author has not yet filled in any details.
So far Jeff Robson has created 15 blog entries.

I Never Knew Excel Could do THAT!

"I Never Knew Excel Could do THAT!" Spreadsheets have come a long way since they were invented in 1979! They’re not the answer to everything … but they may well be the answer to more than you think because this is what we hear all the time: "I Never Knew Excel Could do [...]

CFOs|

Fix MYOB Account Numbers Exported to Excel

Fix MYOB Account Numbers Exported to Excel It used to be simple to export data from MYOB AccountRight to Excel.  With more recent versions, the export has changed which means all your formulas looking for particular account numbers won't find them.  Here's how you can fix MYOB account numbers. The Cause When MYOB [...]

Data Handling, Functions|

When one Excel session just isn’t enough!

By Wyn Hopkins This simple tip may save you a lot of time and effort, but it must be used carefully. With the arrival of Excel 2013 we were finally able to easily split Excel between two screens and happily copy and paste between the two with full paste capability and without the worry of worksheet [...]

The easiest ways to add a new data series to an existing Excel chart

There are lots of ways to add a new data series to an existing Excel chart.  Here are what we suggest are the two easiest ways: Method 1: Copy & Paste Great if your data series aren't in a table or aren't adjacent to each other. 1. Select your data (including the heading) and copy this [...]

Charts|

Infographic: How Digital Disruption is Changing the role of the CFO

Infographic: How Digital Disruption is Changing the role of the CFO Any CFO that still thinks their main role is to produce accounts and lodge tax returns will soon be out of a job. Digital disruption is changing the world’s economy, companies, and every job function they contain. We surveyed a number [...]

CFOs|

58 Crazy Excel Stories (that are probably happening in your company right now)!

58 Crazy Excel Stories (that are probably happening in your company right now)! Crazy things happen when you mix untrained users with Excel. It’s not really rocket science.  Crazy things would happen with any complex system if you don’t train people properly. But many companies simply assume that everyone knows Excel, so they [...]

What to do when they just fired your Excel Guru

"OMG! They Fired our Excel Guru!" Unfortunately, this is all too common these days. Companies, in their over-zealous quest to reduce costs, fire the one person who actually knew how to operate that really complicated Excel spreadsheet that's critical to the report you need to send out next week. What were they thinking!!! Now what? [...]

CFO Secrets of Analysing under Pressure

CFO Secrets of Analysing under Pressure The CFO and their Finance Department are under more pressure than ever before as a result of cost-cutting, staff cuts and an ever increasing demand for analysis to support business decisions like: What are the cost synergies if we acquire X? What if we cut projects A & B, but [...]

7 Forecasting Habits of Highly Successful Companies

Market volatility, depressed prices and slow growth are major factors affecting virtually all companies. For everyone, the focus on maintaining and improving their financial position is intense and this means planning, budgeting and forecasting has never been more critical to success. So here are the seven forecasting habits of highly successful companies: 1. Forecast in two directions Top [...]