COMBINE FILES FROM FOLDER

CREATE DAX MEASURES

COMPARE SUB CATEGORY AGAINST OTHERS

AVOID VLOOKUP USING DATA MODEL

% CONTRIBUTION USING HEATMAP

CREATING MULTIPLE SHEETS IN 1 CLICK

CREATING YOUR FIRST PIVOT TABLE

GETPIVOT DATA

GETTING FREQUENCY

GROUPING DATES AND NON DATES

INTRODUCTION TO THE COURSE

PARETO CHART

PIVOT TABLE INTERFACE AND DESIGN

PROFIT AND SALES CORRELATION

SEASONALITY

SLICER AND TIMELINE

SUMMARIZE VALUES

TOP 10 CUSTOMERS

TREND USING SPARKLINES

SETTING UP DASHBOARD

SHOW VALUES % OF PARENT

SHOW VALUES % OF ROW, COLUMN, GRAND

SHOW VALUES % OF

SHOW VALUES RUNNING TOTAL

SHOW VALUES DIFFERENCE FROM

014 FORMATTING

001 WHAT IS APPS SCRIPT

004 CUSTOM FUNCTIONS

002 SETTING IT UP WRITE FIRST MACRO

003 RECORDING MACRO ON EXCEL VS GOOGLE SHEET VS EXCEL ONLINE