Excel Advanced
Excel Advanced
|
||||
Try Limited, Free Training:
- Harness PivotTables & PivotCharts to analyze data.
- Record macros to automate repetitive tasks.
- Build formulas with IF, SUMIF, VLOOKUP, HLOOKUP fuctions.
- Analyze complex data using What-If Analysis and Goal Seek.
Upgrade to Experience:
-
LinkedIn-ready certificates that verify your skills
-
Skill assessments
-
Unlocked courses & interactive content
-
Customizable content; create your own courses
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| PivotTables | Limited Free Learning | |||
| Create PivotTables | Click to start | Not Started | Not included | |
| Add Multiple PivotTable Fields | Not included | Not Started | Not included | |
| Change a PivotTable's Calculation | Not included | Not Started | Not included | |
| Add Calculated Fields | Not included | Not Started | Not included | |
| The GETPIVOTDATA Function | Not included | Not Started | Not included | |
| Filter PivotTables | Not included | Not Started | Not included | |
| Timelines | Not included | Not Started | Not included | |
| PivotTable Layout | Not included | Not Started | Not included | |
| Group Values | Not included | Not Started | Not included | |
| Refresh a PivotTable | Not included | Not Started | Not included | |
| Format a PivotTable | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| PivotCharts | Limited Free Learning | |||
| Create PivotCharts | Not included | Not Started | Not included | |
| PivotChart Options | Not included | Not Started | Not included | |
| PivotChart Styles | Not included | Not Started | Not included | |
| Drill-Down Data | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Troubleshoot Formulas | Limited Free Learning | |||
| Formula Errors | Not included | Not Started | Not included | |
| The Watch Window | Not included | Not Started | Not included | |
| Evaluate Formulas | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Advanced Formatting | Limited Free Learning | |||
| Customize Conditional Formatting | Not included | Not Started | Not included | |
| Conditional Formatting with Formulas | Not included | Not Started | Not included | |
| Manage Conditional Formatting | Not included | Not Started | Not included | |
| International Currency and Formats | Not included | Not Started | Not included | |
| Body and Heading Options | Not included | Not Started | Not included | |
| Color Formats | Not included | Not Started | Not included | |
| Custom Themes | Not included | Not Started | Not included | |
| Form Controls | Not included | Not Started | Not included | |
| Save Form Templates | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Advanced Formulas | Limited Free Learning | |||
| IF Function | Not included | Not Started | Not included | |
| Nested Functions | Not included | Not Started | Not included | |
| AND, OR, and NOT Functions | Not included | Not Started | Not included | |
| SUMIF, AVERAGEIF, and COUNTIF Functions | Not included | Not Started | Not included | |
| VLOOKUP | Not included | Not Started | Not included | |
| HLOOKUP | Not included | Not Started | Not included | |
| INDEX and MATCH | Not included | Not Started | Not included | |
| UPPER, LOWER, and PROPER | Not included | Not Started | Not included | |
| RIGHT, LEFT, and MID | Not included | Not Started | Not included | |
| Formula Calculation Options | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Analyze Data | Limited Free Learning | |||
| Goal Seek | Not included | Not Started | Not included | |
| Scenario Manager | Not included | Not Started | Not included | |
| Consolidate Data | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Macros | Limited Free Learning | |||
| Enable Macros | Not included | Not Started | Not included | |
| Create Macros | Not included | Not Started | Not included | |
| Modify Macros | Not included | Not Started | Not included | |
| Copy Macros | Not included | Not Started | Not included | |