Excel VBA or macro training
Training
In Chennai
Description
-
Type
Training
-
Level
Advanced
-
Methodology
Inhouse
-
Location
Chennai
-
Class hours
16h
-
Duration
2 Days
-
Start date
Different dates available
Suitable for: If you have basic knowledge of visual basic and would like to empower yourself by learning the advanced level of macro. A a result you will be able to build your own function, can automate the repetitive tasks and do some process improvements for your organisation.
Facilities
Location
Start date
Start date
About this course
The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.
The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.
The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.
The course provides a solid foundation in Excel VBA.
MS Excel Overview.
Recording a Macro. Reviewing the macro code,
Overview of VBA & Office
Objects , methods and Properties,
Form Designing and Control
Loops and Creating reusable VBA Code
Creating User Defined Functions ( UDF)
Error handling, Debugging.
Automation
Security and many more.
Users familiar with recording and editing basic macros in Excel who want to go further in automating and customising Excel using VBA – Visual Basic for Applications. No previous programming experience is required but an expert level of Excel use is assumed.
Anyone who is having good knowledge in excel and would like to enhance the skills to automate the task, consolidation of multiple workbook and worksheets, designing userform , msg box and combo box.
Participant must have minimum knowledge on visual basic application program and a sound user of excel.
Facilitate quality learning.
Simple Solution to Your Hightech problems.
Industry specific contents with real time and practical examples.
Soft copy of the material Precise, handy and user friendly.(hands in practice, Reference manual)
Moderate consultancy charges with compared to others.
Post training support for 90 days.
Reviews
Subjects
- Visual Basic (VB)
- Microsoft Visual Basic
- Microsoft excel training
- Excel MS
- Basic
- Ms Excel
- VBA (Microsoft Access / Office)
- Microsoft Office
- Basic IT
- Visual Modeling
Teachers and trainers (1)
Prabhas Panda
Principal Consultant
A freelancer having 9 years of experience as MS-Office Trainer and 4 years of expertise as automation consultant. Specialised in providing Advanced excel training to corporate and working professionals as well. he has conducted many Public workshop and quite renowned as one of the best trainer in Chennai.
Course programme
What you can do With Excel VBA:
Create a File Explorer using excel
Consolidated 1000 Text files in 30 seconds
Collate Data from Mutiple sheets/workbooks in seconds
Create a Task Manager using Excel
Create an MP3 player using Excel
Create a File Management tool in Excel
Create a Screen Capture Tool in Excel
Create a Data Search Engine using Excel
Make Excel Speak like a Human
MIS Automation
Dashboard Report automation
Create a foolproof Training/Survey/Feedback Form
Join us to Make an Extra Ordinary Difference at your Workplace and be a Winner.
Additional information
Size never exceeds 15!
Course Content regularly upgraded
Focus on real world application‘Stare-at-the-projector’ & ‘Follow-the-instructor’ approach never used!
Trainers are end users of Excel and not IT guys!
Comprehensive take home material
Why Our Training unique:
Excellent training ambiance to facilitate quality learning.
Industry specific contents with real time and practical examples.
Soft copy of the material Precise, handy and user friendly.(hands in practice, Reference manual)
Moderate consultancy charges with compared to others.
Post training support for 90 days.
Excel VBA or macro training