Excel 2016 Level 3 -- (05/31/2019)
Course DateFri May 31, 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 3.
Lesson 1: Working with Multiple Worksheets and Workbooks.
Use Links and External References.
Use 3-D References.
Lesson 2: Using Lookup Functions and Formula Auditing.
Use Lookup Functions.
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.
Lesson 6: Forecasting Data.
Determine Potential Outcomes Using Data Tables.
Determine Potential Outcomes Using Scenarios.
Use the Goal Seek Feature.
Forecasting Data Trends.