English | 2017 | ASIN: B0716VF3GJ | 117 pages | AZW4/EPUB (conv) | 4.90 Mb
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.