Microsoft Excel 2016 In 90 Pages
by Beth Brown /
2016 / English / PDF
4.1 MB Download
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.