Henry Harvin® Ranks in Top 30 most Trusted Companies by Insight Success
Boost your career level with our VBA in Advance Excel Training | Gain in-depth working knowledge of VBA | Understand how to automate personal routine tasks using simple VBA macros | Create strong programs and leverage the power of Excel in your custom programs for Businesses| Utilize the VBA In Excel to analyze huge amounts of data, create and maintain complex models and investment scenarios | Learn from basic VBA Concepts to VBA in Advance in Excel.
By continuing you agree to Henry Harvin® Terms & conditions and Privacy Policy
Placed Learners
There's a reason that 95% of our alumni undertake 3+ courses as a minimum with Henry Harvin®
Know the complete offerings of our VBA in Advance Excel Course in Agra
Average salary hike
Access the best jobs in industry
Maximum salary hike
Two-way Live Training Course
Two-way Live Online Interactive Classroom Sessions
Certification
Distinguish your profile with global credentials and showcase expertise with our Hallmark Completion certificate
Projects
Facility to undergo various projects along with the course.
Guaranteed Internship
Get a guaranteed Internship with Henry Harvin® and in top MNCs like J.P. Morgan, Accenture & many more via Forage.
Placement
Get 3 in 1 Placement support through Placement Drives, Premium access to Job portal & Personalized Job Consulting
Student Engagement & Events
Free Access to #AskHenry Hackathons and Competitions & many other facilities from Henry Harvin®
Masterclass
Access to 52+ Masterclass Sessions for essential soft skill development
Membership
Get Free Gold Membership of Henry Harvin®
E-Learning Access
Free access to the E-learning Portal and future updates. Get access to PPTs, Projects, Quizzes, self-paced Video-based learning, a question bank, a library, practice tests, final assessment, a forum, and doubt sessions.
Entrepreneurship Mentorship
Mentorship from Young Successful Entrepreneurs to set up a sustainable & scalable Business from scratch at both Freelance and entrepreneur levels
VBA is a programming language that was developed by Microsoft. It is integrated into the major Microsoft Office applications, such as Word, Excel, and Acces. VBA enables you to automate various activities in Excel like generating reports, preparing charts & graphs, doing calculations, etc. This automation activity is also often referred to as Macro
Using VBA you can accomplish a very complex task in Excel within very few minutes.VBA is very useful for client oriented work, for accountants, production, planners, production supervisor, sales people, financial analysts and other business data analysts. Complex analysis of data can be completed easily without any manual errors in very less time.
This course will give comprehensive knowledge about basic to advanced levels of Visual Basic Analysis in Advanced Excel. It will help you turn Excel into a powerful professional resource that you can use to manage large amounts of information, calculate and analyze complex data and prepare information reports.
Become a part of the Elite Accounts Academy of Henry Harvin® and join the 460,000+ large Alumni Network Worldwide.
Know the complete offerings of our VBA in Advance Excel Course in Agra
This module will introduce the candidate to the world of excel, its effective working and functions.
• Advantages of using MS Excel & Various purpose to use Excel
• Understanding of Workbook, Worksheet, columns, rows & Cells
• Ribbon & Tabs
• Quick access bar, Formula bar, Name bar, Status bar
• Keyboard Shortcuts & Navigation while using large data
• Different Use of Mouse
• Insert Comment
In this module the candidate will learn about different tables and their working.
• Advantage of Converting data into tables
• Structured formula
• Use of Slicers
• Dynamic Range
In this module the candidate will learn about different references of cells.
• Absolute Reference
• Relative Reference
• Mixed Reference
• 3D Reference
In this module the candidate will learn the basic functions of Excel.
• Text to Column
• Flash Fill
• Auto Fill
In this module learn different ways of sorting data effectively.
• In Ascending & Descending Order
• Sort with Text, Numbers & Date
• Sort with formatting (Cell, Color, Font Color)
• In Multiple Order
• In Custom Order
In this module learn how to filter data by using advanced filters to texts, numbers etc.
• Applying Filters by text, numbers, or date on the Data
• Advanced Filter: Setting up Criteria to Filter the data
• Applying Complex Criteria
• Clearing the existing criteria
• Use Wildcard characters in Filter Criteria
In this module the candidate will learn about basic formulas, functions for easy calculations.
• Form multiple Sheets
• Form multiple Files
• Understanding Syntax, Intellisense, Suggestion box & optional argument
• Basic Calculations & BODMAS Rule
• Calculate Square, cube & Raise Number to Power
In this module the candidate will learn about the ‘If’ function.
• Simple If
• Combination of If with OR, AND & NOT
• Nested If Function
• LEN, TRIM, LEFT, RIGHT, MID, FIND, SEARCH, CONCATENATE, UPPER, LOWER, PROPER
• REPLACE, SUBSTITUTE, SEARCH, FIND
In this module the candidate will learn how to work with COUNTIF and SUMIF, and understand the date and time concept of Excel.
• Date & Time Formula
• COUNTIF, COUNTIFS, SUMIF, SUMIFS
In this module the candidate will learn about Lookup and information functions, its advantages and disadvantages.
• Lookup Functions - VLOOKUP. HLOOKUP. LOOKUP
• Disadvantage / Limitations of Vlookup
• Reference Functions - MATCH INDEX
• Simple XLookup
• Exact Match
• Approx Match
• Nested XLookup
• Case Sensitive Xlookup
• Multiple Answer column Xlookup
• Lookup Repeating Value (Using Filter)
In this module the candidate will learn the effective usage of Named Ranges.
• Defining and Using Range Names
• Using Named Ranges in Functions
In this module the candidate will learn about dependent Data Validation.
• By Numbers, Text Length, Date, List (dropdown)
• Input Message and Error Message
• Dependent Data Validation
• Dynamic Dropdown range with Table
In this module the candidate will learn about Array Formulas such as Sort, Unique and more.
• Spilled Ranges & use of #
• Sort
• Sort by
• Unique
• Filter
• Sequence
• Ifs
In this module the candidate will learn about formatting.
• Applying Conditional Formatting
• Applying Multiple Rule Sets
• Creating Custom Rule Sets
• Viewing and Managing Rules
• Clearing Custom Rules
In this module the candidate will learn about Macros.
• Displaying the Developer Tab
• Review and Purpose of Macros
• Where to Save Macros
• Absolute and relative record
• Running macros: Assigning to Quick Access Toolbar, shapes
• Pictures and keyboard shortcuts
• Macro recording with charts & sorting Data
• Alter the recorded code
• User-Defined Function (UDF)
• Use pre built VBA code
In this module learn about Pivot tables and their uses.
• Creating Pivot Tables
• Rearranging Pivot Table Data
• Modifying Pivot Table calculations
• Drill-Down
• Filtering the Pivot data
• Summarizing Values by Sum. Count. Average. Max. and Product
• Show Values As % of Grand Total, % of Column Total, % of Row Total
• Grouping Fields
• Creating Calculated Column(s) in Pivot
• Creating Calculated Item(s) in Pivot
• Showing and Hiding the Grand Totals
• Refreshing data in pivot table
• Changing the scope of data source
In this module the candidate will learn slicers.
• Inserting and Using a Slicer
• Renaming the Slicer
• Changing Slicer Settings
• Formatting a Slicer
• Clearing the Slicer
In this module the candidate will learn about Power Query.
• Enable PowerPivot
• Understand Import Data, Transform data, Data Model to create a report
• Use Load, Load to & Transform Data
• Use of Power query to record steps for all files from a folder
• Add column, Update Column with Text, Numbers, & date
In this module the candidate will learn about Charts, its types, uses and working.
• Selecting data
• Formatting your Chart
• Understanding Different Types of Charts
• Combo Chart
• Creating Custom chart types
• Use of Secondary Axis
• Using Trend Line in Charts
In this module the candidate will learn about topics such as how to transport data, format painter, printing etc.
• Format Painter
• Freeze Pans
• Removing Duplicates
• Transposing Data
• Paste Special
• Print Settings
• Custom Formatting
In this module the candidate will learn about the Excel Dashboard.
• Objective to Create Dashboard
• Create Pivot Table & Charts
• Design Dashboard
• Use Macro to Automatically Refresh all when row data is changed or new data is added
This module will help the candidate to create a strong security for their data.
• Password Protect workbook (file) for open & modify
• Password Protect Sheet
• Password protect workbook structure (Review => protect Sheet)
• Allow Edit Range with password
In this module the candidate will Introduce the concept of Visual Basic for Application to the candidate.
In this module the candidate will learn about the various Modules and Procedures of VBA.
In this module the candidate will learn abouT Loops and Flows.
In this module the candidate will learn about creating and using messages.
In this module the candidate will learn about cells in Excel and its functions.
In this module the candidate will learn how to work with the rows and the columns for effective representation of data.
In this module the candidate will learn about sheets and its functions.
Resume Writing
Know the complete offerings of our Post Graduate Program in VBA in Advance Excel Course
By continuing you agree to Henry Harvin® Terms & conditions and Privacy Policy
Accounting
Finance
VBA functions
Graphical User Interface (GUI)
VLOOKUP & XLOOUP
Macros
Our course is exhaustive and this Certification is proof that you have taken a giant leap in mastering the domain
The practical knowledge and actionable skillset you've gained working on projects, simulations, case studies will set you ahead of the competition
Talk about it on LinkedIn, WhatsApp, Instagram, Facebook, Twitter, boost your resume or frame it - tell your friends and colleagues about it.
Get VBA in Advance Excel Completion Course Certification from Henry Harvin®
Know more about the value of this certificate in the industry
We are dedicated to supporting our students throughout their career journey. Join us, and let's embark on a journey towards a successful and fulfilling career together.
Exclusive access to our dedicated job portal and apply for jobs. More than 2100+ hiring partners’ including top start–ups and product companies hiring our learners. Mentored support on job search and relevant jobs for your career growth.
Share what kind of job you are looking for and we will provide you with verified job openings that match your requirement.
Data Analyst, Metrics and Analytics Specialist, MIS Executive, Market Research Analyst, Big Data Engineer, Big Data Analytic Architect, Big Data Solution Architect
Henry Harvin®️ ranks amongst the Top 500 Global Edtech Companies with 4,60,000+ Alumni, 900+ B2B Clients, 500+ Award Winning Trainers, and 1200+ Courses.
Trained
Certified & Experienced Instructors
Learn MoreGold Membership & Post Training Followups
Tailor Made Training
Flexible Schedule
Access to the Recorded Sessions
10 in 1 Program
Masterclasses By Henry Harvin®️
One-to-One Training