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

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
Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more