01 introduction-to-getting-organized (19.56 MB)
01 the-analysis-process (23.24 MB)
02 ayanna-sticking-with-it (13.15 MB)
01 always-a-need-to-organize (13.11 MB)
04 more-on-sorting-and-filtering (22.47 MB)
01 sorting-datasets (24.56 MB)
02 the-sort-function (17.89 MB)
04 emma-journey-to-a-meaningful-career (18.33 MB)
01 sorting-queries-in-sql (28.16 MB)
01 getting-started-with-data-formatting (6.38 MB)
02 from-one-type-to-another (34.58 MB)
05 data-validation (16.24 MB)
06 conditional-formatting (23.3 MB)
02 merging-and-multiple-sources (16.02 MB)
03 strings-in-spreadsheets (12.84 MB)
01 what-to-do-when-you-get-stuck (17.22 MB)
03 layla-all-about-the-analyze-phase (20.35 MB)
04 running-into-challenges-not-to-worry (32.34 MB)
05 when-to-use-which-tool (15.51 MB)
01 aggregate-data-for-analysis (14.07 MB)
02 preparing-for-vlookup (19.98 MB)
03 vlookup-in-action (9.5 MB)
04 identifying-common-vlookup-errors (23.65 MB)
02 understanding-joins (28.42 MB)
07 count-and-count-distinct (24.76 MB)
01 queries-within-queries (25.62 MB)
02 using-subqueries-to-aggregate-data (23.86 MB)
04 justin-where-data-analysis-takes-you (12.66 MB)
01 data-calculations (10.88 MB)
02 common-calculation-formulas (54.37 MB)
03 functions-and-conditions (29.31 MB)
06 composite-functions (18.69 MB)
01 start-working-with-pivot-tables (36.91 MB)
02 pivot-tables-continued (18.42 MB)
01 queries-and-calculations (15.88 MB)
03 embedding-simple-calculations-in-sql (30.97 MB)
04 calculations-with-other-statements (14.81 MB)
01 check-and-recheck (28.07 MB)
01 temporary-tables (27.34 MB)
03 multiple-table-variations (19.4 MB)
01 congratulations (6.5 MB)