Excel Intermediate
Importing Data from Text Files
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
Export Data (csv)
3.53 KB
Export Data (xlsx)
13.95 KB
Import from Access (zip)
476.31 KB
Nails Sales Data (txt)
27.08 KB
Nails (xlsx)
8.08 KB
NorthwindDB (xlsx)
8.08 KB
Scroll to Top