We provide businesses in London and the South East with top class Excel training at the introductory, intermediate, advanced and macro levels via our 2-hour courses. The aim is simple: to help Excel users make more productive use of their time.The courses come with free helpdesk support so that those attending can apply their learning on a day-to-day basis. We also offer one-to-one coaching (via Teams or Zoom) for those who need extra help with Excel.




Microsoft Excel is one of the most widely used of all business tools. We create both simple and advanced Excel-based systems that are tailor-made to meet your specific needs.These help you cope more effectively and more productively with the vast amount of data that's available today and gain a competitive advantage. For some clients we combine Excel with Power BI to create dashboards (see sample above) to give you an immediate business overview.



Excel Tips and Tricks

Download our free file with 60 Excel tips, tricks and techniques you can start using right away. They're graded into beginner, intermediate and advanced categories - so whichever level you're at, we're sure you'll find something useful in there.

Just click on the link below....

We're happy to add extra tips if you'd like to suggest some. We'll decide whether to include them....and we'll give you a credit if we do.




Download our free Excel workbook containing 60 tips, tricks and techniques 

60 Excel tips, tricks and techniques
Excel 60 TTT.xlsx
Microsoft Excel sheet [265.1 KB]

Download this handy one-page guide to Excel's If function and related functions:

If Functions.pdf
Adobe Acrobat document [111.6 KB]

Download this guide to Excel's vlookup function:

Lookup Functions.pdf
Adobe Acrobat document [118.1 KB]

This guide covers the more basic functions: sum, average, max, min, upper, lower, proper, trim, concatenate, left, right and find:

Basic Functions.pdf
Adobe Acrobat document [111.5 KB]

Five of the most common spreadsheet mistakes:


1.  Omitting $ signs from formulas when they need to be included - or putting them in the wrong place. A $ in a formula fixes what comes immediately after it, either the row or the column or both, when the formula is copied.


2. Accidentally putting a space after text. Excel will treat a word followed by a space as different from the word on its own - even though they look the same to the user. Use the Trim function to remove unwanted spaces.


3. Getting a "division by zero" error. You can't divide a value by zero or a blank cell. Use the Iferror function to avoid this.


4. Having numbers stored as text. They might look like numbers but Excel won't treat them as such. For a single value you can click on the warning and choose "Convert to Number". For a range of values you can multiply them all by one (use Paste Special, Multiply).


5. Not putting quotation marks round text when used in formulas (but you don't do this when using range names).



Print | Sitemap
© Colin Macleod Associates