Information Technology
Excel 2016 – Part 3
This course builds off the knowledge presented in the Microsoft® Office Excel® 2016: Parts 1 & 2 courses to help you get the most of your Excel experience. This course covers Microsoft Office Specialist exam objectives to help students prep for the exam.
2 Days
16 Hrs
6 Lessons
Course Objectives
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:
- Work with multiple worksheets and workbooks. Use Lookup functions and formula auditing Share and protect workbooks. Automate workbook functionality. Create sparklines and map data. Forecast data.
Agenda
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
- Topic A: Create Sparklines
- Topic B: Map 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
FREE
Interested in course?
Course Type: Instructor Led