Spreadsheets notes

This section is formulas and functions under Spreadsheets: relative versus absolute cell references, formula versus function, order of operations, common functions (SUM, AVERAGE, MIN, MAX, COUNT…

This section is data management and formatting under Spreadsheets. You control how values display, shape rows and columns, sort and filter lists, freeze panes, and apply text wrap / merge. IF and…

This section is the IF function and charts under Spreadsheets. You test a condition and return one of two results, then choose and label a chart that matches the data story. The IF function tests…

This section is spreadsheet integration and printing: move data in and out, link or embed objects when needed, set up the page, then print worksheets and charts cleanly. Database design starts…