BECOME A CERTIFIED ADVANCED EXCEL & POWER BI EXPERT

This is the heading

What will you learn in the program?

Advanced Excel Formulas

  • Super effective 40+ Advanced Excel Formulas that will automate your work by upto 60%
  • Helped my students save 2 hours daily from manual data entry

Excel Advanced Data Visualisation

  • Super effective 40+ Advanced Excel Formulas that will automate your work by upto 60%
  • Helped my students save 2 hours daily from manual data entry

Data Analysis With Pivot Tables

  • Super effective 40+ Advanced Excel Formulas that will automate your work by upto 60%
  • Helped my students save 2 hours daily from manual data entry

Excel Ninja Tips & Tricks

  • Super effective 40+ Advanced Excel Formulas that will automate your work by upto 60%
  • Helped my students save 2 hours daily from manual data entry

Excel Time Saver Shortcuts

  • Super effective 40+ Advanced Excel Formulas that will automate your work by upto 60%
  • Helped my students save 2 hours daily from manual data entry

Power BI Essential Dashboards

  • Super effective 40+ Advanced Excel Formulas that will automate your work by upto 60%
  • Helped my students save 2 hours daily from manual data entry

Power Query Transformations

  • Super effective 40+ Advanced Excel Formulas that will automate your work by upto 60%
  • Helped my students save 2 hours daily from manual data entry

A.I Powered Power BI Dashboards

  • Super effective 40+ Advanced Excel Formulas that will automate your work by upto 60%
  • Helped my students save 2 hours daily from manual data entry

Bonuses

Worth

₹14,000

14,000 Editable PPT Templates For Your Presentation

Worth

₹14,000

14,000 Editable PPT Templates For Your Presentation

Testimonial

Curriculum

Day 1

Chapter 1

Chapter 2

Chapter 3

Day 2

Chapter 1

Chapter 2

Chapter 3

  • Formatting Options
  • Number Formatting
  • Navigation Shortcuts
  • Format Painter
  • Insert Delete Rows & Columns Easily
  • Autofill Data
  • Sorting Data
  • Text Based Filtering
  • Number Based Filtering
  • Date Based Filtering
  • Wildcard Based Filtering
  • Custom Lists
  • Absolute vs Relative References
  • Types of References
    Sum Formula
  • IF Formula
  • Nested IF Formula
  • AND & OR Formula
  • IF & AND Combination
  • IF & OR Combination
  • NOT Formula
  • NOT & IF Combination
  • COUNTIF Formula
  • COUNTIFS Formula
  • AVERAGEIF Formula
  • AVERAGEIFS Formula
  • SUMIF Formula
  • SUMIFS Formula
  • 8+ Statistical Formulas
  • SMALL Formula
  • LARGE Formula
  • RANK Formula
  • VLOOKUP Formula
  • HLOOKUP Formula
  • LookUp Practice
  • INDEX Formula
  • MATCH Formula
  • INDEX & MATCH
  • INDEX & MATCH Practice
  • FV Formula (Finance)
  • RATE Formula (Finance)
  • NPER Formula (Finance)
  • PMT Formula (Finance)
  • PV Formula (Finance)
  • SWITCH Formula
  • UPPER Formula
  • LOWER Formula
  • PROPER Formula
  • TRIM Formula
  • 5+ Date Formulas
  • 5+ Time Formulas
  • Common Errors & How to rectify them
  • Practice Files & Solutions
  • Fundamentals of Data Visualization
  • Shortcuts to insert charts
  • Changing Elements in a chart
  • Formatting Elements in a chart
  • Column Charts
  • Bar Charts
  • Line Charts
  • Select Data Method
  • Area Chart
  • Pie Chart
  • Donut Chart
  • Histogram Chart
  • Pareto Chart
  • Scatter Plot Chart
  • TreeMap Chart
  • Sunburst Chart
  • Waterfall Chart
  • Heat Maps
  • Combo Chart
  • Sparkline Chart
  • Dynamic Dropdown Chart
  • Dynamic Spin Button Chart
  • Funnel Chart
  • Slope Chart
  • Dumbbell Chart
  • Actual vs Target Charts
  • Practice Files & Solutions

FAQs

The workshop starts on Monday, 11th Oct and will go on till Sunday. Saturday will be a break day.

  • Mix of both.
  • Everyday, you will be getting the Session Pre-Recorded Modules.
  • Everyday (all 6Days), before 11am you will be getting the Session Pre-Recorded Modules.
  • Every Second Day there will be a live session at 9PM (IST) to clear all questions/doubts of every session.
  • Like mentioned above. Everyday you will get the recorded videos before 11 am (EST) and you can watch anytime you want throughout the day.
  • Live sessions would be at 9 pm (EST).
  • Sunday, the live MEGA WEBINAR would go on from 11 am (EST) to 1 pm (EST) (2 hours) where we will learn how to analyze dashboard data effectively.
Yes! You will receive recordings of both classes and live sessions. Please note, there would be no recording of the Sunday 11 AM – 1 PM session. That’s the only session where you won’t receive a recording.

You will require a Windows Laptop/PC to attend the workshop. Power BI isn’t available for Mac as of now.

Yes! It is a Microsoft Certified Trainer (MCT) Certified Workshop.
You just need a passion to learn. No prior knowledge about any software is required.

Please email us at [email protected] & our support team will get back to you as soon as possible.

Remember this is a workshop not an online course. So, no you dont get lifetime access to the videos. But we understand, you might want some more time to absorb the information, hence you can view all the videos for 30 days after the workshop.

Join over 9,310,000 learners

₹2499 ₹8500

This Course includes

Step 1

Convenient Video Lessons

Get access to premium video lessons created by Industry Experts to learn at your own convenience.

Step 2

Mentorship Sessions

Get your questions & queries cleared directly from Industry Experts & get first hand experience of your dream job.

Step 3

Mega Webinars

Enjoy hands on practice in our mentor-led Mega Webinars, where you apply the skills learnt during the workshop.

₹670  ₹4000

2700+ Enrolled

Dynamic Pivot Charts & Data Visualization in Excel

Dynamic Pivot Charts & Data Visualization in Excel