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 Assessment
thecertiedge.comthecertiedge.com
  • Home
  • All Courses
  • Contact us
  • Other
    • Gallery
    • About us
    • Terms and Conditions
    • Privacy policy
    • Blog
    • Certificate Authentication
  • Talent Assessment
  • Home
  • Course
  • Training on Advanced Excel + Power BI+ Tableau

Training on Advanced Excel + Power BI+ Tableau

  • 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

Introduction to Advanced Excel

  • Overview of Advanced Excel features
  • Excel Interface and Navigation Techniques
  • Working with Multiple Sheets and Workbooks
  • Customizing Excel Settings

Formulas and Functions

  • Advanced Formulas (IF, SUMIF, VLOOKUP, HLOOKUP, INDEX, MATCH)
  • Logical Functions (AND, OR, NOT)
  • Text Functions (TEXT, CONCATENATE, LEFT, MID, RIGHT)
  • Date & Time Functions

Data Analysis & Pivot Tables

  • Creating Pivot Tables
  • Grouping and Filtering Data in Pivot Tables
  • Pivot Charts
  • Calculated Fields and Items in Pivot Tables

Data Visualization and Conditional Formatting

  • Advanced Charting Techniques
  • Conditional Formatting for Data Insights
  • Sparklines and Data Bars
  • Heat Maps and Custom Formatting Rules

Data Validation, Protection & Macros

  • Data Validation and Lists
  • Protecting and Securing Excel Workbooks
  • Introduction to Macros and VBA for Automation
  • Recording and Editing Simple Macros

Introduction to Power BI

  • Overview of Power BI tools and components
  • Power BI Desktop Interface
  • Connecting to Data Sources
  • Data Loading, Transforming, and Cleaning with Power Query

Data Modeling and Relationships

  • Creating Data Models in Power BI
  • Establishing Relationships between Tables
  • Hierarchies and Cardinality
  • Calculated Columns and Measures using DAX

Data Visualization in Power BI

  • Creating Basic Visualizations (Charts, Tables, Maps, etc.
  • Using Slicers and Filters for Interactive Reports
  • Custom Visualizations
  • Themes and Formatting Best Practices

Advanced Power BI Techniques

  • Advanced DAX Functions (CALCULATE, FILTER, and others)
  • Working with Time Intelligence Functions
  • Power BI Service (Publishing Reports, Dashboards, and Sharing)
  • Power BI Q&A and Natural Language Queries

Introduction to Tableau

  • Overview of Tableau Tools and Interface
  • Connecting to Data in Tableau
  • Data Preparation and Data Source Tab
  • Working with Filters and Basic Charts (Bar, Line, Pie)

Data Analysis and Calculations

  • Creating Calculated Fields
  • Aggregate and Disaggregate Functions
  • Conditional Statements (IF, CASE)
  • Working with Table Calculations

Advanced Visualizations

  • Creating Advanced Charts (Heat Maps, Histograms, Tree Maps, Bullet Charts)
  • Working with Dual-Axis and Combined Charts
  • Using Parameters and Filters for Interactivity
  • Formatting Dashboards for Professional Reports

Tableau Dashboards and Storytelling

  • Creating Interactive Dashboards
  • Best Practices for Dashboard Design
  • Storytelling with Data in Tableau
  • Publishing and Sharing Tableau Dashboards

Course Includes:

  • Price:
    ₹50,000.00 ₹60,000.00
  • Lessons:52
  • Level:Intermediate
₹50,000.00 ₹60,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 Assessment

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