01 course-introduction (12.13 MB)
07 business-analysts-and-microsoft-excel (20.15 MB)
01 introduction-to-microsoft-excel (15.44 MB)
02 entering-and-formatting-data (11.59 MB)
01 reading-large-data-blocks (18.03 MB)
02 sorting-and-filtering-data-in-excel (16.72 MB)
05 module-summary-excel-fundamentals (10.53 MB)
01 what-is-a-formula (14.06 MB)
02 controlling-calculations (16.34 MB)
04 controlling-calculations-in-action (10.02 MB)
01 what-is-a-function-formula-and-how-to-write-it (17.04 MB)
02 using-the-insert-function (8.77 MB)
05 module-summary-formulas-and-functions (21.84 MB)
01 how-inconsistent-data-can-affect-data-analysis (21.33 MB)
01 why-understanding-date-calculations-is-important (16.82 MB)
02 dynamic-date-and-time-entries (10.25 MB)
01 using-the-if-function (20.79 MB)
02 using-nested-if-and-ifs-function (18.57 MB)
06 module-summary-preparing-data-for-analysis-using-functions (18.73 MB)
01 creating-tables (20.56 MB)
02 naming-and-managing-tables (16.24 MB)
04 modifying-tables (14.88 MB)
01 what-is-a-pivot (25.46 MB)
02 working-with-pivottables (26.66 MB)
04 customizing-results (36.32 MB)
01 using-the-show-values-as-feature (31.14 MB)
02 slicers-and-timelines (27.74 MB)
04 calculated-fields (21.65 MB)
05 module-summary-working-with-pivots (23.2 MB)
01 course-recap-preparing-data-for-analysis-with-ms-excel (25.38 MB)
01 congratulations (9.51 MB)