Excel 2019 Advanced
Try this course with a Free Trial
|
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:
-
Customizable, LMS-compatible content
-
Skill assessments
-
Bite-sized, interactive lessons
-
LinkedIn-ready skills certificate
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: