VBA Macro Corporate Training

VBA Macro Corporate Training

MS EXCEL VBA MACRO Training – VBA Macro Corporate Training- Excel 2016 & 2019 Latest Version

Microsoft Visual Basic for Applications (VBA, Macros) when used with Microsoft Excel can build powerful automated business tools quickly and minimum cost. If you sit in front of a computer screen all day creating reports in Microsoft Excel, you know the power of this VBA software package. But if you aren’t using macros yet, you don’t know the half of it. Macros automate common and repetitive keystrokes that you use in Excel to create and edit spreadsheets. By reducing the number of keystrokes required to perform common commands, macros speed up your production and reduce the time you have to spend staring at an electronic spreadsheet each day. We provide the best VBA Macros training in Nungambakkam, Chennai. We also provide Corporate Training in VBA. It is a general purpose programming language, that comes along as standard with the Excel or Office can be used to perform various business tasks like-

Automate Report Generation
Automate Chart creation
Creating Dashboards
Communicating with MS Access Databases
Analyzing Business Data
Reconciling Data
Timesavings
Create our Own Functions

Prerequisites for attending the VBA Training programme:

Good Knowledge of all features of Excel such as Filters, Pivot Tables, Text to Columns etc.
Good knowledge of Fundamental and Formulae and Functions in Excel
Must have worked on applications using Excel for atleast 1 year
Good Analytical Skill and Numerical ability is an advantage
Should take up Excel Test

Syllabus & Training Details

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

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

Create and Design an UserForm
How to Link the VBA Macro to UserForm
Overview of Form Controls

Files Automations through VBA

Files Automations real time scenarios
VBA Sample Project Report preparation

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

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

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

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

Syllabus of Power BI Training – Next Generation Dashboard – 15 Hours Training

Overview of Power BI Desktop

Power BI Mechanism

Power BI Desktop – Installation

Data Set Transforming

Reports and Visualization Controls

Getting started with Power BI Desktop

Connect to data sources in Power BI Desktop

Clean and transform your data with the Query Editor

More advanced data sources and transformation

Cleaning irregularly formatted data

Excel, Access, Text / CSV

XML, JSON, Web

SQL Server Database

Oracle Database

Power BI Data Sets

Power View, Power Query, Power Pivot

Power BI Template

Custom Visual from file & marketplace

Options – Global

Options – Current File

Data Source Current File

Global Permissions

Guided Learnings

Documentation

Training Videos

Support

About

Power BI Blog

Community

Power BI for Developers

Samples

Community Galleries

Submit an idea

Introduction to modelling your data

How to manage your data relationships

Create calculated columns

Optimizing data models

Create calculated measures

Create calculated tables

Explore your time-based data

Introduction to visuals in Power BI

Create and customize simple visualizations

Combination charts

Slicers & Filters

Map visualizations

Matrixes and tables

Scatter charts

Waterfall and funnel charts

Gauges and single-number cards

Modify colours in charts and visuals

Shapes, text boxes, and images

Page layout and formatting

Group interactions among visualization

Duplicate a report page

Show categories with no data

Summarization and category options

Z-order

Visual hierarchies and drill-down

Introduction to the Power BI service

Quick insights in Power BI

Create and configure a dashboard

Ask questions of your data with natural language

Create custom Q&A suggestions

Share dashboards with your organization

Display visuals and tiles full-screen

Edit tile details and add widgets

Get more space on your dashboard

Install and configure a personal gateway

Introduction to using Excel data in Power BI

Upload Excel data to Power BI

Import Power View and Power Pivot to Power BI

Connect OneDrive for Business to Power BI

Excel in Power BI – summary

DAX Introduction

DAX calculation types

DAX functions

Using variables in DAX expressions

Table relationships and DAX

DAX tables and filtering

Introduction to content packs, security, and groups

Publish Power BI Desktop reports

Print and export dashboards and reports

Manually republish and refresh your data

Introducing Power BI Mobile

Create groups in Power BI

Build content packs

Use content packs

Update content packs

Integrate OneDrive for Business with Power BI

Publish to web

Completion of Power BI Guided Learning