Excel is commonly used in data analysis and reporting, but few people can use it truly effectively. For example, many may know how to erform simple sorting or filtering, but most are at a loss to do it to meet specific criteria. After the course, candidates could understand the usage of flash fill. They will familiar with using sorting and filtering and creating a summary report by using Pivot tables.