Title:
Excel all-in-one
Author:
Added Author:
Publication Date:
2022
Publication Information:
Hoboken, NJ : John Wiley & Sons, Inc., [2022]
©2022
Physical Description:
xviii, 763 pages : illustrations ; 24 cm.
ISBN:
9781119830726
Abstract:
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.
General Note:
"Covers Excel 2021 & Office 365 version"--Cover.
Includes index.
Contents:
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.
Title Subject:
Language:
English
