Excel 2016 Level 2 -- (05/30/2019)
Course DateThu May 30, 8:30 AM - 5:00 PM (AKDT)
Course LocationAnchorage Extension, 3700 Centerpoint Dr. Ste. 102, Anchorage, AK
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.
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.
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.