Blog & Excel Tips

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)

You build a VLOOKUP and it gives an #N/A (can't find it) but you then use the FIND tool and you find what you were looking for! A common problem in Excel. So why is Vlookup not finding a value that is there.

If you work with lots of data you will come across cases where you need something to happen if a cell is blank, or the opposite i.e. if not blank then calculate in Excel. Perhaps if the Excel cell is blank the formula must result in a zero, or only cells that are not blank should be calculated.

Due to the existence of various software systems, you often need to get numbers to match each others signs. You will therefore need to know the Excel formula to change negative to positive (and vica versa) in spreadsheets.