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