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

All materials on the site are licensed Creative Commons Attribution-Sharealike 3.0 Unported CC BY-SA 3.0 & GNU Free Documentation License (GFDL)

If you are the copyright holder of any material contained on our site and intend to remove it, please contact our site administrator for approval.

© 2016-2026 All site design rights belong to S.Y.A.