Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MS Office Complete Training in Hindi - Basic to Expert Level
Rating: 4.3 out of 5(241 ratings)
1,253 students

MS Office Complete Training in Hindi - Basic to Expert Level

Get expertise in MS Office Course in MS Word , MS Excel, MS Access & MS PowerPoint (Office 365, 2010, 2013, 2016 & 2019)
Created byHimanshu Dhar
Last updated 10/2025
Hindi

What you'll learn

  • Data management in MS Excel
  • Documentation expertise in MS Word
  • Creating powerful presentation in PowerPoint
  • At the end of this course, you will be able to create a simple DATABASE in Access from scratch
  • Expertise in Text, Logical, Math, Lookup and Reference, Date and Time Function
  • Learning all the Functions with Nested Methodology
  • Mastery in Pivot Table and Chart Preparation
  • Mastery in 'What if Analysis' tools
  • Managing data protection and data sharing in Excel
  • Work with Macro Recording
  • Begin with the basics of creating Microsoft Word documents
  • You will learn how to take full advantage of Microsoft Word
  • Format documents effectively using Microsoft Word Styles
  • Create and Manage Table Layouts
  • Perform Mail Merges to create Mailing Labels and Form Letters
  • Preparing documents for printing and exporting
  • Control page formatting and flow with sections and page breaks
  • Insert Media and Images
  • Working efficiently with quick parts, hyperlink, bookmarking and Cross Reference
  • Using header, footer, page no and table of content
  • Creating hierarchy structure using Smart Art
  • Track and Accept/Reject Changes to a Document
  • Work confidently with Microsoft PowerPoint
  • Create sophisticated and well-organized PowerPoint presentations
  • You will know how to create and modify TABLES in Access
  • You will know how to create QUERIES to ask questions of your Access database
  • You will know how to create FORMS for enter data into your tables
  • You will know how to create REPORTS for sharing and presenting your data in a clear, professional way

Course content

4 sections • 136 lectures • 17h 4m total length

  • Excel Introduction - New File and Title Bar9:08

    Download the practice file

  • Customize Ribbon and Quick Access Toolbar8:16
  • Excel Structure and Worksheets Properties10:47
  • How to do Data Entry and Formatting Effectively14:15
  • Fill Series Options in Excel11:22
  • Flash Fill in Excel3:13
  • Cell Reference in Excel5:57

    • Relative Reference

    • Absolute Reference

    • Mixed Reference

  • Draw Tab in Excel5:20
  • Equation in Excel - Operators based15:47

    • How to use Operation in Excel to do equation

    • BODMAS in EXCEL


  • Equation in Excel - Function based17:17

    • How to apply functions

    • SUM()

    • AVERAGE()

    • COUNT, COUNTA, COUNTBLANK

    • MAX, MIN

    • LARGE, SMALL

    • Nested Function

  • Advance Level Math Function in Excel17:10
  • Database Math Functions in Excel8:44
  • Data Validation in Excel16:05

    • Data Validation Types

    • Input Message

    • Error Alert Customization

  • UPPER, LOWER, PROPER & TRIM Function8:28

    • Introduction to Text Function

    • UPPER()

    • LOWER()

    • PROPER()

    • TRIM()

    • Nesting TRIM with other Function

  • LEFT, RIGHT & FIND Function7:18

    • LEFT()

    • RIGHT()

    • FIND()

  • Find Function Task Solution6:21

    • Advance FIND()

    • Nesting FIND with RIGHT() & LEFT()

  • Nesting LEFT, RIGHT & FIND Function3:53
  • MID Function in Excel4:17

    • MID Function

    • Nested MID

  • CONCATENATE Function4:25

    • CONCATENATE()

    • Nesting CONCATENATE with other Text Function.

  • CONCATENATE Function Project Task Solution2:40
  • Concat and Textjoin Function4:20
  • REPLACE Function in Excel7:15

    • REPLACE()

    • Nested REPLACE()

  • REPLACE Function Project Solution1:55
  • SUBSTITUTE Function in Excel4:30
  • REPT, LEN Function and Project2:23
  • Project Task Solution2:35
  • Numbervalue Function in Excel3:24
  • Text to Column14:28

    • How to use Text to Column

    • Delimited & Fixed Width

    • Date Format through Text to Column

  • Filter Option in Excel15:08
  • Date and Color Filter4:45


    • Date Filter

    • Filter by Color

  • Advanced Filter Option in Excel6:57
  • Sort and Custom Sort in Excel4:37
  • Conditional Formatting - Learn How to Apply6:11
  • Types of Rules in Conditional Formatting11:56
  • Manage Rules in Conditional Formatting4:52
  • Define Name Feature9:00

    • How to naming Ranges

    • Advantages of it

  • Indirect Function5:05
  • Data Validation - Create Dependent List7:01
  • Hyperlink in Excel7:49

    • Types of Hyperlink

    • How to Apply it

  • Group and Subtotal Options7:24
  • IF Function - Logical Test & Introduction7:38

    • Logical Test

    • Introduction to If Function

  • If Function - Nested4:44

    • Nested If Examples

  • IF Function Related Project Solution8:42
  • IF Function - Project Task1:07
  • IF Project - Task Solution4:44
  • IFS Function in Excel4:57
  • AND() & OR() Function6:07

    • AND() Function

    • OR() Function

    • Nested IF() with AND() & OR()

    • Advance Examples

  • XOR Function4:34
  • EMI Calculator - PMT Function6:13

    • How to create EMI Calculator

    • Apply PMT() Function

  • What if Analysis - Data Table11:45

    • How to create data table

    • How to format data table

  • What if Analysis - Goal Seek5:45

    • How to apply Goal seek

    • Get the desired output from complicated equation through Goal Seek

  • Solver Plugin in Excel4:52
  • What if Analysis - Scenario Manager7:22

    • How to Apply Scenario Manager

    • How to merge Scenario

    • How to get summary

  • Pduration Function2:33
  • VLOOKUP Function in Excel13:53
  • IFERROR Function with VLOOKUP8:05
  • Array VLOOKUP Function in Excel6:05
  • HLOOKUP Function4:23
  • MATCH and INDEX Function4:47

    • MATCH()

    • INDEX()

    • Nesting both to get desired result

  • MATCH and INDEX Function Nesting4:25
  • Vlookup TRUE3:47

    • How to use VLOOKUP() TRUE option

  • Amazing Trick in VLOOKUP Function9:56
  • XLOOKUP Function in Excel28:00
  • Chart Preparation - Getting Started with Elements16:30

    • Start with Excel Chart

    • Understanding Layout options

  • Designing and Format Chart14:23

    • Chart Format

    • Chart Design

    • Handling Axis and Series

  • Chart Customization - 1st Part3:50

    • Handling Data Series and Legends

    • Customize options

  • Chart Customization - 2nd Part5:29
  • Pie Chart in Excel12:25
  • Power Map in Excel5:11
  • Quick Analysis and Chart Recommendation4:05
  • Pivot Table in Excel - Complete Guide53:52
  • Power Pivot in Excel29:57

    Practice files available in Resources.

  • Print Options 1 - Page Layout10:25

    • How to set and customize margin

    • page orientation and paper size

    • Print Area & Page Break

    • Set Image as a background

  • Print Options 2- Advance Options8:44

    • How to Repeat heading on each page

    • print pattern

    • customize header and footer

    • How to apply image like a watermark in Excel

  • Protect Workbook (Excel File) in Excel4:47

    • How to protect workbook

    • how and when you may use this option

  • Protect Sheet8:56

    • How to Protect sheet

    • how to allow cells for changes

  • How to Hide Formulas and Unlocked Cell5:11
  • Protect Excel File with Password2:43
  • Share Workbook3:16

    • How to enable share workbook option

    • how and when to use it

  • Date and Time Setting5:55

    • What are the common date entry mistakes?

    • How to overcome?

    • System Date format impact

  • Date and Time Format8:39

    • Date Format

    • Time Format

    • Adding Date and Time

  • Date and Time Functions7:03

    • DAY(), MONTH(), YEAR()

    • HOUR(), MINUTE(), SECOND()

    • DATE(), TIME()

    • Nesting Methodology

  • NETWORKDAYS and NETWORKDAYS.INTL Function4:40
  • DATEDIF Function in Excel3:35
  • Macro Recording Feature in Excel15:30
  • Macro Recording Examples5:56
  • Ways to Run Macros in Excel5:58

Requirements

  • Basic Computer Knowledge

Description

MS Office 2013, 2016, 2019 and Office 365 features has been updated!

Most of us are aware of MS Word, Excel and PowerPoint but are not efficient, as we don’t give so much importance to it and got stuck in workplace because of the lack of knowledge. So become more productive with our online Microsoft Office training course, designed to help you become more efficient in the workplace. Our training classes will teach you everything you need to know about creating worksheets, documents, presentation and more.

This course is intended for individuals and office workers who need to master the features of the most demanding office utility software that is Microsoft Office. In more than 13 hours of video presentations, you'll learn everything you need to know to make your office work more efficiently.

  • Excel Beginner / Intermediate: Create basic spreadsheets and use expense tracking formulas.

  • Excel Advanced: Use complex formulas and data analysis about your company's revenue and expense models.

  • Word: Create documents, embed videos, and set up online collaboration for shared work or school projects.

  • PowerPoint: Create an elegant presentation for your next business meeting with animation, audio / video, and collaboration tools.

  • Access: Learn database management system that combines the relational Access Database Engine with a graphical user interface.

When you complete this course, you will become a work efficiency expert using the tools available in Microsoft Office.

Who this course is for:

  • Anyone want to expertise MS Office
  • For a career as Back Office

Report abuse