Free

Event Information

Share this event

Date and Time

Location

Location

Building 2E Room 108

Friends Who Are Going
Event description

Description

Excel Level 2

Module 1: Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Module 2: Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Module 3: Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Module 4: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Module 5: Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

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

  • Create a PivotTable
  • Analyze PivotTable Data P
  • resent Data with PivotCharts
  • Filter Data by Using Slicers
Share with friends

Date and Time

Location

Building 2E Room 108

Save This Event

Event Saved