Microsoft® Office Excel® 2019: Part 3 Training

The course provides an overview and in-depth access to the Excel environment to equip students with skills that let them collaborate, automate complex tasks, and utilize conditional logic to create and apply formulas and functions.

• Creating map data and spark lines.
• Forecasting data.
• Protecting and sharing workbooks.
• Functioning with workbooks and multiple worksheets.
• Utilize formula audit and lookup functions.
• Automating workbook functionalities.

The target audience for this training are students experienced in Microsoft Excel 2019. Although, students who have deep interest in learning Microsoft Excel features can enrol in this course. You will learn how to troubleshoot complex, large spreadsheets, construct Excel functions and functionalities in performing extensive datasets.

• 1. Working with Multiple Worksheets and Workbooks
• Use Links and External References
• Use 3-D References
• Consolidate Data
View Less    View More   
2. Sharing and Protecting Workbooks
Collaborate on a Workbook
Protect Worksheets and Workbooks
3. Automating Workbook Functionality
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
4. Using Lookup Functions and Formula Auditing
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
5. Forecasting Data
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecast Data Trends
6. Creating Sparklines and Mapping Data
Create Sparklines
Map Data