| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel (VBA) Macro Training in Chennai
VBA MACRO Training at Nungambakkam
Visual Basic For Applications (VBA) & Macro Traning Automate Report Generation Automate Chart creation Creating Dashboards Communicating with MS Access Databases Analyzing Business Data Reconciling Data Timesavings Create our Own Functions Session - 1 & 2 VBA Overview & VBA Basic 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 - 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 & Retrive Data From Access Databsae 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 Retrive specific data using Logical Access Query Create Access Query to Update, Change and Delete the Information in Access Retrive information through Excel from Access Database using VBA Session - 10 Form Controls and User Forms Create and Design an UserForm How to Link the VBA Macro to UserForm Overview of Form Controls Create a Form Information Tables and Database Session - 11 Files Automations through VBA Files Automations real time scenarios VBA Sample Project Report preparation Session - 12 Outlook / Questions and Clarifications Retrive the Information through Excel from Outlook using VBA Write query to Retrive Mail From, To and CC address from Outlook Write query to Retrive Mail Subject and Time from Outlook Write query to retrive Mail Attachment from Outlook 96, Kaveri Complex, Nungambakkam High Road, Chennai - 600034. Nungambakkam 9941246766 9789024023 www.excelsense.com Email - |
|
#2
|
|||
|
|||
|
Dear All,
Please take the below (VBA Macro Training) session. It will be very useful to your carrier. VBA MACRO Training at Nungambakkam Visual Basic For Applications (VBA) & Macro Traning Automate Report Generation Automate Chart creation Creating Dashboards Communicating with MS Access Databases Analyzing Business Data Reconciling Data Timesavings Create our Own Functions Session - 1 & 2 VBA Overview & VBA Basic 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 - 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 & Retrive Data From Access Databsae 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 Retrive specific data using Logical Access Query Create Access Query to Update, Change and Delete the Information in Access Retrive information through Excel from Access Database using VBA Session - 10 Form Controls and User Forms Create and Design an UserForm How to Link the VBA Macro to UserForm Overview of Form Controls Create a Form Information Tables and Database Session - 11 Files Automations through VBA Files Automations real time scenarios VBA Sample Project Report preparation Session - 12 Outlook / Questions and Clarifications Retrive the Information through Excel from Outlook using VBA Write query to Retrive Mail From, To and CC address from Outlook Write query to Retrive Mail Subject and Time from Outlook Write query to retrive Mail Attachment from Outlook 96, Kaveri Complex, Nungambakkam High Road, Chennai - 600034. Nungambakkam 9941246766 9789024023 www.excelsense.com Email - [/quote] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Macro Training in Chennai | Excel Discussion (Misc queries) | |||
| Excel VBA Macro Training in Chennai | Excel Programming | |||
| Advanced Excel Training in Chennai | Excel Programming | |||
| VBA Macro Training in Chennai | Excel Discussion (Misc queries) | |||
Linear Mode
