Data Analysis with Spreadsheets

Data Analysis with Spreadsheets is for professionals who need to make sense of data without learning Python or SQL. Module 1: Data cleaning (duplicates, formatting, text functions, TRIM, CLEAN). Module 2: Analysis formulas (SUMIFS, COUNTIFS, AVERAGEIFS, array formulas). Module 3: PivotTables/pivot tables in both Excel and Sheets. Module 4: Dashboard creation — charts, slicers, KPI cards. Module 5: Data visualization best practices (which chart for which data). Module 6: Connecting data sources — import from CSV, web, APIs. Works in both Google Sheets and Excel. 22 lessons. 8 datasets. 4 dashboard projects. From $164.30.