Correcting numbers in Excel with incorrect commas, points or spaces Oct 3, 2019
Correcting numbers in Excel with incorrect commas, points or spaces where the VALUE function does not work, using a new function in MS Excel.
Home // Blog & Excel Tips // 2
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
For spreadsheet nerds- inventions that changed the world Oct 1, 2019
Podcast- 50 Things That Made the Modern Economy- How a grid on a computer screen gives us a glimpse of the future of automated work
Convert the month number into the months name Sep 30, 2019
2 ways to convert the month number into the months name either just visually (format) or so that the cell contains the word instead of the number.
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 ...
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.
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.