Course Includes
-
Recorded Lessons: 41
-
Recorded Hours: 5
-
Duration:
5 days (Avg)
Course Features
Access on mobile
TDP Assessment Test-
3 Jobs Available
Top Skills Covered
Overview
Course Description
You will learn start from basics to advanced concepts in Microsoft Excel including Charts, Data Reports, Lookup Functions, Analyzing Data, Preparing Dashboard Reports and Macro's.
What you'll learn
- Basic Level of Concepts in Excel
- Intermediate Level of Concepts in Excel
- Advanced Level of Concepts in Excel
Requirements
- Anyone with laptop for Excel practice may start learning the course
Course Content
41 Lessons | 5:00 Total hours
Basic Level of Microsoft Excel
-
Introduction to Excel Workbooks 00:03:56 -
Data entry, Changes and Delete 00:04:45
-
Navigating and Selecting data 00:09:53
-
Auto Fill Handle & View options 00:14:08
-
Formulas and Its Practical Use 00:11:09
-
Functions (Auto Sum, Average, Max and Min) 00:07:32
-
Absolute Cell Reference 00:04:44
-
Perform Calculations across multiple sheets 00:07:31
-
Font Format and Borders 00:06:44
-
Format Painter & Alignment Tools 00:08:01
-
Number and Cell Format 00:08:11
-
Styles & Themes 00:04:48
-
Graphics 00:08:41
-
Find & Replace and Conditional Formatting 00:07:15
-
Filtering and Sorting 00:06:04
-
Print Preview & Page Layout Tools 00:09:16
Intermediate Level of Microsoft Excel
-
About Charts and Graphs 00:08:33
-
Working with Multiple Sheets and 3D Formulas 00:11:37
-
Linking Workbooks and Consolidate Tool 00:08:28
-
Combine Text and Text Case 00:04:33
-
Extracting Text and Find Function 00:06:19
-
Date Calculations 00:03:51
-
Named Ranges 00:05:48
-
Editing and Deleting Named Ranges 00:04:29
-
Count Functions 00:10:18
-
Sparkline & Trendline 00:04:26
-
Create Table and Table tool Options 00:08:22
-
Automation with Tables 00:04:31
-
Sub Total & Convert to Range 00:05:18
Advanced Level of Microsoft Excel
-
Pivot Table 00:04:15
-
Pivot Table Options 00:05:17
-
Pivot Chart & Slicer 00:10:25
-
Data Validation 00:09:26
-
Data Validation using Formulas 00:06:06
-
Advanced Conditional Formatting 00:05:47
-
Logical IF, AND & OR Functions 00:07:37
-
Error handling with IFERROR & IFNA 00:02:40
-
Lookup Functions CHOOSE & VLOOKUP 00:08:21
-
Lookup Functions INDEX & MATCH 00:06:01
-
How to Record Macro 00:08:39
-
How to Run Macro 00:04:56
Jobs based on course skills
