This is the first of 2 videos looking at formatting. Effective formatting will add a professional look to your spreadsheets. In this video learn how to modify text and add colours to your spreadsheet.

Learn about Excel’s Lookup Functions. One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.

Absolute Cell References in Excel. One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.

The guide to Excel formatting continues with a look at changing text colour, border styles, print preview and an introduction to Conditional Formatting.

Drawing borders in Excel. One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.

How to format cells in MS Excel. One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.

Learn how to combine conditional formatting with Excel functions.

The first in a series of charting lessons for Microsoft Excel. One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.

Changing column widths in Microsoft Excel. One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.

This third VLOOKUP tutorial show you how to retrieve ‘close’ matches from your data table and also how to incorporate the IF and ISBLANK functions to make
your VLOOKUP results more user friendly. I hope you find this tutorial helpful.