The Best Excel Course For You.


This Excel Course is designed to help you master excel in the easiest manner. You will learn to use formulas, Make Charts & Graphs, Work with Pivot Tables, do Data Analysis, and make MIS Reports and much more ! For COD - Cash on Delivery please call 9752003788

MS Excel Course

For COD Call 9752003788

2750/-
  • Full Beginner Course
  • Full Intermediate Course
  • Full Advanced Course
  • 150+ Excel Videos
  • 150+ Training Files
  • Free Shipping
  • Language Hindi Or English
  • Call 9752003788 For Cash On Delivery

Excel & Word Course

For COD Call 9752003788

3250/-
  • Full Beginner Course
  • Full Intermediate Course
  • Full Advanced Course
  • 170+ Excel Videos
  • 170+Training Files
  • 70+ MS Word Videos
  • Language Hindi Or English
  • Free Shipping
  • Call 9752003788 For Cash On Delivery


Full VBA Macros Course

For COD Call 9752003788

3450/-
  • Full VBA Macro Course
  • 100+ VBA Macro Videos
  • 100+ Training Files
  • All VBA Topics Covered
  • Free Shipping
  • Language Hindi
  • Call 9752003788 For Cash On Delivery

Full VBA Macros & Excel & Word Course

For COD Call 9752003788

4950/-
  • Full VBA Macro Course
  • 100+ VBA Macro Videos
  • 100+ Training Files
  • 170+ Excel Videos
  • 170+ Training Files
  • 70+ MS Word Videos
  • Language Hindi
  • Free Shipping
  • Call 9752003788 For Cash On Delivery
























































For COD Cash on Delivery, Please Call 9752003788

What’s included in the Full Excel course

This full excel course is divided in three sections 1. Beginner Section, 2 Intermediate Section & 3 Advanced Section. You can jump to any section at your choice depending upon your level of proficiency in Excel.

The beginner section gets you introduced to the basic of excel and commonly used formulas. The intermediate section teaches the formulas and functions for data analysis and reporting. The Advanced sections section teaches you tips and tricks which will make you a Excel Jedi !

Beginner section has 40+ videos 
•Intermediate section has 40+ videos.
•Advanced section has 70+ videos

This Excel Course is designed to help you master excel in the easiest manner. You will learn to use formulas, Make Charts & Graphs, Work with Pivot Tables, do Data Analysis, and make MIS Reports and much more.

The contents of the Excel are Listed below

MS Excel Beginner Course

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 Averageif 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 Intermediate Course

 

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

 

MS Excel Advanced Course

Chapter 1Multiple 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 24Color 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 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 39Dcount 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 49Edate 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

The Contents of the MS Word Course are listed below

MS Word Course

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

 

List of Topics Covered in VBA Macro Course 

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

Learn VBA Part 86 – Use Group By Command

Learn VBA Part 87 – Use Join Command

Learn VBA Part 88 – Use Distinct Command

Learn VBA Part 89 – Insertion Database Hacking

Learn VBA Part 90 – SQL Parameters

Learn VBA Part 91 – SQL Multiple Parameters and Data Types

Learn VBA Part 92 – Connect To a Excel Sheet

Learn VBA Part 93 – Open New Excel Workbook

Learn VBA Part 94 – Open Existing Excel Workbook

Learn Excel part 95 - Searching for Files using FileSystemObjects

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

Learn VBA Part 97 - Combining Data from Multiple Spreadsheets using ADO

Learn VBA Part 98 - GetOpenFilename

Learn VBA Part 99 – Create Own Formula in Excel

Learn VBA Part 100 – Explore Excel File Connection