Get the support you need. Enroll in our Instructor-Led Course.
Lessons
6+ Lessons | 54+ Exercises | 42+ Quizzes | 45+ Flashcards | 45+ Glossary of terms
TestPrep
16+ Pre Assessment Questions | 9+ Post Assessment Questions |
Hands-On Labs
17+ LiveLab | 30+ Video tutorials | 19+ Minutes
Getting Started with Excel 2021
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Enter Cell Data
- Topic E: Use Excel Help
Performing Calculations
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
Basic charting
- Answers to this lesson’s questions
- Problems
Managing Workbooks
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
Recording macros
- Answers to this lesson’s questions
- Problems
Using the Scenario Manager for sensitivity analysis
- Answer to this lesson’s question
- Remarks
- Problems
Getting Started with Excel 2021
- Exporting Ribbon Customizations as a File
- Adding and Replacing Data in a Cell
- Creating and Saving a Workbook
- Copying and Pasting the Data
Performing Calculations
- Creating Worksheet Formulas
- Determining the Minimum Value
- Determining the Maximum Value
- Reusing Formulas
- Calculating the Sum
- Calculating the Average
Basic charting
- Creating a Scatter Chart
Managing Workbooks
- Deleting a Worksheet
- Hiding a Worksheet
- Adding a New Worksheet
- Adding Color to the Worksheet Tab
- Making a Copy of the Worksheet
- Freezing the Top Row