Course Overview
This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparklines feature. Database management, PivotTables, PivotCharts, and Slicers are covered in detail, as well as importing and exporting Excel data to and from other applications.
Course Objectives
Using Advanced Functions Part 1, Using Advanced Functions Part 2, Conditional Formatting and SparkLines, Managing Data, Using PivotTables, PivotCharts, and Slicers, Importing and Exporting Data, Analyzing Data
Agenda
1 - Introduction
2 - Using Advanced Functions Part 1
- Help with Functions
- Logical Functions
3 - Using Advanced Functions Part 2
- Financial Functions
- Text Functions
- Lookup Functions
4 - Conditional Formatting and SparkLines
- Applying Conditional Formats
- Managing Conditional Formats
- Creating Sparklines
- Modifying Sparkline Styles
5 - Managing Data
- Using Data Validation
- Working with Tables
- Sorting a List
- Filtering Data
6 - Using PivotTables, PivotCharts, and Slicers
- Creating a PivotTable
- Filtering and Sorting
- Filtering with Slicers
- Adding a PivotChart
7 - Analyzing Data
- Auditing and Error Checking
- Using the Scenario Manager and Goal Seek
8 - Importing and Exporting Data
- Transferring Between Word and Excel
- Importing a Text File
- Transferring Between Access and Excel
9 - Conclusion