Excel all-in-one /
McFedries, Paul,
Excel all-in-one / Excel all-in-one for dummies Microsoft Excel all-in-one for dummies by Paul McFedries and Greg Harvey, PhD. - xviii, 763 pages : illustrations ; 24 cm - For dummies . - For dummies. .
"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.
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.
9781119830726 1119830729
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs.
Business--Computer programs.
Excel all-in-one / Excel all-in-one for dummies Microsoft Excel all-in-one for dummies by Paul McFedries and Greg Harvey, PhD. - xviii, 763 pages : illustrations ; 24 cm - For dummies . - For dummies. .
"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.
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.
9781119830726 1119830729
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs.
Business--Computer programs.