Microsoft Excel Complete Course | All in one MS Excel Course
Excel the Microsoft Excel Skills By joining the Complete MS Excel Training Course.
Microsoft Excel is a basic & must-learn skill in today’s world for almost everyone. MS Excel is one of the most used products of Microsoft office. It is being used in almost every business, every corporation, and institution for data entry, data analysis, data presentation, data consolidation, or data calculation. Microsoft Excel is a very user-friendly, easy-to-use & interactive software that will give the desired results accurately & within no time. Even if you never used Microsoft Excel before still, you will not feel any difficulty in learning the MS Excel software.
This MS Excel course is ‘All in one complete’ Excel training from beginner to advanced level. If you are an engineer, auditor, data analyst, data scientist, data entry operator, student, teacher, or researcher you can choose this course to gain the skill as per your requirement even if you are from any other background & you want to gain the skill you are more than welcome here.
This Microsoft Excel course has a total of 55 video lectures with a total length of 6 hours. This course is designed by keeping in mind the beginner or entry-level approach but if you already have some knowledge about MS excel or worked before in Excel then you can skip those basic level lectures.
This course is designed in Microsoft Excel 2016 version but it can be easily learned in almost any older or latest version of MS Excel.
Microsoft Excel shortcut keys file & some sample excel files are attached as resources. You can download & practice on it.
This course is divided into the following different sections:
1. Introduction
2. Math & Auto Sum Functions
3. Cell Name & Cell References
4. Home Tab
5. Operator, Equations & Excel Errors
6. Logical Functions
7. Lookup Functions
8. Auditing Tools in Excel
9. Insert Tab
10. Info, Text, Date & Time, and Reference Functions
11. Page Layout & View Tab Options
12. Data Tab
13. Dashboards in Excel
14. Developer Tab
There are so many topics to learn under these sections & you will be going to learn a lot more which will definitely add value to your work.
So, Hit the Enroll Now Button & Enjoy the Course. Happy Learning!
Math & Auto Sum Functions
Cell Name & Cell References
-
2
Basic Mathematical FunctionsIn this video, you will learn about Basic Math Functions like sum, max, min, & count, etc.
-
3
AutoSum Functions
In this video, you will learn about different AutoSum options in Excel.
-
4
Sum IF Function & Remove Duplicates Option
In this video, you will learn about Sum IF Function & Remove duplicates option from Data Tab in Excel.
-
5
Sum IF & Sum IFs, Count IF & Count IFs Functions
In this video, you will learn about Sum IF & Sum IFs, Count IF & Count IFs Functions in Excel.
-
6
Sub Total Function
In this video, you will learn about Sub Total Function in Excel.
-
7
Arrays & Sum Product Functions
In this video, you will learn about Arrays & Sum-Product Functions in Excel.
-
8
Other Mathematical Functions
In this video, you will learn about Some other Math Functions like exponent, square root, etc.
Home Tab
Operators, Equations & Excel Errors
-
11
Formatting in Excel
In this video, you will learn about the Formatting Options in Excel.
-
12
Excel Data Types
In this video, you will learn about Excel Data Types.
-
13
Roaming in Excel
In this video, you will learn about some shortcut keys for Roaming in Excel.
-
14
Go to & Replace Options
In this video, you will learn about the Go to & Replace Options in Excel.
-
15
Auto Fill Options
In this video, you will learn about AutoFill Options in Excel.
-
16
Copy, Paste & Paste Special Options
In this video, you will learn about Copy, Paste & Paste Special Options in Excel.
-
17
Conditional Formatting
In this video, you will learn about Conditional Formatting.
-
18
Sort & Filter Options
In this video, you will learn about Sort & Filter options.
Logical Functions
LOOKUP Functions
-
22
Logical Function IF
In this video, you will learn about the Logical Function IF in Excel.
-
23
Logical Function IF Error
In this video, you will learn about the Logical Function IF Error in Excel.
-
24
Logical Function (IF, Nested IF, OR)
In this video, you will learn about the Logical Functions (IF, Nested IF, OR) in Excel.
-
25
Logical Function AND
In this video, you will learn about the Logical Function AND in Excel.
Auditing Tools in Excel
-
26
VLOOKUP Function
In this video, you will learn about the VLOOKUP Function.
-
27
VLOOKUP Function with Data Validation
In this video, you will see the VLOOKUP Function with the Data Validation option.
-
28
VLOOKUP Function with Wildcard
In this video, you will learn about the VLOOKUP Function with Wildcard.
-
29
VLOOKUP with Helper Column
In this video, you will learn about the VLOOKUP Function with Helper Column.
-
30
Nested VLOOKUP
In this video, you will learn about the Nested VLOOKUP Function.
-
31
HLOOKUP Function
In this video, you will learn about the HLOOKUP Function.
Insert Tab
Info, Text, Date, Time & Reference Functions
-
34
Selecting the Chart
In this video, you will learn how to Select the Right Chart for the Data.
-
35
Charts in Excel
In this video, you will learn about Charts in Excel.
-
36
Tables in Excel
In this video, you will learn about Tables in Excel.
-
37
Pivot Table & Chart in Excel
In this video, you will learn about Pivot Table & Pivot Chart in Excel.
-
38
Sparklines & Slicer Filter Options
In this video, you will learn about the Sparklines & Slicer filter options.
-
39
Inserting Comments
In this video, you will learn about Inserting Comments in Cells.
-
40
Inserting Hyperlink
In this video, you will learn about different Hyperlink Inserting Options.
Page Layout Tab & View Tab Options
Dashboards in Excel
-
45
Text to Columns Tool
In this video, you will learn about the Text to Columns option in Data Tab.
-
46
Data Consolidation in Excel
In this video, you will learn about Data Consolidation in Excel from within the same sheet, from different sheets & from different workbooks.
-
47
Scenario Manager Option
In this video, you will learn about the Scenario Manager option in 'What If Analysis'
-
48
Goal Seek Option
In this video, you will learn about the Goal Seek option in 'What If Analysis'
-
49
Data Table Option
In this video, you will learn about the Data Table option in 'What If Analysis'
-
50
Queries in Excel | Import External Data
In this video, you will learn about the MS Excel Queries & How to Import Data in Excel.
