create dashboard using excel data. can create charts based on pivot tables, create indicators using filters and query. can create time based charts such a gant charts, time lines, and calendars. can automate data aggregation and processing for updating data using VBA scripts. can transform data to other microsoft products such as powerpoint and project.