MS Excel Beginner to Intermediate Level Training
- Description
- Curriculum
- FAQ
- Reviews
Make Your Work Easier By Learning this Microsoft Excel course.
Microsoft Excel is one of the most used products of Microsoft office & used for data entry, data analysis, data presentation, or calculation. This MS Excel course is Beginner to Intermediate Level training especially for engineers, auditors, record keepers, data analysts, data entry operators, students, teachers, or researchers, or for anyone who just wants to learn MS Excel. If your interest lies in any of the above-mentioned areas or any other field where Excel is used then this MS Excel training course really going to help in your work.
Excluding the preview video, this Microsoft Excel course has a total of 42 video lectures with a total length of almost 4.5 hours. This course is designed by assuming that you have very basic knowledge of excel or you are totally beginner & started using MS Excel the very first time. Just to facilitate the beginners, some basic or entry-level topics are also included but you can skip those if you already have the basic knowledge.
This course is designed in Microsoft Excel 2016 version but you can easily learn in almost any older or latest version of MS Excel.
Excel sample files or excel practice worksheets are attached that you can download & practice on. Also, the MS excel shortcut keys file is attached.
This course is divided into the following different sections:
1. Introduction
2. Mathematical Functions in Excel
3. Absolute & Relative References and Excel Cell Name
4. Formatting & Data Types in Excel
5. Roaming in Excel Worksheet or Workbook
6. Operators & Equations in Excel
7. AutoFill, Paste Special Options & Excel Errors
8. Logical Functions in Excel
9. VLOOKUP Function in Excel
10. Auditing in Excel
11. Inserting Charts, Tables, Comments & Hyperlink
12. Info, Text, Date, Time & Reference Functions
13. Data Tools in Excel
14. Conditional Formatting, Sort & Filter Options
15. Printing & Viewing
I strongly believe that this MS excel course will really be worth watching for you & I am sure that you will be very happy to choose this.
Just hit the enroll button & start learning today.
-
2
Basic Math FunctionsIn this video, you will learn about some Basic Mathematical Functions in MS Excel.
-
3
Auto Sum in Excel
In this video, you will learn about the AutoSum option in MS Excel.
-
4
Sum IF Function & Remove Duplicates Option in MS Excel
In this video, you will learn about the Sum If function & Remove Duplicates option in MS Excel.
-
5
Sum IF & Sum IFs, Count IF & Count IFs Functions in Excel
In this video, you will learn about the Sum IF, Sum IFs, Count IF & Count IFs functions in MS Excel.
-
6
Sub Total Function in Excel
In this video, you will learn about the Sub Total function in MS Excel.
-
7
Arrays & Sum Product Function in Excel
In this video, you will learn about the Array & Sum-Product Functions in MS Excel.
-
8
Some Other Math Functions
In this video, you will learn about some other common Mathematical Functions in MS Excel.
-
9
Quiz #02 - Mathematical Functions in ExcelAt the end of the section, you are asked to attempt the quiz. Please read carefully & attempt all.
-
10
Absolute & Relative References in Excel
In this video, you will learn about the Absolute & Relative References in MS Excel.
-
11
Cell or Range Name in Excel
In this video, you will learn about the Cell or Range Name in MS Excel.
-
12
Quiz #03 - Absolute & Relative References and Cell Names in Excel
At the end of the section, you are asked to attempt the quiz. Please read carefully & attempt all.
-
13
Formatting Techniques in Excel
In this video, you will learn about the different formatting techniques in MS Excel.
-
14
Data Types in Excel
In this video, you will learn about the multiple Data Types in MS Excel.
-
15
Quiz #04 - Formatting & Data Types
At the end of the section, you are asked to attempt the quiz. Please read carefully & attempt all.
-
16
Roaming in Excel Worksheet
In this video, you will learn how to roam in an excel sheet by using shortcuts keys.
-
17
Go to & Replace Options
In this video, you will learn about the Go to & Replace options in MS Excel.
-
18
Quiz #05 - Roaming in Excel
At the end of the section, you are asked to attempt the quiz. Please read carefully & attempt all.
-
19
Operators Used in Excel
In this video, you will learn about the Operators in MS Excel.
-
20
Equation Writing or Solving in Excel
In this video, you will learn about writing or solving equations in MS Excel.
-
21
Quiz #06 - Operators & Equations in Excel
At the end of the section, you are asked to attempt the quiz. Please read carefully & attempt all.
-
22
Auto Filling the Data in Excel
In this video, you will learn about the AutoFill option in MS Excel.
-
23
Copy, Paste & Paste Special Options
In this video, you will learn about the Copy, Paste & Paste Special options in MS Excel.
-
24
Excel Errors
In this video, you will learn about the Errors in MS Excel sheets.
-
25
Logical Function IF
In this video, you will learn about the Logical Function IF in MS Excel.
-
26
Logical Function IF Error
In this video, you will learn about the Logical Function IF Error in MS Excel.
-
27
Logical Functions (IF, Nested IF, OR)
In this video, you will learn about the Logical Functions (IF, Nested IF, OR) in MS Excel.
-
28
Logical Function AND
In this video, you will learn about the Logical Function AND in MS Excel.
-
29
VLOOKUP Function
In this video, you will learn about the VLOOKUP Function in MS Excel.
-
30
VLOOKUP with Data Validation
In this video, you will learn about the VLOOKUP Function with the Data Validation option in MS Excel.
-
31
VLOOKUP with Wildcard
In this video, you will learn about the VLOOKUP Function with Wildcard.
-
32
VLOOKUP with Helper Column
In this video, you will learn about the VLOOKUP Function with Helper Column.
-
33
Nested VLOOKUP
In this video, you will learn about the Nested VLOOKUP Function in MS Excel.
-
34
Auditing Using Charts
In this video, you will learn how to quickly Audit the Excel sheet using Charts.
-
35
Sheet Formulas Auditing in Excel
In this video, you will learn how to Audit the Excel Sheet Formulas.
-
36
Quiz #10 - Auditing in Excel
At the end of the section, you are asked to attempt the quiz. Please read carefully & attempt all.
-
37
Charts in Excel
In this video, you will learn about the Charts in MS Excel.
-
38
Tables in Excel
In this video, you will learn about the Tables in MS Excel.
-
39
Inserting Comments
In this video, you will learn how to insert comments to the cell in MS Excel.
-
40
Inserting Hyperlink
In this video, you will learn about the Hyperlink option in MS Excel.
-
41
Quiz #11 - Charts, Tables, Comments & Hyperlink
At the end of the section, you are asked to attempt the quiz. Please read carefully & attempt all.
-
47
Conditional Formatting
In this video, you will learn about Conditional Formatting in MS Excel.
-
48
Sort & Filter
In this video, you will learn about Sort & Filter options in MS Excel.
-
49
Quiz #14 - Conditional Formatting, Sort & Filter
At the end of the section, you are asked to attempt the quiz. Please read carefully & attempt all.
