Author Archives: Chris Mortimer

Cool Excel Formulae: MATCH

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

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

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

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

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

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

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

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