BECOME A CERTIFIED ADVANCED EXCEL & POWER BI EXPERT
This is the heading
Menu
What will you learn in the program?
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
- List Item #1
- List Item #1
- List Item #1
- List Item #1
Chapter 2
- List Item #1
- List Item #1
- List Item #1
- List Item #1
Chapter 3
- List Item #1
- List Item #1
- List Item #1
- List Item #1
Day 2
Chapter 1
- List Item #1
- List Item #1
- List Item #1
- List Item #1
Chapter 2
- List Item #1
- List Item #1
- List Item #1
- List Item #1
Chapter 3
- List Item #1
- List Item #1
- List Item #1
- List Item #1
Excel Essential 101
- 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
Advanced Excel Formulas
- Absolute vs Relative 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
- Types of References
Advanced Excel Formulas
- 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
When does the workshop start?
The workshop starts on Monday, 11th Oct and will go on till Sunday. Saturday will be a break day.
Is the workshop live or pre-recorded?
- 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.
Timings of the workshop?
- 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.
Will I get recordings if I miss out on a live session?
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.
Is there a specific device requirement?
You will require a Windows Laptop/PC to attend the workshop. Power BI isn’t available for Mac as of now.
Is it a certified workshop?
Yes! It is a Microsoft Certified Trainer (MCT) Certified Workshop.
Are there any pre-requisites to attend this workshop?
You just need a passion to learn. No prior knowledge about any software is required.
I made the payment but didn’t receive any update
Please email us at [email protected] & our support team will get back to you as soon as possible.
Will the video access be given for lifetime?
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
- 4.5 hours on-demand video
- 6 articles
- Full lifetime access
- Certificate of completion
- 1,37,000 Worth Rs. Bonus
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
- List Item #1
- List Item #2
- List Item #3
Dynamic Pivot Charts & Data Visualization in Excel
- List Item #1
- List Item #2
- List Item #3
