Course Includes
- Recorded Lessons: 41
- Recorded Hours: 5
- Duration: 5 days (Avg)
Course Features
- Access on mobile
- TDP Assessment Test
- 2 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.