Categories: Microsoft Office Specialist
Advance Excel with Macro | VBA Programming
Learn Advance Excel with VBA Programming and master the skill of automation. Increase your knowledge, create User Defined Functions and automate you day to day work effectively using Excel Macros | VBA Programming.
Accomplished experts and excellent option for employees and job aspirant graduates
No matter whether you are looking for better recognition at work or improved job opportunities; our VBA Programming course in Mumbai and Navi Mumbai is the best choice available. You can learn from highly accomplished experts who have vast experience in this field. Our program meets the requirements of experienced professionals, beginners and aspiring graduates in a perfect way.
The modern complex business environment demands expertise in Microsoft Excel along with Macro | VBA Programming. Our course helps you add this skill set in an easy and affordable manner. Our VBA Programming Training cost is highly affordable and you can expect a systematic approach with us.
Weekend and Weekdays batches available : Contact us
For classroom advanced excel training and certification. Kindly click “Contact us” button and fill the form. Our representative will contact you with all the details.
Syllabus:
Units of study
Advance Excel:
Create Worksheets and Workbooks
- Create a workbook
- Import data from a delimited text file
- Add a worksheet to an existing workbook
- Copy and move a worksheet
Navigate in Worksheets and Workbooks
- Search for data within a workbook
- Navigate to a named cell, range or workbook element
- Insert and remove hyperlinks
Format Worksheets and Workbooks
- Change worksheet tab color
- Rename a worksheet
- Change worksheet order
- Modify page setup
- Insert and delete columns or rows
- Change workbook themes
- Adjust row height and column width
- Insert headers and footers
Customize Options and Views for Worksheets and Workbooks
- Hide or unhide worksheets
- Hide or unhide columns and rows
- Customize the Quick Access toolbar
- Change workbook views
- Change window views
- Modify document properties
- Change magnification by using zoom tools
- Display formulas
Configure Worksheets and Workbooks for Distribution
- Set a print area
- Save workbooks in alternative file formats
- Print all or part of a workbook
- Set print scaling
- Display repeating row and column titles on multipage worksheets
- Inspect a workbook for hidden properties or personal information
- Inspect a workbook for accessibility issues
- Inspect a workbook for compatibility issues
Manage Workbooks Advance Settings
- Save a workbook as a template
- Copy macros between workbooks
- Reference data in another workbook
- Create Worksheets and Workbooks
- Enable macros in a workbook
- Display hidden ribbon tabs
- Restrict editing
- Protect a worksheet
- Protect workbook structure
- Configure formula calculation options
- Manage workbook versions
- Encrypt a workbook with a password
Insert Data in Cells and Ranges
- Replace data
- Cut, copy, or paste data
- Paste data by using special paste options
- Fill cells by using Auto Fill
- Insert and delete cells
Format Cells and Ranges
- Merge cells
- Modify cell alignment and indentation
- Format cells by using Format Painter
- Wrap text within cells
- Apply number formats
- Apply cell formats
- Apply cell styles
Summarize and Organize Data
- Insert sparklines
- Outline data
- Insert subtotals
Create and Manage Tables
- Create an Excel table from a cell range
- Convert a table to a cell range
- Add or remove table rows and columns
Manage Table Styles and Options
- Apply styles to tables
- Configure table style options
- Insert total rows
Filter and Sort a Table
- Filter records
- Sort data by multiple columns
- Change sort order
- Remove duplicate records
Insert and Format Objects
- Insert text boxes and shapes
- Insert Images
- Modify Object Properties
- Add Alternative text to Objects for accessibility
Apply Custom Data Formats and Validation
- Create custom number formats
- Populate cells by using advanced Fill Series options
- Configure data validation
Apply Advanced Conditional Formatting and Filtering
- Create custom conditional formatting rules
- Create conditional formatting rules that use formulas
- Manage conditional formatting rules
Create and Modify Custom Workbook Elements
- Create custom color formats
- Create and modify cell styles
- Create and modify custom themes
- Create and modify simple macros
- Insert and configure form controls
Prepare a Workbook for Internationalization
- Display data in multiple international formats
- Apply international currency formats
- Manage multiple options for +Body and +Heading fonts
Perform Data Analysis and Business Intelligence
- Import, transform, combine, display, and connect to data
- Consolidate data
- Perform what-if analysis by using Goal Seek and Scenario Manager
- Calculate data by using financial functions
Troubleshoot Formulas
- Trace precedence and dependence
- Monitor cells and formulas by using the Watch Window
- Validate formulas by using error checking rules
- Evaluate formulas
Define Named Ranges and Objects
- Name cells
- Name data ranges
- Name tables
- Manage named ranges and objects
Create Advanced Charts
- Create a new chart
- Add additional data series
- Switch between rows and columns in source data
- Analyze data by using Qucik Analysis
- Add trend lines to charts
- Create dual-axis charts
- Save a chart as a template
Create and Manage PivotTables
- Create PivotTables
- Modify field selections and options
- Create slicers
- Group PivotTable data
- Reference data in a PivotTable by using the GETPIVOTDATA function
- Add calculated fields
- Format data
Create and Manage Pivot Charts
- Create PivotCharts
- Manipulate options in existing PivotCharts
- Apply styles to PivotCharts
- Drill down into PivotChart details
Macros
- Introduction to Macros
- Recording a Macros
- Modifying a Recorded Macro
- Using Form Controls
- Macro Security Setting
Format and Modify text using Functions
- Format text by using RIGHT, LEFT and MID functions
- Format text by using UPPER, LOWER and PROPER functions
- Format text by using CONCATENATE function
Apply Functions in Formulas
- Perform calculations by using the SUM function
- Perform calculations by using MIN and MAX functions
- Perform calculations by using the COUNT function
- Perform calculations by using the AVERAGE function
- Perform logical operations by using AND, OR, and NOT functions
- Perform logical operations by using nested functions
- Perform statistical operations by using SUMIFS, AVERAGEIFS, and COUNTIFS functions
Look up data by using Functions
- Look up data by using the VLOOKUP function
- Look up data by using the HLOOKUP function
- Look up data by using the MATCH function
- Look up data by using the INDEX function
Apply Advanced Date and Time Functions
- Reference the date and time by using the NOW and TODAY functions
- Serialize numbers by using date and time functions
Regular Functions and Formulas
- Match Functions
- Information functions
- Formatting functions
- String functions
Macros | VBA Programming:
VBA Overview
- Introduction
- Accessing VBA Editor
VBA Excel Macros
VBA Terms
- Modules
- Procedure
VBA Comments
- Apostrophe Comments
- REM Comments
Message Box
- MsgBox Button Constant
- MsgBox Icon Constant
- MsgBox Retrun Value
Input Box
Variables
- Numeric Data Types
- Non-Numeric Data Types
Constants
Operators in VBA Programming
- Mathematical / Arithmetic Operators
- String Operators
- Comparison Operators
- Logical Operators
VBA Decision Making
- If…Then Statement
- If…Then Statement…Else Statement
- If…Then Statement…ElseIf…Else Statement
- Select….Case Statement | Switch Statement
VBA LOOPS
- For … Next
- For Each… Next
- Do…While Loop
- Do…Until Loop
- While…Wend
VBA Functions
- String Functions
- Date & Time Functions
VBA Arrays
VBA Sub Procedure
VBA Events
VBA Error Handling
VBA Excel Objects
VBA User Form
VBA Project
