Excel 2016 in Easy Steps

Excel 2016 in easy steps will help you get to grips with the latest version of this popular spreadsheet application. Areas covered include:

• Creating, editing and manipulating worksheets
• Formulas, Functions and Pivot Tables
• Handy templates to give you a head start
• Macros for everyday tasks to save time
• Charts to get an overview of your data
• Linking workbooks for automatic updates
• Using the Excel Online app to share and collaborate on spreadsheets and workbooks
• Adding images and illustrations to your spreadsheet to impress your colleagues!

Whether you’re upgrading to Excel 2016 or new to the spreadsheet concept, use this guide to learn the key features constructively and get more out of Excel 2016 – in easy steps!

Table of Contents

Chapter 1 Introduction
Chapter 2 Begin with Excel
Chapter 3 Manage Data
Chapter 4 Formulas and Functions
Chapter 5 Excel Tables
Chapter 6 Advanced Functions
Chapter 7 Control Excel
Chapter 8 Charts
Chapter 9 Macros in Excel
Chapter 10 Templates and Scenarios
Chapter 11 Links and Connections