LCT0038 - Advanced Excel 2019
202747
Delivery Options
LEL-Lecture-lab.
Loading...
Course Description
Excel 2019 provides powerful data analysis capabilities. Learn to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. Learn to use conditional logic to construct and apply elaborate formulas and functions. This course builds upon the foundational and intermediate knowledge presented in the Introduction and Intermediate Excel 2019 course. PREREQUISITES: Intermediate Excel or equivalent experience.
Course Outline
- Lesson 1: Working with Multiple Worksheets and Workbooks
- Use Links and External References
- Use 3-D References
- Consolidate Data
- Lesson 2: Sharing and Protecting Workbooks
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
- Lesson 3: Automating Workbook Functionality
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
- Lesson 4: Using Lookup Functions and Formula Auditing
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
- Lesson 5: Forecasting Data
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecast Data Trends
- Lesson 6: Creating Sparklines and Mapping Data
- Create Sparklines
- Map Data
Learner Outcomes
- Work with multiple worksheets and workbooks.
- Share and protect workbooks.
- Automate workbook functionality.
- Use Lookup functions and formula auditing.
- Forecast data.
- Create sparklines and map data.
Applies Towards the Following Digital Badges
- Microsoft Excel 2019 Digital Badge : Microsoft Excel 2019
Loading...
Enroll Now - Select a section to enroll in
Required fields are indicated by .