LCT0038 - Advanced Excel 2019
Course Description
This course has been revised. Starting August 2024 the title is Excel Part 3 (Microsoft 365).
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.
Note: Summer 2024 is the last time Community Education will be offering Excel 2019. Starting in August, we will be moving to Microsoft 365.
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.
Notes
This course has been revised. Starting August 2024 the title is Excel Part 3 (Microsoft 365).Applies Towards the Following Digital Badges
- Microsoft Excel 2019 Digital Badge : Microsoft Excel 2019