Excel 2016 Level 2 -- (05/30/2019)

Course Date

Thu May 30, 8:30 AM - 5:00 PM (AKDT)

Course Location

Anchorage Extension, 3700 Centerpoint Dr. Ste. 102, Anchorage, AK

TRAINING SCHEDULE:

Course times are scheduled from 8am to 5pm
This includes a 30-minute lunch at 12pm.

Microsoft Office Excel 2016 -Part 2.

Lesson 1: Working with Functions.
Work with Ranges.
Use Specialized Functions.
Work with Logical Functions.
Work with Date & Time Functions.
Work with Text Functions.

Lesson 2: Working with Lists.
Sort Data.
Filter Data.
Query Data with Database Functions.
Outline and Subtotal Data.

Lesson 3: Analyzing Data.
Create and Modify Tables.
Apply Intermediate Conditional Formatting.
Apply Advanced Conditional Formatting.

Lesson 4: Visualizing Data with Charts.
Create Charts.
Modify and Format Charts.
Use Advanced Chart Features.

Lesson 5: Using PivotTables and Pivot Charts.
Create a PivotTable.
Analyze PivotTable Data.
Present Data with Pivot Charts.
Filter Data by Using Timelines and Slicers.

Course Cost

$295