Share with friendslinkedin

CREATE AN EXCEL DASHBOARD WITH POWER QUERY (OFFICE 365)

0
(0 Reviews)

Duration 1 h 20 m 29 s

Price

$ 6 Buy now
CREATE AN EXCEL DASHBOARD WITH POWER QUERY (OFFICE 365)

About Course

Creating a Dashboard in Excel from scratch can feel overwhelming. But it does not have to be!

In this class we will use Excel Power Query together with Excel's data modeling and Pivot Table tools to get it setup REALLY fast. 

In this class you will learn:

  • Import from Text/CSV and Excel files
  • Apply regional settings to make sure dates and numbers are shown correctly
  • Use Excel's data model and Power Pivot
  • How to create an interactive dashboard that can be refreshed with the click of a button
  • How to use Pivot Charts and Pivot Slicers
  • Useful Excel Dashboards Tips and Tricks

The techniques we cover in this class will give you additional ideas to apply to your own reports to give them an edge and make them more professional. 

Follow along with me and create this interactive dashboard from scratch!

Course content

videoIntroduction2 m 2 s Start
videoClass Expectations1 m 10 s Start
videoHow To Use Downloadable Resources1 m 40 s Start
videoPrepare a Draft of the Dashboard3 m 48 s Start
videoImport Master data from External Workbook with Power Query5 m 33 s Start
videoImport Data from Text File with Power Query4 m 27 s Start
videoCreate the Data Model & Define Relationships in Power Pivot3 m 9 s Start
videoCreate Logic for Latest and Previous Month in Power Query7 m 43 s Start
videoSetup Calculations with Pivot Tables for Latest Month3 m 53 s Start
videoLink Excel Shapes to Data & Linked Picture Trick9 m 27 s Start
videoTop 3 Sales Managers & Numbers (Sorted Excel Pivot Table)5 m 9 s Start
videoLinked Table for Sales by Product Category8 m 24 s Start
videoExcel Pivot Chart for Monthly Sales6 m 5 s Start
videoPivot Slicer Connected to Multiple Pivot Tables12 m 15 s Start
videoFinalize the Excel Dashboard5 m 44 s Start
ubaid

ubaid

Course Instructor

0
(0 Reviews)
See more