Intermediate Module 01
Powerful Excel Functions You Can Use Every Day

Formulas and functions sit at the heart of any spreadsheet. It's the engine. Excel provides over 450 functions and the more you know, the more you'll be able to achieve with Excel. Let's get to it.

Download the training notes (PDF)

1.1    Training notes

1.2   A refresher of Excel's 5 basic formula functions

1.3   Refesher exercise - solutions

1.4   COUNT functions (COUNT, COUNTA, COUNTBLANK)

1,5   COUNT functions exercise - solutions

1.6   The PI function

1.7   LOGIC functions (AND and OR) and lots of clever tricks you never knew existed

1.8   Logic functions exercise - solutions

1.9   The IF function

1.10   IF function exercise - solutions

1.11   DATE & TIME functions

1.12   DATE & TIME functions exercise - solutions

1.13   ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, TRUNC functions

1.14   NUMBER functions exercise - solutions

1.15   COMBO functions (COUNTIF, SUMIF, SUMIFS)

1.16   COMBO functions exercise - solutions


Privacy Terms Contact
Copyright © Two Rivers Software Training. All Rights Reserved