Excel (Intermediate)

This half day workshop, will be in the format of an explanation/demonstration followed by practical exercises, and will cover the following:

• Understand and use Functions (Logical/Statistical/Look up - VLOOKUP)
• How to apply Conditional Formatting
• Create/Format a Table
• Sort and Filter data
• Create a Data Validation list
• Create a Chart
• Create a Pivot Table and Chart
• How to link data to worksheets and workbooks
• How to Protect sheets and workbooks

Please bring along a laptop or tablet with access to excel If possible.