Excel 2016 for dummies - Greg Harvey

Learn to:

• Use Excel on any Windows device whether clicking, typing, tapping, or gesturing


• Share worksheets on OneDrive with Skype for Business and Instant Messaging


• Present worksheets in online meetings and edit them in your favorite browser

Play show and tell with your data

Whether youre starting from square one or updating your skills, this handson guide to Excel 2016 gets you up and running fast. Youll easily get the hang of worksheets, formulas, graphs, formatting, and more as you explore this powerful, versatile application. Show off your data and maximize its potential!

• For the love of spreadsheets
  if youre starting with no background in using spreadsheets, youll discover the secrets of the Ribbons interface before moving on to creating worksheets


• Hey, good lookin
  find out how to edit spreadsheets to make them look good, including how to make major changes without courting disaster


• Make it your minion
  discover the ins and outs of keeping track of data in a single worksheet or multiple worksheets within the same workbook


• Dig in to data
  set up data tables with one and two inputs, perform goal seeking, and create different cases with Scenario Manager


• Pivot on point
  get introduced to Excel 2016s powerful pivot table and pivot chart capabilities that enable you to summarize and filter vast amounts of data

Open the book and find:

• Steps for inserting, rearranging, and deleting information in a spreadsheet


• How to stay on top of the data in your spreadsheets


• Steps for transferring data between the sheets of different workbooks


• How to use the data list to track and organize information


• Easytofollow guidance on Addins for Office and Excel


• Just how easy it is to create a chart using the data in a worksheet