TY - BOOK AU - McFedries,Paul AU - Harvey,Greg TI - Excel all-in-one T2 - For dummies SN - 9781119830726 PY - 2022///] CY - Hoboken, NJ PB - John Wiley & Sons KW - Microsoft Excel (Computer file) KW - Electronic spreadsheets KW - Computer programs KW - Business N1 - "Learning made easy"--Cover; "Covers Excel 2021 & Office 365 version"--Cover; Includes index; Book 1: Excel basics. Excel : the 50-cent tour ; Customizing Excel -- Book 2: Worksheet design. Building worksheets ; Formatting worksheets ; Editing and proofing worksheets ; Managing worksheets ; Printing worksheets -- Book 3: Formulas and functions. Building basic formulas ; Logical functions and error trapping ; Date and time formulas ; Finagling financial formulas ; Math and statistical formulas ; Lookup, information, and text formulas -- Book 4: Worksheet collaboration and review. Protecting workbooks and worksheet data ; Preparing a workbook for distribution ; Sharing workbooks and worksheet data -- Book 5: Charts and graphics. Charting worksheet data ; Adding graphic objects -- Book 6: Data management. Building and maintaining tables ; Filtering and querying a table -- Book 7: Data analysis. Performing what-if analysis ; Performing large-scale data analysis -- Book 8. Macros and VBA: Recording and running macros ; VBA programming N2 - Get a grip on the most essential features in the application, including built in templates, formulas, and PivotTables. You'll also learn how to make your data accessible with charts and graphics ER -