Select non-adjacent cells: Click a cell, then Command-click any other cells. If you do this accidentally, drag the yellow dot back to its original position, or press Command-Z on the keyboard to undo the action. If you drag the yellow dot, you copy the cell contents to the rows you drag over. Select a range of adjacent cells: Click a cell, then drag a white dot in any direction across the range of adjacent cells. Select a cell to add or edit its content: Double-click it.

Add a legend, gridlines and other markings.Add column, bar, line, area, pie, doughnut and radar charts.Functions that accept conditions and wildcards as arguments.String operator and wildcards in formulas.Quickly calculate a sum, average and more.Change how pivot table data is sorted, grouped and more.Add calculations to summarise group data.Add tickboxes and other controls to cells.Intro to images, charts and other objects.