Excel 2016 Intermediate- Cell Referencing & Formulas
- 1st November 2017
- 09:00 AM - 12:00 PM
- 354.1.015 (Computer Lab Library SW1.015)
- Add to Calendar
Objectives of this course are to enable experienced users of Microsoft Excel to increase their knowledge of the many features of this powerful spreadsheet application.
Cell Referencing - Absolute, relative and partial cell referencing - Tracing precedents - Working with Labels and Names Functions & Formulae - Using the IF, AND, and OR functions - Using the VLOOKUP and HLOOKUP functions Working With Excel Files - Linking workbooks & calculating across multiple worksheets - Creating templates - Protecting data
Please ensure you log into TCMS to enrol if you are interested in attending the session.