Excel Basic to Advance Training Course in Hindi / Urdu
4.6 (160 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
461 students enrolled

Excel Basic to Advance Training Course in Hindi / Urdu

Excel Basics to Advance Training Course 2020 covers Vlookup , Pivot table , if conditions , dashboard reporting & more
4.6 (160 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
461 students enrolled
Last updated 2/2020
Hindi
Current price: $48.99 Original price: $69.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 20.5 hours on-demand video
  • 5 articles
  • 103 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will have a detailed understanding of advance excel each and every aspect
Requirements
  • To practice on this course , students must have an efficient system with good specifications as this software is large
Description

***** COURSE UPDATED: Jan 2020 *****

If you have already been using Microsoft Excel then you know that the calculation, graphing and tables available help you track, manipulate and report important data. There is more to excel than a few SUMs, though, and this is the training course to get you into the advanced uses of Excel so you can really use the data and numbers you are tracking to your advantage.

No matter if you are beginner or existing user of excel , this course is suitable both. It will improve your skills and open the hidden secrets and wonders of excel possibilities with this versatile spreadsheet program. In this course we will discuss and bring your excel knowledge & skills to the next level.

The course is tremendously comprehensive and the best part is you will learn advance functionalities in small chunks of real practical industry scenario based assignments that is easier for you to digest and follow along

The Ultimate Excel course over 60+ precise videos. Not by discussing only the functionalities but discussing the functionalities and possibilities in excel while doing a real client project.

 In this course I have provided you with free downloadable Excel workbooks for each tutorial    

I have been helping thousands of people further their careers by teaching them Excel the easiest and most comfortable way. These tutorials will give you career-building skills that you can use to become better and more efficient at your job.

The Ability to Master Excel

By the end of this course you will be able to grasp most of the excel advance features that excel amazing tools has to offer. Which enables you to get more power and incredibly reducing you time & effort by increasing your efficiency in data analysis & reporting tasks

What is the target audience?

  • New users, beginners, intermediates and advanced Excel users

What am I going to get from this course?

  • Over 60 lectures and 6 hours of content!

  • Well-designed and easy-to-understand materials

  • Detailed explanations with comprehensible Case Studies based on real situations

  • Downloadable course materials & Workbooks to follow along

  • Lifetime Access to all the lectures on the course.

  • Regular Video updates!

  • Fast and responsive support for any feedback or questions !

  • If you're not Satisfied, there's a 30 day money back guarantee !

By the completion of this course you will:

  • Work comfortably with Microsoft Excel and many of its advanced features

  • Become one of the top Excel users in your team

  • Be much quicker at carrying out regular tasks

  • Know how to create a model with multiple scenarios

Note:

Learning Excel if you are completely new to excel , becoming an excel guru is very easy. But it takes effort & continuous practice. For that we have provided compressive project based assignments videos with downloadable workbooks to follow along. Watch the lectures , try dong that by yourself, pause where ever it is required. But don't try to take it in all at once.

If you feel like you can do 1 section a week, do 1 section a week.

If you have time, do 1 section a day.

But don't stress out.

Best of Luck with Your amazing journey of unfolding unlimited possibilities of excel !

Who this course is for:
  • students of finance , sales and marketing and hr professionals as well administration team all are equally suitable for the course
Course content
Expand all 151 lectures 20:31:03
+ Excel Introduction
10 lectures 01:54:04
Advance Excel Portal Usage Guide
13:51
Important Info
02:14
Marksheet Part 2
12:00
Marksheet Part 3
27:57
Marksheet Part 4
14:54
+ Excel Module 1
21 lectures 02:23:35
Introduction to Modules and Keyboard Shortcuts
09:07
A Unique Searching Technique
07:04
Vlookup Made Even Easier Using Named Ranges
09:02
Data Validation with Error Alerts
02:53
Vlookup in Discount Tables
10:09
Vlookup Dynamic Application
12:55
Vlookup and Error Modification
07:09
HLookup Application
09:19
Test Assignment
02:04
Home Assignment Vlookup Solved
05:20
Repositioning of Data for Advance Vlookup Technique
10:22
Quick Reminder
01:30
1. VLookup with Payroll Taxation
06:01
Additional Fixed charge Taxation with Vlookup
04:16
Index Match Function
11:07
Vlookup for Large Data Reconciliation
04:23
Vlookup for Large Data Reconciliation Part 2
06:19
Introduction to Hyperlinks
05:23
Hyperlinks for Data Mapping
05:00
+ Excel Module 2
23 lectures 02:04:28
How to Edit Multiple Sheets at same time
06:25
Creating Master Total from multiple sheets
03:18
FAQ's Leaving a Review
02:40
Introduction to Sum If Function
06:44
Sumif Method 2
01:34
Countif By Both Methods and Test Assignment
03:47
Two D Sum by Sumifs Using Absolute Relative Ref Mix
13:25
Mix of Absolute and Relative Reference Logic
06:23
Sumifs using Named Ranges From Selection
05:11
Sumifs With Full Column Criteria ref
03:54
Sumif By Class
03:49
Sumif and D formulas Req 1
03:35
Quick Reminder
01:30
Sumif and D formulas Req 2
09:26
Sumif and D Formulas Req 3
08:58
Concept of Auto Totalling Within Data
09:31
Removing and Reapplying Subtotals with different Criteria
02:01
Application of Multiple Subtotals
04:58
Subtotal and Sumif Situations with data Validation
07:21
Advance Filter Part 2
07:09
Advance Filter Part 3
04:20
Additional Point in Advance Filter Part 4
01:43
+ Module 3
40 lectures 04:16:54
Introduction to Module 3 and group function
03:54
Date Functions In Excel
11:48
Time Functions In Excel
04:37
Text Functions and Comments in Excel
07:50
More Text Related Functions in Excel
07:49
Calculate Years of Experience
10:18
Remove Unnecessary Blanks for Data Cleaning
04:33
Conditional Formatting Traditional Method Revision
01:50
Conditional Formatting Self Defined Formula
07:46
Quick Reminder
01:30
Bank Book Reconciliation
06:59
Bank Reconciliation with conditional formatting
06:29
42. Dealing with If Scenarios Excel
06:15
Dealing with IF OR Scenarios
04:06
How to Seperate Data of A cell into Multiple Columns
08:57
Removing Blank Fields (Entire Row)
05:20
Practical Assesment Part 1
09:57
Practical Assesment Part 2
03:13
Practical Assesment Part 3
06:05
Flash Fill Practical Assesment
05:02
Practical Assesment P4- Conditions
04:05
FAQ's Leaving a Review
02:40
Practical Assesment P4- Conditions Solved
06:54
Aged Debtors Analysis Start
10:10
Aged Debtors Analysis Conditions Application
10:49
Aged Debtors Analysis Reconcilliation
09:45
Aged Debtors Analysis Advance Totalling Technique
11:01
Aged Debtors Analysis Applying Advance Conditional Formatting
07:55
Quick Reminder
01:30
Aged Debtors Analysis Conditional Formatting Part 2
03:04
Print Settings in Excel Part 1
07:53
Print Settings in Excel Part 2
06:00
Print Settings in Excel Part 3
04:18
Print Settings in Excel Part 4
08:23
Cheques Printing System Part 2
07:08
Cheques Printing System Part 3
07:21
Cheques Printing System Part 4
05:34
+ Excel Module 4
13 lectures 01:36:30
Introduction to Module 4
06:20
Data Summary Report With Subtotal
06:32
Data Summary outside data with 1 criteria
03:42
Data summary Outside Data with muliple criterias
07:12
Data Analysis Using Pivot Table
08:24
Data Analysis With Pivot Part 2
07:07
Data Analysis With Pivot Part 3
04:10
Data Analysis With Pivot Part 4
09:09
Data Analysis With Pivot Part 5
04:16
Dashboard Reporting Part 1
12:57
Quick Reminder
01:30
Dashboard Final
20:33
Days Calculation According to Working Days
04:38
+ Excel Bookeeping System
2 lectures 20:07
Bookeeping System Part 1
12:27
Bookeeping System Part 2
07:40
+ Excel Live Classroom
36 lectures 07:24:33
Day 1 Part 1
20:26
Day 1 Part 2
20:01
Day 2 Part 1
24:51
Day 2 Part 2
04:06
Day 3 Part 1
18:54
Day 3 Part 2
05:51
Day 4 Part 1
11:55
Day 4 Part 2
10:20
Day 5 Part 1
14:09
Day 5 Part 2
11:01
FAQ's Leaving a Review
02:40
Day 5 Part 3
01:53
Day 6 Part 1
11:30
Day 6 Part 2
04:01
Day 7 Part 1
20:48
Day 7 Part 2
11:36
Quick Reminder
01:30
Day 8 Part 1
11:52
Day 8 Part 2
17:36
Day 9 Part 1
15:31
Day 9 part 2
08:12
Day 9 Part 3
14:52
Day 10 Part 1
23:24
Day 10 Part 2
02:38
Day 11 Part 1
08:15
Day 11 Part 2
04:43
Day 11 Part 3
10:52
Day 12 Part 1
13:12
Day 12 Part 2
12:35
Day 13 Part 1
23:09
Day 13 Part 2
18:36
Day 14 Part 1
11:23
Day 14 Part 2
18:08
Day 15 Part 1
15:48
Day 15 Part 2
16:45
Quick Reminder
01:30
+ FAQS
6 lectures 30:51
Pivot Table Practical Assessment Requirement 1
08:59
Pivot Table Practical Assessment Requirement 2
04:07
Pivot Table Practical Assessment Requirement 3
04:34
Pivot Table Practical Assessment Requirement 3 Part 2
05:29
Convert Date to Proper Format
07:38
Bonus Section
00:04