Advanced Excel Course Online
About Course
This course is about advanced Microsoft Excel, which is a very widely used software application in a wide range of industries. Having a good knowledge of MS Excel can prove to be an added advantage for your career, or your business. Once you are done with the course, you will be able to use many of the options in MS Excel.
What Will You Learn?
- Fundamentals of MS Excel from scratch.
- functions in MS Excel.
- Shortcut keys.
- Learn to use many different features in MS Excel.
Course Content
Introduction to Advance Excel
Welcome to the course on MS excel, where we are going to learn many fundamental things about Microsoft Excel application, which is a very widely used software across different industries. This course covers many concepts from fundamental to critical, starting from saving the worksheet or aligning the text, to data validation, charts and much more.
-
Introduction to Advance Excel
01:59
Advance Functions
-
SUMIF and SUMIFS function
27:21 -
Countif and Countifs Functions
15:59 -
AVERAGEIF AND AVERAGEIFS function
07:02
Text functions
-
LEN function
02:28 -
Lower Upper and Proper functions
07:42 -
TRIM function
03:21 -
Left Mid and Right function
13:43 -
CONCAT function
02:17 -
Exact function
02:58
Lookup functions
-
VLOOKUP
17:39 -
HLOOKUP
10:50 -
XLOOKUP basics
11:55 -
VLOOKUP across sheets
05:28
Conditional Statements
-
Simple IF function
04:37 -
Nested If function
11:44 -
If with an AND
07:04 -
IF with an OR
07:25 -
IFERROR function
04:41
Pivot Tables
-
What is a pivot table
13:03 -
How to create pivot Table
19:38
Power Query
-
Power Query
31:09
Charts
-
Column chart
14:34 -
Line chart
11:10 -
Pie Chart
14:05 -
bubble chart
09:42 -
XY scatter chart
12:42
Dashboard
-
Dashboard Video example
45:33 -
Sales Dashboard Example 2
51:42
VBA and Macros
-
VBA For excel – Introduction
10:45 -
How to enable Developer Tab
05:00 -
Macros
23:36 -
Recording a Macro and observing the code
10:48 -
Rules for naming variables and more about variables
13:20 -
First VBA Program
07:40 -
variables in VBA Excel
16:26 -
comments in VBA
08:31 -
Copy and paste using VBA
07:57 -
Cell referencing
21:50 -
getting input from the user
10:42 -
Showing the output
06:06
Operators in VBA
-
Operators in VBA introduction
02:55 -
Operators – Arithmetic Operators in VBA
08:42 -
Operators – Comparison Operators
07:36 -
Logical Operators in VBA
15:05 -
Concatenation operators in VBA
06:20
If else if in VBA
-
If else statement basics
18:38 -
If elseIf in VBA
13:28
Looping
-
For Next loop
24:23 -
Do Until Loop
11:04 -
Do while loop
39:15
Functions
-
Functions in VBA
27:52
Sub procedure in VBA
-
Sub procedure in VBA
13:13
events
-
What are events in MS Excel
02:00 -
What are the different levels of events
06:01 -
worksheet level events
17:11 -
Workbook level events
22:42
Errors in VBA
-
What are errors in VBA
20:40 -
Error handling
20:26
