CERTIFIED ADVANCED EXCEL, POWER BI, PPT & TABLEAU MASTERCLASS

Master the Most In-Demand Skills of 2022 by spending less than 30 minutes a day. Get Certified by a MCT & take the next step towards growing in your career.

Get Certified by a Microsoft Certified Trainer 

36,294+ students trained with 4.8/5 rating

Our students work at:

Register before December 04, 2022 to unlock bonuses worth ₹ 1,57,000

What will you learn in the Masterclass?

Complete Excel Essentials

Advanced Excel Formulas

Excel Advanced Data Visualisation

Data Analysis With Pivot Tables

Macros & ActiveX Controls

Power BI Dashboards Masterclass

Power Query Transformations

PowerPoint Slide Design Mastery

PowerPoint Animation PRO

Tableau A - Z Expert

Register before December 04, 2022 to unlock bonuses worth ₹ 1,57,000

"Jatan's Masterclass has literally fastracked my career by 10 years. I can't believe I used to spend hours doing what I can do in minutes after enrolling & learning from Jatan. Thanks to him, I am an expert in Excel, Power BI, PowerPoint & Tableau!"

Don't Just Take My Word For It, Here's Some More Proof For You To See...

Register before December 04, 2022 to unlock bonuses worth ₹ 1,57,000

Register before midnight of 03 Dec 2022

To Unlock the bonuses worth Rs 1,57,000/-

Bonus 1

Microsoft Office 365 Subscription (5 Years)

Worth Rs 35,000

Bonus 2

100+ Completely Customizable Excel Templates

Worth Rs 30,000

Bonus 3

Excel Freelancing Training to earn using Excel

Worth Rs 25,000

Bonus 4

Build a personal brand & get 100s of endorsements Training

Worth Rs 40,000

Bonus 5

52 Weeks of Mentorship directly from Mr. Jatan Shah (MCT)

Worth Rs 20,000

Bonus 6

Exclusive Access to Skill Nation's community of Excel Experts (lifetime)

Worth Rs 7,000

To claim your bonuses, register before...

  • 00Hours
  • 00Minutes
  • 00Seconds

Register before December 04, 2022 to unlock bonuses worth ₹ 1,57,000

Detailed Breakdown of Masterclass Curriculum

  • 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

  • Tables & their benefits
  • Introduction to source data
  • Inserting Pivot Tables
  • Understanding the Field List
  • Clear, Select & Move Functions
  • Refreshing Pivot Tables
  • Number & Conditional Format a Pivot Table
  • Sorting a Pivot Table
  • Filter a Pivot Table (Special Trick)
  • Group a Pivot Table (Special Trick)
  • Pivot Table Layouts
  • Table Styles, Grand & Sub Totals
  • Summarize Values By
  • Show Values By
  • Calculated Fields
  • Pivot Charts
  • Slicers
  • Timelines
  • Case Study #1
  • Case Study #2
  • Case Study #3
  • Mega Case Study

  • Name Manager
  • What If Analysis - Goal Seek
  • IFERROR Formula
  • Freeze Panes
  • Multi Level Sort
  • Hide Data
  • Group Data
  • Page Layout & Setup Options
  • Protecting Workbooks
  • Show Formulas Shortcut
  • Text to Columns
  • Working with CSV Files
  • Transposing your Data
  • Inserting Shapes
  • Inserting Smart Art
  • Inserting Images
  • Tracing Precedents
  • Tracing Dependents
  • Remove Duplicates

  • New Features & Changes in Excel
  • XLOOKUP Formula (VLOOKUP Killer)
  • FILTER Formula
  • SORT Formula
  • SORTBY Formula
  • UNIQUE Formula
  • MAXIFS Formula
  • MINIFS Formula
  • IFS Formula (Nested IF Killer)
  • RANDARRAY Formula
  • Combining ALL formulas (PRO)
  • Filled Map Visual
  • Funnel Visual
  • Get Geographical Data in Excel (Automatically)
  • Import Stock Market Data in Excel (Automatically)

  • Wide table vs Tall table
  • Unpivot & Pivot your data
  • Fill Data
  • Replace Data
  • Splitting Data
  • Formatting data
  • Date & Time based transformations
  • Relationships in Data Model
  • Cardinality
  • Lookup formulas vs Relationships
  • Absence of relationships (common scenario)

  • Installation
  • Understanding the interface
  • Types of connectors
  • Loading Data
  • 3 Ways to create a visual
  • Understanding aggregation
  • Understanding the field box
  • Drilling up & Down your data
  • Advanced Drill Down options
  • Formatting visuals
  • Solving a real life challenge
  • Tables & Matrix
  • Bar & Column Charts
  • Pie & Donut
  • Treemaps
  • Line & Combo Charts
  • Bubble Maps
  • Filled Maps
  • Cards & Multi Row Cards
  • Inserting extra elements
  • Assignment
  • Step by step guide on building a bank dashboard
  • Analysing data the expert way
  • 3 AI Powered Visuals to enhance your dashboard

  • Basic Knowledge of PPT
  • How to rotate anything
  • How to set alignments
  • Which are the best fonts to use
  • All about Text Boxes
  • Adding & Editing Images
  • How to remove background
  • Use of Merge Shape
  • Advanced Shape Uses
  • Format Painter
  • Using Custom Colors
  • Using Gradient Fill
  • Best PPT Shortcuts

  • Welcome Slide
  • Presentation Content
  • Services / Features Slide
  • Social Media Profile Slide
  • Percentage & Equation Diagram Slide
  • Pricing Table Slide
  • Process Analysis Slide
  • World Map Slide Design
  • Portfolio Slide Design
  • Infographics Design in PPT
  • SWOT Analysis
  • Resume Slide Design
  • How to design any slide in PPT

  • Essentials of Slide Transition
  • Professional Slide Transitions
  • Timeline Slide Transitions
  • Attractive Slide Transitions
  • Essentials of Slide Animation
  • Entrance Animations
  • Emphasis Animations
  • Exit Animations
  • Motion Paths
  • Animation Painter Tool
  • Team Member Animations

  • Installation
  • Navigation in Tableau
  • Your first 3 minute challenge
  • Marks Tab
  • Granularity
  • Saving & Formatting Data
  • Understanding Maps
  • Relationships & Joins
  • Data Blending
  • Calculated Fields
  • Actual vs Budget
  • Dual Axis
  • Highlight function
  • Creating Bins
  • Parameters
  • Improving Dashboards
  • Executive Story
  • Executive Dashboard
  • Data Preparation
  • PDF to Visualization
  • Grouping Data Challenge
  • Highlight on Maps
  • Predictability using Clustering
  • Multiple Variable Clustering
  • Powerful Trend Analysis
  • Licenses in Tableau

Register before December 04, 2022 to unlock bonuses worth ₹ 1,57,000

Become a Certified Analytics Expert

Yes! You will be certified by a Skill Nation which brings a lot of credibility to your certificate & your resume.

Official and verified

Receive an instructor signed certificate with institution’s logo to verify your achievements and increase your job prospects.

Easily shareable

Add the certificate to your CV or your Resume or post it directly on Linkedin. You can even post it on Instagram and Twitter.

Career improving

Use your Analytical skills to secure a great job & climb up the corporate ladder. Have your certificate act as a proof of your knowledge.

Register before December 04, 2022 to unlock bonuses worth ₹ 1,57,000

How does the Masterclass work?

Step 01

Convenient Video Lessons

Watch interesting bite-sized video modules at your convenience with lifetime access.

Step 02

Live Doubt Solving Sessions

Attend LIVE Weekly Doubt Solving Sessions to get all your questions answered by dedicated experts.

Step 03

Get Certified by Skill Nation

Get Certified by Skill Nation & make your resume stand out with practical skills.

Meet your trainer

Hi, I am Jatan Shah, a Microsoft Certified Trainer & a Microsoft Certified Excel Expert. I help working professionals master analytical skills with ease & consult for top corporate brands to make them more Data Analysis & Presentation Efficient. 

At age 21, I founded my own training & consulting academy which has trained over 45,000+ students just in the last 2 years.

After working as a company valuation analyst helping multiple companies get funding with my valuation models, I found my passion in teaching & now I aim to provide top quality skill training at affordable rates to all working professionals.

Register before December 04, 2022 to unlock bonuses worth ₹ 1,57,000 

Convenient Fees

One Time Fee

Rs 9999 Rs 144000

No Cost EMI

Rs 4999 (Installment x2)

Frequently Asked Questions

I have tried my best to answer all the frequently asked questions. If you still have more questions, please write to us at [email protected] (Give us 24 working hours to respond back).
 

Great question. You get the best of both worlds. Certified Data Analytics Program will have 25 hours of self paced modules that you can watch at your own convenience with lifetime access. You will also have LIVE weekly doubt solving sessions for an entire year where you can ask all your doubts & queries.

There is no time limit for completing the Masterclass. You have lifetime access to it and can watch at your own pace.

Yes! You will have access to all video modules AND the LIVE doubt solving sessions incase you are unable to make it. You can learn post office hours too!

Yes, you will be getting Certified in all 4 softwares by Skill Nation.

Yes! You will get lifetime access to all the video modules.

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

No, you can only watch them online on the portal. The access is for lifetime.

Do you work with any kind of data? If yes, learning to analyze & present it efficiently is a no brainer for you.

Register before December 04, 2022 to unlock bonuses worth ₹ 1,57,000