Overflow error in Excel PowerQuery Sep 16, 2019
An annoying error when using Get & Transform (PowerQuery) in Excel is the overflow error as it is not always clear what it may be. The error says '[Expression.Error] An error occurred ...
Home // Blog & Excel Tips
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Request info on training dates, prices and venue
Copying links to other excel workbooks always looks at same cell Sep 9, 2019
Linking cells between WORKBOOKS and why links to other excel workbooks always looks at the same cell whereas links to sheets correctly moves.
Developing a financial modelling strategy that supports business goals Sep 4, 2019
Developing a financial modelling strategy that supports business goals- transcript from the live presentation by Adrian Miric
MS Excel is the solution Jun 18, 2019
The answer to the question "what software package must I make sure that my kids learn"
See, and play with the Excel data when PowerQuery editor is open Jun 18, 2019
A method to see, and play with the Excel data when PowerQuery editor is open or open 2 PowerQuery windows at the same time.
The European Spreadsheet Risk Interest Group Conference (EuSpRIG 2019) Jun 17, 2019
The European Spreadsheet Risk Interest Group Conference (EuSpRIG 2019) will be held on 11-12 July 2019 in London. Real life case studies of EUC control and deep dive into data analysis,
Temporarily disable print areas in Excel Jun 1, 2019
Occasionally you may want to print everything again but you don't want to clear the print areas and then reset them once you have a full print.
Reverse Homework MS Excel Training May 21, 2019
The Reverse Homework MS Excel Training is a way to get the best out of combining online and classroom training. It is ideal for MS Excel.
Consulting
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
Live Training
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."
Free Excel Tips & Tricks delivered straight to your mailbox. Sign up today.