Spreadsheets

Excel 2016/2013 Part 2

This course builds on the Excel basics and covers how to create advanced formulas; sort, filter, outline, and subtotal data; and create and format charts.

Dates & Times

CourseDate & TimeLocationCost
Excel 2016/2013 Part 2February 14 - 8:30 - 4:30LathamRegister
Excel 2016/2013 Part 2March 20 - 8:30 - 4:30LathamRegister
Excel 2016/2013 Part 2April 24 - 8:30 - 4:30LathamRegister
Excel 2016/2013 Part 2May 21 - 8:30 - 4:30LathamRegister

Course Outline

This course is appropriate for individuals who currently use Excel to create and edit spreadsheets and are looking to increase their knowledge of the program.

Includes:
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Working with Functions

  • Work with ranges
  • Use specialized functions
  • Work with logical functions
  • Work with date & time functions
  • Work with text functions

Lesson 2: Working with Lists

  • Sort data
  • Filter data
  • Query data with database functions
  • Outline and Subtotal data

Lesson 3: Analyzing Data

  • Create and modify tables
  • Apply intermediate conditional formatting
  • Apply advanced conditional formatting

Lesson 4: Visualizing Data with Charts

  • Create charts
  • Modify and format charts
  • Use advanced chart features

Lesson 5: Using PivotTables and PivotCharts

  • Create a Pivot Table
  • Analyze PivotTable data
  • Present data with PivotCharts
  • Filter data by using Timelines and Slicers