Best Advanced Excel Course Certification- Henry Harvin® in Bangalore

Advanced Excel Course Training in Bangalore

Henry Harvin® Ranks No.1 for Advanced Excel Certification Course in India by Best Course News by Best Course News

  • ★ ★ ★ ★ ★ 4.8/5 Ratings
  • 1.1 Million Learners
  • 4325 Learner’s Rating
  • 81% Report Career Benefits

No. 1 Ranked Advanced Excel Course in India | Trained 5,935+ Participants | Get Exposure to 11+ projects | Learn to Apply Advanced Formulas, Perform Data Analysis & Data Visualization, and Create Pivot Tables & Dashboards| Live Online Classroom Core and Brush-up Training Sessions

Starts In 1 day

17 Apr 2024

Learning Period

24 Hours

Book a Live Class, For Free!

svg-seat Limited seats left

By continuing you agree to Henry Harvin® Terms & conditions and Privacy Policy

Placed Learners

  • Image 4
  • Image 5
  • Image 6
  • Image 7
  • Image 8
  • Image 9
  • Image 10
  • Image 11
  • Image 12
  • Image 13
  • Image 14
  • Image 15
  • Image 16
  • Image 17
  • Image 18
  • Image 19
  • Image 20
  • Image 21
  • Image 22
  • Image 23
  • Image 24
  • placed-learner-1
  • placed-learner-2
  • placed-learner-3
  • placed-learner-4
  • placed-learner-5
  • placed-learner-6
  • placed-learner-7
  • placed-learner-8
  • placed-learner-9
  • placed-learner-10
  • placed-learner-11

Accreditations & Affiliations

accreditations-affiliations1 accreditations-affiliations1 accreditations-affiliations1 accreditations-affiliations1 accreditations-affiliations1 accreditations-affiliations1

There's a reason that 95% of our alumni undertake 3+ courses as a minimum with Henry Harvin®

images78
Nayan
★ ★ ★ ★ ★
link-img
images78
Asma
★ ★ ★ ★ ★
link-img
images78
Siddhartha
★ ★ ★ ★ ★
link-img
images78
Shailja
★ ★ ★ ★ ★
link-img
images78
Veeranjaneyulu
★ ★ ★ ★ ★
link-img
images78
Vinod
★ ★ ★ ★ ★
link-img
images78
TAMILARASAN
★ ★ ★ ★ ★
link-img
images78
Thenraja
★ ★ ★ ★ ★
link-img
images78
Tulika
★ ★ ★ ★ ★
link-img
images78
Sayali
★ ★ ★ ★ ★
link-img
images78
Hariharan
★ ★ ★ ★ ★
link-img
images78
SRUTHI
★ ★ ★ ★ ★
link-img
images78
Annapurna
★ ★ ★ ★ ★
link-img
images78
Mahashweta
★ ★ ★ ★ ★
link-img
images78
Siddhesh
★ ★ ★ ★ ★
link-img
images78
abhijit
★ ★ ★ ★ ★
link-img
images78
Prashant Kumar
★ ★ ★ ★ ★
link-img
images78
Anisha
★ ★ ★ ★ ★
link-img
images78
Anirban
★ ★ ★ ★ ★
link-img
images78
Shubham
★ ★ ★ ★ ★
link-img

Know the complete offerings of our Advanced Excel Course in Bangalore

Key Highlights

images37
24 Hours of Instructor-Led Sessions
images37
8 Hours of Live Interactive Doubt Solving Sessions
images37
4 Hours of Live Master Sessions by Industry Experts
images37
192 Hours of Self Paced Learning
images37
Job-Ready Portfolio of 2+ Capstone Projects
images37
127 Auto-Graded Assessments
images37
4+ Industry Case Studies
images37
36 Guided Hands-On Exercises
images37
2+ Assignments and Mini Projects
images37
2 Mock Interviews and 2 Hackathons
images37
Get 1-Year Gold Membership of Henry Harvin® Accounrs Academy
images37
Get a guaranteed Internship with Henry Harvin® and in top MNC's like J.P. Morgan, Accenture & many more via Forage
images37
Get 3 in 1 Placement support through Placement Drives, Premium access to Job portal & Personalized Job Consulting
images37
3 Hours of Mentorship by Industry Experts
images37
Earn Certification of Course from Henry Harvin®, Govt of India recognized & Award-Winning Institute and NSDC Certification

Upcoming Cohorts

Our Placement Stats

80% images38

Average salary hike

2100+

Access the best jobs in industry

150% images39

Maximum salary hike

Access the best jobs in the industry

You Get 10-In-1 Program

Two-way Live Training Course

Two-way Live Online Interactive Classroom Sessions

 random imgee

Certification

Distinguish your profile with global credentials and showcase expertise with our Hallmark Completion certificate

 random imgee

Projects

Facility to undergo various projects along with the course.

random imgee

Guaranteed Internship

Get a guaranteed Internship with Henry Harvin® and in top MNCs like J.P. Morgan, Accenture & many more via Forage.

 random imgee

Placement

Get 3 in 1 Placement support through Placement Drives, Premium access to Job portal & Personalized Job Consulting

 random imgee

Student Engagement & Events

Free Access to #AskHenry Hackathons and Competitions & many other facilities from Henry Harvin®

 random imgee

Masterclass

Access to 52+ Masterclass Sessions for essential soft skill development

 random imgee

Membership

Get Free Gold Membership of Henry Harvin®

 random imgee

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.

 random imgee

Entrepreneurship Mentorship

Mentorship from Young Successful Entrepreneurs to set up a sustainable & scalable Business from scratch at both Freelance and entrepreneur levels

 random imgee

About the Advanced Excel Course

Duration of Advanced Excel Training Course

  • 24 hours of Two-way Live Online Interactive Advanced Excel Classes 
  • Post that, 24 hours of Live Online Masterclass Sessions (Optional) with our Advanced Excel Classes spread over the next 12 months
  • Attend Unlimited Batches for the next 1 year from the date of enrollment without paying anything extra in our live Advanced Excel classes

About the Advanced Excel Certification

Distinguish your profile with the global credential of Certified Advanced Excel Practitioner (CAEP) and showcase expertise by using the Hallmark of CAEP next to your name. For example, Mr. Karan Kumar (CAEP)

Trainer Profile for Advanced Excel Classes

Trainers providing training in Henry Harvin® possess in-depth knowledge about the tools of Excel. Their efficiency and experience are a bonus that leads to successful learning. In our Advanced Excel Classes, trainers aim to introduce aspirants to real-time issues and teach them to identify the root causes of problems, analyze them, and generate solutions with the use of different tools on various business case studies.

Gold Membership Program

Get 1-Year Gold Membership of Henry Harvin® Accounrs Academy

  • Avail monthly Masterclass Sessions to revise concepts and ask doubts with our Advanced Excel Classes
  • Get Access to LMS Portal with Recorded Videos, Exercises Case Studies
  • Opportunity to network with other industry experts from Management Academy
  • Placement Support with weekly job assistance after completion of our Advanced Excel Classes

Career Benefits of Advanced Excel Course

  • With us at Henry Harvin®, acquire new-generationytical skills with  Advanced Excel classes 
  • Take an Advanced Excel Certification course online to create impressive Excel spreadsheets & dashboards, and perform advanced data analysis
  • Become an expert with Advanced Excel Training in data formatting, data analysis, and data visualization to be globally accepted as a recognized Microsoft Excel Professional
  • Advanced Excel C will help you successfully manage large amounts of data thereby increasing the productivity and revenue of the organization.
  • If you are working in corporate development, equity research, financial planning, analysis, etc. then this Microsoft Excel Certification will give you the essential tools & techniques to rise up the professional ladder 
  • Revamp your credentials by specializing in Advanced Excel skills, which will help you visualize and modify data, prepare comprehensive reports, and analyze information with speed and accuracy
  • Learn to build complex functions and formulae in Microsoft Excel to answer questions about company finances, efficiency, workflow, inventory, and solve problems arising in business in our Advanced Excel Classes
  • Upgrade your CV with Advanced Excel certification credentials (CAEP) and grow professionally
  • Become eligible for promotion or new job roles requiring advanced analytical skills and offer great payouts after finishing these prestigious Advanced Excel Classes

Learning Benefits of Advanced Excel Certification Course

  • Learn the tools  of Advanced Excel to create powerful business solutions with our Advanced Excel Classes
  • Master the ability to record and modify create macros in Microsoft Excel  with our Advanced Excel Classes
  • Know the importance of Index, Match, If with And/Or, Offset combined with other functions in excel and how it helps simplify the process
  • Learn how to create an Excel template setup, financial statements, tables, charts among others  with our Advanced Excel Classes
  • Create dynamic models to cater for different periods to minimize the time consumed with the Advanced Excel Course
  • Learn how to create attractive tables, graphs, and charts for financial analysis output  with our Advanced Excel Classes
  • Get a good understanding of how to gather, structure, and present impressive datasets with Advanced Excel Certification course online
  • Learn to combine multiple worksheets and workbooks with features such as Power Tables, Tables, cell styles, formatting options, etc. with our Advanced Excel Classes

Projects covered (Hands-on Practical Experience) in our Advanced Excel Classes

  • HR: Analyze the Attrition rate of Employees
  • Sales: Predicting Department wise Sales
  • Multi-Domain: Business Analytics Optimization
  • Marketing: Website Trend Analysis
  • Financial Analysis: Stock Market Prediction
  • Finance: Analyze ETF Trends

Agota™ Framework

It is a versatile 10-in-1 program that includes various aspects of competency development and career development.

  • Training: 24 Hours of Two-way Live Online Interactive Classes for Advanced Excel.
  • Projects: Facility to undergo projects in advanced Excel Spreadsheets, dashboards, and more
  • Masterclass: Access to 52+ Masterclass Sessions for essential soft skill development
  • Student Engagement & Events: Free Access to #AskHenry Hackathons and Competitions & many other facilities from Henry Harvin®
  • Membership: Get 1-Year Gold Membership of Henry Harvin® Accounrs Academy
  • E-Learning  Free access to 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.
  • Certification: Distinguish your profile with global credentials and showcase expertise with our Hallmark Completion certificate
  • Internship Support: Get a guaranteed Internship with Henry Harvin® and in top MNC's like J.P. Morgan, Accenture & many more via Forage.
  • Entrepreneurship Mentorship: Mentorship from Young Successful Entrepreneurs to set up a sustainable & scalable Business from scratch at both Freelance and entrepreneur levels
  • Placement Support: Get 3 in 1 Placement support through Placement Drives, Premium access to Job portal & Personalized Job Consulting

Know the complete offerings of our Advanced Excel Course Training in Bangalore

Advanced Excel Course Curriculum

  • Module 1: Introduction to MS Excel

    • 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
    • Quiz Module 1
  • Module 2: Working With Tables

    • Advantage of Converting data into tables
    • Structured formula
    • Use of Slicers
    • Dynamic Range
    • Quiz Module 2
  • Module 3: Understanding Cell References

    • Absolute Reference
    • Relative Reference
    • Mixed Reference
    • 3D Reference
    • Quiz Module 3
  • Module 4: Basics Functions of Excel

    • Text to Column
    • Flash Fill
    • Auto Fill
    • Quiz Module 4
  • Module 5: Sorting Data

    • In Ascending & Descending Order
    • Sort with Text, Numbers & Date
    • Sort with formatting (Cell, Color, Font Color)
    • In Multiple Order
    • In Custom Order
    • Quiz Module 5
  • Module 6: Filtering Data

    • 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
    • Quiz Module 6
  • Module 7: Data Consolidation/ Basics of Formula/ Functions

    • Form multiple Sheets
    • Form multiple Files
    • Understanding Syntax, Intellisense, Suggestion box & optional argument
    • Basic Calculations & BODMAS Rule
    • Calculate Square, cube & Raise Number to Power
    • Quiz Module 7
  • Module 8: If Functions and Test Functions

    • 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
    • Quiz Module 8
  • Module 9: Working With Dates, Countlifs, and Sumlfs

    • Date & Time Formula
    • COUNTIF, COUNTIFS, SUMIF, SUMIFS
    • Quiz Module 9
  • Module 10: Lookup and information Functions

    • 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)
    • Quiz Module 10
  • Module 11: Using Named Ranges

    • Defining and Using Range Names
    • Using Named Ranges in Functions
    • Quiz Module 11
  • Module 12: Data Validation

    • By Numbers, Text Length, Date, List (dropdown)
    • Input Message and Error Message
    • Dependent Data Validation
    • Dynamic Dropdown range with Table
    • Quiz Module 12
  • Module 13: Dynamic Array Formula

    • Spilled Ranges & use of #
    • Sort
    • Sort by
    • Unique
    • Filter
    • Sequence
    • Ifs
    • Quiz Module 13
  • Module 14: Using Conditional formatting

    • Applying Conditional Formatting
    • Applying Multiple Rule Sets
    • Creating Custom Rule Sets
    • Viewing and Managing Rules
    • Clearing Custom Rules
    • Quiz Module 14
  • Module 15: Macros (only Recording, non VBA)

    • 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 prebuild VBA code
    • Quiz Module 15
  • Module 16: Summarizing Data With Pivot Tables

    • 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
    • Quiz Module 16
  • Module 17: Working With Slicers

    • Inserting and Using a Slicer
    • Renaming the Slicer
    • Changing Slicer Settings
    • Formatting a Slicer
    • Clearing the Slicer
    • Quiz Module 17
  • Module 18: Power Pivot / 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
    • Quiz Module 18
  • Module 19: Charts

    • 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
    • Quiz Module 19
  • Module 20: Other Topics

    • Format Painter
    • Freeze Pans
    • Removing Duplicates
    • Transposing Data
    • Paste Special
    • Print Settings
    • Custom Formatting
    • Quiz Module 20
  • Module 21: 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
    • Quiz Module 21
  • Module 22: Protecting and Security

    • Password Protect workbook (file) for open & modify
    • Password Protect Sheet
    • Password protect workbook structure (Review => protect Sheet)
    • Allow Edit Range with password
    • Quiz Module 22
  • Module 23: Mail Merge

    • Understand Mail Merge
    • Quiz Module 23

Know the complete offerings of our Post Graduate Program in Advanced Excel Course

Book a Live Class, For Free!

svg-seat Limited seats left

By continuing you agree to Henry Harvin® Terms & conditions and Privacy Policy

Skills Covered

Mail Merge

Excel Dashboard

Working with Slicers

Power Query

Data Validation

Excel Functions

Tools Covered

tool-image1

Know more about 50+ tools covered in this Advanced Excel Course in Bangalore

Advanced Excel Course Trainers

Extra large avatar

CA Sabeena Vasudeva

A versatile, accomplished & goal-oriented professional with over 15 years of experience in Indirect Taxation, GST, Compliance Management, Litigation, Advisory Services, Transition & Migration, Training & Development and People Management with a proven track record of delivering consistent business results through adept leadership and application of sound management practice Highly capable of providing strategic advisory, tax planning on GST, and other indirect taxation, compliance management, litigation operations, departmental representation, filing appeals and several others Excelled at leading indirect tax planning, reporting and compliance efforts for domestic & cross border operations; proficient in minimizing company’s tax exposure while ensuring compliance with all applicable laws and regulations
Extra large avatar

Parvez B Ansari

Parvez B Ansari is having 8 years of experience on Accounting & Taxation including GST Compliance and Tally.ERP9 Management. He has delivered number of live workshop and training session on compliances accounting & taxation including offline and online mode to the corporates, freshers and working professionals. He is currently working as Corporate tr
Extra large avatar

CS Meenu Arya

Meenu Arya is having 8 years of experience including almost 4 years of consultancy In GST. She has worked into number of domains such as Consultancy, Advisory, Litigation and analysis in the field of direct & indirect taxation. She is currently working as partner in a reputed consultancy firm located in Delhi NCR Region. In her current role, she provides consultancy / advisory services after thoroughly analysing model of business houses and providing the solutions to the respective management. She is a expert in the field of litigation in Indirect , Direct Taxes and Company matters and has presented cases against various Tax Authorities as well.

Know more about background of our trainers

Certifications

Get Ahead with Henry Harvin® Advanced Excel Course in Bangalore Certification

What you'll Learn in this course

Advanced Formulas and Functions

Advanced Filtering and Sorting Techniques

Data Validation Rules

Consolidating Data from Multiple Sources

Data Visualization Techniques

Recording and Editing Macros

Our courses and Course Certificates are trusted by these industry leaders

images68

Know more about the value of this certificate in the industry

Career Services By Henry Harvin®

Career Services
images53

Placement Drives

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.

images54

Premium access to Henry Harvin® Job portal

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.

images55

Personalized Job Consulting

Share what kind of job you are looking for and we will provide you with verified job openings that match your requirement.

Job Profiles

Data Analyst

Operations Manager

Financial Auditor

Supply Chain Expert

Treasury Manager

Business Consultant

Accountants

Inventory and Product Managers

Ecommerce Developers

FAQs

Popular Programs

GST Practitioner Course Training
best seller pic1

4.6(5443 Ratings) 18765 Learners

Income Tax Course
best seller pic1

4.7(3987 Ratings) 11757 Learners

Tax Practitioner Course
best seller pic1

4.8(2351 Ratings) 34762 Learners

GST Plus Course
best seller pic1

4.9(1283 Ratings) 7589 Learners

Certified Advanced QuickBook Course
best seller pic1

4.6(8723 Ratings) 21095 Learners

Income Tax Plus Course
best seller pic1

4.8(2230 Ratings) 23154 Learners

Who We Are?

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.

460,000+

Trained

6,700+

Reviews with 4.5/5
rating

7,000+

Live Classes Every
Month

210+

Corporate Partners

180+

College Partners

87%

Reported Career
Benefits

Why Us?

Certified & Experienced Instructors

Learn More pic31

Gold 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

Awards

award award1 award33 award2

Henry Harvin® often makes the news

images70 images71 images72 images73 images74 images75

Excited to Learn?

Advanced Excel Course in other cities