Blog & Excel Tips

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?

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.

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. 

One of the most common queries we get is more information about our MS Excel VBA training course. Although we offer a VBA course and are happy to provide it, we strongly believe in teaching the correct tools to the correct people. We don't want you to waste money on a course when there are easier, more understandable ways to achieve the same thing.

Microsoft Excel course dates guaranteed! We are pleased to announce that we have run 100 consecutive public Excel courses (since July 2009), with NO CANCELLATIONS! See some of the recent courses on the facebook page.

The 2018 Russia World Cup sweepstakes spreadsheet is now ready. Run your office pool with minimal effort. Includes an automatic update of the match scores.

A common question is why is Excel always 1 day short when subtracting dates? As a result you always need to add 1 day if you want the answer that a human expects.

Excel formulas need a semicolon instead of a comma! How to change back so that you can enter Excel formulas with a comma separating the parts of the formula e.g. =LEFT(A1,2) rather than =LEFT(A1;2)