If you use PowerQuery you may notice that in the filter, some of the options you want to use seem to be missing. So why is ' Begins with, Ends With, Contains missing ' missing from some PowerQuery filters?
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.
You've built your Pivot Table in MS Excel, but the column and row labels are not showing the name of the relevant field. How can you fill the empty labels with the headings in a Pivot Table?
How to remove conditional formatting in MS Excel Jun 12, 2018
Conditional formatting is a useful feature but there are times that you need to remove either all the conditional formatting or else the conditional formatting on specific cells. Two ways of how to remove conditional formatting in MS Excel.
...Problem is that if ALL the workbooks aren't open, instead of seeing the numbers you see #Value! errors. Can you address the situation where SUMIFS returns value when linked workbooks are closed?
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.
Pause/ Switch off conditional formatting in MS Excel May 21, 2018
As useful as Conditional formatting is, it is sometimes nice to be able to pause/ switch off conditional formatting in MS Excel. So ideally you want a switch that says something like Switch On/ Off Conditional formatting. When the switch is set as 'Off', the conditional formatting is made inactive.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."