uCertify
Microsoft Excel 2021 Expert MSEXCEL-EXP.AD1
uCertify, Helena, Missouri, United States, 64459
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.Get the support you need. Enroll in our Instructor-Led Course.
15+ Lessons |54+ Exercises |46+ Quizzes |48+ Flashcards |48+ Glossary of termsTestPrep
10+ Pre Assessment Questions |10+ Post Assessment Questions |Hands-On Labs
28+ LiveLab |10+ Video tutorials |08+ MinutesWorking with Multiple Worksheets and Workbooks
Topic A: Use Links and External ReferencesTopic B: Use 3-D ReferencesTopic C: Consolidate Data3
Sharing and Protecting Workbooks
Topic A: Collaborate on a WorkbookTopic B: Protect Worksheets and Workbooks4
Automating Workbook Functionality
Topic A: Apply Data ValidationTopic B: Search for Invalid Data and Formulas with ErrorsTopic C: Work with Macros5
Using Lookup Functions, Dynamic Arrays, and Formula Auditing
Topic A: Use Lookup FunctionsTopic B: Use Dynamic Arrays and Dynamic Array FunctionsTopic C: Trace CellsTopic D: Watch and Evaluate Formulas6
Forecasting Data
Topic A: Determine Potential Outcomes Using Data TablesTopic C: Use the Goal Seek FeatureTopic D: Forecast Data Trends7
Creating Sparklines and Mapping Data
Topic A: Create SparklinesTopic B: Map DataAppendix B: Cube Functions
Appendix C: Importing and Exporting Data
Topic A: Import and Export DataTopic A: Internationalize WorkbooksAppendix E: Working with Power Pivot
Topic A: Work with Power PivotAppendix F: Advanced Customization Options
Topic A: Customize Advanced OptionsAppendix G: Working with Forms and Controls
Topic A: Work with Forms and ControlsAppendix H: Using Array Formulas
Topic A: Use Array Formulas1
Working with Multiple Worksheets and Workbooks
Creating LinksCreating External LinksCreating a 3-D FormulaConsolidating Data2
Sharing and Protecting Workbooks
Fixing the Missing Alternative Text Error by Using the Accessibility CheckerExporting the Workbook in the PDF File FormatHiding the WorksheetEnabling Worksheet ProtectionHiding the Formulas3
Automating Workbook Functionality
Enabling and Configuring the Settings for Data ValidationChecking the Worksheet For Errors In FormulasFinding and Fixing Invalid Data EntriesSaving the Workbook as a Macro-Enabled Workbook4
Using Lookup Functions, Dynamic Arrays, and Formula Auditing
Microsoft Excel 2021
Microsoft Excel 2021
ISBN: 978-1-64459-382-0uCertifyMSEXCEL.AD1Microsoft Excel Data Analysis and Business Modeling
Microsoft Excel Data Analysis and Business Modeling
Microsoft Excel Data Analysis and Business Modeling
ISBN: 978-1-64459-368-4uCertifyXLS-DA-BM.AB1Microsoft Excel 2019
Microsoft Excel 2019
ISBN: 978-1-64459-225-0MicrosoftMO-200.AI3Microsoft Excel 2021
Microsoft Excel 2021
ISBN: 978-1-64459-382-0uCertifyMSEXCEL.AD1Microsoft Excel Data Analysis and Business Modeling
Microsoft Excel Data Analysis and Business Modeling
Microsoft Excel Data Analysis and Business Modeling
ISBN: 978-1-64459-368-4uCertifyXLS-DA-BM.AB1Microsoft Excel 2019
Microsoft Excel 2019
ISBN: 978-1-64459-225-0MicrosoftMO-200.AI3
#J-18808-Ljbffr
15+ Lessons |54+ Exercises |46+ Quizzes |48+ Flashcards |48+ Glossary of termsTestPrep
10+ Pre Assessment Questions |10+ Post Assessment Questions |Hands-On Labs
28+ LiveLab |10+ Video tutorials |08+ MinutesWorking with Multiple Worksheets and Workbooks
Topic A: Use Links and External ReferencesTopic B: Use 3-D ReferencesTopic C: Consolidate Data3
Sharing and Protecting Workbooks
Topic A: Collaborate on a WorkbookTopic B: Protect Worksheets and Workbooks4
Automating Workbook Functionality
Topic A: Apply Data ValidationTopic B: Search for Invalid Data and Formulas with ErrorsTopic C: Work with Macros5
Using Lookup Functions, Dynamic Arrays, and Formula Auditing
Topic A: Use Lookup FunctionsTopic B: Use Dynamic Arrays and Dynamic Array FunctionsTopic C: Trace CellsTopic D: Watch and Evaluate Formulas6
Forecasting Data
Topic A: Determine Potential Outcomes Using Data TablesTopic C: Use the Goal Seek FeatureTopic D: Forecast Data Trends7
Creating Sparklines and Mapping Data
Topic A: Create SparklinesTopic B: Map DataAppendix B: Cube Functions
Appendix C: Importing and Exporting Data
Topic A: Import and Export DataTopic A: Internationalize WorkbooksAppendix E: Working with Power Pivot
Topic A: Work with Power PivotAppendix F: Advanced Customization Options
Topic A: Customize Advanced OptionsAppendix G: Working with Forms and Controls
Topic A: Work with Forms and ControlsAppendix H: Using Array Formulas
Topic A: Use Array Formulas1
Working with Multiple Worksheets and Workbooks
Creating LinksCreating External LinksCreating a 3-D FormulaConsolidating Data2
Sharing and Protecting Workbooks
Fixing the Missing Alternative Text Error by Using the Accessibility CheckerExporting the Workbook in the PDF File FormatHiding the WorksheetEnabling Worksheet ProtectionHiding the Formulas3
Automating Workbook Functionality
Enabling and Configuring the Settings for Data ValidationChecking the Worksheet For Errors In FormulasFinding and Fixing Invalid Data EntriesSaving the Workbook as a Macro-Enabled Workbook4
Using Lookup Functions, Dynamic Arrays, and Formula Auditing
Microsoft Excel 2021
Microsoft Excel 2021
ISBN: 978-1-64459-382-0uCertifyMSEXCEL.AD1Microsoft Excel Data Analysis and Business Modeling
Microsoft Excel Data Analysis and Business Modeling
Microsoft Excel Data Analysis and Business Modeling
ISBN: 978-1-64459-368-4uCertifyXLS-DA-BM.AB1Microsoft Excel 2019
Microsoft Excel 2019
ISBN: 978-1-64459-225-0MicrosoftMO-200.AI3Microsoft Excel 2021
Microsoft Excel 2021
ISBN: 978-1-64459-382-0uCertifyMSEXCEL.AD1Microsoft Excel Data Analysis and Business Modeling
Microsoft Excel Data Analysis and Business Modeling
Microsoft Excel Data Analysis and Business Modeling
ISBN: 978-1-64459-368-4uCertifyXLS-DA-BM.AB1Microsoft Excel 2019
Microsoft Excel 2019
ISBN: 978-1-64459-225-0MicrosoftMO-200.AI3
#J-18808-Ljbffr