Excel Intermediate
Introduction to DataBase Functions
Excel Intermediate
0%
Completed
Excel Intermediate
Intermediate Shortcut Keys
Video - 00:4:00 mins
Lists
What are Lists
Video - 00:3:00 mins
Sorting a List
Video - 00:1:38 mins
Sorting Multiple Criteria
Video - 00:2:18 mins
Custom Sort
Video - 00:2:58 mins
What are Filters
Video - 00:2:31 mins
Format a List as a Table
Video - 00:2:16 mins
DataBase Functions
Introduction to DataBase Functions
Video - 00:3:30 mins
DSum Function
Video - 00:4:54 mins
DSum Function Single Criteria
Video - 00:2:51 mins
DSum Function Multiple Criteria
Video - 00:5:4 mins
DAverage
Video - 00:2:13 mins
DCount Function
Video - 00:1:49 mins
Subtotal
Video - 00:3:30 mins
Data Validation
Data Validation - List
Video - 00:5:54 mins
Data Validation - Decimal
Video - 00:1:54 mins
Input and Error Messages
Video - 00:4:16 mins
Importing and Exporting
Importing Data from Text Files
Video - 00:5:36 mins
Importing Data from MS Access
Video - 00:6:14 mins
Exporting Data to a Text File
Video - 00:3:35 mins
Creating Basic Charts
Creating Basic Charts
Video - 00:3:32 mins
The Chart Ribbon
Video - 00:4:00 mins
Adding and Modifying Data on a Chart
Video - 00:2:18 mins
Formatting Charts
Video - 00:4:33 mins
Pivot Tables
Understanding Pivot Tables
Video - 00:3:19 mins
Creating Pivot Tables
Video - 00:6:16 mins
Pivot Table Calculations
Video - 00:3:35 mins
Grouping Pivot Table Data
Video - 00:2:53 mins
Formatting Pivot Table Data
Video - 00:3:14 mins
Drilling Down into Pivot Table Data
Video - 00:3:47 mins
Creating Pivot Charts
Video - 00:3:16 mins
Filtering Pivot Table Data
Video - 00:3:44 mins
Filtering using the Slicer
Video - 00:2:51 mins
Working with large data
Grouping Data
Video - 00:2:52 mins
Consolidating Data
Video - 00:5:4 mins
LookUp Functions
VLookUp
Video - 00:2:58 mins
HlookUp
Video - 00:3:2 mins
Index and Match
Video - 00:4:50 mins
Advanced Functions
Text to Columns
Video - 00:1:32 mins
Hyperlinks
Video - 00:4:00 mins
PMT Function
Video - 00:1:38 mins
FV Function
Video - 00:3:39 mins
Excel Intermediate – Conclusion
Excel Intermediate - Conclusion
Video - 00:1:38 mins
More
Announcements
Reviews
Course Info
Exercise Files
DataBase Functions (xlsx)
13.30 KB
Scroll to Top