Bibliograph

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

Type

Label

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

Language

eng

Illustrations

illustrations

Index

index present

Literary Form

non fiction

Main title

Excel all-in-one

Oclc number

1265457742

Responsibility statement

by Paul McFedries and Greg Harvey, PhD

Series statement

For dummies

Summary

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

Table Of 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

Target audience

adult

resource.variantTitle

Microsoft Excel all-in-one for dummiesExcel, all-in-one : Excel 2021 and Office 365Excel all in oneExcel all-in-one for dummiesExcel all in one for dummies

Contributor