Microsoft Excel 2021 Expert MSEXCEL-EXP.AD1 Job at uCertify, Helena, MO

TldROVlEckpzS3I3dzI2R3BnWUpQaDl5MkE9PQ==
  • uCertify
  • Helena, MO

Job Description

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 terms TestPrep 10+ Pre Assessment Questions |10+ Post Assessment Questions | Hands-On Labs 28+ LiveLab |10+ Video tutorials |08+ Minutes Working with Multiple Worksheets and Workbooks Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data 3 Sharing and Protecting Workbooks Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks 4 Automating Workbook Functionality Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros 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 6 Forecasting Data Topic A: Determine Potential Outcomes Using Data Tables Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends 7 Creating Sparklines and Mapping Data Topic A: Create Sparklines Topic B: Map Data Appendix B: Cube Functions Appendix C: Importing and Exporting Data Topic A: Import and Export Data 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 1 Working with Multiple Worksheets and Workbooks Creating Links Creating External Links Creating a 3-D Formula Consolidating Data 2 Sharing and Protecting Workbooks Fixing the Missing Alternative Text Error by Using the Accessibility Checker Exporting the Workbook in the PDF File Format Hiding the Worksheet Enabling Worksheet Protection Hiding the Formulas 3 Automating Workbook Functionality Enabling and Configuring the Settings for Data Validation Checking the Worksheet For Errors In Formulas Finding and Fixing Invalid Data Entries Saving the Workbook as a Macro-Enabled Workbook 4 Using Lookup Functions, Dynamic Arrays, and Formula Auditing Microsoft Excel 2021 Microsoft Excel 2021 ISBN: 978-1-64459-382-0 uCertifyMSEXCEL.AD1 Microsoft 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-4 uCertifyXLS-DA-BM.AB1 Microsoft Excel 2019 Microsoft Excel 2019 ISBN: 978-1-64459-225-0 MicrosoftMO-200.AI3 Microsoft Excel 2021 Microsoft Excel 2021 ISBN: 978-1-64459-382-0 uCertifyMSEXCEL.AD1 Microsoft 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-4 uCertifyXLS-DA-BM.AB1 Microsoft Excel 2019 Microsoft Excel 2019 ISBN: 978-1-64459-225-0 MicrosoftMO-200.AI3 #J-18808-Ljbffr uCertify

Job Tags

Similar Jobs

Tenstorrent Inc.

Senior Physical Design Engineer - CTS Job at Tenstorrent Inc.

 ...collaboration, curiosity, and a commitment to solving hard problems. We are growing our team and looking for contributors of all seniorities.CTS Methodology Lead for high-performance designs going into industry leading CPU and AI/ML architecture. This role involves owning and... 

Hays

Assistant Construction Project Manager - Multifamily projects Job at Hays

 ...concrete)~11 new townhomes They are now seeking a Project Engineer or an Assistant Project Manager to join their growing team to help support the...  ...25 years of experience in ground-up multi-family Construction experience. In return you will receive a... 

Newtown Savings Bank

HMDA & CRA Data Compliance Specialist (onsite) Job at Newtown Savings Bank

 ...multi-tasker to join our Loan Servicing Department as a HMDA and CRA Data Compliance Specialist. This position is responsible for...  ...opportunity at our Corporate office in Newtown, CT. The role has a remote option of one day per week.PRIMARY RESPONSIBILITIESComplete... 

FAENA

Bartender Job at FAENA

 ...software, and cash handling procedures.~ Fluent in English; additional languages a plus.~ Availability to work evenings, weekends, and holidays. SKILLS~ Mastery of cocktail-making techniques, including stirring, shaking, muddling, and garnishing.~... 

ABM Industries

School Cleaner Job at ABM Industries

**Overview****Job Summary Details:**The Cleaner provides the cleaning and upkeep of an assigned area.**Benefit Information:**ABM offers...  ...experience required and on the job training provided- No high school diploma, GED or college degree required**Preferred...