Description
Intermediate Excel eLearning course. This course is designed to guide you through some of the essential functions contained within Microsoft Excel.
Educational goals
No educational goals
/5744%2FfZx0S3H2RmKXGlvhdcio_excel%20log%2F56acb89d57e5573330ede4380efb463789d90371da40dd2f3087b6f5c995a933.png)
Excel - Intermediate *
E-learning course
1
3 hours
0
Intermediate Excel - welcome to the course
2 Videos
3 Documents
Welcome Video
Section 1 - Introductions to functions
7 Videos
1 Quiz
This section will explore the following functions within Excel
COUNT
COUNTBLANK
COUNTIF
IF
SUM
SUMIF
Section 2 - Filters & Sub Totals
3 Videos
1 Quiz
This section will explore the followings:
Table Filters
Subtotal filters
Section 3 - Text Functions
6 Videos
1 Quiz
This section will explore the following:
LEN
LEFT RIGHT MID
CONCATENATE
TEXT JOIN
FLASHFILL
Section 4 - Joining Data Functions
11 Videos
1 Quiz
This section will cover the following:
NAMED RANGES
VLOOKUP
MATCH
INDEX
INDEX MATCH
INDEX MATCH MATCH
XLOOKUP
Section 5 - Pivot Tables
3 Videos
1 Quiz
In this section we will explore the following:
What is a pivot table
Creation of pivot tables
Using pivot tables
Section 6 - Additional Functions
3 Videos
1 Quiz
In section we will explore the following:
CORREL
RANK
End of course assessment
1 Questions mix
Please take this short assessment to check your understanding of the course.
You can re-take as many time as you like
End of course survey
1 Iframe
Closing thoughts
1 Video
Training company
Click2 Learn
Language
English
Keywords
No keyword
Designers
Dan
Briscoe
/5744%2FfZx0S3H2RmKXGlvhdcio_excel%20log%2F56acb89d57e5573330ede4380efb463789d90371da40dd2f3087b6f5c995a933.png)