Microsoft Excel – Mastering Formulas and Functions Course
Is this course right for me?
Our Excel – Mastering Formulas and Functions course shows you how to construct formulas and functions in Excel and get the most out of their functionality.
This course is aimed at existing Excel users who can create and amend spreadsheets but find formulas frustrating.
Training course objectives:
- Create different types of formula
- Use absolute references in formulas
- Use a range of Excel functions
- Use the auditing tools to see how formulas are constructed
Versions Available
2003, 2007, 2010
Related Training Courses in Our Range
Creating formulas
- Basic formulas
- Formula syntax
- Operators and brackets
- Ordering calculations
Using basic functions
- The function wizard
- Copying formulas
- Autocalculate
Using Maths functions
- SUM
- PRODUCT
Absolute vs relative references in formulas
- Editing formulas
- Using absolute references in formulas
- Using partial absolute referencing
Working with percentages
- Creating formulas with percentages
- Formatting as a percentage
Formula auditing
- Using the auditing facility
- Tracing how formulas are made up
- Evaluating formulas
Statistical functions
- MAX and MIN
- AVERAGE, MEDIAN and MODE
Range names
- Naming ranges
- Using range names in formulas
Using VLOOKUP
- Constructing a simple VLOOKUP function
Count functions
- COUNT
- COUNTA
- COUNTBLANK
Date and time functions
- Using date functions
- Using time functions
Text functions
- Using text functions
