Excel 2016 Intermediate - Half 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:

  • Create and modify charts and Sparklines 
  • Calculate with advanced formulas 
  • Work with Tables
  • Sort and filter data 

Class Content

Lesson 1: Working with Charts

  1. Creating a Chart using the Recommend Chart feature
  2. Changing the Chart using the Chart Element, Styles and Filters buttons
  3. Adding Chart Elements 
  4. Moving a Chart to a Different Excel Worksheet 
  5. Enhancing a worksheet with Sparklines 
  6. Exploring new Chart Types

Lesson 2: Calculating with Advanced Formulas

  1. Naming Cells 
  2. Sharing Data between Worksheets 
  3. Calculating Across Worksheets 
  4. Calculating with Date Functions 
  5. Calculating with Lookup and Reference Functions 
  6. Calculate with Logical Functions 

Lesson 3: Working with Tables

  1. Freezing Panes 
  2. Creating a Table
  3. Formatting and Customizing a Table
  4. Applying Conditional Formatting 
  5. Extracting or Adding data with Flash Fill

Lesson 4: Sorting and Filtering Data

  1. Sorting by Columns 
  2. Creating an Advanced Sort 
  3. Using AutoFilter to Filter by Columns 

Have a Question?

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

Get in touch!