Microsoft Excel 2016 Step by Step (2015)

Microsoft Excel 2016 Step by Step (2015)

Part 1: Create and format workbooks

1.Set up a workbook

2.Work with data and Excel tables

3.Perform calculations on data

4.Change workbook appearance

Part 2: Analyze and present data

5.Understanding Functions

6.Reorder and summarize data

7.Combine data from multiple sources

8.Analyze alternative data setss

9.Create charts and graphics

10.Create dynamic worksheets by using PivotTables

Part 3: Collaborate and share in Excel

11.Print worksheets and charts

12.Automate repetitive tasks by using macros

13.Work with other Microsoft Office apps

14.Collaborate with colleagues

Part 4: Perform advanced analysis

15.Perform business intelligence analysis

16.Create forecasts and visualizations