Excel Training in Hindi
4.3 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
95 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Training in Hindi to your Wishlist.

Add to Wishlist

Excel Training in Hindi

Learn to manage complex data in Excel with ease
4.3 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
95 students enrolled
Last updated 4/2016
Hindi
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 8.5 hours on-demand video
  • 11 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Manage data in Excel
  • How to use Excel Functions and nested functions
  • Use of Advance tools in Excel
  • Developing problem solving ability related to Excel
View Curriculum
Requirements
  • Basic of Computer
Description

This is an Excel training program with an effort to put live practicals experience in the form of videos. This course will taught 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 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 is the target audience?
  • Management Graduates
  • HR Professionals
  • Marketing Professionals
  • MIS Aspirants
  • Any Graduate
Curriculum For This Course
55 Lectures
08:23:17
+
Introduction to Excel
3 Lectures 39:28
  1. Title Bar, Tabs, Ribbons, Workbooks, Worksheets, Range etc
  2. Customizing Ribbons and options
Preview 17:41

  • How to use Operation in Excel to do equation
  • BODMAS in EXCEL
Equation in Excel - Operators based
05:42

  • Data Validation Types
  • Input Message
  • Error Alert Customization
Data Validation
16:05
+
Module 2 - Excel Cell handling & Function
3 Lectures 32:15
  • How to apply functions
  • SUM()
  • AVERAGE()
  • COUNT, COUNTA, COUNTBLANK
  • MAX, MIN
  • LARGE, SMALL
  • Nested Function
Equation in Excel - Function based
13:58

  • Cell Properties
  • Text Autofill
  • Date Autofill
  • Number Autofill


Cell Properties and Autofill
13:31

  • Relative Reference
  • Absolute Reference
  • Mixed Reference
Preview 04:46
+
Module 3 - Text Handling
8 Lectures 01:12:59
  • Introduction to Text Function
  • UPPER()
  • LOWER()
  • PROPER()
  • TRIM()
  • Nesting TRIM with other Function
Text Function 1 - Introduction
07:40

  • LEFT()
  • RIGHT()
  • FIND()
Text Function 2 - LEFT, RIGHT & MID Function
11:25

  • Advance FIND()
  • Nesting FIND with RIGHT() & LEFT()
Text Function 3 - Nested FIND, LEFT & RIGHT
08:22

  • MID Function
  • Nested MID
Text Function 4 - MID Function
10:28

  • CONCATENATE()
  • Nesting CONCATENATE with other Text Function.
Text Function 5 - Concatenate
07:51

  • REPLACE()
  • Nested REPLACE()
Text Function 6 - REPLACE
09:02

  • SUBSTITUTE()
  • REPT()
  • LEN()
  • Nested Function
Text Function 7 - Substitute, Rept & Len
05:57

  • How to use Text to Column
  • Delimited & Fixed Width
  • Date Format through Text to Column
Text to Column
12:14
+
Module 4 - Data Management
4 Lectures 41:18
  • How to Apply Filter correctly
  • How to use Filter
  • Text Filter
Use of Filter 1
09:49

  • Number Filter
  • Date Filter
  • Filter by Color
Use of Filter 2
06:33

  • How to naming Ranges
  • Advantages of it
Define Name
12:32

  • Types of Hyperlink
  • How to Apply it
Hyperlink in Excel
12:24
+
Module 5 - Logical & Advance Math Functions
6 Lectures 59:51
  • Logical Test
  • Introduction to If Function
Preview 10:07

  • Nested If Examples
If Function - Nested
08:02

  • Nesting IF() with other Functions to get desiredoutput
IF Function - Advance
08:46

  • AND() Function
  • OR() Function
  • Nested IF() with AND() & OR()
  • Advance Examples
AND() & OR() Function
16:54

  • SUMIF()
  • COUNTIF()
  • AVERAGEIF()
Advance Math Function 1 - SUMIF, COUNTIF, AVERAGEIF
07:44

  • SUMIFS()
  • COUNTIFS()
  • AVERAGEIFS()
  • Wild Card
Advance Math Function 2 - SUMIFS, COUNTIFS, AVERAGEIFS
08:18
+
Module 6 - What if Analysis & Financial
4 Lectures 32:31
  • How to create EMI Calculator
  • Apply PMT() Function
EMI Calculator - PMT Function
05:19

  • How to create data table
  • How to format data table
What if Analysis 1 - Data Table
09:25

  • How to apply Goal seek
  • Get the desired output from complicated equation through Goal Seek
What if Analysis 2 - Goal Seek
06:34

  • How to Apply Scenario Manager
  • How to merge Scenario
  • how to get summary
What if Analysis 3 - Scenario Manager
11:13
+
Module 7 - LOOKUP & Reference Functions
7 Lectures 51:02
  • VLOOKUP()
  • HLOOKUP()
Lookup & Reference 1 - VLOOKUP & HLOOKUP
09:12

  • MATCH()
  • INDEX()
  • Nesting both to get desired result
Lookup & Reference 2 - MATCH, INDEX, OFFSET
11:41

  • OFFSET()
  • Nesting Offset and more example
Lookup & Reference 3 - OFFSET
04:16

  • How to use VLOOKUP() TRUE option
Lookup & Reference 4 - VLOOKUP TRUE
04:40

  • LOOKUP()
  • Drawbacks and how to apply it correctly
Lookup & Reference 5 - LOOKUP()
05:45

  • How to apply VLOOKUP() in all columns in a single go
  • Array VLOOKUP()
  • VLOOKUP() with IFERROR
  • VLOOKUP with IF
Lookup & Reference 6 - Tricks 1
10:28

  • Nested Lookup Function
  • Advance Level Examples and problem solving
Lookup & Reference 7 - Tricks 2
05:00
+
Module 8 - Data Organizing
9 Lectures 01:33:16
  • How to apply conditional formatting
  • Types of Conditional Formatting


Conditional Formatting 1
11:39

  • How to Manage Rules - Edit & Delete
  • How to apply new Rules - Based on Formulas
Conditional Formatting 2 - Customize
07:13

  • Advance Customize options
Conditional Formatting 3
05:16

  • Start with Excel Chart
  • Understanding Layout options
Chart Preparation 1 - Introduction
15:15

  • Chart Format
  • Chart Design
  • Handling Axis and Series
Chart Preparation 2 - Format, Design, Axis & Series
07:59

  • Handling Data Series and Legends
  • Customize options
Chart Preparation 3 - Customize
06:04

  • How to create Pivot Table
  • Managing Fields Properly in Field area
  • Managing Value setting
  • How to get detailed report

Pivot Table 1 - Starts with
14:25

  • 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 2 - Exploring Features & Functionality
16:28

  • Handling Dates and Values through Group option
  • Doing Calculation through Calculated field.
Pivot Table 3 - Advance
08:57
+
Print Options in Excel - Page Layout
2 Lectures 22:04
  • How to set and customize margin
  • page orientation and paper size
  • Print Area & Page Break
  • Set Image as a background
Print Options 1 - Page Layout
11:39

  • How to Repeat heading on each page
  • print pattern
  • customize header and footer
  • How to apply image like a watermark in Excel
Print Options 2- Advance Options
10:25
+
Excel Security Options
4 Lectures 23:10
  • How to protect workbook
  • how and when you may use this option
Protect Workbook
04:06

  • How to Protect sheet
  • how to allow cells for changes
Protect Sheet
06:16

  • How to hide formulas
  • How to customize protect related options
  • Making workbook password protected
Protection Advance Options
09:32

  • How to enable share workbook option
  • how and when to use it
Share Workbook
03:16
1 More Section
About the Instructor
Sr MIS Trainer Himanshu Dhar
4.1 Average rating
35 Reviews
656 Students
3 Courses
MIS Trainer

My Name is Himanshu Dhar. I am an MIS trainer from I Turn Institute. I am having more then 6 years of experience in different projects in Excel and Macros. I do take care of free lancing projects as well and brings that practical touch into teaching. In the Institute I have trained more then 2000 students from various backgrounds and have conducted many corporate training and seminars.