Microsoft Excel 2021 Intermediate
(MSEXCEL-INT.AD1) / ISBN : 978-1-64459-409-4
This course includes
Interactive Lessons
Gamified TestPrep
Hands-On Labs
Instructor Led (Add-on)
AI Tutor (Add-on)
About This Course
Skills You’ll Get
Get the support you need. Enroll in our Instructor-Led Course.
Interactive Lessons
9+ Interactive Lessons | 84+ Exercises | 51+ Quizzes | 39+ Flashcards | 39+ Glossary of terms
Gamified TestPrep
20+ Pre Assessment Questions | 16+ Post Assessment Questions |
Hands-On Labs
30+ LiveLab | 46+ Video tutorials | 48+ Minutes
1
About This Course
- Course Description
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
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
4
Analyzing Data
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
5
Visualizing Data with Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
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
A
Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts
B
Appendix B: Financial Functions
C
Appendix C: Working with Graphical Objects
- Topic A: Insert Graphical Objects
- Topic B: Modify Graphical Objects
- Topic C: Work with SmartArt
1
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
2
Working with Lists
- Filtering the Data for all Employees
- Creating a Custom Filter
- Using Database Functions
3
Analyzing Data
- Converting the Data into a Table
- Applying a Quick Style to a Table
- Adding New Entries to a Table
4
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
5
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
Related Courses
All Course
MCA Microsoft 365 Teams Administrator Study Guide (MS-700)
MS-700.AE1
MCA Microsoft 365 Teams Administrator Study Guide (MS-700)
ISBN: 9781644593509MS-700.AE1
