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 March 26, 2023 to unlock bonuses worth ₹ 1,57,000
What will you learn in the Masterclass?
Complete Excel Essentials
- Start from the basics of MS Excel to have a solid foundation for advanced learnings
- Move beyond theory & get hands-on practice of all essential tools in MS Excel
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
- Over 25+ Attractive Advanced Excel Charts to help you visualise your data efficiently.
- Guaranteed to boost your presentation skills (no more boring basic charts)
Data Analysis With Pivot Tables
- Powerful & Dynamic Excel Pivot Tables to analyse all kinds of data within seconds
- Easy & quick in-depth analysis to answer key questions. Apply all learnings on multiple case studies provided
Macros & ActiveX Controls
- Learn to automate your work using macros that will save your hours of time & effort
- Convert static excel sheets to dynamic reports using Excel's powerful ActiveX Controls
Power BI Dashboards Masterclass
- Take your data analysis & visualization game to the next level with Power BI
- Learn to build Power BI Dashboards from scratch. No prior knowledge required
Power Query Transformations
- Lean to clean, structure, organize & modify ANY kind of unstructured data
- Automate structuring of data from external sources to save up time & reduce redundant work
PowerPoint Slide Design Mastery
- Learn to build stunning presentations for all kinds of industries in less than 15 minutes
- Helps my students become the star presenter of their office
PowerPoint Animation PRO
- Bring your presentations to life by adding visually appealing animations & transitions
- Over 14 animations & transitions taught to make you stand out from the crowd
Tableau A - Z Expert
- Learn everything about the world's #1 data tool right from the basics till the most advanced level
- Use Tableau to build stunning infographics that take everyone's breath away
Register before March 26, 2023 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 March 26, 2023 to unlock bonuses worth ₹ 1,57,000
Register before midnight of 25 Mar 2023
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 March 26, 2023 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 March 26, 2023 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 March 26, 2023 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
- Microsoft Certified
- 36,294+ Trained
- 753+ Endorsements
- 97,340+ Followers
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 March 26, 2023 to unlock bonuses worth ₹ 1,57,000
Convenient Fees
Frequently Asked Questions
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 March 26, 2023 to unlock bonuses worth ₹ 1,57,000
