Buy the Best Excel Course in the world and learn Excel in Hindi.

Product

Excel Course

Rs 3450/   Rs 2950/ 

40 Beginner Level Videos

40 Intermediate Videos

70 Advance Level Videos

150+ Excel Practice Sheets

2007,2013,2016 versions

Language Hindi or English

Call 9752003788 for Support

Product

Excel And Word Course

Rs 3950/   Rs 3450/ 

40 Beginner Level Excel

40 Intermediate Excel

70 Advance Level Excel

150+ Excel Practice Sheets

100 MS Word Videos

Language Hindi or English

Call 9752003788 for Support

Product

VBA Macros Course

Rs 4250/   Rs 3750/ 

Full Excel Macro Course

100 VBA Macro Videos

100 Code Files with

India's Best VBA Course

Covers All Aspects

Language Hindi

Call 9752003788 for Support

Product

VBA Excel Combo

Rs 7650/   Rs 4950/

Full Excel Course 150+

Full VBA Course 100 Videos

150+ Practice Excel Sheets

100 VBA Sheets

Extensive Practice Material

Language Hindi

Call 9752003788 for Support

Product

VBA Excel Word PPT Combo

Rs 7650/   Rs 5950/

Full Excel Course 150+

Full VBA Course 100 Videos

Full Word Course 45 Videos

Full PPT Course 45 Videos

Extensive Practice Material

Language Hindi

Call 9752003788 for Support

Product

Excel Word PPT Outlook Combo

Rs 6550/   Rs 4450/

Full Excel Course

Full Word Course

Full PPT Course

Full Outlook Course

2007,2013,2016 versions

Language Hindi

Call 9752003788 for Support

Product

MS Word Course 60 Videos

Rs 2450/   Rs 1950/

Full Word Course

60 HD Quality Videos

Well Structured Course

2007,2013,2016 versions

Language Hindi or English

Call 9752003788 for Support

Call 9752003788 for Support

Product

MS PowerPoint Course 48 Videos

Rs 2450/   Rs 1950/

Full Word Course

48 HD Quality Videos

Well Structured Course

Includes 40+ Practice Files

2007,2013,2016 versions

Language Hindi

Call 9752003788 for Support

Product

MS Outlook Course 45 Videos

Rs 2450/   Rs 1950/

Full Outlook Course

45 HD Quality Videos

Well Structured Course

Includes 40+ Practice Files

2007,2013,2016 versions

Language Hindi

Call 9752003788 for Support



See The Contents Of All The Courses

Chapter 1 Basics Of MS Excel

Chapter 2 Basics Of MS Excel 2

Chapter 3 Calculate Average In Excel

Chapter 4 Calculate Sum In Excel

Chapter 5 Count The Cells Containing Numbers In Excel

Chapter 6 Count The Not Empty Containing Numbers In Excel

Chapter 7 Join Content Of Multiple Cells In One Cell In Excel

Chapter 8 Calculate Running Total In Excel

Chapter 9 Do Addition Of Numbers In Excel

Chapter 10 Do Subtraction Of Numbers In Excel

Chapter 11 Do Division Of Numbers In Excel

Chapter 12 Do Multiplication In Excel

Chapter 13 Calculate Percentage In Excel

Chapter 14 Countblank Cells In Excel

Chapter 15 IF Formula In Excel

Chapter 16 CountIF Formula In Excel

Chapter 17 Vlookup Formula In Excel

Chapter 18 Sumif Formula In Excel

Chapter 19 Hlookup Formula In Excel

Chapter 20 sverageif Formula In Excel

Chapter 21 Pivot Table In Excel

Chapter 22 Insert Comment In Excel

Chapter 23 Edit Comment In Excel

Chapter 24 Delete Comment In Excel

Chapter 25 Create Border In Excel

Chapter 26 Wrap Text In Excel

Chapter 27 Merge Cells In Excel

Chapter 28 Number Formatting In Excel

Chapter 29 Paste Special In Excel

Chapter 30 Sort In Excel

Chapter 31 Convert Columns To Rows In Excel

Chapter 32 Conditional Formatting Cells Rules In Excel

Chapter 33 Conditional Formatting Top Bottom In Excel

Chapter 34 Excel Bar Graph

Chapter 35 Excel Column Graph

Chapter 36 Create Pie Chart In Excel

Chapter 37 Calculate Hour Minute Seconds In Excel

Chapter 38 Use Date In Excel In Excel

Chapter 39 Use Month Function In Excel

Chapter 40 Use Dictionary In Excel

Chapter 41 Use Hyperlink In Excel

MS Excel ABS Function Chapter 1

MS Excel Sumif Function Chapter 2

MS Excel Hlookup Function Chapter 3

MS Excel Vlookup Function Chapter 4

MS Excel Countif Function Chapter 6

MS Excel AverageIf Function Chapter 7

MS Excel AverageIfs Function Chapter 8

MS Excel AverageA Function Chapter 9

Data Validation With Date Chapter 10

Data Validation With List Chapter 11

Data Validation With Time Chapter 12

Data Validation With Numbers Chapter 13

MS Excel Sumproduct Function Chapter 14

MS Excel Rank Function Chapter 15

MS Excel Min Function Chapter 16

MS Excel Max Function Chapter 17

MS Excel Cell Function Chapter 18

MS Excel N Function Chapter 19

MS Excel Char Function Chapter 20

MS Excel Clean Function Chapter 21

MS Excel Code Function Chapter 22

MS Excel Exact Function Chapter 23

MS Excel Round Function Chapter 24

MS Excel Large Function Chapter 25

MS Excel Mode Function Chapter 26

MS Excel Median Function Chapter 27

MS Excel Vlookup Exact Function Chapter 28

MS Excel Hlookup Exact Function Chapter 29

Remove Duplicates In Excel Chapter 30

Create Random Numbers In Excel Chapter 31

Change Text To Upper Case In Excel Chapter 32

Change Text To Lower Case In Excel Chapter 33

Change Text To Proper Case In Excel Chapter 34

Add Password To Excel File Chapter 35

Send Email From Excel File Chapter 36

Add Custom Background Image In Excel Chapter 37

Zoom In Zoom Out In Excel Chapter 38

Auto Fill Data In Excel Chapter 39

Add Special Characters In Excel Chapter 40

Change Color Of Border Line In Excel Chapter 41

Change Theme In Excel Chapter 42

Chapter 1 Multiple Vlookup In Excel

Chapter 3 Vlookup Highest Value In Excel

Chapter 2 Vlookup Lowest Value In Excel

Chapter 4 Vlookup Multiple Results In Excel

Chapter 5 Remove NA Error From Vlookup Results

Chapter 6 Vlookup With MID Formula In Excel

Chapter 7 Or Function In Excel

Chapter 8 And Function In Excel

Chapter 9 Choose Function In Excel

Chapter 10 Indirect Function In Excel

Chapter 11 Replace Function In Excel

Chapter 12 Mid Function In Excel

Chapter 13 Len Function In Excel

Chapter 14 Left Function In Excel

Chapter 15 Find Function In Excel

Chapter 16 Roundup Function In Excel

Chapter 17Ceiling Function In Excel

Chapter 18 Correl Function In Excel

Chapter 19 Forecast Function In Excel

Chapter 20 Frequency Function In Excel

Chapter 21 Subtotal Function In Excel

Chapter 22 Sumifs Function In Excel

Chapter 23 Whatif Analysis Function In Excel

Chapter 24 Color A Column With A Formula In Excel

Chapter 25 Color A Row With A Formula In Excel

Chapter 26 Highlight A Cell With Formula

Chapter 27 Isodd Function In Excel

Chapter 28 Isnumber style="color: #000000;"> Function In Excel

Chapter 29 Istext Function In Excel

Chapter 30 Islogical Function In Excel

Chapter 31 Isnontext Function In Excel

Chapter 32 Iserror Function In Excel

Chapter 33 Iserr Function In Excel

Chapter 34 Isblank Function In Excel

Chapter 35 Dget Function In Excel

Chapter 36 Dmax Function In Excel

Chapter 37 Dproduct Function In Excel

Chapter 38 Dcounta Function In Excel

Chapter 39 Dcount Function In Excel

Chapter 40 Dsum Function In Excel

Chapter 41 Daverage Function In Excel

Chapter 42 Calculate Depreciation In Excel

Chapter 43 SLN Depreciation In Excel

Chapter 44 SYD Depreciation In Excel

Chapter 45 PMT Function In Excel

Chapter 46 Calculate Loan EMI In Excel

Chapter 47 Datedif Function In Excel

Chapter 48 Datevalue Function In Excel

Chapter 49 Edate Function In Excel

Chapter 50 Eomonth Function In Excel

Chapter 51 Match Function In Excel

Chapter 52 Match Function Approximate And Exact Match Part 1

Chapter 53 Match Function Approximate And Exact Match Part 2

Chapter 54 Index Function

Chapter 55 Index And Match Function Part 1

Chapter 56 Index And Match Function Part 2

Chapter 57 Index And Match Function Part 3

Chapter 58 Index And Match Function Part 4

Chapter 59 Index And Match Function Part 5

Chapter 60 Index And Match Function Part 6

Chapter 61 Index And Match Function Part 7

Chapter 62 Index And Match Function Part 8

Chapter 63 Index And Match Function Part 9

Chapter 64 Index And Match Function Part 10

Chapter 65 Index And Match Function Part 11

Chapter 66 Lookup Data From 3 Tables In Excel

Chapter 67 Only Select Cells With Comments In Excel

Chapter 68 Hide Formula In Excel

Chapter 69 Insert Serial Number Automatically In Excel

Learn MS Word for Beginners Entering Text Chapter 1

Learn MS Word Deleting Text Chapter 2

MS Word Splitting and Joining Text Chapter 3

Learn MS Word Undo and Redo Chapter 4

MS Word Find and Replace Chapter 5

Learn MS Word Text Block Chapter 6

Learn MS Word Text Block Chapter 6

Learn MS Word Spell Check Chapter 7

Learn MS Word Check Word Count Chapter 8

MS Word Text Formatting Chapter 10

MS Word Print a Document Chapter 11

MS Word Formatting a Document Chapter 12

MS Word Page Formatting Chapter 13

MS Word Understanding Section Chapter 14

MS Word Create Cover Page Chapter 15

MS Word Creating Headers Chapter 16

MS Word Editing Headers Chapter 17

MS Word Advanced Headers Chapter 18

MS Word Learn To Use Styles Chapter 19

MS Word Creating Formatting Style Chapter 20

MS Word Assign Shortcut Key to Style Chapter 21

MS Word Apply A Theme Chapter 22

MS Word Modifying A Theme Chapter 23

Learn MS Word Create Borders 24

MS Word Edit Borders 25

Learn MS Word Create Page Border 26

Learn MS Word Create Text And Paragraph Border 27

Learn MS Word Creating Tables Chapter 28

MS Word editing Tables Chapter 29

MS Word Design Tables Chapter 30

Learn MS Word Create Bullet Points Chapter 31

Use Format Painter In MS Word In Hindi Chapter 32

Creating Line Numbers In MS Word Hindi Chapter 33

Create Table Of content In MS Word Hindi Chapter 34

Save As Option In MS Word Hindi Chapter 35

View 2 Documents Side By Side In MS Word Hindi Chapter 36

Use Comments In MS Word Hindi Chapter 37

Insert Image In MS Word Hindi Chapter 38

Enter Footnote And Endnote In MS Word Hindi Chapter 39

Insert Shape In MS Word Hindi Chapter 40

Insert Clip Art In MS Word Hindi Chapter 41

Mix Image And Text Hindi In MS Word Chapter 42

Moving Images Hindi In MS Word Chapter 43

Insert Special Characters Hindi In MS Word Chapter 44

Insert Text Box Hindi In MS Word Chapter 45

Insert SmartArt Hindi In MS Word Chapter 46

Handle Multiple Documents Hindi In MS Word Chapter 47

Insert Video Hindi In MS Word Chapter 48

Merge Cells In Google Documents Hindi In MS Word Chapter 49

Convert MSword File To PDF Hindi In MS Word Chapter 50

Convert MSword File To Other Format Hindi In MS Word Chapter 51

Use Comments In MS Word Hindi Chapter 52

Highlight Content Hindi In MS Word Chapter 53

Mail Merge In MS Word Hindi Chapter 54

1 PowerPoint For Starters

2 Move from slide to slide

3 Displaying your PowerPoint Presentation

4 Adding text Media in PowerPoint Presentation

5 Saving your PowerPoint Presentation

6 Create Duplicate Objects in MS PowerPoint

7 Delete a Slide in PowerPoint

8 Undo Redo Stuff in MS PowerPoint

9 Duplicating a Slide in MS PowerPoint

10 Slide Sorter View

11 Outline View

12 Using Spell Check in PowerPoint

13 Using Thesaurus in PowerPoint

14 Using Capitalizing Options in PowerPoint

15 Using Notes in PowerPoint Presentation

16 Print options in PowerPoint

17 Setup Slide Show in PowerPoint

18 Add SmartArt and Shapes in PowerPoint

19 Insert Charts in PowerPoint

20 Insert Header Footer in PowerPoint

21 Use Transitions in PowerPoint

22 Use Animations in PowerPoint

23 Check Accessibility

24 Using Smart Lookup

25 Using Translation

26 Using Comments

27 Using Inking

28 Using Outline View

29 Using Slide Sorter

30 Using Notes Pane

31 Using Reading View

32 Using Zoom and Fit To Window

33 Handout Master

33 Handout Master

35 Ruler, Gridlines and Guide

36 Work in Grey Scale and Black and White

37 Work on PPT in 2 Windows at Once

38 View Multiple PowerPoint Files Together

39 Change Layout of a Slide in PowerPoint Presentation

40 Text Direction in PowerPoint

41 Convert Text to Smart Art

42 Using Quick Styles

43 Understanding Text Effects

44 Use Find and Replace in PowerPoint

45 Sharing Options in PowerPoint

46 Convert PPT to PDF

47 Convert PPT to Video

48 Understanding Export Options in PowerPoint

Reading Mail

Reading mail

Manage the inbox

Saving attachments from a message

Searching mail

Creating search folders

Ignoring conversations and flagging as junk

Using filters and the People pane

 

Organizing Mail

Using conditional formatting to change font and colour

Create Folders

Organising mail into folders

Using Quick Steps to process messages

Using mail rules to process messages

Cleaning up your mailbox

 

 

Creating and Sending Mail

Creating a new message

Add attachment to email

Replying to a message

Forwarding a message

Saving a Draft

Formatting a message

Creating voting buttons in a message

Adding signatures

Sending an out-of-office or autoreply email

Exploring delivery options

Creating personal stationery

Exploring other mail settings

 

Creating and Working with People

Navigating the People hub

Creating a new contact

Creating a new contact group

Working with contacts

Sharing contact data with others

 

Working with the Calendar

Navigating the Calendar

Changing the look of the calendar

Creating an appointment

Creating a meeting

Responding to a meeting invitation

Opening other calendars

Printing, emailing, and sharing the calendar

Creating additional calendars

Setting calendar preferences

 

Creating Tasks and Notes

Navigating tasks

Creating and assigning tasks

Creating notes

 

Working with Outlook Data

 Backing up or moving Outlook

Reusing text by creating Quick Parts

Setting advanced general Outlook options

VBA Part 1- Intro to VBA Hindi

VBA Part 2 - Refer workbook and range in Hindi

VBA Part 3 - Refer cell to enter value with VBA Hindi

VBA Part 4 - Hide Unhide Row Column with VBA Hindi

VBA Part 5 - Change Cell colour and Font colour with VBA Hindi

VBA Part 6 - Intro to Variables in VBA HINDI

VBA Part 7 - Handling Decimals Math Calculations in VBA Hindi

VBA Part 8 - Intro to Strings in VBA Hindi

VBA Part 9 - Strings in VBA Hindi

VBA Part 10 - Date Variables in VBA Hindi

VBA Part 11 - Use Date Variables in VBA Hindi

VBA Part 12 - Intro to Boolean in VBA Hindi

VBA Part 13 - IF Statement in VBA Hindi

VBA Part 14 - IF ELSE Statement in VBA Hindi

VBA Part 15 - Nested IF ELSE Statement in VBA Hindi

VBA Part 16 - Use Select Case Variable in VBA Hindi

VBA Part 17 - Use AND OR ELSEIF in VBA Hindi

VBA part 18 - Use Array in VBA Hindi

VBA Part 19 - Use 2 Dimensional Array in VBA Excel Hindi

VBA Part 20 - Use FOR Loop VBA Excel Hindi

VBA Part 21 - Use FOR Loop in Array in VBA Excel Hindi

VBA Part 22 - Use FOR Loop for Workbook Objects Hindi

VBA Part 22 - Use For Loop with Arrays Hindi

VBA Part 23 - Use NESTED FOR Loop in VBA Hindi

VBA Part 24 - Do While Loop in VBA Hindi

VBA Part 25 - Do Until Loop in VBA Hindi

VBA Part 26 - Nested Do While Loop in VBA Hindi

VBA Part 27 - Speed Up Loops to Execute Code Faster in VBA Hindi

VBA Part 28 - Call Another Sub Procedure in a Sub Procedure Hindi

VBA Part 29 - Call Variable Scope from another Sub Procedure in a Sub Procedure Hindi

VBA Part 30 - Pass a Variable to a Function

VBA Part 31 - Pass Multiple Variables to a Function

VBA Part 32 - Return Values with a Function

VBA Part 33 - Pass variable as reference in a Function

VBA Part 34 - Understanding Events and Selection Changes

VBA Part 35 - Event - DoubleClick Event

VBA Part 36 - Worksheet Change Event

VBA Part 37 - Workbook Activate Event and Deactivate Event

VBA Part 38 - Use Workbook Open Event

VBA Part 39 - Use Workbook BeforeClose Event

VBA Part 41 - Intro To User Forms

VBA Part 42 - Use Command Buttons in User Forms

VBA Part 43 - Add User Name Password with User Form

VBA Part 44 - Use Option Buttons in Userforms

VBA Part 45 - Use Checkboxs in Userforms

VBA Part 46 - Use Lists in Userform

VBA Part 47 - Use Frames in UserForms

VBA Part 48 - Create Multipage Userform

VBA Part 49 - Insert Video in Userform

VBA Part 50 - Insert Picture in Userform

VBA Part 51 - Use Events in Userform

VBA Part 52 - Use Active X Controls

VBA Part 53 - Use textbox as active x control

VBA Part 54 - Create Dropdownlist with Active x Control

VBA Part 55 - Use Spin Button Active X Control

VBA Part 56 - Use checkbox Active X Control

VBA Part 57 - Use Options Button Active X Control

VBA Part 58 - Use List Box Active X Control

VBA Part 59 - Send Email Via VBA Code

VBA Part 60 - Send Email with Attachments Via VBA Code

VBA Part 61 - Open Object with Shell Command

VBA Part 62 - Open Object and Use Sendkeys Command

VBA Part 63 - Open 2 Objects and Use Sendkeys Command

VBA Part 64 - Use Class Module in VBA

VBA Part 65 - Use Let and Get Methods inClass Module in VBA

VBA Part 66 - Use Function and Sub in Class Module in VBA

VBA Part 67 - Use Initialize and Terminate Commands Class Module in VBA

VBA Part 68 - Error Handling in VBA

VBA Part 70 - Establish Database Connection in VBA

VBA Part 71 - Use Recordsets and SQL Database Connection in VBA

VBA Part 72 - Use WHERE Cause in Recordsets and SQL Database Connection in VBA

VBA Part 73 - Use Select to Return Multiple Records SQL Database Connection in VBA

VBA Part 74 - Insert Values in SQL Database Connection in VBA

VBA Part 75 - Delete Values in SQL Database Connection in VBA

VBA Part 76 - Update Values in SQL Database Connection in VBA

VBA Part 77 - Use AND Statement in SQL Database Connection in VBA

VBA Part 78 - Use AND OR Statement in SQL Database Connection in VBA

VBA Part 79 - Use SQL Numeric Parameters in VBA

VBA Part 80 - Use SQL Date Parameters in VBA

VBA Part 81 - Use SQL Between Parameters in VBA

VBA Part 82 - Use Order By Ascending Descending Parameters in VBA

VBA Part 83 - Use Sort TOP Parameters in VBA

VBA Part 84 - Sum the Data in SQL Connection in VBA

VBA Part 85 - Sum Data With Group By Command in SQL Connection in VBA

VBA Part 86 – Use Group By Command

VBA Part 87 – Use Join Command

VBA Part 88 – Use Distinct Command

VBA Part 89 – Insertion Database Hacking

VBA Part 90 – SQL Parameters

VBA Part 91 – SQL Multiple Parameters and Data Types

VBA Part 92 – Connect To a Excel Sheet

VBA Part 93 – Open New Excel Workbook

VBA Part 94 – Open Existing Excel Workbook

VBA Part 95 - Searching for Files using FileSystemObjects

VBA Part 96 – Obtaining data from all spreadsheets in a folder

VBA Part 97 - Combining Data from Multiple Spreadsheets using ADO

VBA Part 98 - GetOpenFilename

VBA Part 99 – Create Own Formula in Excel

VBA Part 100 – Explore Excel File Connection




Download Practice File


All videos are in HD quality and use HD Sound Quality

See a sample video on the left hand side of this text

Comprehensive training material provided.

Download a sample from below


Download Sample Practice File











Frequently Asked Questions


You can make payments online with Debit card, Credit Card, Net banking. You can deposit funds in our SBI Bank account. You can also buy the course with Cash On Delivery Option

The course will be sent in a DVD via DTDC courier. Download option is also available to get the course immediately. You can choose any 1 option to get the course

The videos are in MP4 format in HD quality. The videos can be played on any computer, laptop, phone, tab or tv which can play MP4 videos.

Yes, For Excel Course the practice files are given in Excel format. Yes, For PowerPoint Course the practice files are given in PPT format. Yes, For VBA Course the practice files are given in Excel Macro format.

We have covered Excel 2007, 2010, 2013 and 2016 versions in the course so that you can learn the best of all the versions.

You can book a free training session with Guruji by calling 9752003788 to solve your doubts.





Office Address - 316,Orbit Mall. Indore. Ph 0731-4050700. Email us at [email protected]
Bank account Details
Account Holder Name - Blueinvents International
Bank Name - SBI
Account type - Current Account
Account Number - 36168961434
IFSC Code - SBIN0003432
Branch Name - OLD PALASIA
MICR Code - 452002011
Branch Code - 003432
Part Payment Link - http:[email protected]

Excel Made Easy