Author Archives: Chris Mortimer

Cool Excel Formulae: MATCH

By Chris Mortimer | Published: December 4, 2012

Learn to save time, stress and impress your colleagues / classmates with the MATCH formula. Practise! Download the file used in the video here.

Posted in Excel Guidance Videos, Excel Guidance Videos & Articles, Intermediate Videos | Comments closed

Cool Excel Formulae: OFFSET

By Chris Mortimer | Published: December 4, 2012

Learn to save time, stress and impress your colleagues / classmates with the OFFSET formula. Practise! Download the file used in the video here.

Posted in Excel Guidance Videos, Excel Guidance Videos & Articles, Intermediate Videos | Comments closed

Cool Excel Formulae: COUNTA

By Chris Mortimer | Published: December 4, 2012

Learn how to save time and impress your colleagues or classmates using the COUNTA formula. Practise! Download the file used in the video here.

Posted in Excel Guidance Videos, Excel Guidance Videos & Articles, Intermediate Videos | Comments closed

Cool Excel Formulae: COUNTIF

By Chris Mortimer | Published: December 4, 2012

Learn how to save time and impress your colleagues or classmates using the COUNTIF formula. Practise! Download the file used in the video here.

Posted in Excel Guidance Videos, Excel Guidance Videos & Articles, Intermediate Videos | Comments closed

Cool Excel Formulae: IFERROR

By Chris Mortimer | Published: December 4, 2012

Learn how to handle errors and make your spreadsheet more robust using IFERROR. Practise! Download the file used in the video here.

Posted in Excel Guidance Videos, Excel Guidance Videos & Articles, Intermediate Videos | Comments closed

Cool Excel Formatting: Dynamic Headers

By Chris Mortimer | Published: December 4, 2012

Make your spreadsheet look interesting and make important information stand out using cool dynamic table headers. Practise! Download the file used in the video here.

Posted in Excel Guidance Videos, Excel Guidance Videos & Articles, Intermediate Videos | Comments closed

Cool Excel Formulae: IF

By Chris Mortimer | Published: December 4, 2012

Learn how to save time and impress your colleagues and classmates with the IF formula. Practise! Download the file used in the video here.

Posted in Excel Guidance Videos, Excel Guidance Videos & Articles, Intermediate Videos | Comments closed

Cool Excel Formatting: Cell Borders

By Chris Mortimer | Published: December 4, 2012

Learn about how to make your spreadsheets look cool, and how to make important information stand out using cell borders. Practise! Download the file used in the video here.

Posted in Beginner Videos, Excel Guidance Videos, Excel Guidance Videos & Articles | Comments closed