Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting скачать в хорошем качестве

Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting

Download Files: https://people.highline.edu/mgirvin/A... In this video learn about how to build Excel Dashboard based on Data Model and see first DAX Measure (Formula): 1. (00:22) Introduction 2. (02:43) Power Query to Clean, Transform & Import Text Files (From Folder feature) 3. (09:35) Import Data into Power Pivot Data Model 4. (11:23) PivotTable #1: for Month & Year Revenue 5. (11:38) Group Dates in PivotTable based on Data Model: Automatically adds Columns to Data Model Table. 6. (13:38) First DAX Measure: "Formula for PivotTable" 7. (19:04) Add Slicer to Multiple PivotTables 8. (19:52) Chart #1: Line Chart for Month and Year Data 9. (20:27) Name PivotTables 10. (21:20) PivotTable #2: Revenue for each SalesRep. Name Pivot. Connect to Slicer. 11. (22:39) Chart #2: Bar Chart for SalesRep Revenue 12. (23:52) PivotTable #3: Create Year PivotTable. Name Pivot. Connect to Slicer. 13. (26:00) Create Text Label for Chart #2 based on PivotTable #3 and Slicer. 14. (27:10) PivotTable #4: Cross Tabulated Table for Product and Region. 15. (28:45) Conditional Formatting for PivotTable #4. 16. (29:58) Paste Linked Picture of PivotTable in Dashboard 17. (30:48) Add formatting and Alignment to Dashboard 18. (33:25) Add new Text Files to Folder and Refresh Dashboard 19. (34:59) Edit Query to remove data from Dashboard. 20. (35:38) Summary Reference Video: Excel Magic Trick 1379: Power Query Combine Binary "Expand Button" January 2017 Update    • Excel Magic Trick 1379: Power Query Combin...