Microsoft Excel: Part II

Building on Microsoft Excel: Part I, this course focuses on creating sophisticated workbooks and worksheets. Enhance your grasp of organizational intelligence, refine data analysis and extraction skills, and gain expertise in presenting insights to decision-makers for informed strategic decisions.

$202/Attendee

Cost

Program Length

2 Days

Upcoming Session

Scheduled by Demand

Join the Waitlist to be notified.

9:00AM - 5:00 PM

(Central Time Zone)

Virtual (Teams)

Course Overview

Course 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
- Query Data with Database Functions
- 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
Using PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers

Be the first to know when registration opens by joining our exclusive Training Notification List.

Early Access: Get priority access.
Stay Informed: Receive details about new sessions.
Limited Spots: Ensure you secure your spot.

No Upcoming Session?

Join Waitlist

For cancellation notices received more than fifteen business days prior to the class date, students may receive either a full refund or reschedule into another class date.

For cancellation notice less than fifteen business days prior to the class start date, students will receive an voucher in the amount of the paid tuition to use for the same course up to a six months’ time frame and will be automatically put onto the wait list of the course of their choice and granted final admission ten business days prior to class start day based on enrollment levels.