MS Excel Workshop - Intermediate

Digital Business Association presents TechWeek Conference 2018!

The day includes hands-on and full day Microsoft Excel Workshop - Office 2016.

There will be a 30 minute lunch break provided (bring your own lunch).

Location: L Building, Room L3012

Led By: Microsoft Certified, Isabella Annouza

Workshop Content: Microsoft® Office Excel® 2016 (Intermediate)

Lesson 1: Customizing the Excel Environment

• Topic A: Configure Excel Options
• Topic B: Customize the Ribbon and the Quick Access Toolbar
• Topic C: Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

• Topic A: Use Range Names in Formulas
• Topic B: Use Specialized Functions
• Topic C: Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

• Topic A: Analyze Data by Using Text and Logical Functions
• Topic B: Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

• Topic A: Create and Modify Tables
• Topic B: Sort Data
• Topic C: Filter Data
• Topic D: Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

• Topic A: Create Charts
• Topic B: Modify and Format Charts

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

• Topic A: Create a PivotTable
• Topic B: Analyze PivotTable Data
• Topic C: Present Data with PivotCharts
• Topic D: Filter Data by Using Slicers