Book

Excel all-in-one / by Paul McFedries and Greg Harvey, PhD.

McFedries, Paul, (author.). Harvey, Greg, (author.).

Summary:

Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel

Record details

ISBN: 9781119830726
Physical Description: xviii, 763 pages : illustrations ; 24 cm.
Publisher: Hoboken, New Jersey : John Wiley & Sons, Inc., [2022]
Copyright: ©2022

Content descriptions

General Note:

"Covers Excel 2021 & Office 365 version"--Cover.

Includes index.

Formatted Contents Note:

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.