Curriculum
Learn to use Microsoft Excel like a Pro - Intermediate Level
Excel Intermediate
0/1
Lists
0/5
-
02. What are Lists?Sorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
03:01 -
03. Sorting a ListSorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
01:39
-
04. Sorting multiple CriteriaSorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
02:18
-
05. Custom SortSorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
02:55
-
06. Format a List as a TableSorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
02:16
DataBase Function
0/4
-
07. instruction to DataBase FunctionsThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
03:29
-
08. DSum Function – Single CriteriaSorry, this lesson is currently locked. You need to complete "07. instruction to DataBase Functions" before accessing it.
02:51
-
09. DAverageSorry, this lesson is currently locked. You need to complete "07. instruction to DataBase Functions" before accessing it.
02:12
-
10. DCount FunctionSorry, this lesson is currently locked. You need to complete "07. instruction to DataBase Functions" before accessing it.
01:48
Data Validation
0/3
-
11. Data Validation ListThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
05:54
-
12. Data Validation DecimalSorry, this lesson is currently locked. You need to complete "11. Data Validation List" before accessing it.
01:54
-
13. Input and Error MessagesSorry, this lesson is currently locked. You need to complete "11. Data Validation List" before accessing it.
04:17
Creating Basic Charts
0/1
Pivot Tables
0/5
-
15. Formatting Pivot Table DataSorry, this lesson is currently locked. You need to complete "Creating Basic Charts" before accessing it.
03:44
-
16. Drilling down into Pivot Data TableThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Text lesson
-
17. Creating Pivot ChartsSorry, this lesson is currently locked. You need to complete "16. Drilling down into Pivot Data Table" before accessing it.
03:16
-
18. Filtering Pivot Table DataSorry, this lesson is currently locked. You need to complete "16. Drilling down into Pivot Data Table" before accessing it.
02:51
-
19. Filtering using the SlicerSorry, this lesson is currently locked. You need to complete "16. Drilling down into Pivot Data Table" before accessing it.
02:50
Lookup Functions
0/3
-
20. VLookUpThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
02:58
-
21. HILookUPSorry, this lesson is currently locked. You need to complete "20. VLookUp" before accessing it.
03:02
-
22. Index and MatchThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
04:51
Advanced Functions
0/4
-
23. FV FunctionSorry, this lesson is currently locked. You need to complete "Lookup Functions" before accessing it.
03:38
-
24. PMT FunctionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
01:37
-
25. HyperlinksThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
03:59
-
26. Text and ColumnsThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
01:31
Video lesson
