Skip to content

Microsoft Excel | Advanced (MEA)


This is the advanced level of Excel. It will focus on features to manage large sets of data by creating analysed reports, advanced filters and automating tasks with macros.

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.

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.

1 Day

Learning Methodologies:

*Pricing available upon request.

for group pricing

Apply Now

Please fill in the form below, and submit your information. Our team will follow up and start your online application.

nEed more Info

Please fill in the form below and our team will be in contact.