Skip to Main Content

Microsoft Excel Level 2

Hours: 6.00 | Estimated Cost: $179.00

Use Microsoft® Excel® to create advanced formulas and organize your data into tables. Discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons. Prerequisite: Microsoft® Office Excel® 2016 - Level 1 or equivalent knowledge/experience.

Additional Information

Learn About
  • Working with Functions
  • Working with Lists
  • Analyzing Data
  • Visualizing Data with Charts
  • Analyzing data with PivotTables and Pivot Charts
Benefits & Outcomes
  • Improve productivity by allowing mundane tasks to be completed more efficiently
  • Learn valuable tips and tricks to improve efficiency and accuracy
  • Become proficient in Microsoft Excel
Training Outline

**Working with Functions**

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

**Working with Lists**

  • Sort Data
  • Filter Data
  • Outline and Subtotal Data

**Analyzing Data**

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

**Visualizing Data with Charts**

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

**Analyzing Data with PivotTables and PivotCharts**

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by using Timelines and Slicers
Business and Industry Services

Fox Valley Technical College
Business & Industry Services (BIS)
D. J. Bordini Center
5 N. Systems Drive
Appleton, WI 54914-1655
View BIS Calendar

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771

Join us on LinkedIn