Microsoft Office Training in Gurgaon

Overview

The History of VBA

Why VBA

VBA Summary

Active sheet, Active cell, offset, sheet add, rename, etc.

Static & Dynamic

Array functions

Filter, cut, copy, paste, remove duplication, etc.

File system basics

Understanding file permissions

Setting file permissions

Accessing files

Writing to files

Deleting files

Reading files

Examining file details

Working with directories

Viewing directory content

If statements

Else and elseif statements

Logical operators

And. OR, Not. Go to Statements

Switch statements

While loops

For loops

For each loops

do while

do until

Continue

Break

Understanding array pointers

Subroutine

Passing value to sub- procedure

Message box

VBA Inbuilt functions

Passing values in functions

Workbook and worksheet functions

Keywords

Difference between sub-routines and functions

Creating own functions in VBA for Excel

Create new databases, create databases using templates, create databases in older formats, create databases using wizards

Edit references between tables, create and modify relationships, set primary key fields, enforce referential integrity, set foreign keys, view relationships

Navigate to specific records, set a form as the startup option, use navigation forms, set navigation options, change views

Compact databases, repair databases, back up databases, split data bases, encrypt databases with a password, merge databases, recover data from backups

Print reports, print records, maintain backward compatibility, save databases as templates, save databases to external locations, export to alternate formats

Create new tables, import external data into tables, create linked tables from external sources, import tables from other database, create tables from templates and application parts

Hide fields in tables, change data formats, add total rows, add table descriptions, rename tables

Update records, add new records, delete records, append records from external data, find and replace data, sort records, filter records, group records

Add fields to tables, add a validation rules to fields, change field captions, change field sizes, change field data types, configure fields to auto-increment, set default values, use input masks, delete fields

Run queries, create crosstab queries, create parameter queries, create action queries, create multi-table queries, save queries, delete queries

Rename queries, add new fields, remove fields, hide fields, sort data within queries, format fields within queries

RAdd calculated fields, add conditional logic, group and summarize data, use comparison operators, use basic operators

Create new forms, create forms with application parts, save forms,

delete forms

Move form controls, add form controls, modify data sources, remove

form controls, set form control properties, manage labels

Modify tab order in forms, format print layouts, sort records, apply

Modify tab order in forms, format print layouts, sort records, apply themes, change margins, insert backgrounds, auto-order forms, insert headers and footers, insert images, modify existing forms

Find and replace text

Insert symbols and special characters

Apply text effects

Apply formatting by using Format Painter

Set line and paragraph spacing and indentation

Apply built-in styles to text

Clear formatting

Format text in multiple columns

Insert page, section, and column breaks

Change page setup options for a section

Convert text to tables

Convert tables to text

Create tables by specifying rows and columns

Sort table data

Configure cell margins and spacing

Merge and split cells

Resize tables, rows, and columns

Split tables

Configure a repeating row header

Format paragraphs as numbered and bulleted lists

Change bullet characters and number formats

Define custom bullet characters and number formats

Increase and decrease list levels

Restart and continue list numbering

Set starting number values

Insert footnotes and endnotes

Modify footnote and endnote properties

Create and modify bibliography citation sources

Insert citations for bibliographies

Insert tables of contents

Customize tables of contents

Insert bibliographies

Insert shapes

Insert pictures

Insert 3D models

Insert SmartArt graphics

Insert screenshots and screen clippings

Insert text boxes

Apply artistic effects

Apply picture effects and picture styles

Remove picture backgrounds

Format graphic elements

Format SmartArt graphics

Format 3D models

Add and modify text in text boxes

Add and modify text in shapes

Add and modify SmartArt graphic content

Position objects

Wrap text around objects

Add alternative text to objects for accessibility

import Word document outlines

insert slides from another presentation

insert slides and select slide layouts

insert Summary Zoom slides

duplicate slides

hide and unhide slides

modify individual slide backgrounds

insert slide headers, footers, and page numbers

create sections

modify slide order

rename sections

apply formatting and styles to text

format text in multiple columns

create bulleted and numbered lists

insert hyperlinks

insert Section Zoom links and Slide Zoom links

resize and crop images

apply built-in styles and effects to images

insert screenshots and screen clippings

insert and change shapes

draw by using digital ink

add text to shapes and text boxes

resize shapes and text boxes

format shapes and text boxes

apply built-in styles to shapes and text boxes

add alt text to graphic elements for accessibility

order shapes, images, and text boxes

align shapes, images, and text boxes

group shapes and images

display alignment tools

create and insert tables

insert and delete table rows and columns

apply built-in table styles

create and insert charts

modify charts

insert SmartArt graphics

convert lists to SmartArt graphics

add and modify SmartArt graphic content

insert 3D models

modify 3D models

insert audio and video clips

create and insert screen recordings

configure media playback options

apply basic and 3D slide transitions

configure transition effects

animate text and graphic elements

animate 3D models

configure animation effects

configure animation paths

reorder animations on a slide

set transition effect duration

configure transition start and finish options