Who should do this course?
Anyone who wants to enhance their knowledge of Excel by learning the advanced features like reporting and comparing large sets of data with PivotTables. It is also intended for users who want to automate tasks learning about macros among other advanced features.

Pre-requisites
Excel basic knowledge is required and we assume basic computer skills like working with a mouse and typing on a keyboard are in place. It would be beneficial if you have some knowledge of the Excel intermediate level.

• Create an outline of your data.
• Calculate subtotals on data sets.
• Consolidating and linking data within spreadsheets.
• Applying advanced filters and use forms in a spreadsheet.
• Importing and exporting text files.
• Creating and using macros.
• Combining and comparing large sets of data in a spreadsheet by using PivotTables.
• Create drop-down lists.
• Protecting information of workbooks and spreadsheets.
• Collaborating and sharing spreadsheets by using tracking features.