Using Multiple Worksheets:
This session looks at working on workbooks with more than one sheet. You’ll lean how to use grouping to work more efficiently, how to calculate using cells from different sheets and you’ll learn how to create a summary multiple data sheets.
Grouping across Sheets; Linking Formulae across Sheets; Consolidation.
You will need to be confident setting up a spreadsheet and performing basic calculations. If you are not confident with this please see our session on basic formulas.