top of page

Certification Program in

Advanced Excel & VBA

For Students, Freshers and working/business professionals Online, Live & Interactive program

Thoughtware Analytics Logo (2).jpg

PRACTICAL & job oriented

5 WEEKENDS

40 Hours

live

Student Library

JOIN STUDENTS WHATSAPP GROUP

Join other Excel & VBA aspirants and get your questions answered about the course, fees, scholarships, placement assistance, and interships.

Advanced Excel & VBA refers to the use of complex features and functions in Microsoft Excel to analyze, manage, and visualize data effectively.

 

It goes beyond basic spreadsheet operations like data entry and simple formulas.

 

Who Should Learn Advanced Excel and VBA?

 

Advanced Excel and VBA are valuable skills for professionals in various industries who work with data, reporting, and automation.

 

Here are some key groups who should consider learning them:

1. Finance & Accounting Professionals

• Financial analysts, accountants, and auditors use Advanced Excel for financial modeling, budgeting, forecasting, and reporting.

• VBA helps automate tasks like data consolidation, financial calculations, and report generation.

 

2. Data Analysts & Business Intelligence Professionals

• Use Excel's data analysis tools (Pivot Tables, Power Query) for insights and decisionmaking.

• VBA automates data processing, visualization, and reporting.

 

3. HR & Payroll Specialists

• Manage large employee datasets, salary calculations, and HR reports efficiently.

• VBA can automate attendance tracking, payroll processing, and report generation.

 

4. Sales & Marketing Professionals

• Analyze sales trends, customer behavior, and marketing campaign performance using Excel.

• VBA automates sales reports, dashboards, and CRM data management.

 

5. Engineers & Project Managers

• Use Excel for project tracking, resource planning, and cost estimation.

• VBA helps automate repetitive calculations and report updates.

 

6. Researchers & Students

• Handle statistical analysis, experimental data, and academic research.

• VBA helps streamline data processing and result analysis.

 

7. Administrators & Office Workers

• Manage records, schedules, and reports efficiently.

• VBA automates repetitive office tasks, reducing errors and saving time.

 

8. Entrepreneurs & Small Business Owners

• Track expenses, sales, and inventory using Excel tools.

• VBA automates reporting and workflow processes to improve productivity.

 

Learning Advanced Excel boosts efficiency, while VBA helps automate workflows, making professionals more competitive in their fields.

Basic & Advance Excel Training Syllabus

EXCEL INTRODUCTION

• An overview of the screen, navigation, and basic spreadsheet concepts

• Various selection techniques

• Shortcut Keys CUSTOMIZING EXCEL

• Customizing the Ribbon

• Using and Customizing AutoCorrect

• Changing Excel's Default Options

 

USING BASIC FUNCTIONS

• Using Functions - Sum, Average, Max, Min, Count, Counta

• Absolute, Mixed and Relative Referencing

 

FORMATTING AND PROOFING

• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc.

• Basic conditional formatting

 

MATHEMATICAL FUNCTIONS

• Sum If, Sum Ifs, Count If, Count Ifs

• Average If, Average Ifs

 

PROTECTING EXCEL

• File Level Protection

• Workbook, Worksheet Protection

 

TEXT FUNCTIONS

• Upper, Lower, Proper

• Left, Mid, Right

• Trim, Len, Exact

• Concatenate

• Find, Substitute

 

DATE AND TIME FUNCTIONS

• Today, Now

• Day, Month, Year

• Date, Date If, Date Add

• Month, Weekday

 

ADVANCED PASTE SPECIAL TECHNIQUES

• Paste Formulas, Paste Formats

• Paste Validations

• Transpose Tables

 

NEW EXCEL CHARTS

• New Charts - Tree Map & Waterfall

• Sunburst, Box and Whisker Charts

• Combo Charts - Secondary Axis

• Adding Slicers

 

Tool in Pivot & Table

• Using Power Map and Power View

• Forecast Sheet

• Sparklines - Line, Column & Win/Loss

• Pivot Tables

 

SORTING AND FILTERING

• Filtering on Text, Numbers & Colors

• Sorting Options

 

PRINTING WORKBOOKS

• Setting Up Print Area

• Customizing Headers & Footers

• Designing the structure of a template

• Print Titles - Repeat Rows / Columns

 

WHAT IF ANALYSIS

• Goal Seek

• Scenario Analysis

• Data Tables (PMT Function)

• Solver Tool

 

LOGICAL FUNCTIONS

• IF Function

• How to Fix Errors - IFERROR

• Nested IF

• Complex IF and OR functions

 

DATA VALIDATION

• Number, Date & Time Validation

• Text and List Validation

• Custom validations based on formulas

• Dynamic Dropdown List Creation using Data Validation - Dependency List

 

LOOKUP FUNCTIONS

• VLOOKUP / HLOOKUP

• Index and Match

• Creating Smooth User Interface Using Lookup

• Nested

 

VLOOKUP

• Reverse Lookup using Choose Function

• Worksheet linking using Indirect

• VLOOKUP with Helper Column

 

PIVOT TABLES

• Creating Simple Pivot Tables

• Basic and Advanced Value Field Settings

• Classic Pivot Table

• Grouping based on Numbers and Dates

• Calculated Field & Calculated Items

 

ARRAY FUNCTIONS

• What are the Array Formulas, Uses of the Array Formulas?

• Basic Examples of Arrays

• Array with IF, LEN, and MID function formulas

• Array with Lookup functions

• Advanced Use of formulas with Array

 

CHARTS AND SLICERS

• Various Charts

• Using SLICERS, Filter data with Slicers

• Manage Primary and Secondary Axis

Macros & VBA (Visual Basic for Applications)

Recorded Macros

• Understanding Excel Macros

• Enable the Developer Tab

• Record a Macro

• Run a Macro

• Edit a Macro

• Macro Security

• Saving a Document as Macro Enabled

• Relative Cell References

• Assigning a Macro to the Toolbar

• Assigning a Keyboard Shortcut to a Macro

 

Understanding Excel VBA

• Programming in Microsoft Excel

• VBA Terminology

• VBA Editor Screen

• Closing the Editor

• Viewing the Excel Object Model

• Using the Immediate Window

• Setting Property Values

• Working with Worksheets

• Accessing Help

 

Starting with Excel VBA

• Using the Project Explorer

• Working with the Properties Window

• Working with a Code Module

• Setting Breakpoints in Code

 

Using Excel Objects

• Application Object

• Workbook Object

• Range Object

• Using Range Objects

• Using Objects in a Procedure

​

Programming Techniques

• MsgBox Function

• InputBox Function

• InputBox Method

• Simple If Statement

• If...Then...Else Statement

• Select Case Statement

• Do Loop

• Do Until Loop

• Do While Loop

• For Next Loop

• For Each...Next Loop

 

Creating Custom Forms

• Steps to Create Custom Forms

• Adding TextBoxes to a Form

• Changing TextBox Control Properties

• Adding Label Controls to a Form

• Adding a Combo Box Control

• Adding Option Buttons

•Adding Command Buttons

 

Procedures

• Understanding Procedures

• Creating a New Sub Routine

• IntelliSense

• Using the Edit Toolbar
• Commenting Statements

• Indenting Code

• Bookmarking in Procedures

 

Using Variables

• Understanding Variables

• Creating and Using Variables

• Explicit Declarations

• Scope of Variables

• Understanding Passing Variables

• Declaring Data Types

• Using Arrays

​

Functions in VBA

• Understanding Functions

• Creating User-Defined Functions

• VARTYPE Function

• Creating a Function Library

• Importing a VBA Module

 

Error Handling

• Error Types

• Excel Objects

• Handling Errors

• Error-Handling Routine

• On Error Statements

• Error Statement

• Untrapped Errors

• Working with Err Object

Module 1 – Data Science basics (2 hrs)

  • What is coding?

  • Which tools and why?

  • Big Data understanding

  • Statistics/Mathematics basics

Module 2 – Python for data analytics (20 hrs)

  • Is Anaconda/Jupiter still relevant? How Google Collaboratory is replacing it?

  • Conditional & Loop statements

  • Functions

  • Exceptions handling, types of error

  • Modules

  • Tuples, lists, dictionaries

  • NumPy, Pandas

  • Matplotlib

  • Importing files in Python

  • Seaborn

  • Working on datasets(incl preparation, modeling & analysis)

Module 1 – Data Science basics (2 hrs)

  • What is coding?

  • Which tools and why?

  • Big Data understanding

  • Statistics/Mathematics basics

Module 2 – Python for data analytics (20 hrs)

  • Is Anaconda/Jupiter still relevant? How Google Collaboratory is replacing it?

  • Conditional & Loop statements

  • Functions

  • Exceptions handling, types of error

  • Modules

  • Tuples, lists, dictionaries

  • NumPy, Pandas

  • Matplotlib

  • Importing files in Python

  • Seaborn

  • Working on datasets(incl preparation, modeling & analysis)

Detailed Content at the end

 

Placement Assistance – Resume preparation & career advice

 

Duration: 5 weekends, ~ 40 Hrs(Live) Program Saturdays & Sundays, 9am to 1pm

 

Starts on : 22nd March 2025

 

Enrollment under Progress

 

Certificate: After successful training and passing an exam, certificate will be issued by our organization

 

Training Materials: All Excel templates/data sets and relevant study materials will be provided

 

Working System: Candidates are expected to get their own system for learning and practice

 

Price:

1. Rs 25,000 plus GST. Now only Rs 14,999 plus GST. Valid for limited period only

2. This is special promotional price.

3. This pricing is for individuals and request for quote, if you need for corporate training

4. No refund or exchange is possible under any circumstances. Pl make sure you understand the content, scope and methodology, before you enroll

 

Payment: Payment from multiple modes possible – UPI, Credit card, Debit card, Internet Banking and Pocket Wallet. Please reach out to us to get the payment link

Program Conducted by:

237860496_332794388768341_5045427919071572628_n.jpg
  • LinkedIn

Lead Trainer:
Mr. Pattabhi Raman, APICS – CPIM, CSCP, CLTD, DDI – DDPP, PMP

Globally recognized Supply Chain expert

​

Advisers & Consultants 

 

​

​

​

​

​

​

Training Materials:

All Excel/SQL/Python templates/solutions and video recordings link/login will be provided. Recommended books will be suggested

​

Note:

# All rights reserved. Program content, schedule maybe updated depending on requirements

# The candidate is expected to have latest version of software installed in the system and ready with the system during the program. We will not involve in software installation, during our programs

# This Executive program is developed for skill development and are not recognized by any universities and government authorities

gitap.PNG

Dr PC Gita PhD

Ex- CIPLA, SCI, Protec

Marketing & HR Specialist

Contact us for more Info

png-transparent-computer-icons-whatsapp-whatsapp-text-trademark-logo-removebg-preview.png

Thoughtware Training Pvt Ltd Bangalore is one of the best Analytics Training Institute in India

© 2022 by Thoughtware Training Pvt Ltd

bottom of page