Upon Request Courses

Excel 2010/2007 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

Request

Call (518) 786-1181 or contact us for customized, individual or group training.

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: Customizing the Excel Environment

  • Configure Excel options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel add-ins

Lesson 2: Creating Advanced Formulas

  • Use range names in formulas
  • Use specialized functions
  • Use array formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

  • Analyze data by using text and logical functions
  • Apply advanced conditional formatting

Lesson 4: Organizing and analyzing datasets and tables

  • Create and modify tables
  • Sort data
  • Filter data
  • Use SUBTOTAL and database functions

Lesson 5: Visualizing Data with Basic Charts

  • Create charts
  • Modify and format charts

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

  • Create a PivotTable
  • Analyze PivotTable data
  • Present data with PivotCharts
  • Filter data by using slicers