Microsoft Excel 2021 Intermediate

Acquire the necessary expertise for Excel 2021 through the Microsoft Excel 2021 Intermediate course and practical exercises. This program expands on the fundamental concepts covered in the Microsoft® Office Excel® 2021: Part 1 course, empowering you to craft sophisticated workbooks and worksheets, thus enhancing your grasp of organizational intelligence. Upon completion, you'll have the ability to proficiently analyze extensive datasets, extract valuable insights, and effectively communicate this information to key decision-makers.

Lessons 1: About This Course

 

• Course Description

 

Lessons 2: Working with Functions

 

• Topic A: Work with Ranges
• Topic B: Use Specialized Functions
• Topic C: Work with Logical Functions
• Topic D: Work with Date and Time Functions
• Topic E: Work with Text Functions

 

Lessons 3: Working with Lists

 

• Topic A: Sort Data
• Topic B: Filter Data
• Topic C: Query Data with Database Functions
• Topic D: Outline and Subtotal Data

 

Lessons 4: Analyzing Data

 

• Topic A: Create and Modify Tables
• Topic B: Apply Intermediate Conditional Formatting
• Topic C: Apply Advanced Conditional Formatting

 

Lessons 5: Visualizing Data with Charts

 

• Topic A: Create Charts
• Topic B: Modify and Format Charts
• Topic C: Use Advanced Chart Features

 

Lessons 6: Using PivotTables and PivotCharts

 

• Topic A: Create a PivotTable
• Topic B: Analyze PivotTable Data
• Topic C: Present Data with PivotCharts
• Topic D: Filter Data by Using Timelines and Slicers
• Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

Appendix B: Financial Functions

Appendix C: Working with Graphical Objects

 

• Topic A: Insert Graphical Objects
• Topic B: Modify Graphical Objects
• Topic C: Work with SmartArt

 

Hands-on LAB Activities

 

Working with Functions

 

• Creating Named Ranges
• Editing Range Names
• Using an Existing Range in a Function
• Using the Formula AutoComplete Method to Enter Range Names
• Using the TODAY Function
• Calculating the Years of Service for Each Employee
• Adding the Arguments for the IF Portion of the Nested Function
• Calculating the 1 Percent Goal Bonus for Employees
• Using the NETWORKDAYS Function
• Extracting the Building Code from the Combined Field
• Extracting the Floor Code from the Combined Field
• Concatenating the Names in a Single Field

Working with Lists

 

• Filtering the Data for all Employees
• Creating a Custom Filter
• Using Database Functions

Analyzing Data

 

• Converting the Data into a Table
• Applying a Quick Style to a Table
• Adding New Entries to a Table

Visualizing Data with Charts

 

• Creating a Clustered Column Chart
• Changing the Labels of the Line Chart
• Changing the Chart Type
• Creating the Combo Chart
• Adding the Trendline
• Saving a Chart as a Template

Using PivotTables and PivotCharts

 

• Adding Fields to the PivotTable
• Building the PivotTable Report
• Sorting the Values
• Modifying the Formatting of the PivotTable Report
• Modifying the PivotTable Report
• Inserting a Timeline

​Who Should Pursue This Certification?

The Microsoft Excel 2021 Intermediate Certification is relevant for a diverse range of individuals seeking to elevate their Excel proficiency beyond basic usage. This certification is beneficial for business professionals in various fields, data analysts, accountants, project managers, students, administrative personnel, educators, small business owners, and those looking to transition into roles that require Excel expertise. Additionally, it serves as a structured pathway for anyone wishing to enhance their Excel skills, providing formal recognition of their proficiency. However, it's worth noting that continuous practice and application of Excel in practical scenarios are equally important for mastery, alongside formal certification.

🔥 Benefits and Beyond:

Beyond certification seekers, Excel 2021 Intermediate proficiency benefits business leaders, educators, job seekers, and entrepreneurs. It enables better decision-making, enhances teaching capabilities, boosts job marketability, and aids in effective financial management for small businesses.