Skip to content
edvry
  • HOME
  • COURSES
  • CATEGORIES
    • Business
      • Business Analytics & Intelligence
      • Business Law
      • Business Strategy
      • Communication
      • E-Commerce
      • Entrepreneurship
      • Human Resources
      • Management
      • Other Business
      • Project Management
    • Design
      • Design Tools
      • Graphic Design & Illustration
    • Development
      • Data Science
      • Database Design & Development
      • Game Development
      • Mobile Development
      • No-Code Development
      • Programming Languages
    • Finance & Accounting
      • Cryptocurrency & Blockchain
      • Financial Modeling & Analysis
      • Investing & Trading
    • IT & Software
      • IT Certifications
      • Network & Security
      • Operating Systems & Servers
      • Other IT & Software
    • Marketing
      • Content Marketing
      • Digital Marketing
      • Growth Hacking
      • Marketing Analytics & Automation
      • Paid Advertising
    • Office Productivity
      • Microsoft
      • Other Office Productivity
    • Personal Development
      • Career Development
      • Personal Brand Building
      • Personal Productivity
    • Photography & Video
      • Other Photography & Video
    • Engineering
    • Online Education
    • Other Teaching & Academics
    • Teaching & Academics
      • Science
    • Search Engine Optimization
    • Social Media Marketing
    • Software Development Tools
    • Software Engineering
    • Software Testing
    • Web Development
    • Video Design
    • Web Design
  • PAGES
    • Pricing
  • ABOUT US
edvry
  • HOME
  • COURSES
  • CATEGORIES
    • Business
      • Business Analytics & Intelligence
      • Business Law
      • Business Strategy
      • Communication
      • E-Commerce
      • Entrepreneurship
      • Human Resources
      • Management
      • Other Business
      • Project Management
    • Design
      • Design Tools
      • Graphic Design & Illustration
    • Development
      • Data Science
      • Database Design & Development
      • Game Development
      • Mobile Development
      • No-Code Development
      • Programming Languages
    • Finance & Accounting
      • Cryptocurrency & Blockchain
      • Financial Modeling & Analysis
      • Investing & Trading
    • IT & Software
      • IT Certifications
      • Network & Security
      • Operating Systems & Servers
      • Other IT & Software
    • Marketing
      • Content Marketing
      • Digital Marketing
      • Growth Hacking
      • Marketing Analytics & Automation
      • Paid Advertising
    • Office Productivity
      • Microsoft
      • Other Office Productivity
    • Personal Development
      • Career Development
      • Personal Brand Building
      • Personal Productivity
    • Photography & Video
      • Other Photography & Video
    • Engineering
    • Online Education
    • Other Teaching & Academics
    • Teaching & Academics
      • Science
    • Search Engine Optimization
    • Social Media Marketing
    • Software Development Tools
    • Software Engineering
    • Software Testing
    • Web Development
    • Video Design
    • Web Design
  • PAGES
    • Pricing
  • ABOUT US
  • Home
  • Course
  • Advanced Microsoft Interactive and Dynamic Excel Dashboard

Advanced Microsoft Interactive and Dynamic Excel Dashboard

  • By admin
  • Microsoft
    (0.0/ 0 Rating)
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • Description
  • Curriculum
  • FAQ
  • Reviews
19292

If you are really new to Excel dashboards or data analytics in general or you want to advance your knowledge, this is the course for you. We have provided you with the fundamentals you need to work with Excel efficiently and effectively.

This dashboard is going to take you through Power Query, Power Pivot, Modeling, and DAX (Data Analysis Expression).

Learning this advanced Excel Dashboard will make you use Power BI with ease as it uses DAX for computation and Power Query for cleaning and data transformation.

Our aim in this course is to show you how to analyze data and create a visualization from the different tables without you using Xlookup, VLOOKUP or Index and Match but just with simple data Modeling in Power Pivot.

This course is 100% practical

Microsoft Excel is the most commonly used data analysis tool available on the market today. In this course, we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)

Say no to a boring dashboard. With this course, you will start creating a very powerful interactive and dynamic Excel dashboard from day one.

If you are ready to learn with me, let’s join the class and see how creative you could be in the few days to come as you begin the class.

Remember you have life Time access to this course.

This course will be updated frequently with the new dashboard.

be free to ask questions should you got stuck in any of the steps.

I am already waiting for you in the class, nice to have you.

Advanced Power Query In Excel for Data Cleaning and Transformation
  • 1
    Course Project Snippet
    Video lesson
  • 2
    Why do we need to use Power Query & Power Pivot
    Video lesson
  • 3
    Advanced Process to a Better Dashboard Creation
    Video lesson
  • 4
    Course Materials
    Video lesson
  • 5
    Picking the best Charts for your visualizations
    Video lesson
  • 6
    Build free Portfolio to showcase your Dashboard skills to Employers
    Video lesson
How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports
  • 7
    Project Overview
    Video lesson
  • 8
    How to Activate Microsoft Excel Power Pivot
    Video lesson
  • 9
    Importing data into Power Query
    Video lesson
  • 10
    Power Query Transform vs Add Columns explained
    Video lesson
  • 11
    Importing Multiple tables into Power Query
    Video lesson
  • 12
    Updating your current Workbook Settings to get proper Dates and Time
    Video lesson
  • 13
    Checking errors and remove columns and rows in Power Query
    Video lesson
  • 14
    How to add Index number in Power Query
    Video lesson
  • 15
    Merging Queries in Power Query
    Video lesson
  • 16
    Basic way to Append Queries
    Video lesson
  • 17
    Best way to Append Queries using Folder with Auto Update
    Video lesson
  • 18
    Creating a Custom Calendar Table in Power Query
    Video lesson
  • 19
    Better way to Create a Date Table in Power Query (Auto Update)
    Video lesson
  • 20
    How to Move data into Power Pivot from Worksheet
    Video lesson
  • 21
    Important Data Source Settings in Power Query
    Video lesson
  • 22
    Data view vs Diagram view
    Video lesson
  • 23
    Understand Database Normalization
    Video lesson
  • 24
    Creating Relationships in Power Pivot
    Video lesson
  • 25
    How to Edit Relationships in Power Pivot
    Video lesson
  • 26
    Power Pivot view vs Normal Excel Pivot Table
    Video lesson
  • 27
    Power Query and Data Modelling conclusion
    Video lesson
DAX Pack (common DAX functions)
  • 28
    Introduction to DAX in Excel Power Pivot
    Video lesson
  • 29
    How to add DAX Calculated Column
    Video lesson
  • 30
    Calculated Column with Dax If function
    Video lesson
  • 31
    Calculated Column with Dax Switch function
    Video lesson
  • 32
    Total Revenue with Calculated Column
    Video lesson
  • 33
    Introduction to DAX Measures in Power Pivot
    Video lesson
  • 34
    How to write DAX using the Measure BOX
    Video lesson
  • 35
    Implicit vs Explicit Measures
    Video lesson
Advanced Customer Dashboard in Excel using DAX and Excel Functions
  • 36
    How to create a Separate Measures Table
    Video lesson
  • 37
    How to calculate COGS and Gross profit
    Video lesson
  • 38
    Calculating returned Rate using DAX
    Video lesson
  • 39
    How to use DAX All Function
    Video lesson
  • 40
    How to use the DAX Filter Function
    Video lesson
  • 41
    Filtering Table with DAX Function
    Video lesson
  • 42
    How to mark your Date Table
    Video lesson
  • 43
    Time Intelligence YTD MTD and QTD DAX Function
    Video lesson
  • 44
    Last month Revenue and MoM percentage Change
    Video lesson
  • 45
    How to calculate 10-Days Rolling total
    Video lesson
  • 46
    How to calculate 10 Days Transactional Average
    Video lesson
  • 47
    Better to Count using DAX
    Video lesson
Adidas Sales Dashboard
  • 48
    Dashboard overview
    Video lesson
  • 49
    Setting Dashboard Canvas
    Video lesson
  • 50
    How to add M-Code, Last Update date code
    Video lesson
  • 51
    Adding values to cards
    Video lesson
  • 52
    Adding Icons
    Video lesson
  • 53
    Adding new cards with Gradient colors
    Video lesson
  • 54
    How to create a Dynamic Top N in Excel
    Video lesson
  • 55
    Creating a dynamic Title
    Video lesson
  • 56
    How to create multiple Doughnut chart
    Video lesson
  • 57
    Inserting a Bar charts
    Video lesson
  • 58
    How to create a Map chart
    Video lesson
  • 59
    5 Less and Top Profitable Cities
    Video lesson
  • 60
    How to connect Slicers to PivotTables
    Video lesson
Full Dynamic HR (Human Resources) Dashboard
  • 61
    Dashboard Overview
    Video lesson
  • 62
    Transforming and Cleaning data with Power Query
    Video lesson
  • 63
    Inserting PivotTable and Advanced Number formatting
    Video lesson
  • 64
    Adding Month Filter
    Video lesson
  • 65
    Dynamic way to show previous Month revenue with Percentage Change
    Video lesson
  • 66
    Quantity Ordered and Transaction Cards
    Video lesson
  • 67
    Which Product contributed more to Revenue
    Video lesson
  • 68
    Which State should we push more Products to?
    Video lesson
  • 69
    What is the peak month for 2020 and 2021?
    Video lesson
  • 70
    What's our top Region & Sales Channel?
    Video lesson
  • 71
    Revenue trend by Weekday
    Video lesson
  • 72
    Connecting Slicers to PivotTables
    Video lesson
  • 73
    How to create a Single Button that clear all filters
    Video lesson
  • 74
    New way to save your work
    Video lesson
  • 75
    Formatting Slicers
    Video lesson
  • 76
    Cleaning up your dashboard
    Video lesson
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.71
102 reviews
Please, login to leave a review
Stars 5
58
Stars 4
31
Stars 3
7
Stars 2
5
Stars 1
1
Show more

Course Includes:

  • Price:Free
  • Instructor:admin
  • Duration:15 total hours
  • Lessons:1
  • Students:1520
  • Certifications:No
Enroll course

Share On:

Courses You May Like

572168_b277_9.jpg
beginner
Microsoft PowerPoint for 2023 3 Hour Crash Course
(0.0/ 0 Rating)
Free
  • 1 Lessons
  • 963 Students
Add to Wishlist
beginner
Microsoft PowerPoint for 2023 3 Hour Crash Course
(0.0/ 0 Rating)
Free

Requirements Microsoft365 Win or MAC / or PowerPoint 2019 / PowerPoint 2016...

  • 1 Lessons
  • 963 Students
Enroll Now
2e6f10b86796c8d59d8d220be14efdbc
7 total hours
Microsoft Excel: Data Analysis with Excel Pivot Tables
(0.0/ 0 Rating)
Free
  • 1 Lessons
  • 253321 Students
Add to Wishlist
Microsoft Excel: Data Analysis with Excel Pivot Tables
(0.0/ 0 Rating)
Free

Excel Pivot Tables are an absolutely essential tool for anyone working in data analytics...

  • 1 Lessons
  • 253321 Students
Enroll Now
895f445bbe4c4e2ec4a4c9035beb645c
1.5 total hours
Google Gemini Complete Course: Learn Generative AI w/ Gemini
(0.0/ 0 Rating)
Free
  • 1 Lessons
  • 2045 Students
Add to Wishlist
Google Gemini Complete Course: Learn Generative AI w/ Gemini
(0.0/ 0 Rating)
Free

Unleash the Power of Google Gemini: Your AI Revolution Starts Here Are...

  • 1 Lessons
  • 2045 Students
Enroll Now
595020e41963e0a9f16274484c9b5105
24.5 total hours
ChatGPT Complete Guide: Learn Midjourney, ChatGPT 4 & More
(0.0/ 0 Rating)
Free
  • 0 Lessons
  • 212329 Students
Add to Wishlist
ChatGPT Complete Guide: Learn Midjourney, ChatGPT 4 & More
(0.0/ 0 Rating)
Free

Have you heard about the amazing things people and businesses are doing...

  • 0 Lessons
  • 212329 Students
Enroll Now
b298e01a3556d4583da5d29755e8f7dd
2.5 total hours
Microsoft PowerPoint for 2024 – 3 Hour Crash Course!
(0.0/ 0 Rating)
Free
  • 1 Lessons
  • 6985 Students
Add to Wishlist
Microsoft PowerPoint for 2024 – 3 Hour Crash Course!
(0.0/ 0 Rating)
Free

THIS COURSE WAS RECENTLY RE-RECORDED – NEW LECTURES, RESOURCES AND QUALITY. CHECK OUT FREE PREVIEW LECTURES! Do you struggle to get...

  • 1 Lessons
  • 6985 Students
Enroll Now
c2521e4a5b48743a5980081cd2fb56c2
3 total hours
The Complete Guide To Custom GPTs and Actions
(0.0/ 0 Rating)
$49.99$10
  • 1 Lessons
  • 1609 Students
Add to Wishlist
The Complete Guide To Custom GPTs and Actions
(0.0/ 0 Rating)
$49.99$10

Do you want to create your own custom ChatGPT, tailored just for...

  • 1 Lessons
  • 1609 Students
Enroll Now
a3a92a455f1473466d93731a6c288eee
3 total hours
ChatGPT Crash Course: Introduction to ChatGPT for Work
(0.0/ 0 Rating)
Free
  • 1 Lessons
  • 11571 Students
Add to Wishlist
ChatGPT Crash Course: Introduction to ChatGPT for Work
(0.0/ 0 Rating)
Free

Are you ready to dive into the world of AI communication and...

  • 1 Lessons
  • 11571 Students
Enroll Now
42c5ec43d2d458c449829278fafe5711
3 total hours
ChatGPT and the New Wave of ML Language Models
(0.0/ 0 Rating)
$59.99$14
  • 1 Lessons
  • 7748 Students
Add to Wishlist
ChatGPT and the New Wave of ML Language Models
(0.0/ 0 Rating)
$59.99$14

Over 100 million people have tried ChatGPT since it first debuted in...

  • 1 Lessons
  • 7748 Students
Enroll Now
Education-for-Everyone-(2)

Edvry is your ultimate destination for high-quality online learning. We offer expert-led courses across various fields, empowering learners to gain new skills, advance their careers, and achieve their goals.

Online Platform

  • About Us
  • Become an Instructor
  • Zoom Meeting
  • Events
  • Contact Us

Links

  • Membership Level
  • Membership Account
  • Membership Cancel
  • Membership Orders
  • My account
  • Sign In/Registration

Contacts

Enter your email address to register to our newsletter subscription

Icon-facebook Icon-linkedin2 Icon-instagram Icon-twitter Icon-youtube
Copyright 2025 Edvry
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
I want to sign up as instructor
Remember me
Sign In Sign Up
Restore password
Send reset link
Password reset link sent to your email Close
Your application is sent We'll send you an email as soon as your application is approved. Go to Profile
No account? Sign Up Sign In
Lost Password?
edvry
Sign inSign up

Sign in

Don’t have an account? Sign up
Lost your password?

Sign up

Already have an account? Sign in