Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

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.
NameBuy
Microsoft Excel 2021 Expert
Test Prep
10+ Pre Assessment Questions | 10+ Post Assessment Questions |
Features
28+ LiveLab | 10+ Video tutorials | 08+ Minutes

Why choose TOPTALENT?

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