Excel 2013: How To Use Conditional Formatting

Conditional Formatting enables you to apply formatting to a cell (for example, background colour, font, text colour, bold, etc) if a condition or set of conditions are true. For example, “apply a red background to A1 if it contains the word COMPLETE and a green...

Convert a PDF to Excel

All recent versions of Excel have the ability to create a PDF of your spreadsheet without requiring 3rd Party tools. In this short video tutorial, in addition to demonstrating how to do this, I also show how to convert a PDF into an editable Excel file using a free...

Customising The Ribbon in Excel (Windows)

The Ribbon is the strip of buttons and icons that appears at the top of the screen in Excel 2007 and above. It replaces the toolbars and menus found in earlier versions. In Excel 2010 and above you can edit The Ribbon – adding your own buttons, removing ones...

Customising The Ribbon in Excel (Mac)

The Ribbon is the strip of buttons and icons that appears at the top of the screen in Excel 2011 and 2016 for the Mac. You can edit The Ribbon – adding your own buttons, removing ones that you personally don’t find useful and rearranging the layout to make...

Excel 2010 Overview

In March 2010 I delivered a webinar to the North West Institute of IT Trainers. The webinar was called “Microsoft Office 2010 Revealed” and took a look at the new features of Microsoft Office 2010. Below is a 10-minute segment of the webinar that covers...