O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Excel Basics In 30 Minutes, 2nd Edition, 2nd Edition

Book Description

"Want to learn how to use Microsoft Excel for a career boost or to better handle data? Excel Basics In 30 Minutes covers Excel 2016, Excel Online, and Google Sheets."

Table of Contents

  1. Cover
  2. What Readers are Saying...
  3. Title page
  4. Copyright information
  5. Introduction: Excel: Not Just For Nerds!
  6. Chapter 1: The Basics: Cells, Functions, and Formulas
    1. The different flavors of Excel (and Google Sheets)
      1. Excel 2003 (and earlier), Excel for Mac (2008 or earlier)
      2. Excel 2007, Excel 2010, Excel 2013, and Excel for Mac (2011 or later)
      3. Office 365
      4. Excel Online
      5. Excel for mobile devices
      6. Google Sheets
      7. Using this guide with Excel and Google Sheets
      8. Firing up Excel and creating a new file
        1. Spreadsheet terminology
      9. Working with cells
      10. Your first spreadsheet formula
      11. Introducing functions with SUM
      12. AutoSum and the one Greek letter you need to know
        1. Quickly accessing other functions
      13. Formatting cells and text
    2. Chapter quiz
  7. Excel Ninja Skill #1: AutoFill
    1. AutoFill magic
    2. Formulas and AutoFill
    3. Dragging to extend functions
  8. Chapter 2: More Basic Excel Skills: Percentages, Pasting, and Rows
    1. Working with multiple worksheets
      1. How to create a new worksheet
      2. Copy, paste, and paste special
        1. How to duplicate a worksheet
      3. Adding rows
        1. What happens to functions, formulas, and references
      4. Using percentages
        1. Parentheses and PEMDAS
        2. Declining percentages
      5. Static cell references
      6. Spreadsheet division
      7. Referencing other worksheets
    2. Chapter quiz
  9. Excel Ninja Skill #2: Charts
    1. Chart wizards
      1. Pie charts
      2. Chart options and customizations
    2. Column charts and line charts
  10. Chapter 3: Sorting and Filtering
    1. Sorting
      1. Hiding rows and columns
      2. Rearranging a list in alphabetical order
      3. Basic sorting in Excel
      4. Basic sorting in Google Sheets
      5. An alternate sorting scenario
      6. Sorting with multiple criteria
    2. Filtering
    3. Chapter quiz
  11. Chapter 4: Printing, PDFs, and Import/Export Features
    1. Printing
      1. Adjust column widths
      2. Switch from portrait to landscape mode
      3. How to set the print area
      4. Printing cell outlines
    2. Exporting PDFs
      1. Importing and exporting
        1. Importing data into Excel
        2. Exporting data
        3. Exporting charts
    3. Chapter quiz
  12. A Message from the Author
  13. About the Author
  14. Glossary
  15. Appendix I: Registering for Google Sheets
  16. Appendix II: Quiz answers