At the completion of this course you should be able to:
- use a range of techniques to work cells, ranges, tables, worksheets.
- understand Page Layout formatting to better control printouts to paper or pdf.
- use a range of popular worksheet functions (VLOOKUP etc…) and understand how to teach yourself functions that you have not used before.
- create and range names.
- create and work with tables.
- understand apply more sophisticated number formatting and conditional formatting techniques to worksheet cells.
- use goal seeking to determine the values required to reach a desired result.
- use a range of elements and features to enhance charts.