
In this video, you will see the Introduction of the MS Excel Interface.
In this video, you will learn about Basic Math Functions like sum, max, min, & count, etc.
In this video, you will learn about different AutoSum options in Excel.
In this video, you will learn about Sum IF Function & Remove duplicates option from Data Tab in Excel.
In this video, you will learn about Sum IF & Sum IFs, Count IF & Count IFs Functions in Excel.
In this video, you will learn about Sub Total Function in Excel.
In this video, you will learn about Arrays & Sum-Product Functions in Excel.
In this video, you will learn about Some other Math Functions like exponent, square root, etc.
In this video, you will learn about Cell or Range Name & their use in Excel Functions.
In this video, you will learn about Absolute & Relative Data Cell References.
In this video, you will learn about the Formatting Options in Excel.
In this video, you will learn about Excel Data Types.
In this video, you will learn about some shortcut keys for Roaming in Excel.
In this video, you will learn about the Go to & Replace Options in Excel.
In this video, you will learn about AutoFill Options in Excel.
In this video, you will learn about Copy, Paste & Paste Special Options in Excel.
In this video, you will learn about Conditional Formatting.
In this video, you will learn about Sort & Filter options.
In this video, you will learn about Operators used in Excel.
In this video, you will learn about Equation Writing or Solving in Excel.
In this video, you will learn about Excel Sheet Errors.
In this video, you will learn about the Logical Function IF in Excel.
In this video, you will learn about the Logical Function IF Error in Excel.
In this video, you will learn about the Logical Functions (IF, Nested IF, OR) in Excel.
In this video, you will learn about the Logical Function AND in Excel.
In this video, you will learn about the VLOOKUP Function.
In this video, you will see the VLOOKUP Function with the Data Validation option.
In this video, you will learn about the VLOOKUP Function with Wildcard.
In this video, you will learn about the VLOOKUP Function with Helper Column.
In this video, you will learn about the Nested VLOOKUP Function.
In this video, you will learn about the HLOOKUP Function.
In this video, you will learn how to quickly Audit the Sheet using Charts.
In this video, you will learn about the Sheet Formulas Auditing Tools.
In this video, you will learn how to Select the Right Chart for the Data.
In this video, you will learn about Charts in Excel.
In this video, you will learn about Tables in Excel.
In this video, you will learn about Pivot Table & Pivot Chart in Excel.
In this video, you will learn about the Sparklines & Slicer filter options.
In this video, you will learn about Inserting Comments in Cells.
In this video, you will learn about different Hyperlink Inserting Options.
In this video, you will learn about Info Functions in Excel.
In this video, you will learn about Text Functions in Excel.
In this video, you will learn about Date, Time & Reference Functions in Excel.
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!