Jan 28, 2014
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...
Jan 26, 2014
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...
Jan 20, 2014
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...
Jan 20, 2014
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...
Mar 1, 2012
In March 2010 I delivered a live 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...
