COURSE MATERIAL ONLY
Includes a hard-copy book and access to an online Learning Locker (ebook).  If you have taken the respective ProMark class within the past 3 months, you will also receive 90 days of on-call training support for that class. (Please add your class date in either of the text fields below.)
 
Price includes shipping and handling.
 
Target Student: This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features
 
Course Content
Lesson 1: Working with Multiple Worksheets and Workbooks 
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
 
Lesson 2: Using Lookup Functions and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas
 
Lesson 3: Sharing and Protecting Workbooks 
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks 
 
Lesson 4: Automating Workbook Functionality 
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
 
Lesson 5: Creating Sparklines and Mapping Data 
Topic A: Create Sparklines
Topic B: Map Data
 
Lesson 6: Forecasting Data 
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecasting Data Trends