Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

EXCEL VBA(MACROS)

No Reviews Yet

Course type: Online Instructor led Course

Platform: SKYPE , Google Hangout etc

Course ID: 16238

Course type: Online Instructor led Course

Platform: SKYPE , Google Hangout etc

Students Interested 0 (Seats Left 0)

₹ 8,500

No Reviews Yet

Date and Time

Not decided yet.

VR Software Solutions picture
VR Software Solutions

M.sc in informatios systems & MCA

10 Years of Experience

About VR Software Solutions

Both lecturers have got 10+ yrs of teaching experience and they have taught across various institutes
No reviews currently Be the First to Review

About the Course

The Online classes are conducted by the expert trainer who has 15 years experience in Excel and MACROS. He has taken up many corporate sessions of bacthes covering more than 50+ students per batch.We offer Professional and advance Excel/MACROS training at all levels (graduate, postgraduate and professional)
Students with similar needs are grouped in to batches.
****We conduct DAILY and WEEKEND batches ****
***Advanced Excel course would be for 20 hrs followed by MACROS classes for 20 hrs ****. In total we shall conduct 40 classes and ensure you become an expert and you shall be able to create your own macros based on your OR your company needs..

Topics Covered

Session - 1

VBA Overview & VBA Basics

What is VBA?
Quick Review of Macros
Introducing the Visual Basic Editor
Using the Visual Basic Editor
Uses of Record Macro
Understanding and creating Modules
How to create a Message Box
Write program to update and retrieve information using Input Box
Conditions (IF, AND, OR etc.)
Understanding and using Select Case statement
How do I define a Variables and Rules for defining a Variable Name and Type
Creating And Using Variables
Working with For …. Next procedure
Working with Do While …. Loop procedure
Calling Procedures from one procedure to another
How to Save and Protect Modules

Session - 2 & 3
Workbook Objects
Create or Add Single and Multiple Workbooks
Workbooks Save and Save As with Password
Open Single and Multiple Workbooks
Close Specific and Multiple Workbooks
Get Count of Workbooks
To refer a particular Workbooks
Activate from one Workbook to another Workbook
Open Workbooks from Specific Path
Get Workbooks Name and Path
Hide and Unhide for Single and Multiple
Workbooks
Calculate entire Workbook
Protect and Unprotect Worksheets

Session - 4
Worksheet Objects
Insert a Single and Multiple Worksheets
Delete Specific and Multiple Worksheets
Get Count of Worksheets
Select a Specific and All Worksheets
Get All Worksheets Name
Hide and Unhide for Single and Multiple Worksheets
Rename for Single and Multiple Worksheets
Protect and Unprotect Worksheets
Sort and Move Worksheets
Calculate entire Worksheet

Session - 5
Cell Objects
Insert single and multiple Row, Column and Cells
Delete single and multiple Row, Column and Cells
Get Range or Address of Cell and Selection
Navigate from one Cell to another Cell
Select specific Range, Cell, Rows and Column
Types of Selection and Offset method
All the Options in Paste Special
All the Options in Go To
How to update the Formulas
Cut, Copy and Paste Options

Session - 6
Excel Options
Create New Pivot, Refersh and Other Pivot Opotions
All the Filter and Advance Filter Options
Data Sort Options
All Text to Columns Options
All Data Formatting Options
Fill, Clear, Find and Replace Options
Preparation of Chart and Dashboard

Session - 7
VBA Function
What is Function?
User Defined Function
Create a Function using IF Condition and Select Case
Create an Advanced IF Conditional Fuctions
Create an Advanced Computation and Conditional Function

Session - 8
VBA Function
Create a Vlookup Fucntions
Create a Sum Fuctions
Create Count Function
Count All
Count Only Numbers
Count Only Text
Count Only Blanks
Count All

Session - 9
Access Database & Retrieve Data From Access Database Using VBA Excel
Create a New Table and Database in MS Access
Load the Data into Access Database
Create a Query in Access Database
Create Single and Multiple Mapping Tables
Filter Single and Multiple criteria using Access Query
Create Query for Data Grouping
Create Query to Select required Columns
Retrieve specific data using Logical Access Query
Create Access Query to Update, Change and Delete the Information in Access
Retrieve information through Excel from Access Database using VBA

Session - 10
Form Controls and User Forms
Create and Design an User Forms
How to Link the VBA Macro to User Forms
Overview of Form Controls
Create a Form Information Tables and Database

Session - 11
Files Automation through VBA
Files Automation real time scenarios
VBA Sample Project Report preparation

Session - 12
Outlook / Questions and Clarifications
Retrieve the Information through Excel from Outlook using VBA
Write query to Retrieve Mail From, To and CC address from Outlook
Write query to Retrieve Mail Subject and Time from Outlook
Write query to Retrieve Mail Attachment from Outlook

Who should attend

Working Professionals looking to automate process and move to next level.
All the Finance and Marketing professional.
People who want to make a career in Reporting,Analysis and Automation.

Pre-requisites

Share your Skype Id's .
Let us know your pre requisites in the DEMO class so that we can plan your course.
Basic computer knowledge.Excel knowledge would be an added advantage.

What you need to bring

Good presence of Mind.

Key Takeaways

Advanced Excel Knowledge
VBA knack to automate your processes
Creating Dashboards
Analyzing Business Data
Reconciling Data
Automate Report Generation

Reviews

No reviews currently Be the First to Review

Students Interested 0 (Seats Left 0)

₹ 8,500

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 8,500 Enquire

Enquire

Submit your enquiry for EXCEL VBA(MACROS)

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Naveen

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer