Mashup of - MS Excel Beginner Course, MS Excel Intermediate Course, MS Excel Advanced Course, MS Word, Excel Dashboard, MS PowerPoint and MS Outlook
Excel Superstar offers courses that are uniquely designed to give you a complete tour of Excel and its Techniques. Anyone who wishes to master MS Excel or any other Microsoft Office Tools completely can do it here. The mission is to turn our learners into Absolute Professionals who have complete knowledge about MS Office Tools.
Learn Excel VBA Tutorial in Hindi in 7 days
Full Beginner to Advanced Course
Language Hindi-English Mix
Price including GST
Call 7021329219 for more info
Our Course has got 80+ video tutorials to benefit your Excel and other Microsoft Office course-based Knowledge. These video tutorials will help you to learn ‘How to deliver faster while doing less work.’ These are Educational Videos having fun elements as well so that the learners do not lose the interest. Fun Elements are the extended benefits to users which helps in memorizing the lessons well.
All the courses of MS Office are designed keeping the users in mind. It should deliver its complete value-adding productivity in the Professional life. Learn Advanced Excel Formulas and skills to Excel at work. This will help you to Achieve the quest to Work Smart and achieve more
The same video tutorials are put up on our Website and YouTube Channel. There are training files that will be made available to the Learners.
The list of things that you’re going to get from this course:
1. 80+ top-notch videos
2. All the training materials
001 - Why do we learn Excel VBA Macros?
001A - How to learn Excel VBA Macros?
002 - How to enable Developer Tab in Excel?
003 - Basics of Developer Tab in Excel
004 - Important Macro Security Settings in Excel
005 - How to save Macros in Excel for future use?
006 - Part 1 - How to create a Macros in Excel
007 - Part 2 - How to run a Macro in all open Workbooks
008 - Part 3 - Using a Button to run a Macros in Excel
009 - Part 4 - Running a Macro in different ways in Excel
010 - Part 5 - Understanding VBA Workspace in Excel (Basics)
011 - Part 6 - Watch a Macro being recorded
012 - Part 1 - Searching Google for VBA Codes - using the 3 magic words
013 - Part 2- Searching Google for VBA Codes - in Blogs vs Forum
014 - VBA Workspace - a detailed tour
015 - How to increase the font size of the VBA Codes
016 - 3 shortcuts to write VBA Codes faster
017 - VBA Code Testing Tricks
018 - Part 1 - Concept of Objects, Properties, Methods in Excel VBA
019 - Part 2 - Concept of Objects, Properties, Methods in Excel VBA
020 - Part 3 - Concept of Objects, Properties, Methods in Excel VBA
021 - Part 4 - Concept of Objects, Properties, Methods in Excel VBA
022 - Range & Cells Object in Excel VBA
023 - Example - Using Cells Object with a simple Do-While Loop in Excel VBA
024 - What is OFFSET property in Excel VBA
025 - Range Navigation in Excel VBA (Basics)
026 - Exercise - Finding Last filled Row & Next Row in Excel VBA
027 - Exercise - Finding Last Column No.
028 - Part 1 - Variables - Concept, How & Why declare Variables, Initialization
029 - Part 2 - Variables - Data Types
030 - Part 3 - Variables - Best Practices to name Variable
031 - Part 4 - Variables - How to remember to declare Variables (Option Explicit)
032 - Part 5 - Variables - DIM vs SET
033 - Pvt vs Public 01
034 - Pvt vs Public 02
035 - Loops - For Next Loop - Basics
036 - Loops - If Then Else with For Next Loop
037 - Loops - For Each Next - Basics
038 - Loops - If Then Else with For Each Next Loop
039 - Loops - Do While Loop - Basics
040 - Loops - Do Until Loop - Basics
041 - Loops - With Statement
042 - Loops - Select Case - Basics
043 - Part 1 - Input Box - Basics
044 - Part 2 - Input Box - Inserting user input in a cell
045 - Part 3 - Input Box - Different Value Types
046 - Part 4 - Input Box with IF Then Else Statement
047 - Introduction
048 - MsgBox - 1
049 - MsgBox - 2
050 - MsgBox - 3
051 - MsgBox - 4
052 - User Forms - Project 1 - Part 1 - TextBox & CommandButton - Basics
053 - User Forms - Project 1 - Part 2 - TextBox & CommandButton - Designing
054 - User Forms - Project 1 - Part 3 - TextBox & CommandButton - Configuring
055 - User Forms - Project 1 - Part 4 - TextBox & CommandButton - Load button
056 - User Forms - Project 2 - Part 1 - Option Button & CommandButton - Basics
057 - User Forms - Project 2 - Part 2 - Option Button & CommandButton - Configuring
058 - User Forms - Project 3 - Part 1 - Option Button in Multiple Clusters (3 ways)
059 - User Forms - Project 3 - Part 2 - Option Button in Multiple Clusters (3 ways)
060 - Multi Page - Introduction
061 - Multi Page - 1
062 - Multi Page - 2
063 - Multi Page - 3
064 - Check Box 001
065 - Combo Box - Method 1
066 - Combo Box - Method 2
067 - User Defined Functions (UDF) - Basics
068 - UDF Example 1 - ScoreResult with IF END IF
069 - UDF Example 2 - CellComments
070 - UDF Samples - Series A
071 - UDF Samples - Series B
072 - Form Controls vs ActiveX Controls
073 - MouseMove Event w. Appln Statusbar
074 - Introduction
075 - Events - WorkbookOpen and WorksheetActivate
076 - Exercise 1 - Tracking Workbook Opens
077 - Exercise 2 - Tracking Workbook Save
078 - Event - WorksheetBeforeDoubleClick
079 - Event - WorksheetChange
080 - Event - Worksheet_Calculate
081 - Pivot Table - Refresh - WorkSheetActivate
082 - Speed up the code running - 1
083 - Speed up the code running - 2
084 - Speed up the code running - 3
The Course Material will be delivered in the Pen Drive by Courier or Speed post. This would be done in a 2 day, i.e. immediately after your order is received.
In case, if any learner wishes to track the courier no. The Courier Tracking no. would be sent to you via mail.
Requirements are simple:
- Since you’re getting the Tutorials in the video form, you need a laptop or a Computer.
- You need Microsoft office tools in your PC like MS Excel.
- If you have a smartphone, such an add-on, view it while you’re free, traveling or whenever you wish to.
This offer is valid in all over India.
In case if you’ve any question or doubt, feel free to clear your doubts. We’re available for assistance.
You can mail us on - <firstname.lastname@example.org>
You can call on - +91 7021329219
Address: Suit No. 1 Sunderdham Society, Near Jai Vaibhav Society, Jambali Gali, Borivali West, Mumbai – 400 092
Find Bank details below to pay via Cash deposit in Bank:
Bank Name: YES BANK
Account Name: YODA LEARNING SOLUTIONS
IFSC Code: YESB0000213
Account Number: 021383800001525