Microsoft Excel Training - Beginner to Expert Level in Hindi

Name: Microsoft Excel Training - Beginner to Expert Level in Hindi
Rating: 4.4 (146 reviews)

This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Excel 2010, 2013, 2016 and 2019

Created byHimanshu Dhar

Last updated 10/2022

Hindi

What you'll learn

Managing data in Excel
Good understanding of Excel at MIS level
Working with Power Pivot and Power Map feature
Learn all the updated features till MS Excel 2019 version
Expertise in Text Function
Expertise in Logical Function
Expertise in Lookup and Reference Function
Expertise in Date and Time Function
Mastery in Pivot Table and Chart Preparation
Mastery in 'What if Analysis' tools
Print Option in Excel
Data Validation, Filter and Conditional Formatting
Working with Draw Tab
Mastery in Data organising Tools in Excel
Mastery in Data creation and Data Manipulation in Excel
Managing data protection and data sharing in Excel
Work with Macro Recording

Course content

11 sections • 65 lectures • 9h 30m total length

Introduction to Excel - Structure17:41
Title Bar, Tabs, Ribbons, Workbooks, Worksheets, Range etc
Customizing Ribbons and options
Equation in Excel - Operators based5:42
How to use operators in Excel to do equation
BODMAS in EXCEL
Equation in Excel - Function based13:58
How to apply functions
SUM()
AVERAGE()
COUNT, COUNTA, COUNTBLANK
MAX, MIN
LARGE, SMALL
Nested Function
Data Validation16:05
Data Validation Types
Input Message
Error Alert Customization
Draw Tab in Excel - Updated5:20

Text Function 1 - Introduction7:40
Introduction to Text Function
UPPER()
LOWER()
PROPER()
TRIM()
Nesting TRIM with other Function
Text Function 2 - LEFT, RIGHT & FIND Function11:25
LEFT()
RIGHT()
FIND()
Text Function 3 - Nested FIND, LEFT & RIGHT8:22
Advance FIND()
Nesting FIND with RIGHT() & LEFT()
Text Function 4 - MID Function10:28
MID Function
Nested MID
Text Function 5 - Concatenate7:51
CONCATENATE()
Nesting CONCATENATE with other Text Function.
Concat and Textjoin Function - Updated4:20
Text Function 6 - REPLACE9:02
REPLACE()
Nested REPLACE()
Text Function 7 - Substitute, Rept & Len5:57
SUBSTITUTE()
REPT()
LEN()
Nested Function
Numbervalue Function - Updated3:24
The Excel NUMBERVALUE function converts a number in text format to numeric value, using specified decimal and group separators.
Text to Column12:14
How to use Text to Column
Delimited & Fixed Width
Date Format through Text to Column

IF Function - Logical Test & Introduction10:07
Logical Test
Introduction to If Function
If Function - Nested8:02
Nested If Examples
IFS Function - Updated4:57
IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
IF Function - Advance8:46
Nesting IF() with other Functions to get desired output
AND() & OR() Function16:54
AND() Function
OR() Function
Nested IF() with AND() & OR()
Advance Examples
Advance Math Function 1 - SUMIF, COUNTIF, AVERAGEIF7:44
SUMIF()
COUNTIF()
AVERAGEIF()
Advance Math Function 2 - SUMIFS, COUNTIFS, AVERAGEIFS8:18
SUMIFS()
COUNTIFS()
AVERAGEIFS()
Wild Card

EMI Calculator - PMT Function5:19
How to create EMI Calculator
Apply PMT() Function
What if Analysis 1 - Data Table9:25
How to create data table
How to format data table
XOR Function - Updated4:34
The XOR function returns a logical Exclusive Or of all arguments.
What if Analysis 2 - Goal Seek6:34
How to apply Goal seek
Get the desired output from complicated equation through Goal Seek
What if Analysis 3 - Scenario Manager11:13
How to Apply Scenario Manager
How to merge Scenario
how to get summary
Pduration Function - Updated2:33
PDURATION() Function helps the user calculate the time or the specific number of periods required for an investment made to reach a particular value

Lookup & Reference 1 - VLOOKUP & HLOOKUP9:12
VLOOKUP()
HLOOKUP()
Lookup & Reference 2 - MATCH, INDEX, OFFSET11:41
MATCH()
INDEX()
Nesting both to get desired result
Lookup & Reference 3 - OFFSET4:16
OFFSET()
Nesting Offset and more example
Lookup & Reference 4 - VLOOKUP TRUE4:40
How to use VLOOKUP() TRUE option
Lookup & Reference 5 - LOOKUP()5:45
LOOKUP()
Drawbacks and how to apply it correctly
Lookup & Reference 6 - Tricks 110:28
How to apply VLOOKUP() in all columns in a single go
Array VLOOKUP()
VLOOKUP() with IFERROR
VLOOKUP with IF
Lookup & Reference 7 - Tricks 25:00
Nested Lookup Function
Advance Level Examples and problem solving

Conditional Formatting 111:39
How to apply conditional formatting
Types of Conditional Formatting
Conditional Formatting 2 - Customize7:13
How to Manage Rules - Edit & Delete
How to apply new Rules - Based on Formulas
Conditional Formatting 35:16
Advance Customize options
Chart Preparation 1 - Introduction15:15
Start with Excel Chart
Understanding Layout options
Chart Preparation 2 - Format, Design, Axis & Series7:59
Chart Format
Chart Design
Handling Axis and Series
Chart Preparation 3 - Customize6:04
Handling Data Series and Legends
Customize options
Power Map in Excel - Updated5:11
Microsoft Power Map for Excel is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways.
Pivot Table 1 - Starts with14:25
How to create Pivot Table
Managing Fields Properly in Field area
Managing Value setting
How to get detailed report
Pivot Table 2 - Exploring Features & Functionality16:28
Managing Field List, Buttons & Field Headers
Refresh Options
Designing Pivot Table
Pivot Table layout
Changing Source Data
Managing Slicer
Pivot Chart
Multiple Pivot Table
Pivot Table 3 - Advance8:57
Handling Dates and Values through Group option
Doing Calculation through Calculated field.
Power Pivot in Excel - Updated29:57
Practice Files are available in Resources
Quick Analysis and Chart Recommendation - Updated4:05

Requirements

Basic of Computer

Description

This course has been updated to the latest Excel 2019 version topics. New topics has been added in such a manner that almost all the topics from 2010, 2013, 2016 and 2019 has been covered.

This is an Excel training program with an effort to put live practical experience in the form of videos. This course will teach you thoroughly on how to manage important tools in Excel and how to apply various functions with nested methodology. It is advisable that you must follow the structure pattern for better understanding.

What can be expected?

At the end of the course you will be able to handle data in excel, also will be able to apply text, logical, math, lookup & reference functions very easily. You will find it easy to manage organizing tools in Excel like charts, pivot table, filter, Conditional Formatting etc.

Who should do this?

If you work on Excel and found it difficult to apply advance functions and tools then this is must course for you. Candidate must have basic computer knowledge and should be aware of Excel environment.

Even though the course which is up right now will be sufficient but every week I will keep on adding more videos.

Who this course is for:

Management Graduates
HR Professionals
Marketing Professionals
MIS Aspirants
Any Graduate

Microsoft Excel Training - Beginner to Expert Level in Hindi

What you'll learn

Explore related topics

Course content

Introduction to Excel5 lectures • 59min

Module 2 - Excel Cell Handling3 lectures • 22min

Module 3 - Text Handling10 lectures • 1hr 21min

Module 4 - Data Management4 lectures • 41min

Module 5 - Logical & Advance Math Functions7 lectures • 1hr 5min

Module 6 - What if Analysis & Financial6 lectures • 40min

Module 7 - LOOKUP & Reference Functions7 lectures • 51min

Module 8 - Data Organizing12 lectures • 2hr 12min

Print Options in Excel - Page Layout2 lectures • 22min

Excel Security Options4 lectures • 23min

Requirements

Description

Who this course is for: