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...
Jul 8, 2013
The screenshot below is from a spreadsheet that is used to calculate the square footage (area) and perimeter of a rectangular or square shape, such as a garden or a room. The purpose of this (example) spreadsheet is to answer questions such as How much turf do we need...
