Share

Excel (Level 2)

...

× Home About Services Support Community Contact Store Help Social

Excel - Level 2

This course is for advanced to Microsoft Excel

Microsoft® Excel - Level 2

This course is for advanced to Microsoft Excel


Course Overview

This course builds upon the knowledge presented in the Microsoft® Office Excel 2016: Part 1 course and helps start students down the road to creating advanced workbooks & worksheets that can help deepen their understanding.

Who Should Attend

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

Course Objectives

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will: Work with Functions Work with Lists Analyze Data Visualize Data with Charts. Create advanced formulas. Analyze Data with PivotTables and PivotCharts.

Course Outline

1 - Working with Functions

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

​2 - Working with Lists

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

3 - Analyzing Data

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

4 - Visualizing Data with Charts

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

5 - Analyzing Data with PivotTables and PivotCharts

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

Level: 2
Duration: 1-day
Price: $295.00