Blog & Excel Tips

Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.

Forecasting tool in Excel July 16, 2018

From Excel 2016, there is a convenient Forecasting tool in Excel which allows you to show Excel some historical data (say 24 months worth of sales) and Excel will, taking growth and seasonality into account, forecast for up to 50 months into the future.

GETPIVOTDATA Data Field a cell reference June 29, 2018

GETPIVOTDATA is a brilliant formula that allows you to effectively run a VLOOKUP within a Pivot Table. It is possible to make the GETPIVOTDATA use dynamic references but the one that doesn't work so well is the Data Field.

Turn TRUE FALSE into numbers in Excel May 25, 2018

When using Microsoft Excel you often end up with a logical answer i.e. a TRUE or a FALSE. In Excel TRUE and FALSE are actually seen as the numbers 1 (True) and 0 (False). So how can you turn TRUE FALSE into numbers in Excel?

MS Excel PowerQuery Training Course in Johannesburg May 22, 2018

In several of our recent public courses we have mentioned and shown a bit of what MS Excel's PowerQuery can do. Due to the amount of people that are interested we are going to run a 1 day PowerQuery in MS Excel course on the 14th June 2018 in Johannesburg. To get more information email mashooda@AuditExcel.co.za.

Consulting

We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.

Find Out More

Live Training

"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."

Find Out More