Excel 2013 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
  • Sort and filter data
  • Customize the Excel window

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

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. Creating a Table
  2. Formatting and Customizing a Table
  3. Using Conditional Formatting
  4. 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

Lesson 5: Customizing the Excel Window

  1. Freezing Panes
  2. Customizing the Ribbon and Quick Access toolbar

Have a Question?

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

Get in touch!