Excel 2010 Intermediate - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Customize the Excel environment
  • Create advanced formulas
  • Analyze data by using functions and conditional formatting
  • Organize and analyze datasets and tables
  • Visualize data by using basic charts
  • Analyze data by using PivotTables, Slicers, and PivotCharts

Course Content

Lesson 1: Customizing the Excel environment

  1. Configure Excel options
  2. Customize the Ribbon and the Quick Access Toolbar
  3. Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

  1. Use Range Names in Formulas
  2. Use Specialized Functions
  3. Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

  1. Analyze Data by using Text and Logical Functions
  2. Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

  1. Create and Modify Tables
  2. Sort Data
  3. Filter Data
  4. Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

  1. Create Charts
  2. Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

  1. Create a PivotTable
  2. Analyze PivotTable Data
  3. Present Data with PivotCharts
  4. Filter Data by using Slicers

Appendix A: Financial Functions 
Appendix B: Date and Time Functions
Appendix C: Working with Graphical Objects
Appendix D: Microsoft Office Excel 2010 Exam 77-882
Appendix E: Microft Office Excel 2010 Expert Exam 77-888

If you would like to customize this class please call us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!