Course Content
Excel Intermediate Resources
-
Excel Intermediate Resources
00:00 -
Excel – Intermediate – Course Info
00:00
Section 1 – Excel – Intermediate
-
1 – Excel Intermediate Introduction
01:37 -
2 – Intermediate Shortcut Keys
04:00
Section 2 – Lists
-
3 – What are Lists
03:00 -
4 – Sorting a List
01:38 -
5 – Sorting – Multiple Criteria
02:18 -
6 – Custom Sort
02:54 -
7 – What are Filters
02:31 -
8 – Format a List as a Table
02:16
Section 3 – DataBase Functions
-
9 – Introduction to DataBase Functions
03:29 -
10 – DSum Function
04:53 -
11 – DSum Function – Single Criteria
02:50 -
12 – DSum Function – Multiple Criteria
06:15 -
13 – DAverage
02:12 -
14 – DCount Function
01:47 -
15 – Subtotal
03:29
Section 4 – Data Validation
-
16 – Data Validation – List
05:54 -
17 – Data Validation – Decimal
01:54 -
18 – Input and Error Messages
04:16
Section 5 – Importing and Exporting
-
19 – Importing Data from Text Files
05:35 -
20 – Importing Data from MS Access
06:12 -
21 – Exporting Data to a Text File
03:34
Section 6 – Creating Basic Charts
-
22 – Creating Basic Charts
03:31 -
23 – The Chart Ribbon
03:59 -
24 – Adding and Modifying Data on a Chart
02:17 -
25 – Formatting Charts
04:32
Section 7 – Pivot Tables
-
26 – Understanding Pivot Tables
03:18 -
27 – Creating Pivot Tables
06:15 -
28 – Pivot Table Calculations
03:34 -
29 – Grouping Pivot Table Data
02:52 -
30 – Formatting Pivot Table Data
03:13 -
31 – Drilling Down into Pivot Table Data
03:46 -
32 – Creating Pivot Charts
03:15 -
33 – Filtering Pivot Table Data
03:43 -
34 – Filtering using the Slicer
02:50
Section 8 – Working with Large Data
-
36 – Consolidating Data
05:04 -
35 – Grouping Data
02:52
Section 9 – LookUp Functions
-
37 – VLookUp
02:58 -
38 – HLookUp
03:02 -
39 – Index and Match
04:50
Section 10 – Advanced Functions
-
40 – FV Function
03:38 -
41 – PMT Function
01:37 -
42 – Hyperlinks
03:59 -
43 – Text to Columns
01:31
Section 11 – Excel Intermediate – Conclusion
-
44 – Excel Intermediate – Conclusion
01:37
