About this course
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.
90 minutes.
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.
Recent reviews
Daphne was a great instructor and very patient. They did well to involve the whole class and make sure everyone was ok. They also did well in challenging us to think about when we would use it and make us explain how we did exercises, rather than just telling us.