Excel 2016 Level 3 -- (05/31/2019)

Course Date

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

Course Location

Anchorage 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 3.

Lesson 1: Working with Multiple Worksheets and Workbooks.
Use Links and External References.
Use 3-D References.
Consolidate Data.

Lesson 2: Using Lookup Functions and Formula Auditing.
Use Lookup Functions.
Trace Cells.
Watch and Evaluate Formulas.

Lesson 3: Sharing and Protecting Workbooks.
Collaborate on a Workbook.
Protect Worksheets and Workbooks.

Lesson 4: Automating Workbook Functionality.
Apply Data Validation.
Search for Invalid Data and Formulas with Errors.
Work with Macros.

Lesson 5: Creating Sparklines and Mapping Data.
Create Sparklines.
Map Data.

Lesson 6: Forecasting Data.
Determine Potential Outcomes Using Data Tables.
Determine Potential Outcomes Using Scenarios.
Use the Goal Seek Feature.
Forecasting Data Trends.

Course Cost