Microsoft Excel Intermediate 2016

Module 1  - Working with Functions and
                  Formulas

Lesson 1.1 - Using Formulas in Excel

·         Understanding Relative and Absolute Cell References

·         Understanding Basic Mathematical Operators

Lesson 1.2 - Exploring Excel Functions

·         What are Functions?

·         Finding the Right Functions

·         Inserting Functions

·         Some Useful and Simple Functions

Lesson 1.3 - Using Functions in Excel

·         Working with Nested Functions

·         Using the IF Function

·         Nested IF Functions

Module 2 - Managing Tables

Lesson 2.1 - Working with Tables

·         What is a Table?

·         Creating Tables

·         Modifying Tables

·         Using the Table Tools – Design Tab

·         Adding a Total Row

Lesson 2.2 - Working with Tables and Filters

·         Sorting Data in a Table

·         What is an AutoFilter?

·         Creating a Custom AutoFilter

·         Using an Advanced Filter

·         Using an Advanced Filter with Logical Statements

·         Copying Filtered Records

Module 3 - Showing Data as a Graphic

Lesson 3.1 - Adding Sparklines

·         What are Sparklines?

·         Adding Sparklines

·         About the Sparkline Tools Tab

·         Editing Sparkline Data