Level 9 Data Scientist — MS Office

Level 9 · Data Scientist

Spreadsheets — many tables, one answer

Answer one question from many tables — sheets, lookups, statistics, a pivot.

14 of 14 chapters ready

1Chapter 1One Workbook, Many TabsInsert SheetRename Sheet 2Chapter 2A Number From Another TabReference another sheet 3Chapter 3Call the Range by NameDefine Name 4Chapter 4Two Conditions at OnceCOUNTIFSSUMIFSAVERAGEIFS 5Chapter 5A Lookup That Does Not FailINDEX + MATCHIFERROR 6Chapter 6Split It, Then Clean ItSplit Text to ColumnsRemove Duplicates 7Chapter 7Months Out of DatesYEAR / MONTH 8Chapter 8Formulas That Return a TableUNIQUEFILTERSORT 9Chapter 9The Middle, Three WaysMEDIANMODESTDEV 10Chapter 10Who Is Top, and by How MuchRANKLARGE / SMALL 11Chapter 11Color by AmountColor Scales 12Chapter 12The Shape of the DataTrendlineHistogram ChartBucket size 13Chapter 13Rows Times ValuesPivot TableSummarize by 14CapstoneThe Survey ReportA finished three-tab workbook: fifty survey rows, a pivot, two charts, five answers