Excel 2021 Advanced
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Excel 2021 Advanced
4 hour course
Learn to:
- Create PivotTables
- Troubleshoot complex formulas
- Automate tasks with macros
- Use IF, VLOOKUP, & advanced
Features:
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
Excel 2021 Advanced
Try this course with a Free Trial
|
||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| PivotTables |
Verified Learning
|
|||
| Create PivotTables Click to start | Not Started | Not Started | Not Started | |
| Add Multiple PivotTable Fields | Not Started | Not Started | Not Started | |
| Change a PivotTable's Calculation | Not Started | Not Started | Not Started | |
| Add Calculated Fields | Not Started | Not Started | Not Started | |
| The GETPIVOTDATA Function | Not Started | Not Started | Not Started | |
| Filter PivotTables | Not Started | Not Started | Not Started | |
| Timelines | Not Started | Not Started | Not Started | |
| PivotTable Layout | Not Started | Not Started | Not Started | |
| Group Values | Not Started | Not Started | Not Started | |
| Refresh a PivotTable | Not Started | Not Started | Not Started | |
| Format a PivotTable | Not Started | Not Started | Not Started | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| PivotCharts |
Verified Learning
|
|||
| Create PivotCharts | Account Required | |||
| PivotChart Options | ||||
| PivotChart Styles | ||||
| Drill-Down Data | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Troubleshoot Formulas |
Verified Learning
|
|||
| Formula Errors | ||||
| The Watch Window | ||||
| Evaluate Formulas | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Advanced Formatting |
Verified Learning
|
|||
| Customize Conditional Formatting | ||||
| Conditional Formatting with Formulas | ||||
| Manage Conditional Formatting | ||||
| International Currency and Formats | ||||
| Body and Heading Options | ||||
| Color Formats | ||||
| Custom Themes | ||||
| Form Controls | ||||
| Save Form Templates | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Advanced Formulas |
Verified Learning
|
|||
| IF Function | ||||
| Nested Functions | ||||
| AND, OR, and NOT Functions | ||||
| SUMIF, AVERAGEIF, and COUNTIF Functions | ||||
| VLOOKUP | ||||
| HLOOKUP | ||||
| INDEX and MATCH | ||||
| UPPER, LOWER, and PROPER | ||||
| RIGHT, LEFT, and MID | ||||
| Formula Calculation Options | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Analyze Data |
Verified Learning
|
|||
| Goal Seek | ||||
| Scenario Manager | ||||
| Consolidate Data | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Macros |
Verified Learning
|
|||
| Enable Macros | ||||
| Create Macros | ||||
| Modify Macros | ||||
| Copy Macros | ||||
Quick Answer: