Skip to content
thecertiedge.comthecertiedge.com
  • Category
    • Cloud Computing
    • Others
    • SAP
  • Home
  • All Courses
  • Contact us
  • Other
    • Gallery
    • About us
    • Terms and Conditions
    • Privacy policy
    • Blog
    • Certificate Authentication
  • Talent acquisition
thecertiedge.comthecertiedge.com
  • Home
  • All Courses
  • Contact us
  • Other
    • Gallery
    • About us
    • Terms and Conditions
    • Privacy policy
    • Blog
    • Certificate Authentication
  • Talent acquisition
  • Home
  • Course
  • Advanced Excel

Advanced Excel

  • By Certiedge official
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape

Course Duration: 32 Hours of Comprehensive Learning

Mode of Learning:

Choose the training format that best fits your schedule and learning style:

  1. Online Instructor-Led Training – Learn directly from certified experts in live interactive sessions.
  2. Online Self-Paced Learning – Study anytime, anywhere with flexible access to course materials.
  3. Onsite / Classroom Training – Experience hands-on, instructor-led sessions in a collaborative environment.

What’s Included:

Our comprehensive training program is designed to ensure a complete, career-ready learning experience. You’ll get:

  • Onsite Instructor-Led Sessions
  • Live Role
  • Certified Trainers
  • Post-Training Support
  • Resource Materials including eBooks, eGuides, and reference documentation.
  • Real-World Scenarios & Case Studies
  • Networking Opportunities
  • Group Projects and Collaborative Activities
  • Best Practices and Industry Insights
  • Access to Recorded Sessions (available only for online programs) for flexible review.
  • Follow-Up Sessions
  • Tool Demonstrations and Walkthroughs

Empower your career with expert-led, practical, and flexible training designed to help you master real-world skills and stay ahead in the industry.

 

Show More

Course Content

Review of Basic Excel Functions

  • Overview of Excel Interface and Features
  • Essential Excel Functions Recap: SUM, AVERAGE, COUNT, etc.

Advanced Cell Referencing

  • Absolute vs Relative vs Mixed References
  • Using Named Ranges for Easier Management

Logical Functions

  • IF, AND, OR, IFERROR
  • Nested IF Statements

Lookup and Reference Functions

  • VLOOKUP, HLOOKUP, INDEX, MATCH
  • Using INDIRECT for Dynamic References

Data Sorting and Filtering

  • Sorting Data by Multiple Criteria
  • Advanced Filtering Techniques (AutoFilter, Custom Filters)

Data Validation

  • Setting Up Validation Rules (Lists, Date Ranges, Text Length)
  • Preventing Invalid Data Entry

Creating Pivot Tables

  • What are Pivot Tables?
  • Step-by-Step Guide to Building Pivot Tables

Pivot Charts

  • Creating Pivot Charts from Pivot Tables
  • Formatting and Customizing Pivot Charts

Creating Advanced Charts

  • Combination Charts (Bar + Line)
  • Histogram and Boxplot Charts

Customizing Charts

  • Formatting Data Series, Axes, and Legends
  • Dynamic Chart Labels and Titles

Data Consolidation and Grouping

  • Consolidating Multiple Data Ranges
  • Grouping Data by Categories

Text Functions for Data Cleaning

  • Text-to-Columns
  • LEFT, RIGHT, MID, LEN, TRIM, FIND, SUBSTITUTE

Introduction to Power Query

  • Importing Data from Various Sources (CSV, Web, SQL)
  • Transforming Data with Power Query

Data Automation Using Macros

  • Introduction to Macros and VBA
  • Recording and Editing Simple Macros

Advanced Conditional Formatting

  • Using Conditional Formatting Rules for Data Visualization
  • Applying Color Scales, Icon Sets, and Data Bars

Creating Dashboards and Reports

  • Combining Pivot Tables, Charts, and Conditional Formatting
  • Designing Interactive Dashboards in Excel

Course Includes:

  • Price:
    ₹51,000.00 ₹57,000.00
  • Lessons:32
  • Level:Intermediate
₹51,000.00 ₹57,000.00
10ZUCU1h07wsB2i2AtWrsOOBCipoGRxlcLVnuH0OBSOebJFPcu325fCF7uAblhKs

No. 112, AKR Tech Park, B Block, 7th Mile, Hosur Road,
Bommanahalli, Bangalore – 560068, Karnataka

Company

  • Home
  • All Courses
  • Contact us
  • Other
  • Talent acquisition

Support

  • Home
  • About us
  • Contact us
  • Privacy policy
  • Terms and Conditions
  • Blog

Contacts

Call: (+91) 987-667-0964
Email: customersupport@thecertiedge.com

Icon-linkedin2 Icon-instagram X-twitter Icon-youtube
©2024-2025 Certiedge Solutions and Services. All Rights Reserved
thecertiedge.comthecertiedge.com
Hi, Welcome back!
Forgot Password?
Don't have an account?  Register Now