Create and Format Workbooks : Set up a workbook ; Work with data and Excel tables ; Perform calculations on data ; Change workbook appearance.
Analyze and Present Data : Manage worksheet data ; Reorder and summarize data ; Combine data from multiple sources ; Analyze alternative data sets ; Create charts and graphics ; Create dynamic worksheets using PivotTables.
Collaborate and share in Excel : Print worksheets and charts ; Automate repetitive tasks by using macros ; Work with other Microsoft Office apps ; Collaborate with colleagues.
Perform Advanced Analysis : Perform business intelligence analysis ; Create forecasts and visualizations.