Microsoft Excel Beginner-Advanced and Professional हिन्दी

4.4 ★★★★ ★

Microsoft Excel Beginner-Advanced and Professional हिन्दी

Name: Microsoft Excel Beginner-Advanced and Professional हिन्दी
Rating: 4.4 (280 reviews)
Author: Bollaman Bhavani

A Compulsion Course for all Students and Working Professionals

updated on icon Updated on Apr, 2024

language icon Language - Hindi

person icon Bollaman Bhavani

category icon Microsoft Office,Office Productivity,Excel

Lectures -42

Duration -3 hours

4.4 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

This course will provide you everything you need to know about Microsoft Excel.

You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Chartered Accountant having 12+ year of experience, this course provides comprehensive coverage on Microsoft Excel. .

In only nine hours of videos, provided to you in 99 separate video lectures so that no one video is too long, you will learn all of the following about Microsoft Excel:

Basic Formatting & Editing
Paste Special
Some Special Features
Cell Referencing in Excel
Text Function
Basic Excel Formula & functions
Advanced Excel Formula & functions
Formula (Auditing) Checking in Excel
Data Protection in Excel
Merge multiple files in one click
Basic and advanced Pivot
Charts and Graphs in Excel
Slicer (advanced filter for presentation)
Shapes and Smart art
How to Prepare Dashboard
What if analysis
Important Shortcuts in Excel
Macro for Non Technical People
Macro - How to record
Macro - How to create button to run
Macro - Editing and Debugging
Macro - Relative reference

Apart from above, we will be learning lots of other features during this entire course.

Basic Excel Formula & functions
Advanced Excel Formula & functions
Formula (Auditing) Checking in Excel
Data Protection in Excel
Merge multiple files in one click
Basic and advanced Pivot
Charts and Graphs in Excel
Slicer (advanced filter for presentation)
Shapes and Smart art
How to Prepare Dashboard
What if analysis
Important Shortcuts in Excel
Macro for Non Technical People

Goals

What will you learn in this course:

To make you excel in MS Excel

Prerequisites

What are the prerequisites for this course?

a desire to learn new skills

Microsoft Excel Beginner-Advanced and Professional हिन्दी

Curriculum

Check out the detailed breakdown of what’s inside the course

Microsoft Excel Beginner Advanced हिन्दी
42 Lectures

1 How to Start MS Excel - Open Close , Preview Functionalities 05:17 05:17
2 Sum Functionality in MS Excel 06:36 06:36
3 Subtraction Functionality in MS Excel 00:58 00:58
4 Multiplication Functionality in MS Excel 02:39 02:39
4A Percentage Functionality in MS Excel 01:30 01:30
4B Division Functionality in MS Excel 03:09 03:09
4C Count Functionality in MS Excel 05:59 05:59
4D Date & Time Functionality in MS Excel 02:56 02:56
5. Learn How to Create Tabs, Groups and add Tools to it in MS Excel 05:30 05:30
6. Excel - Editing Data I over writing I editing I find & replace I undo & redo I Goto 06:06 06:06
7. MS Excel-HomeTab-GroupClipBoardExplained-Copy,Cut,Paste,CopyasPicture,FormatPainter,Past Special 08:29 08:29
8. MS Excel-HomeTab-FontGroupExplained-FontSize,FontFaceStyle,BoldItalic,Underline,Borders 07:53 07:53
9. Home Tab - Alignmnet Group Explained - Merge, Wrap Text, Alignments & more 05:11 05:11
10. Characteristics of a cell explained in Ms Excel 01:14 01:14
11. Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsfot Excel Excel 03:43 03:43
12. Text to columns Explained in Ms Excel 04:45 04:45
13. MS Excel - Comments - add, edit, delete & Show all 03:06 03:06
14. MS Excel - Fill Series - with formatting, without formatting & more 02:44 02:44
15. Fill Series - Advance Fill - Numbers, Months, Daya, Custom List Edit & Add,FillDown,Right&more 07:49 07:49
16. Fill Series - Flash Fill 04:13 04:13
17. MS Excel - How to Hind and Unhide Rows, Columns, Sheets 06:20 06:20
18. Freeze Panes - Top Row, Columns & Multiple Rows & Columns in Hindi 07:07 07:07
19. MS Excel - Filters - Learn How to Use Filter to anylise a Big Data in Hindi 07:47 07:47
20. MS Excel - Split Sheet Window 02:29 02:29
22. MS Excel - Working with Sheets 06:23 06:23
23. MS Excel - View Sheets Side by Side from One Excel File 03:46 03:46
24. MS Excel - Workbook Protection - Learn how to setup a Password to open Excel File 03:28 03:28
25. MS Excel - Sheet & Cells Protection 05:02 05:02
26. MS Excel - Create & Remove Drop Down List in Hindi 08:33 08:33
27. Concatenate - Join Multiple Text Strings into ONE 01:22 01:22
28. MS Excel - Trim Functions - Remove unnecessary Elements from strings in Hindi 01:50 01:50
29. MS Excel - Print Formulas Left, Right, Middle 04:10 04:10
30. MS Excel - Date Related Fromulas 03:11 03:11
31. MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New Documents in Hindi 10:21 10:21
33. MS Excel - Page Header & Footer I Add Page Numbers,Logo,Report Name,Date,Time & more in Hindi 07:00 07:00
34. Conditional Formatting in hindi 06:21 06:21
MS Excel - Import Data from Text Document - with Auto Refresh in Hindi 03:34 03:34
MS Excel - Format Multiple Sheets at a time 04:24 04:24
MS Excel 3d Sum 04:12 04:12
MS Excel - Consolidate ( 3d Sum extension) 04:14 04:14
MS Excel - Bar Code I Install Bar code font I Generate Bar Codes in Hindi 05:49 05:49
Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I Comparative Operators 03:45 03:45

Instructor Details

Bollaman Bhavani

Course Certificate

Use your certificate to make a career change or to advance in your current career.