{"product_id":"microsoft-excel-2016-in-90-pages-9780998684406","title":"Microsoft Excel 2016 In 90 Pages","description":"\u003cp\u003e • Author(s): Beth Brown\u003cbr\u003e • Publisher: Belleyre Books\u003cbr\u003e • Publisher Imprint: Belleyre Books\u003cbr\u003e • BISAC: General\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e*Includes tear-out QUICK REFERENCE with step-by-step instructions \u003c\/p\u003e\u003cp\u003eMICROSOFT 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: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCreate and format a spreadsheet using practices that optimize data analysis.\u003c\/li\u003e\n\u003cli\u003eEnsure accurate data with data validation and Excel's AutoComplete, AutoCorrect, Auto Fill, and spelling checker features.\u003c\/li\u003e\n\u003cli\u003eProduce the most impact through conditional formatting and sparklines.\u003c\/li\u003e\n\u003cli\u003eOrganize related data into tables that sort, filter, use slicers, have a totals row, and use calculated columns to analyze data.\u003c\/li\u003e\n\u003cli\u003eVisualize data relationships through charts, including pie, line, bar, treemap, waterfall, and stock charts.\u003c\/li\u003e\n\u003cli\u003eUse formulas and functions to generate new information.\u003c\/li\u003e\n\u003cli\u003ePerform What-If? analysis with scenarios, goal seek, and data tables.\u003c\/li\u003e\n\u003cli\u003eGenerate PivotTable and PivotChart reports for tables and Data Models.\u003c\/li\u003e\n\u003cli\u003eCreate Data Models by defining relationships between tables.\u003c\/li\u003e\n\u003cli\u003eWork more effectively by using multiple sheets, inserting cell comments, creating macros, and designing custom templates.\u003c\/li\u003e\n\u003cli\u003eLearn how to protect worksheet data and work collaboratively.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Belleyre Books","offers":[{"title":"Paperback","offer_id":45506862743703,"sku":"9780998684406","price":770.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9780998684406.webp?v=1767109061","url":"https:\/\/atlanticbooks.com\/products\/microsoft-excel-2016-in-90-pages-9780998684406","provider":"Atlantic Books","version":"1.0","type":"link"}