Microsoft Excel – Level 2

1 Day Course

Lesson 1: Using Formulas in Excel, Part 1

Understanding Relative and Absolute Cell References
Understanding Basic Mathematical Operators
Using Formulas with Multiple Cell References
Understanding the Formula Auditing Buttons

Lesson 2: Using Formulas in Excel, Part 2

Fixing Formula Errors
Modifying Error Checking Options
Displaying and Printing Formulas

Lesson 3: Logical Functions

Using the IF and IFS Functions
Working with Nested Functions
Breaking up Complex Formulas
AND, OR and NOT Functions

Lesson 4: Working with Names and Ranges

What are Range Names?
Defining and Using Range Names
Defined Names Commands
Selecting Nonadjacent Ranges

Lesson 5: Working with Summary Functions

Using the SUMIFS Function
Using the COUNTIFS Function
Using the AVERAGEIFS Function

Lesson 6: Working with Tables

What is a Table?
Creating Tables
Modifying Tables
Using the Table Tools
Adding a Total Row

Lesson 7: Validating your Data

Data Validation using Lists
Data Validation with Dates and Numbers

Lesson 8: Conditional Formatting

Data Bars
Color Scales
Icon Sets
Use a Formula to Format