microsoft Excel

Ace Data Visualisation and Dashboard with Pivot Tables and Power Query

Trusted by Over 7K Students and Multiple Corporates with 4.6+ Rating
769 reviews
4.6/5

About the Course

Our Learners Excel, Just Like the Brands They Work For!

8
sales force
1
7
3
icai logo_2
5
2

Here's What You're Going to Learn

Grad Me Up's Promises

This Course is Suitable for You if

Students

You are a student looking to enhance your data analysis skills and learn structured techniques for creating dashboards that will help you in academics and future career opportunities.

Fresher

You are a fresher starting your career and want to master tools like Pivot Tables and Power Query to stand out in interviews and excel in data-related roles.

Working Professionals

You have 2–9 years of experience but are struggling to analyze data efficiently, automate processes, or create impactful dashboards that can help you secure a promotion or a high-paying job.

What Makes Grad Me Up Different?



This is a screenshot of LinkedIn. In India alone, there are over 6,000 jobs that demand Data Analysis

BUT THERE‘S A HUGE PROBLEM

NO ONE IS PROVIDINIG HANDS-ON TRAINING

ALMOST ALL THE TUTORS ARE PROVIDING ONLY PRE-RECORDED LECTURES BECAUSE OF WHICH…

Less than 5% of people complete online courses

No mechanism for feedback and accountability

Data Visualization cannot be learnt by watching videos

We identified this gap and with this Course and we’re on a mission to equip Students and Professionals with practical knowledge that will help them build a
fulfilling and rewarding career

Bonus Contents - Worth ₹10,500+

Pricing

Register now to avail the deal

Minutes
Seconds
Oops! You missed the deal.

Instructors

CA Isha Jaiswal

Co-Founder and Content Creator

CA Rajat Jaiswal

Co-Founder

This course includes:

Course Details

Level:

Beginner to Intermediate
(This course is perfect for students, freshers, and working professionals who want to master data visualization, Pivot Tables, and Power Query. Whether you're just starting or looking to enhance your existing skills, this course caters to all levels.)

Access

Life Time
(Enjoy lifetime access to the course materials, including recorded lectures, templates, datasets, and bonus content. Revisit lessons anytime to refresh your skills.)



Certificate

Shareable
(Earn a recognized certificate that highlights your expertise in Pivot Tables, Power Query, and dashboard creation. Share it on LinkedIn or add it to your resume for career growth.)



Learning Format

Live sessions
(Engage in real-time learning, solve practical exercises, and get expert guidance during live sessions. Learn by doing with a focus on creating dashboards and automating tasks.)


Assignments

Yes, hands-on practice included
(Practice what you learn with 10+ assignments, including real-world datasets and dashboard-building exercises. Apply your skills to solve practical business problems.



Module Breakdown

  • Understanding the basics of Excel structure and functions.
  • Formatting data for better visualization.
  • Introduction to conditional formatting for insights.
  • Overview of charts and graphs in Excel.
  • Best practices for organizing raw data.
  • Creating and customizing Pivot Tables.
  • Using calculated fields and calculated items.
  • Grouping, filtering, and sorting data in Pivot Tables.
  • Summarizing data with advanced aggregation techniques.
  • Creating Pivot Charts for dynamic visualizations.
  • Understanding Power Query and its interface.
  • Importing data from multiple sources (Excel, CSV, databases).
  • Transforming data with Power Query Editor (merge, split, etc.).
  • Cleaning messy datasets automatically.
  • Loading transformed data into Excel.
  • Combining multiple datasets using Append and Merge queries.
  • Creating custom columns with M language formulas.
  • Automating repetitive tasks with query steps.
  • Handling errors and troubleshooting in Power Query.
  • Optimizing query performance for large datasets.
  • Principles of effective dashboard design (layout, colors, interactivity).
  • Using slicers and timelines for dynamic filtering.
  • Linking Pivot Tables, Charts, and Power Query outputs into dashboards.
  • Adding interactivity with form controls (buttons, drop-downs).
  • Exporting dashboards as shareable reports.
  • Sales analysis dashboard (revenue trends, top products).
  • HR analytics dashboard (employee attrition, attendance).
  • Financial analysis dashboard (profit/loss tracking).
  • Marketing campaign performance dashboard.
  • Inventory management dashboard.
  • Automating reports with macros and VBA integration (basic level).
  • Using advanced Excel functions (INDEX-MATCH, XLOOKUP) in dashboards.
  • Troubleshooting common issues in Pivot Tables and Power Query.
  • Optimizing file performance for large datasets.
  • Bonus tips to enhance productivity in Excel.

BONUS 1

Three Power Query Templates Pre-designed templates to automate data cleaning and transformation processes, saving hours of manual work. [Worth ₹9,200] – FREE


BONUS 2

An Excel E-Book with 90+ Formulas for Data Visualization A comprehensive guide to mastering essential Excel formulas and techniques for creating impactful visualizations. [Worth ₹1,100] – FREE

BONUS 3

Course Completion Certificate Receive a professional certificate from Grad Me Up to showcase your expertise in Power Query and Pivot Tables. [Priceless] – FREE


BONUS 4

Private WhatsApp Community Access Join an exclusive community of learners and experts for lifetime support, networking, and tips on data visualization. [Priceless] – FREE

Testimonial

What people say about us