Course Details
Course Outline
1 - Working with Multiple Worksheets & Workbooks
Reference Cells and Groups of Cells Across WorksheetsLink Cells to External WorksheetsConsolidate Data Across Worksheets
2 - Using Lookup Formulas and Formula Auditing
Search Rows or Columns Using LOOKUP FunctionsDisplay Relationships Between Cells and Formulas with the Trace CommandWatch Cells and Formulas From the Watch Tool
3 - Sharing and Protecting Workbooks
Collaborate on WorkbooksApply Varying Levels of Workbook Access and Protections
4 - Automating Workbook Functionality
Create and Manage Validation Rules and ListsSearch for Invalid Data and Formulas with ErrorsRecord Macros to Automate Tasks
5 - Creating Sparklines and Mapping Data
Create Sparklines to Show TrendsMap Data
6 - Forecasting Data
Determine Potential Outcomes Using Data Tables and ScenariosSolve for Desired Outputs with the Goal Seek FeatureForecast Data Trends
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
If you’re proficient in Excel 2016 and looking to master more advanced features, this course is for you.
Prerequisites
Other Prerequisites
Excel 2016 - Part 3 is an advanced course.
To get the most out of your Excel 2016 training, you should have completed Excel 2016 - Part 1 and Excel 2016 - Part 2 or have real-world experience creating and analyzing datasets using Excel 2016.
When enrolling in this course, you should also know how to work with functions and lists, build charts, create advanced formulas, manipulate datasets and tables, use PivotTables and PivotCharts and customize the Excel environment.