Curriculum
6 Sections
21 Lessons
10 Weeks
Expand all sections
Collapse all sections
1- INTRO
0
2- WORKING WITH FUNCTIONS
6
2.1
Work with Ranges
2.2
Use Specialized Functions
2.3
Work with Logical Functions
2.4
Work with Date and Time Functions
2.5
Work with Text Functions
2.6
Apply specialized formulas
3- WORKING WITH LISTS
4
3.1
Sort Data
3.2
Filter Data
3.3
Query Data with Database Functions
3.4
Outline and Subtotal Data
4- ANALYZING DATA
3
4.1
Create and Modify Excel Tables
4.2
Apply Intermediate Conditional Formatting
4.3
Apply Advanced Conditional Formatting
5- VISUALIZING DATA WITH CHARTS
3
5.1
Create Charts
5.2
Modify and Format Charts
5.3
Use Advanced Chart Features
6- USING PIVOTTABLES AND PIVOTCHARTS
5
6.1
Create a PivotTable
6.2
Analyze PivotTable Data
6.3
Build dynamic & Present Data with PivotCharts
6.4
Filter Data by Using Timelines and Slicers
6.5
CONGRATULATIONS & NEXT STEPS
Excel Intermediate Training
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content