題名:
Excel all-in-one
個人著者:
附加著者:
PUBDATE:
2022
GVPL_PUBLICATION_INFO:
Hoboken, NJ : John Wiley & Sons, Inc., [2022]
©2022
物理描述:
xviii, 763 pages : illustrations ; 24 cm.
ISBN（国际标准书号）:
9781119830726
摘要:
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.
一般注釋:
"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.
LANGUAGE:
English
