Excel 2016 in easy steps by Michael Price

Excel 2016 in easy steps by Michael Price is a guide to using Excel 2016. It focuses on the key features of this spreadsheet application, for both newcomers and those upgrading.

Key details

• Covers creating, editing and manipulating worksheets
• Explains formulas, functions and PivotTables
• Includes templates designed to help you get started
• Introduces macros for everyday tasks
• Shows how to create charts for viewing data
• Describes linking workbooks for automatic updates

Synopsis

This book is written to help you get to grips with Excel 2016, taking you through a range of practical areas within the application. It looks at working with worksheets, using formulas and functions, and building PivotTables, alongside tools such as templates and macros.

It also covers presenting information with charts, linking workbooks so updates carry through automatically, and using the Excel Online app for sharing and collaboration. In addition, it explains how to add images and illustrations to spreadsheets.