08 6210 8500
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 [...]
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 [...]
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 [...]
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 don’t need much (if any) [...]
Power Query Trap: Formula Autofill If you output the results of Power Query to a table in Excel then it’s often really useful to be able to add an extra calculated column or two onto the end of this output table. I used to do this all the time when using Microsoft Query. However, now [...]
"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 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 [...]
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 [...]
What do you do when costs go bad? CFOs in the mining, resources & engineering sectors are facing cost pressures and pricing volatilities that are squeezing profits. Key risks on the radars of many CFOs include: Declining commodity prices How to reduce wage, salary and contracting costs (that are often combined with diminishing productivity). Increasing taxes [...]
Accuracy of Budgets and Forecasts In times of increasing volatility, decision-makers have an even greater need for meaningful, accurate, up-to-date financial projections so they can respond to changes in economic conditions rapidly. In a recent survey of global corporations, research firm Aberdeen Group found that market volatility is the major challenge for effective financial [...]
In the current environment, reducing costs and increasing productivity are the keys to success. This was emphasised strongly by a recent PriceWaterhouseCoopers (PwC) report which found that profits at the world's top 40 mining companies, including BHP Billiton and Rio Tinto, slumped by half as the mining boom came off its highs, then reduced by [...]
Pay my invoice
