Autoplay
Autocomplete
Previous Lesson
Complete and Continue
PIVOT TABLES - DATA ANALYSIS AND DASHBOARDS
INTRODUCTION
INTRODUCTION TO THE COURSE (1:40)
GETTING STARTED
CREATING YOUR FIRST PIVOT TABLE (6:17)
PIVOT TABLE INTERFACE AND DESIGN (7:42)
SUMMARIZE VALUES (2:13)
SHOW VALUES - RUNNING TOTAL (4:52)
PARETO CHART (2:21)
SHOW VALUES - % OF (2:27)
SHOW VALUES - DIFFERENCE FROM (4:06)
SHOW VALUES - % OF PARENT (3:14)
SHOW VALUES - % OF ROW, COLUMN, GRAND (3:21)
SLICER AND TIMELINE (6:26)
GROUPING DATES AND NON-DATES (6:16)
GETPIVOT DATA (8:52)
EXAMPLES
TOP 10 CUSTOMERS (2:01)
GETTING FREQUENCY (4:02)
COMPARE SUB-CATEGORY AGAINST OTHERS (3:34)
PROFIT AND SALES CORRELATION (2:41)
SEASONALITY (4:54)
% CONTRIBUTION USING HEATMAP (3:46)
TREND USING SPARKLINES (1:57)
POWER PIVOT
AVOID VLOOKUP USING DATA MODEL (11:22)
CREATE DAX MEASURES (5:03)
COMBINE FILES FROM FOLDER (6:57)
ADDITIONAL TIPS
CREATING MULTIPLE SHEETS IN 1 CLICK (3:10)
SETTING UP DASHBOARD (6:00)
FILES FOR PRACTICE
FILES FOR PRACTICE
Get Your Certificate
PROFIT AND SALES CORRELATION
Complete and Continue