Self paced

Advance Excel & Power BI

This course is designed to help professionals unlock the full potential of Excel and Power BI for data analysis, reporting, and visualization. Participants will learn advanced Excel functions, data manipulation, and how to create interactive reports and dashboards using Power BI, enabling them to make informed decisions backed by data.

  • 4.9/5.0
  • 2K Enrolled
  • All level
  • Last updated 03/2024
  • Hinglish
Course Description

This course is designed to help professionals unlock the full potential of Excel and Power BI for data analysis, reporting, and visualization. Participants will learn advanced Excel functions, data manipulation, and how to create interactive reports and dashboards using Power BI, enabling them to make informed decisions backed by data.

Benefits
  • Master advanced Excel functions like VLOOKUP, INDEX MATCH, and array formulas.
  • Learn to create sophisticated data models and reports in Power BI.
  • Enhance your ability to analyze and visualize complex data.
  • Gain valuable skills for data-driven decision-making in business.
  • Improve your productivity with automation techniques in Excel.

Take away
  • Proficiency in advanced Excel techniques and data analysis.
  • Ability to create dynamic reports and interactive dashboards in Power BI.
  • Hands-on experience with data visualization best practices.
  • Certification to showcase your advanced data analysis skills.
  • Enhanced decision-making abilities through data insights and reporting.
Tools of home tab

2m 10s


Tools of home tab-2

2m 10s


Details of Conditional Formatting in Excel

2m 10s


Format as Table in Excel

2m 10s


File Export

2m 10s


Vertical Lookup (VLOOKUP)

2m 10s


Data Tab (Part 1)

2m 10s


Data Tab (Part 2)

2m 10s


Button Creation (Part 1)

2m 10s


Button Creation (Part 2)

2m 10s


Formula Tab (Part 1)

2m 10s


Formula Tab (Part 2)

2m 10s


Chart Creation (Part 1)

2m 10s


Chart Creation (Part 2)

2m 10s


Drill Through (Part 1)

2m 10s


Drill Through (Part 2)

2m 10s


Introduction

2m 10s


Course overview

2m 10s


Creation of 3D Charts (Part 1)

2m 10s


Creation of 3D Charts (Part 2)

2m 10s


Pivot Table Analyze Tab

2m 10s


Overview

2m 10s


Pivot table

2m 10s


Page Layout (Part 1)

2m 10s


Page Layout (Part 2)

2m 10s


Description Tab

2m 10s


Formula to Make S Curve

2m 10s


Dashboard (Part 1)

2m 10s


Dashboard (Part 2)

2m 10s


Introduction to Power BI (Part 1)

2m 10s


Introduction to Power BI (Part 2)

2m 10s


Format & Transform (Part 1)

2m 10s


Format & Transform (Part 2)

2m 10s


instructor-image

Anudesh has 3+ years of experience as a Business Analyst in the IT industries expertise in project management, agile, scrum, and business analysis. He has completed his graduation in civil engineering and made a successful career in IT project management. He is a certified scrum master and mentored 2000 + students with different skills. He has worked with many startups in different technologies and domains.

  • 9.1k
  • 4.5
  • 29 Courses
  • 205
About Instructor
Anudesh has 3+ years of experience as a Business Analyst in the IT industries expertise in project management, agile, scrum, and business analysis. He has completed his graduation in civil engineering and made a successful career in IT project management. He is a certified scrum master and has mentored 2000 + students with different skills. He has worked with many startups in different technologies and domains.

Our Student Reviews

4.5

(Based on todays review)

avatar
Jacqueline Miller

2 days ago

Perceived end knowledge certainly day sweetness why cordially. Ask a quick six seven offer see among. Handsome met debating sir dwelling age material. As style lived he worse dried. Offered related so visitors we private removed. Moderate do subjects to distance.

avatar
Louis Ferguson

1 days ago

Water timed folly right aware if oh truth. Imprudence attachment him for sympathize. Large above be to means. Dashwood does provide stronger is. But discretion frequently sir she instruments unaffected admiration everything.


avatar
Dennis Barrett

2 days ago

Handsome met debating sir dwelling age material. As style lived he worse dried. Offered related so visitors we private removed. Moderate do subjects to distance.


Leave a Review
Frequently Asked Questions

This course is designed for data analysts, business professionals, and anyone interested in data visualization and business intelligence.

No, the course is beginner-friendly and covers everything from the basics to more advanced features.

You’ll need Power BI Desktop, which is free to download, and access to Power BI Service for sharing reports.

The course typically takes around 6-10 hours to complete, depending on your pace.

Yes, upon successfully completing the course, you will receive a certification of completion.
Ask Your Question
  • Louis Ferguson

    Removed demands expense account in outward tedious do. Particular way thoroughly unaffected projection?

    5hr
course image

₹5000

60% off

5 days left at this price

This course includes

  • Lectures 10
  • Duration 6 Hours
  • Skills All level
  • Language Hinglish
  • Deadline Feb. 10, 2025
  • Certificate Yes
📞