Details
Introduction to VBA
- 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)
Sneak peek in to Excel Object Model
- 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
Introduction to MS Access & SQL
- 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
Understanding User Form Events & Working with Multiple Forms
- 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
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
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
- 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
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