Feb 6, 2014
Macros are used to save you time by automating tasks. Any task can be automated using a macro. For example, I have a friend who works for a small company. He often has to print Excel reports using different paper sizes – A4 and Letter. Although it’s easy...
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...
May 10, 2013
In this video, a 10 minute clip taken from a webinar that I delivered in 2012, I build a spreadsheet that can be used by anyone planning a wedding. The video covers absolute cell references, SUMIF, COUNTIF and conditional formatting. I used Excel 2011 for Mac but...
