Note |
Includes index. |
|
"Covers 2021 & Office 365 versions"--cover. |
|
"8 books in one"--cover. |
Contents |
book 1. The 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 anaylsis -- book 8. Macros and VBA: Recording and running macros ; VBA programming. |
Summary |
"Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel … Microsoft Excel offers unsurpassed functionality and accessibility for data exploration and analysis to millions of users around the world. And learning to unlock its full potential is easier than you can imagine with help from Excel All-in-One For Dummies. Follow along with Excel expert and veteran author Paul McFedries as he walks you through every feature and technique you need to know to get the most out of this powerful software. You'll learn how to design worksheets, use formulas and functions, collaborate with colleagues and review their work, create charts and graphics, manage and analyze data, and create macros. Plus, you'll discover all the capabilities Microsoft has included in the newest versions of Excel, including dark mode and accessibility features." -- Provided by publisher. |
Subject |
Microsoft Excel (Computer file)
|
|
Electronic spreadsheets -- Computer programs.
|
|
Business -- Computer programs.
|
Genre |
Handbooks and manuals.
|
Series |
For dummies
|
|
Learning made easy
|
|
--For Dummies.
|
Add'l Names |
Harvey, Greg PhD author.
|
Other title |
Cover title: Microsoft Excel all-in-one for dummies. |
ISBN |
9781119830726
|
|
1119830729
|
|