Microsoft Excel 2016: step by step

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.