Introduction -- Part 1 : Create and format workbooks. Set up a workbook ; Work with data and Excel tables ; Perform calculations on data ; Change workbook appearance -- Part 2 : 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 -- Part 3 : Collaborate and share in Excel. Print worksheets and charts ; Automate repetitive tasks by using macros ; Work with other Microsoft Office apps ; Collaborate with colleagues -- Part 4 : Perform advanced analysis. Perform business intelligence analysis ; Create forecasts and visualizations.
|