Level 5 Analyst — MS Office

Level 5 · Analyst

Spreadsheets — formulas

Let the numbers work: formulas, references, sorting, and a first chart.

14 of 14 chapters ready

1Chapter 1A Grid That Holds FactsType in a cellColumn WidthWrap Text 2Chapter 2Numbers Wearing CostumesCurrencyPercent StyleDecrease DecimalDate format 3Chapter 3Let the Sheet Do the SumStart a formulaRelative referenceFill downSUM 4Chapter 4The Middle, the Most, the LeastAVERAGEMIN / MAX 5Chapter 5Counting and RoundingCOUNT / COUNTAROUND 6Chapter 6Lines and BlocksBordersFill ColorMerge & Center 7Chapter 7The Row That StaysFreeze Panes 8Chapter 8Putting It in OrderSort 9Chapter 9Bars for ComparingBar / Column Chart 10Chapter 10Lines for Change Over TimeLine Chart 11Chapter 11Slices of a WholePie Chart 12Chapter 12A Chart Nobody Has to Ask AboutChart Title and Axis Titles 13Chapter 13Reading Someone Else's SheetA stranger's sheet explained cell by cell 14CapstoneThe Results SheetA class results sheet for 24 students and three tests: rounded averages, best, worst and count, sorted, frozen, shaded header, titled bar chart