Microsoft Excel 2021 Expert
Gain the skills required to work in Excel 2021 with the Microsoft Excel 2021 Expert course and lab. This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2021: Part 1 and Microsoft® Office Excel® 2021: Part 2 courses to help you get the most out of your Excel experience. After taking this course, you’ll be able to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions.
- Price: $279.99
- Delivery method: eLearning
- DIR Discount: 20%
Submit form to obtain discount
Test Prep
10+ Pre Assessment Questions |
10+ Post Assessment Questions |
Features
28+ LiveLab |
10+ Video tutorials |
08+ Minutes
Why choose TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
Outline
Lessons 1:
About This Course
- Course Description
Lessons 2:
Working with Multiple Worksheets and Workbooks
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
Lessons 3:
Sharing and Protecting Workbooks
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
Lessons 4:
Automating Workbook Functionality
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
Lessons 5:
Using Lookup Functions, Dynamic Arrays, and Formula Auditing
- Topic A: Use Lookup Functions
- Topic B: Use Dynamic Arrays and Dynamic Array Functions
- Topic C: Trace Cells
- Topic D: Watch and Evaluate Formulas
Lessons 6:
Forecasting Data
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
Lessons 7:
Creating Sparklines and Mapping Data
- Topic A: Create Sparklines
- Topic B: Map Data
Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts
Appendix B: Cube Functions
Appendix C: Importing and Exporting Data
- Topic A: Import and Export Data
Appendix D: Internationalizing Workbooks
- Topic A: Internationalize Workbooks
Appendix E: Working with Power Pivot
- Topic A: Work with Power Pivot
Appendix F: Advanced Customization Options
- Topic A: Customize Advanced Options
Appendix G: Working with Forms and Controls
- Topic A: Work with Forms and Controls
Appendix H: Using Array Formulas
- Topic A: Use Array Formulas