Excel 2010 - Advanced

3 Hours, 6 Minutes
Delivery Method
LearnNow On Demand

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.


Purchase This On Demand Title or a LearnNow On Demand subscription

Excel 2010 - Advanced
  Buy Now $39.99 Purchase this course for 12 months.
  Buy Now $99.95 Purchase this course and hundreds of others with our LearnNow On Demand 12-month subscription.

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


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