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
Frequently asked questions
Who is this course designed for?
This course is designed for beginners who want to learn the basics of Excel, as well as intermediate users looking to enhance their skills in data analysis, visualization, and automation.
What topics will be covered in the course?
The course will cover a variety of topics, including Excel interface, data entry and formatting, formulas and functions, data analysis tools, charts and graphs, pivot tables, and data visualization techniques.
Do I need prior experience with Excel to take this course?
No prior experience is required. The course is structured to accommodate beginners, but it will also provide valuable insights for those with some experience in Excel.
Are there any prerequisites for this course?
Participants should have a basic understanding of computer usage and familiarity with the Windows operating system. No specific Excel skills are required.
How will the course be delivered?
The course will be delivered online through a series of video lectures, practical exercises. Participants will have access to course materials and resources for self-study.
