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
-
2Basic Mathematical Functions
In this video, you will learn about Basic Math Functions like sum, max, min, & count, etc.
-
3AutoSum Functions
In this video, you will learn about different AutoSum options in Excel.
-
4Sum IF Function & Remove Duplicates Option
In this video, you will learn about Sum IF Function & Remove duplicates option from Data Tab in Excel.
-
5Sum 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.
-
6Sub Total Function
In this video, you will learn about Sub Total Function in Excel.
-
7Arrays & Sum Product Functions
In this video, you will learn about Arrays & Sum-Product Functions in Excel.
-
8Other Mathematical Functions
In this video, you will learn about Some other Math Functions like exponent, square root, etc.
Home Tab
Operators, Equations & Excel Errors
-
11Formatting in Excel
In this video, you will learn about the Formatting Options in Excel.
-
12Excel Data Types
In this video, you will learn about Excel Data Types.
-
13Roaming in Excel
In this video, you will learn about some shortcut keys for Roaming in Excel.
-
14Go to & Replace Options
In this video, you will learn about the Go to & Replace Options in Excel.
-
15Auto Fill Options
In this video, you will learn about AutoFill Options in Excel.
-
16Copy, Paste & Paste Special Options
In this video, you will learn about Copy, Paste & Paste Special Options in Excel.
-
17Conditional Formatting
In this video, you will learn about Conditional Formatting.
-
18Sort & Filter Options
In this video, you will learn about Sort & Filter options.
Logical Functions
LOOKUP Functions
-
22Logical Function IF
In this video, you will learn about the Logical Function IF in Excel.
-
23Logical Function IF Error
In this video, you will learn about the Logical Function IF Error in Excel.
-
24Logical Function (IF, Nested IF, OR)
In this video, you will learn about the Logical Functions (IF, Nested IF, OR) in Excel.
-
25Logical Function AND
In this video, you will learn about the Logical Function AND in Excel.
Auditing Tools in Excel
-
26VLOOKUP Function
In this video, you will learn about the VLOOKUP Function.
-
27VLOOKUP Function with Data Validation
In this video, you will see the VLOOKUP Function with the Data Validation option.
-
28VLOOKUP Function with Wildcard
In this video, you will learn about the VLOOKUP Function with Wildcard.
-
29VLOOKUP with Helper Column
In this video, you will learn about the VLOOKUP Function with Helper Column.
-
30Nested VLOOKUP
In this video, you will learn about the Nested VLOOKUP Function.
-
31HLOOKUP Function
In this video, you will learn about the HLOOKUP Function.
Insert Tab
Info, Text, Date, Time & Reference Functions
-
34Selecting the Chart
In this video, you will learn how to Select the Right Chart for the Data.
-
35Charts in Excel
In this video, you will learn about Charts in Excel.
-
36Tables in Excel
In this video, you will learn about Tables in Excel.
-
37Pivot Table & Chart in Excel
In this video, you will learn about Pivot Table & Pivot Chart in Excel.
-
38Sparklines & Slicer Filter Options
In this video, you will learn about the Sparklines & Slicer filter options.
-
39Inserting Comments
In this video, you will learn about Inserting Comments in Cells.
-
40Inserting Hyperlink
In this video, you will learn about different Hyperlink Inserting Options.
Page Layout Tab & View Tab Options
Dashboards in Excel
-
45Text to Columns Tool
In this video, you will learn about the Text to Columns option in Data Tab.
-
46Data 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.
-
47Scenario Manager Option
In this video, you will learn about the Scenario Manager option in 'What If Analysis'
-
48Goal Seek Option
In this video, you will learn about the Goal Seek option in 'What If Analysis'
-
49Data Table Option
In this video, you will learn about the Data Table option in 'What If Analysis'
-
50Queries in Excel | Import External Data
In this video, you will learn about the MS Excel Queries & How to Import Data in Excel.