Excel Formulas and Functions Training

This class is designed for students who use Excel regularly and want to explore formulas and functions to make their spreadsheets even more powerful.

Training Class Goal

Students will come from this class with experience using a number of specific formulas and functions and confidence to explore the hundreds of functions possible with Microsoft Excel.

Prerequisites

Some experience using Microsoft Excel, basic Windows and computer skills.

Training Topics Covered

• Formula and Function Structures
• Formulas with Multiple Calculations
• 3-D Formulas
• Static Cell References
• Copying Formulas and Filling a series
• Number formatting
• Date & Time Functions
• Nesting IF statements
• Working with Time and IF Statements
• Ensuring dates don’t fall on weekends
• And & Blank functions
• Text Functions
• V & H Lookups
• Mathematical: Round up and Sum IF functions
• Statistical: Average & Mode functions
• Conditional Formatting formulas
• Other classes covering Formulas & Functions