Advanced Microsoft Interactive and Dynamic Excel Dashboard
- Description
- Curriculum
- FAQ
- Reviews
Advanced Excel Dashboard Creation
Description:
Take your Excel skills to the next level with our Advanced Microsoft Interactive and Dynamic Excel Dashboard course. Excel dashboards are powerful tools for visualizing data and making informed decisions, and this course will equip you with the knowledge and techniques needed to create interactive and dynamic dashboards that impress and inform. From advanced data visualization to interactive features, you’ll learn how to design and build professional-grade dashboards that drive insights and facilitate data-driven decision-making.
Whether you’re a business analyst, financial professional, or data enthusiast, this course is tailored to help you unlock the full potential of Excel for dashboard creation. Through hands-on tutorials and real-world examples, you’ll gain practical experience in building dynamic dashboards that meet the needs of your organization or clients.
Requirements:
Participants should have a solid understanding of Excel fundamentals, including functions, formulas, and data manipulation techniques. Familiarity with basic data visualization concepts and Excel features such as PivotTables and Charts is recommended. Access to Microsoft Excel (preferably Excel 2016 or later) and a computer with internet access is necessary to complete the course exercises.
Who this course is for:
– Business analysts seeking to enhance their data analysis and visualization skills to create impactful dashboards.
– Financial professionals looking to improve reporting processes and present data in a compelling and interactive format.
– Data enthusiasts interested in learning advanced Excel techniques for dynamic dashboard creation to showcase insights and trends effectively.
In this course, you’ll:
– Explore advanced Excel features and techniques for building interactive and dynamic dashboards.
– Learn how to create dynamic charts, slicers, and interactive elements to enhance dashboard usability.
– Discover best practices for designing visually appealing dashboards that effectively communicate insights.
– Gain practical experience through hands-on projects and case studies, applying learned concepts to real-world scenarios.
– Master the art of storytelling with data, leveraging Excel dashboards to present findings and drive decision-making.
Enroll now to elevate your Excel skills and become proficient in creating advanced interactive and dynamic dashboards!
-
7
Project Overview -
8
How to Activate Microsoft Excel Power Pivot
-
9
Importing data into Power Query
-
10
Power Query Transform vs Add Columns explained
-
11
Importing Multiple tables into Power Query
-
12
Updating your current Workbook Settings to get proper Dates and Time
-
13
Checking errors and remove columns and rows in Power Query
-
14
How to add Index number in Power Query
-
15
Merging Queries in Power Query
-
16
Basic way to Append Queries
-
17
Best way to Append Queries using Folder with Auto Update
-
18
Creating a Custom Calendar Table in Power Query
-
19
Better way to Create a Date Table in Power Query (Auto Update)
-
20
How to Move data into Power Pivot from Worksheet
-
21
Important Data Source Settings in Power Query
-
22
Data view vs Diagram view
-
23
Understand Database Normalization
-
24
Creating Relationships in Power Pivot
-
25
How to Edit Relationships in Power Pivot
-
26
Power Pivot view vs Normal Excel Pivot Table
-
27
Power Query and Data Modelling conclusion
-
28
Introduction to DAX in Excel Power Pivot
-
29
How to add DAX Calculated Column
-
30
Calculated Column with Dax If function
-
31
Calculated Column with Dax Switch function
-
32
Total Revenue with Calculated Column
-
33
Introduction to DAX Measures in Power Pivot
-
34
How to write DAX using the Measure BOX
-
35
Implicit vs Explicit Measures
-
36
How to create a Separate Measures Table
-
37
How to calculate COGS and Gross profit
-
38
Calculating returned Rate using DAX
-
39
How to use DAX All Function
-
40
How to use the DAX Filter Function
-
41
Filtering Table with DAX Function
-
42
How to mark your Date Table
-
43
Time Intelligence YTD MTD and QTD DAX Function
-
44
Last month Revenue and MoM percentage Change
-
45
How to calculate 10-Days Rolling total
-
46
How to calculate 10 Days Transactional Average
-
47
Better to Count using DAX
-
48
Dashboard overview
-
49
Setting Dashboard Canvas
-
50
How to add M-Code, Last Update date code
-
51
Adding values to cards
-
52
Adding Icons
-
53
Adding new cards with Gradient colors
-
54
How to create a Dynamic Top N in Excel
-
55
Creating a dynamic Title
-
56
How to create multiple Doughnut chart
-
57
Inserting a Bar charts
-
58
How to create a Map chart
-
59
5 Less and Top Profitable Cities
-
60
How to connect Slicers to PivotTables
-
61
Dashboard Overview
-
62
Transforming and Cleaning data with Power Query
-
63
Inserting PivotTable and Advanced Number formatting
-
64
Adding Month Filter
-
65
Dynamic way to show previous Month revenue with Percentage Change
-
66
Quantity Ordered and Transaction Cards
-
67
Which Product contributed more to Revenue
-
68
Which State should we push more Products to?
-
69
What is the peak month for 2020 and 2021?
-
70
What's our top Region & Sales Channel?
-
71
Revenue trend by Weekday
-
72
Connecting Slicers to PivotTables
-
73
How to create a Single Button that clear all filters
-
74
New way to save your work
-
75
Formatting Slicers
-
76
Cleaning up your dashboard
