Dates?
Times? Costs? Credit card Bookings? Click here.
Advanced Microsoft Excel
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 (peter@harvestconsulting.com.au)
Please email the trainer only about the content of this course. All other queries should be directed to training@melbpc.org.au.