Microsoft Excel for Office 365 (Desktop or Online) – Part 1

Audience:

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Outline:

Module 1 – WORKING WITH FUNCTIONS

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date and Time Functions
  • Work with Text Functions

Module 2 – WORKING WITH LISTS

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Module 3 – ANALYZING DATA

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Module 4 – VISUALIZING DATA WITH CHARTS

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

Module 5 – USING PIVOTTABLES AND PIVOTCHARTS

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers