Excel Workbook For Dummies, 2nd Edition

Excel Workbook For Dummies, 2nd Edition

by Paul McFedries, Greg Harvey
Released January 2022
Publisher(s): For Dummies
ISBN: 9781119832157

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Get practical walkthroughs for the most useful Excel features

Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for.

This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program.

Work through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also:

  • Brush up on and practice time-saving keyboard shortcuts for popular commands and actions
  • Get a handle on multi-functional and practical pivot tables with intuitive practice exercises
  • Learn to secure your data with spreadsheet password protections

Perfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.

Table of contents

  1. Cover
  2. Title Page
  3. Copyright
  4. Introduction
    1. About This Book
    2. Conventions Used in This Book
    3. Foolish Assumptions
    4. Beyond the Book
    5. Icons Used in This Book
    6. Where to Go from Here
  5. Part 1: Building Worksheets
    1. Chapter 1: Getting Familiar with the Excel Interface
      1. Launching Excel
      2. Identifying the Parts of the Excel Window
      3. Selecting Commands in the Backstage View
      4. Selecting Commands from the Ribbon
      5. Selecting Commands on the Quick Access Toolbar
    2. Chapter 2: Entering the Worksheet Data
      1. Opening a New Workbook
      2. Moving Around the Workbook
      3. Selecting Cell Ranges
      4. Making Cell Entries
      5. Saving the Spreadsheet Data in a Workbook File
    3. Chapter 3: Formatting the Worksheet
      1. Resizing Columns and Rows
      2. Cell Formatting Techniques
      3. Hiding Columns and Rows
    4. Chapter 4: Printing Worksheet Reports
      1. Previewing Pages in the Worksheet and Backstage View
      2. Adjusting Page Breaks
      3. Adding Headers and Footers
      4. Adding Print Titles to a Report
      5. Modifying the Print Settings for a Report
      6. Printing All or Part of the Workbook
    5. Chapter 5: Modifying the Worksheet
      1. Finding and Identifying the Region That Needs Editing
      2. Selecting the Ranges to Edit
      3. Editing Data Entries
      4. Deleting and Inserting Data and Cells
      5. Moving and Copying Data and Cells
      6. Adding Notes to the Worksheet
      7. Using Find and Replace and Spell Checking
      8. Editing Multiple Worksheets
  6. Part 2: Using Formulas and Functions
    1. Chapter 6: Building Formulas
      1. Building Formulas
      2. Using External Reference Links
      3. Controlling When Formulas Are Recalculated
    2. Chapter 7: Copying and Correcting Formulas
      1. Copying Formulas with Relative References
      2. Copying Formulas with Absolute References
      3. Copying Formulas with Mixed References
      4. Using Range Names in Formulas
      5. Building Array Formulas
      6. Tracing and Eliminating Formula Errors
      7. Dealing with Circular References
    3. Chapter 8: Creating Date and Time Formulas
      1. Constructing Date and Time Formulas
      2. Working with Simple Date Functions
      3. Working with Excel’s Fancier Date Functions
      4. Working with the Time Functions
    4. Chapter 9: Financial Formulas and Functions
      1. Working with Financial Functions
      2. Using the Basic Investment Functions
      3. Figuring the Depreciation of an Asset
    5. Chapter 10: Using Math Functions
      1. Rounding Off Values
      2. Finding Products, Powers, and Square Roots
      3. Doing Fancier Sums
    6. Chapter 11: Using Common Statistical Functions
      1. Computing Averages
      2. Finding the Highest and Lowest Values
      3. Counting Cells
      4. Using the Statistical Functions in Analysis ToolPak Add-in
    7. Chapter 12: Using Lookup Functions
      1. Looking Up Stuff with XLOOKUP
      2. Returning Single Values from a Lookup Table
    8. Chapter 13: Using Logical Functions
      1. Working with the Logical Functions
      2. Constructing Decision-Making Formulas
      3. Constructing Error-Trapping Formulas
    9. Chapter 14: Text Formulas and Functions
      1. Constructing Text Formulas
      2. Using Text Functions
  7. Part 3: Working with Graphics
    1. Chapter 15: Charting Worksheet Data
      1. Understanding Excel Charts
      2. Creating Charts
      3. Formatting Charts
      4. Editing Charts
    2. Chapter 16: Adding Graphics to Worksheets
      1. Understanding Graphic Objects
      2. Adding Various Types of Graphic Objects
  8. Part 4: Managing and Securing Data
    1. Chapter 17: Building and Maintaining Tables
      1. Creating a Table
      2. Sorting Tables
      3. Subtotaling a Table
      4. Filtering a Table
      5. Querying External Database Tables
    2. Chapter 18: Protecting Workbooks and Worksheet Data
      1. Password-Protecting the Workbook
      2. Protecting the Worksheet
      3. Doing Data Entry in a Protected Worksheet
      4. Protecting the Entire Workbook
  9. Part 5: Doing Data Analysis
    1. Chapter 19: Performing What-If Analysis
      1. Performing What-If Analysis with Data Tables
      2. Analyzing Data with Scenarios
      3. Goal Seeking in a Worksheet
      4. Creating Complex Models with Solver
    2. Chapter 20: Generating PivotTables
      1. Working with PivotTables
      2. Creating PivotTables
      3. Modifying the PivotTable
      4. Creating PivotCharts
  10. Part 6: Macros and Visual Basic for Applications
    1. Chapter 21: Using Macros
      1. Creating Macros
      2. Assigning Macros to the Quick Access Toolbar
      3. Assigning Macros to the Ribbon
    2. Chapter 22: Using the Visual Basic Editor
      1. Using the Visual Basic Editor
      2. Creating User-Defined Functions
  11. Part 7: The Part of Tens
    1. Chapter 23: Top Ten Features in Excel
      1. The Excel Ribbon and Backstage View
      2. Conditional Formatting
      3. PivotTable Filtering with Slicers
      4. Home Tab Formatting and Editing
      5. Insert Tab Charting
      6. Format as Table
      7. The Zoom Slider on the Status Bar
      8. Page Layout View
      9. Style Galleries
      10. Live Preview
    2. Chapter 24: Top Ten Tips for Using Excel Like a Pro
      1. Generating New Workbooks from Templates
      2. Organizing Data on Different Worksheets
      3. Creating Data Series with AutoFill
      4. Using Range Names
      5. Freezing Column and Row Headings
      6. Preventing Data Entry Errors with Data Validation
      7. Trapping Error Values
      8. Saving Memory by Using Array Formulas
      9. Using Outlines to Control the Display of Data
      10. Using View Side by Side to Work with Two Workbooks
  12. Index
  13. About the Authors
  14. Connect with Dummies
  15. End User License Agreement

Product information

  • Title: Excel Workbook For Dummies, 2nd Edition
  • Author(s): Paul McFedries, Greg Harvey
  • Release date: January 2022
  • Publisher(s): For Dummies
  • ISBN: 9781119832157