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...
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 23, 2014
A question that is often asked is “when I add up times and the total comes to more than 24 hours, why does it not show correctly?”. To answer this, I’m using a timesheet as an example: **Download the spreadsheet here** My working day is split into 2...
Jan 20, 2014
Yesterday I was creating a piece of elearning using Adobe Captivate. I had a file that consisted of 33 slides along with a 6 minute MP3 of my narrative. When viewed by end users, the eLearning had to move from one slide to the next with no intervention from the...
Apr 6, 2013
Microsoft recently released Excel 2013 for Windows. The application contains a whole slew of new features. I’ve produced 4 free short video tutorials that cover the key features: Flash Fill – this is awesome! Timeline Slicers Quick Analysis Pivot...
