VBA Macro Training Content
• Understanding Loops & Writing VBA Code
• Variables & More
• Dealing with Cells & Ranges
• Workbooks, Worksheets & Databases
• Working with Charts & Shapes
• Working with Pivots
• User Forms & Databases
• More User Forms & Example Application
• Integrating with Word & PowerPoint
• Additional VBA Techniques
• Using Do While Loop & IF Statement in VBA
• DO WHILE Loop Explained
• Using FOR NEXT Loop in Excel
• Using SELECT CASE Statement in VBA & Working with User
• Defined Functions (UDF)
• Deep Dive in to VBA: Theory on Variables, Scoping etc.
• How to Save and Reuse your Macros
• Dealing with Cells & Ranges Workbooks, Worksheets & Databases
• Working with Charts & Shapes
• Displaying Message Boxes using VBA
• Understanding & Using Cells Object
• File Handling: Opening, Reading & Writing to Files from VBA
• Wrapping a Set of Formulas with IFERROR
• ODBC Connectivity to SQL Database and Query Handling
• Files and Folder Handling (FSO Method)
• Interacting with other MS - Office applications (word, PowerPoint and MS-Access)
• Interacting with Outlook Applications
• Running the SQL Queries within Excel Environment
• Interacting with Internet Explorer
• Interacting with Client Application
• Interacting with SAP Environment by Excel
• Interacting with MAINFRAME by Excel
• Send keys
• Excel to Excel
• Excel to MS Office Applications (Excel, outlook, Access, word, notepad..etc)
• Excel to Database by using SQL
• Excel to Internet Explorer
• Excel to Mainframe
• Excel to SAP
• Excel to Client Application (All kind of applications by identifying API)
• Using Worksheets, Workbook Objects in
• VBA: Example on how to save a copy of workbook
• Consolidate Multiple Workbooks in to one using VBA
• Delete Blank Cells & Sort a List using VBA
• Generating Multiple PDF Reports using VBA
• Creating Spark-line Chart in Excel using VBA
• Cleaning up multiple charts using VBA
• Interactive Excel Charts using VBA
• Animating Excel Charts with VBA
• Building an Application using User Forms & VBA
• Integrating with Word & PowerPoint
• Generate MS Word Reports from Excel
• Create a PPT Slide Deck from Excel
• Running a Macro when user selects a cell
• Showing & Hiding information using VBA
• Text Processing & Analysis using VBA
• Using Arrays in VBA
• Building a Workbook Change Tracker App using VBA
• Debugging & Error Handling in VBA
In the age of information technology every person should be aware of the latest innovations. Modern programs, languages of programming and so on are constantly appearing. Nearly everybody knows Microsoft office and use it every day. But everybody wants to know how to work with it more efficient and quicker. Do you want to find out how to make your work with MS Office, even more, better? You’ll learn it from this course teaching you VBA (Visual Basic for Application). This programming language will automate your work with MS Office and makes it easier.
After this Visual Basic course will able to customize MS office for your needs. You’ll able to:
• To write your formulas and functions in Excel, output pre-programmed messages etc…
• To record macros
• To create custom applications in such programs as Outlook, Excel, PowerPoint, and Access
• It’s only a part of the information, you’ll learn
What this course will cover?
This course will provide you with a lot of information given below:
• You will be able to understand how to work with Visual Basic
• You will find out how to record macros
• You’ll learn how to use loops and functions
• You’ll be taught to create code in Visual Basic Editor
• You’ll get information on debugging, and securing your code
• You will be explained how to make dialogue boxes, input boxes
• You’ll be efficient to XML-based files
Who is this course useful for?
• If you want to work more effectively and efficiently using programs of packaging in Microsoft office.
• Individuals working for IT-industry.
• If you’re a freelancer and want to work efficiently
• Who want to be aware of the latest programming languages? This is for you!
• Application developers
• For people who are in business. The ability to use VBA will meet your business needs
• People who prefer working in Microsoft Office Products
What are your benefits?
To say that Word, Excel, PowerPoint, Outlook, and Access are very popular programs is to say nothing. Daily Creation of documents and presentations and, of course, everybody use outlook to stay in touch with clients. And in common, it gets a lot of time. Everyone wants to reduce the time spending on working with these programs and optimize your working process. It is important to learn how to use such. And this educational course will help you.
The benefits are:
• VBA programming is easy to learn and simple to use
• Gets you work done quicker
• Gives you an opportunity to create your own applications
• To run database more effectively
• To improve work with Excel and Word
Course Duration, Fees