Error

Invalid column name 'Price'.

Excel 2010 - Advanced

 Jump to Course Request Form

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

Course Outline

1 - Introduction

  • 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

  • Course Recap