Advanced Microsoft Excel 2003/2007
Do you need to:
- Summarise large amounts of data in tables or lists
- Use more complex functions
- Link information with other applications
Prerequisites:
- A sound knowledge of topics covered in Introduction to Excel or similar experience
By the end of the course you will be able to:
- Use Excel as a database to sort and filter lists of information
- Build and consolidate linking formulas to make spreadsheets and spreadsheet calculations more manageable
- Use advanced Excel functions such as IF and VLOOKUP to reduce the risk of data error
- Use PivotTables to summarise large amounts of data in lists or tables
- Record and edit macros to automate repetitive tasks
Trainer:
Peter Harvest
Queries should be directed to training@melbpc.org.au.