Microsoft Excel 2016 In 90 Pages (Paperback) (ISBN-13: 9780998684406)

*Includes tear-out QUICK REFERENCE with step-by-step instructions

MICROSOFT EXCEL 2016 IN 90 PAGES guides you through the process of creating spreadsheets. With step-by-step instructions, screenshots, and tables detailing Excel commands and features, you will be immediately on track to analyzing data. Look inside to learn how to:

• Create and format a spreadsheet using practices that optimize data analysis.
• Ensure accurate data with data validation and Excel's AutoComplete, AutoCorrect, Auto Fill, and spelling checker features.
• Produce the most impact through conditional formatting and sparklines.
• Organize related data into tables that sort, filter, use slicers, have a totals row, and use calculated columns to analyze data.
• Visualize data relationships through charts, including pie, line, bar, treemap, waterfall, and stock charts.
• Use formulas and functions to generate new information.
• Perform What-If? analysis with scenarios, goal seek, and data tables.
• Generate PivotTable and PivotChart reports for tables and Data Models.
• Create Data Models by defining relationships between tables.
• Work more effectively by using multiple sheets, inserting cell comments, creating macros, and designing custom templates.
• Learn how to protect worksheet data and work collaboratively.
  
  Author: Beth Brown
  ISBN-10: 0998684406
  ISBN-13: 9780998684406
  Publisher: Belleyre Books
  Language: English
  Published: 05/11/2017
  Pages: 122
  Format: Paperback
  Weight: 0.51lbs
  Size: 9.69h x 7.44w x 0.26d