Excel Training in Hindi

Learn to manage complex data in Excel with ease
4.3 (6 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
$19
$30
37% off
Take This Course
  • Lectures 55
  • Length 8.5 hours
  • Skill Level All Levels
  • Languages Hindi
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 Hindi

Course 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.

What are the requirements?

  • Basic of Computer

What am I going to get from this course?

  • 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

What is the target audience?

  • Management Graduates
  • HR Professionals
  • Marketing Professionals
  • MIS Aspirants
  • Any Graduate

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Excel
17:41
  1. Title Bar, Tabs, Ribbons, Workbooks, Worksheets, Range etc
  2. Customizing Ribbons and options
05:42
  • How to use Operation in Excel to do equation
  • BODMAS in EXCEL
16:05
  • Data Validation Types
  • Input Message
  • Error Alert Customization
Section 2: Module 2 - Excel Cell handling & Function
13:58
  • How to apply functions
  • SUM()
  • AVERAGE()
  • COUNT, COUNTA, COUNTBLANK
  • MAX, MIN
  • LARGE, SMALL
  • Nested Function
13:31
  • Cell Properties
  • Text Autofill
  • Date Autofill
  • Number Autofill


04:46
  • Relative Reference
  • Absolute Reference
  • Mixed Reference
Section 3: Module 3 - Text Handling
07:40
  • Introduction to Text Function
  • UPPER()
  • LOWER()
  • PROPER()
  • TRIM()
  • Nesting TRIM with other Function
11:25
  • LEFT()
  • RIGHT()
  • FIND()
08:22
  • Advance FIND()
  • Nesting FIND with RIGHT() & LEFT()
10:28
  • MID Function
  • Nested MID
07:51
  • CONCATENATE()
  • Nesting CONCATENATE with other Text Function.
09:02
  • REPLACE()
  • Nested REPLACE()
05:57
  • SUBSTITUTE()
  • REPT()
  • LEN()
  • Nested Function
12:14
  • How to use Text to Column
  • Delimited & Fixed Width
  • Date Format through Text to Column
Section 4: Module 4 - Data Management
09:49
  • How to Apply Filter correctly
  • How to use Filter
  • Text Filter
06:33
  • Number Filter
  • Date Filter
  • Filter by Color
12:32
  • How to naming Ranges
  • Advantages of it
12:24
  • Types of Hyperlink
  • How to Apply it
Section 5: Module 5 - Logical & Advance Math Functions
10:07
  • Logical Test
  • Introduction to If Function
08:02
  • Nested If Examples
08:46
  • Nesting IF() with other Functions to get desiredoutput
16:54
  • AND() Function
  • OR() Function
  • Nested IF() with AND() & OR()
  • Advance Examples
07:44
  • SUMIF()
  • COUNTIF()
  • AVERAGEIF()
08:18
  • SUMIFS()
  • COUNTIFS()
  • AVERAGEIFS()
  • Wild Card
Section 6: Module 6 - What if Analysis & Financial
05:19
  • How to create EMI Calculator
  • Apply PMT() Function
09:25
  • How to create data table
  • How to format data table
06:34
  • How to apply Goal seek
  • Get the desired output from complicated equation through Goal Seek
11:13
  • How to Apply Scenario Manager
  • How to merge Scenario
  • how to get summary
Section 7: Module 7 - LOOKUP & Reference Functions
09:12
  • VLOOKUP()
  • HLOOKUP()
11:41
  • MATCH()
  • INDEX()
  • Nesting both to get desired result
04:16
  • OFFSET()
  • Nesting Offset and more example
04:40
  • How to use VLOOKUP() TRUE option
05:45
  • LOOKUP()
  • Drawbacks and how to apply it correctly
10:28
  • How to apply VLOOKUP() in all columns in a single go
  • Array VLOOKUP()
  • VLOOKUP() with IFERROR
  • VLOOKUP with IF
05:00
  • Nested Lookup Function
  • Advance Level Examples and problem solving
Section 8: Module 8 - Data Organizing
11:39
  • How to apply conditional formatting
  • Types of Conditional Formatting


07:13
  • How to Manage Rules - Edit & Delete
  • How to apply new Rules - Based on Formulas
05:16
  • Advance Customize options
15:15
  • Start with Excel Chart
  • Understanding Layout options
07:59
  • Chart Format
  • Chart Design
  • Handling Axis and Series
06:04
  • Handling Data Series and Legends
  • Customize options
14:25
  • How to create Pivot Table
  • Managing Fields Properly in Field area
  • Managing Value setting
  • How to get detailed report

16: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
08:57
  • Handling Dates and Values through Group option
  • Doing Calculation through Calculated field.
Section 9: Print Options in Excel - Page Layout
11:39
  • How to set and customize margin
  • page orientation and paper size
  • Print Area & Page Break
  • Set Image as a background
10:25
  • How to Repeat heading on each page
  • print pattern
  • customize header and footer
  • How to apply image like a watermark in Excel
Section 10: Excel Security Options
04:06
  • How to protect workbook
  • how and when you may use this option
06:16
  • How to Protect sheet
  • how to allow cells for changes
09:32
  • How to hide formulas
  • How to customize protect related options
  • Making workbook password protected
03:16
  • How to enable share workbook option
  • how and when to use it
Section 11: Date and Time in Excel
06:57
  • What are the common date entry mistakes?
  • How to overcome?
  • System Date format impact
07:23
  • Date Format
  • Time Format
  • Adding Date and Time
04:02
  • DAY(), MONTH(), YEAR()
  • HOUR(), MINUTE(), SECOND()
  • DATE(), TIME()
  • Nesting Methodology
10:49
  • 1904 Format Mystery
  • Date Format Mystery
  • How to find age
  • NETWORKDAYS()
06:12
  • How to correct wrong date entry

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Take This Course