Excel 2013 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:  Microsoft Office Excel 2013 Exam 77-420
Appendix B:  Microsoft Office Excel 2013 Expert Exams 77-427 and 77-427
Appendix C:  Financial Functions
Appendix D:  Date and Time Functions
Appendix E:  Working with Graphical Objects

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!