Excel 2016 Advanced
|
||||
What you'll learn:
- 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.
What’s Included:
- Skill assessments
- Bite-sized, interactive lessons
- LinkedIn-ready skills certificate
- Customizable content
| 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 | |
| PivotCharts | Verified Learning | |||
| Create PivotCharts | Account Required | |||
| PivotChart Options | ||||
| PivotChart Styles | ||||
| Drill-Down Data | ||||
| Troubleshoot Formulas | Verified Learning | |||
| Formula Errors | ||||
| The Watch Window | ||||
| Evaluate Formulas | ||||
| 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 | ||||
| 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 | ||||
| Analyze Data | Verified Learning | |||
| Goal Seek | ||||
| Scenario Manager | ||||
| Consolidate Data | ||||
| Macros | Verified Learning | |||
| Enable Macros | ||||
| Create Macros | ||||
| Modify Macros | ||||
| Copy Macros | ||||
Quick Answer:
