Microsoft Advance Excel and VBA Automation Online Training

 

Learn Excel Basics and VBA


Enroll Now – Contact or Whats App 9916470692 || send email to padhlee@gmail.com

Online Training

3 Month Course – Saturday or Sunday ( 2 hour session )
4 Classes per month.

Real-life Case Studies​

Live project based on any of the selected use cases, involving implementation of the various Excel Formulas.

Short Batches

Our Batch Size is 4-5 students to pay complete attention
Trained more than 600 students.

24 x 7 Expert Support

We have 24×7 online support team available to help you with any technical queries you may have during the course.

Frequently asked questions

How to take Excel online Training ?

We provide you the proper software installation to take the live sessions with the trainer. Few students are enrolled in a webinar. You can ask your questions directly in the sessions.

What are the Pre-requisites for online training ?

Need a Computer System , a good Internet connection.

What is the objective of this Course ?

The objective of this course is too well verse the students with all Excel Basics and VBA automation concept.

Can I pay the Fees in installments ?

Yes , Students can pay the fees in installments. If students pay the full fees in advance then he/she will get discount of 1000 rs.

EXCEL vba CURRICULUM

1) VBA Overview
a)VBA Editor
b)Basic Excel Terms
c)Msg Box
d)Input Box
e)Comments
3 ) Conditional Logic
a)If-Else
b)Condition operators
c)Logical operator
d)Select case
e)With and End with
5) Programming Loops
a)Excel VBA For Loops
b)Excel VBA For Each Loops
c)The Cells Property
d)Excel VBA Do Loops
7) Subs and Functions
a)Subroutines
b)Passing Values to a Sub
c)The Message Box
d)Functions in Excel VBA
e)Worksheets Functions
f)The Set Keyword
g)Save function as Add-Ins
9 ) Excel VBA – Excel Objects
a)Create Object
b)Assigning an Object to a Variable
c)Object Properties
d)Object Methods
11) Excel – VBA Error Types[Error Handling]
a)Compile Errors
b)Runtime Errors
c)Logical Errors (‘bugs’)
13) An Excel Picture Viewer Project
a)VBA Option Button Code
b)ImageBox VBA Code
c)Next and Previous Buttons
d)Add New Photo Button
e)Save New Image
f)Copy an Image with Excel VBA
15) Connect with an external data
a)Read external Files
b)Dialog Box Practices
2)VBA Programming Variables
a)Variables( Data types)
b)Variable Practice
c)Add and Subtract
d)Multiply and divide
4) String and String Functions
a)Text Strings in Excel VBA
b)Changing Case
c)Trim, Len, and Space
d)Excel VBA Replace
e)InStr, InStrRev, StrReverse
f)The Left and Right Functions
g)The Mid Function
h)A String Exercise
6)Programming Arrays
a)Arrays in Excel VBA
b)Arrays and Loops
c)Multidimensional Arrays
d)Arrays and the Split function
8 )Creating Your First Macro
a)Recording Your First Macro
b)Recording a Marco
c)See the Recorded Syntax
d)Run the Recorded Marco
10) Excel Events
a)Workbook Event
b)Worksheets Event
c)OR Charts Event
12) Excel VBA and User Forms
a)Get Started with User Forms
b)User Form Buttons
c)Launching your User Forms
14) An Excel Picture Viewer Project
a)Excel Picture Viewer
b)Design the User Form
c)Option and Command Buttons
d)Add New Photo Tab
e)Form Initialize Event
f)Get Text box data
16) Work on automation project

Advance Excel CUrriculum

1) Basics of Excel
Data Formatting in Excel like colors, fonts, Bullets etc
Basic Sorting and Filtering
Basic Formula like SUM,AVERAGE,COUNT,MAX,MIN etc
Spreadsheet Basics
Creating, Editing, saving and Printing spreadsheets
3) Custom and Conditional Formats
Creating a custom format
Create a custom number format
Conditional Formatting
Creating Conditional Formatting
Editing Conditional Formatting
Adding Conditional Formatting
Deleting Conditional Formatting from the selected range
5) Working with Range Names
Using Range names
Creating range names
Using range names in formulas
Creating range names from headings
Deleting range names
7) Absolute and Relative cell reference
Relative cell reference
Absolute cell reference
9) Explore more in Excel
Freeze of windows
Splitting of Windows
Paste Special
Spark lines
Remove duplicates
Go to function tab
Data Reconciliation
11) Getting data
Creating subtotal
Using Automatically Outline
Grouping Data Manually
13) Working with Pivot Tables
Creating Pivot tables
Adding Pivot table Report Fields
Refreshing Pivot table Reports
Changing the summary functions
Creating report filter page
15 ) Worksheet Protection
Protecting your work sheet
Protecting range with password
Protecting your Workbook and Excel Files
17 ) Multiple workbooks
Linking workbooks
Editing the Link
Consolidating the workbooks
19 ) Working with Macros
Display the developer Tab
Changing Macro security Settings
Recording and running a Macro
2) Getting Advance in excel
Sorting Data by values, colors , etc
Filtering by numbers , text , values , logical
Functions ,colors
Using Filters to Sort Data
Using Auto filter
Creating a custom AutoFilter
Advance Filtering Options
4) Data Validation
Specifying a valid range of value of a cell
Specifying a valid value for a cell
Specifying custom validation based on formula for a cell
6) Using Formulas and Functions
Text Function
Logical Functions
Date and Time Functions
Information Function
Database Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and reference functions
8) Excel Auditing Tool
Trace precedents
Remove arrows
10) Managing Tables
Creating Tables
Naming the Tables
Changing the Table style
Creating a total row
Creating a calculated column
using Filtering in Table
Removing the duplicate record
12) Working with Charts
Creating a chart
Formatting a chart
Adding Labels
Changing the chart type, Data source
14) Working with Reports
Creating Subtotals
Multiple Level subtotals
Creating Pivot tables
Formatting and customizing Pivot tables
Using advanced options of pivot table
pivot charts
Consolidating data from multiple sheets and files
using pivot tables
Using external data source
Using data consolidation feature to consolidate data
Show value as ( % of Rows , % of columns , Running Total )
Viewing subtotal under pivot
Creating Slicers
16) Using Shared Work Books
Sharing a workbook
Opening and editing a shared workbook
Tracking changes
Resolving conflict in a shared workbook
18 ) What-IF Analysis
Goal Seek
Data Tables
Scenario Manager