Exporting data from and importing into Excel Creating tables and using in-built functions to perform calculations Creating charts, pivot tables, and pivot charts Perform what if analysis using features like goal seek and scenario manager Creating macros using logic to perform complex manipulations Creating databases using Microsoft Access Creating queries, form and reports