Excel Intermediate
- Intermediate
- 0 Total Enrolled
- 4 hours 61 minutes Duration
- 5 August 2025 Last Updated
Hi, Welcome back!
What Will You Learn?
- ● Work with DataBase functions
- ● SumIFs
- ● Be a master with Pivot Tables
- ● Automate, streamline, and completely revolutionize your workflow with Excel
Course Content
Excel Intermediate
-
Intermediate Shortcut Keys
04:00
Lists
-
What are Lists
03:00 -
Sorting a List
01:38 -
Sorting Multiple Criteria
02:18 -
Custom Sort
02:58 -
What are Filters
02:31 -
Format a List as a Table
02:16
DataBase Functions
-
Introduction to DataBase Functions
03:30 -
DSum Function
04:54 -
DSum Function Single Criteria
02:51 -
DSum Function Multiple Criteria
05:04 -
DAverage
02:13 -
DCount Function
01:49 -
Subtotal
03:30
Data Validation
-
Data Validation – List
05:54 -
Data Validation – Decimal
01:54 -
Input and Error Messages
04:16
Importing and Exporting
-
Importing Data from Text Files
05:36 -
Importing Data from MS Access
06:14 -
Exporting Data to a Text File
03:35
Creating Basic Charts
-
Creating Basic Charts
03:32 -
The Chart Ribbon
04:00 -
Adding and Modifying Data on a Chart
02:18 -
Formatting Charts
04:33
Pivot Tables
-
Understanding Pivot Tables
03:19 -
Creating Pivot Tables
06:16 -
Pivot Table Calculations
03:35 -
Grouping Pivot Table Data
02:53 -
Formatting Pivot Table Data
03:14 -
Drilling Down into Pivot Table Data
03:47 -
Creating Pivot Charts
03:16 -
Filtering Pivot Table Data
03:44 -
Filtering using the Slicer
02:51
Working with large data
-
Grouping Data
02:52 -
Consolidating Data
05:04
LookUp Functions
-
VLookUp
02:58 -
HlookUp
03:02 -
Index and Match
04:50
Advanced Functions
-
Text to Columns
01:32 -
Hyperlinks
04:00 -
PMT Function
01:38 -
FV Function
03:39
Excel Intermediate – Conclusion
-
Excel Intermediate – Conclusion
01:38
Student Ratings & Reviews
No Review Yet