The Excel 2016: Up To Speed guide helps you to get up and running quickly with the world's most popular spreadsheet application. This handy step-by-step guide is written from scratch, starting with basic Excel topics and moving on to more advanced features of application, designed to help you to become more productive more quickly. Though comprehensive, the information in this book is presented in a clear, concise manner with screenshots providing helpful visual guidance all along the way.
In no time at all you're be importing and exporting data, creating formulas, modifying and formatting spreadsheets, setting up and formatting data in tables, creating beautiful charts, adding and subtracting dates, creating impressive PivotTables, and much more.
Table of Contents
Chapter 1 - Excel Basics
Chapter 2 - Working with Data
Chapter 3 - Editing a Worksheet
Chapter 4 – Formatting a Worksheet
Chapter 5 - Page Setup and Printing
Chapter 6 - Formulas and Functions
Chapter 7 - Using a Formula to Join the Contents of Multiple Cells
Chapter 8 - Modifying Workbooks
Chapter 9 - Working with Tables
Chapter 10 - Working with Charts
Chapter 11 - Working With Graphics
Chapter 12 - Financial & Logical Functions
Chapter 13 - Date and Time Functions
Chapter 14 - Managing Workbooks
Chapter 15 - Importing & Exporting Data
Chapter 16 - Formatting Numbers
Chapter 17 - Working with Ranges
Chapter 18 - Working with Macros
Chapter 19 - Data Analysis Tools
Chapter 20 - Summarizing Data
Chapter 21 - Analyzing Your Data
Chapter 22 - Collaborating with Others
