Course Details

InteliGenes Technologies is a very renowned training center.We provide training on various technology.Our VBA course is very useful for them who wants to set their feet in the IT industry. Below topics will be covered:-

• 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 into Excel Object Model Deep Dive into 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 into one using VBA Delete Blank Cells & Sort a List using VBA Generating Multiple PDF Reports using VBA Creating Sparkline 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