In this course, we will dive into some powerful features of Excel so you can analyze your data and make it dance for you!
We will work with some intermediate functions such as:
- VLOOKUP
- IF
- Pivot Tables
- Filtering
- Subtotaling
- Tables
You won't believe the reporting you will produce after this course!
You should be comfortable creating formulas and understand absolute references. The Excel Level 1 course will do that for you if needed!
Course Content:
Resources
Available in
days
days
after you enroll
Lesson 1 - Review, Tips and Tricks
Available in
days
days
after you enroll
Lesson 2 - Excel Tables and Conditional Formatting
Available in
days
days
after you enroll
Lesson 3 Excel Functions: IF, COUNTIF, SUMIF
Available in
days
days
after you enroll
Lesson 4 - More Excel Functions: VLOOKUP, ROUND, NOW
Available in
days
days
after you enroll
Lesson 5 - Excel Graphs and Working with Multiple Sheets
Available in
days
days
after you enroll
Lesson 6 - Excel Sorting and Filtering
Available in
days
days
after you enroll
Lesson 7 - Excel Subtotals
Available in
days
days
after you enroll
Lesson 8 - Excel Pivot Tables
Available in
days
days
after you enroll
Lesson 9 - Named Ranges and Data Validation (Drop Down Lists)
Available in
days
days
after you enroll
Lesson 10 - Review
Available in
days
days
after you enroll
Wrap up
Available in
days
days
after you enroll