Best Advanced Excel Course Certification- Henry Harvin® in Surat

Advanced Excel Course Training in Surat

Henry Harvin® Ranks No.1 for Advanced Excel Certification Course 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 2 day

02 Dec 2024

Learning Period

24 Hours

Book a Live Class, For Free!

svg-seat Limited seats left

By submitting this form, you agree to receive SMS communications related to courses at Henry Harvin I have read and acknowledge Henry Harvin’s Privacy Policy and Terms & of Service Message & data rates apply. Message frequency varies. Reply HELP for help and STOP to opt-out.

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
Jagdev Kumar
★ ★ ★ ★ ★
link-img
images78
Abhilasha
★ ★ ★ ★ ★
link-img
images78
Kavya
★ ★ ★ ★ ★
link-img
images78
Umesh
★ ★ ★ ★ ★
link-img
images78
Swaroop
★ ★ ★ ★ ★
link-img
images78
Nishit
★ ★ ★ ★ ★
link-img
images78
Kajal
★ ★ ★ ★ ★
link-img
images78
Ameya
★ ★ ★ ★ ★
link-img
images78
Jagpal
★ ★ ★ ★ ★
link-img
images78
Harsh
★ ★ ★ ★ ★
link-img
images78
Sakeela
★ ★ ★ ★ ★
link-img
images78
Mushfik Hasnen
★ ★ ★ ★ ★
link-img
images78
Aditi
★ ★ ★ ★ ★
link-img
images78
KRUPHA NANDHINEE
★ ★ ★ ★ ★
link-img
images78
Aditi
★ ★ ★ ★ ★
link-img
images78
Tejasri
★ ★ ★ ★ ★
link-img
images78
Pratham
★ ★ ★ ★ ★
link-img
images78
Ramesh
★ ★ ★ ★ ★
link-img
images78
Kunal Kanti
★ ★ ★ ★ ★
link-img
images78
Subir
★ ★ ★ ★ ★
link-img

Know the complete offerings of our Advanced Excel Course in Surat

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
1 Mock Interview and 1 Hackathon
images37
Get 1-Year Gold Membership of Henry Harvin® School of Accounts 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
2 Hours of Mentorship by Industry Experts
images37
Earn Certification of Course from Henry Harvin®, Govt of India recognized & Award-Winning Institute and NSDC Certification

Curriculum For Advanced Excel Course in Surat

  • icons-carri22 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
  • icons-carri22 Module 2: Working With Tables

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

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

    • Text to Column
    • Flash Fill
    • Auto Fill
    • Quiz Module 4
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 Module 9: Working With Dates, COUNTIFS, and SUMIFS

    • Date & Time Formula
    • COUNTIF, COUNTIFS, SUMIF, SUMIFS
    • Quiz Module 9
  • icons-carri22 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
  • icons-carri22 Module 11: Using Named Ranges

    • Defining and Using Range Names
    • Using Named Ranges in Functions
    • Quiz Module 11
  • icons-carri22 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
  • icons-carri22 Module 13: Dynamic Array Formula

    • Spilled Ranges & use of #
    • Sort
    • Sort by
    • Unique
    • Filter
    • Sequence
    • Ifs
    • Quiz Module 13
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 Module 20: Other Topics

    • Format Painter
    • Freeze Pans
    • Removing Duplicates
    • Transposing Data
    • Paste Special
    • Print Settings
    • Custom Formatting
    • Quiz Module 20
  • icons-carri22 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
  • icons-carri22 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
  • icons-carri22 Module 23: Mail Merge

    • Understand Mail Merge
    • Quiz Module 23
  • icons-carri22 Module 24: Complimentary Module 1: Soft Skills Development

    • Business Communication
    • Preparation for the Interview
    • Presentation Skills
  • icons-carri22 Module 25: Complimentary Module 2: Resume Writing

    • Resume Writing

Know the complete offerings of our Advanced Excel Course

Admission Closes On 02 Dec 2024

Days

00

Hours

00

Minutes

00

Seconds

00
svg-seat Limited seats left

By submitting this form, you agree to receive SMS communications related to courses at Henry Harvin I have read and acknowledge Henry Harvin’s Privacy Policy and Terms & of Service Message & data rates apply. Message frequency varies. Reply HELP for help and STOP to opt-out.

Upcoming Cohorts

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 Surat

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 Surat 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

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

Mini MBA Course
best seller pic1

4.5(4733 Ratings) 15243 Learners

GST Plus Course
best seller pic1

4.9(1283 Ratings) 7589 Learners

Excel for Business Analyst Course
best seller pic1

4.4(4091 Ratings) 25635 Learners

TDS Practitioner Course
best seller pic1

4.8(2145 Ratings) 32456 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 Henry Harvin for the best Advanced Excel Course

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

+91 9899 577 620 Need Advice!