jrobson@accessanalytic.com.au

Home/Jeff Robson

About Jeff Robson

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

Power BI Data Sources for Estimating Market Share

Power BI data sources can be almost any file, database or web service. Here's an innovative way to use this amazing connectivity to estimate your market share using free information sources from the web. Facebook tells me my Market Size If you've ever placed an ad on Facebook, you'll know the incredible range of characteristics [...]

2017-10-29T11:01:32+00:00 Data Handling, Power BI|

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 [...]

2017-03-13T14:49:44+00:00 Data Handling, Functions|

7 Mischievous Adventures in Excel

This eBook has some great ideas on how to have more fun in Excel than you can poke a kitten at (usually at your colleague’s expense!) *evil laugh* If you’d like some ideas for some mischievous adventures that will mess with your friend’s head (and their models), download this now! You'll learn things [...]

2017-03-08T03:53:54+00:00 Keyboard, Productivity|

Excel Shortcuts: 22 of the very best and most handy!

A collection of our favourite keyboard shortcuts in Excel. Pin it up on your wall & share it with your friends. Shortcuts to save time and maximise productivity including: Creating charts faster Faster formatting Navigating a large spreadsheet and 19 more!          

2017-03-08T03:53:54+00:00 Keyboard, Productivity|

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 [...]

2017-03-08T03:53:54+00:00 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 [...]

2017-03-08T03:53:54+00:00 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 [...]