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.
- 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
- 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
Make every day count. Discover your passions. Advance your career. Play and learn.
I started a new job as a graphic and web designer and the digital badge I got was part of the reason they chose to hire me. I couldn't have done it without you!
David is a truly amazing teacher who makes learning the harmonica lots of fun. His enthusiasm is contagious and he has a heart of gold.
The Writing Salon was so much more than a writing class. The experience was energetic, enthusiastic and supportive. I highly recommend this class for anyone who wants to develop their skills as a writer!
As always, your Spanish classes are packed with new information about the language. You make it easy to learn Spanish and keep it very interesting. Thank you!
I have participated in many LLI classes over the past two years. Gary is a terrific discussion facilitator and brings excellent background knowledge to our classes. I'm learning so much about Foreign Policy.
Just want to let you know how much I enjoyed your class. Hope you will have more classes since I am a novice in the wine area and am anxious to learn.