Close cookie details

This site uses cookies. Learn more about cookies.

OverDrive would like to use cookies to store information on your computer to improve your user experience at our Website. One of the cookies we use is critical for certain aspects of the site to operate and has already been set. You may delete and block all cookies from this site, but this could affect certain features or services of the site. To find out more about the cookies we use and how to delete them, click here to see our Privacy Policy.

If you do not wish to continue, please click here to exit this site.

Hide notification

  Main Nav
Excel 2019 For Dummies
Cover of Excel 2019 For Dummies
Excel 2019 For Dummies
Borrow Borrow Borrow

The bestselling Excel book on the market — now in a new edition covering the latest version of Excel!

Excel is the spreadsheet and data analysis tool of choice for people across the globe who utilize the Microsoft Office suite to make their work and personal lives easier. It is estimated that 1 in 7 people on the planet use Microsoft Office! If you’re one of them, and want to get up to speed on the latest changes in Excel, you’ve come to the right place.

Excel 2019 For Dummies has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand. It includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing webpage, pivot tables, pivot charts, formulas and functions, Excel data analysis, sending worksheets via e-mail, and so much more!

  • Get to know the new Excel interface  
  • Become a pro at the spreadsheet and data analysis tool that’s available as part of the Microsoft Office suite
  • Find time-tested and trusted advice from bestselling author and expert Greg Harvey
  • Use Excel to streamline your processes and make your work life easier than ever  before
  • Written by a bestselling author and seasoned educator, Excel 2019 For Dummies makes it easier than ever to get everything out of this powerful data tool.

    The bestselling Excel book on the market — now in a new edition covering the latest version of Excel!

    Excel is the spreadsheet and data analysis tool of choice for people across the globe who utilize the Microsoft Office suite to make their work and personal lives easier. It is estimated that 1 in 7 people on the planet use Microsoft Office! If you’re one of them, and want to get up to speed on the latest changes in Excel, you’ve come to the right place.

    Excel 2019 For Dummies has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand. It includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing webpage, pivot tables, pivot charts, formulas and functions, Excel data analysis, sending worksheets via e-mail, and so much more!

  • Get to know the new Excel interface  
  • Become a pro at the spreadsheet and data analysis tool that’s available as part of the Microsoft Office suite
  • Find time-tested and trusted advice from bestselling author and expert Greg Harvey
  • Use Excel to streamline your processes and make your work life easier than ever  before
  • Written by a bestselling author and seasoned educator, Excel 2019 For Dummies makes it easier than ever to get everything out of this powerful data tool.

    Available formats-
    • Kindle Book
    • OverDrive Read
    • EPUB eBook
    Languages:-
    Copies-
    • Available:
      1
    • Library copies:
      1
    Levels-
    • ATOS:
    • Lexile:
    • Interest Level:
    • Text Difficulty:

    Recommended for you

    About the Author-
    • Greg Harvey began training business people to use computers and software back in the days of DOS. He is the author of numerous For Dummies books, including all editions of Excel All-in-One For Dummies, Excel Workbook For Dummies, and Excel For Dummies . He has worked as an independent trainer and as an instructor at Golden Gate University.

    Table of Contents-
    • Introduction 1

      About This Book 1

      How to Use This Book 2

      What You Can Safely Ignore 2

      Foolish Assumptions 2

      How This Book Is Organized 3

      Part 1: Getting Started with Excel 2019 3

      Part 2: Editing Without Tears 4

      Part 3: Getting Organized and Staying That Way 4

      Part 4: Digging Data Analysis 4

      Part 5: Life Beyond the Spreadsheet 4

      Part 6: The Part of Tens 5

      Conventions Used in This Book 5

      Selecting Ribbon commands 5

      Icons Used in This Book 6

      Beyond the Book 7

      Where to Go from Here 7

      Part 1: Getting Started with Excel 2019 9

      Chapter 1: The Excel 2019 User Experience 11

      Excel’s Ribbon User Interface 12

      Going Backstage 14

      Using the Excel Ribbon 15

      Customizing the Quick Access toolbar 21

      Having fun with the Formula bar 24

      What to do in the Worksheet area 26

      Showing off the Status bar 34

      Launching and Quitting Excel 35

      Starting Excel from the Windows 10 Start menu 35

      Starting Excel from the Windows 10 Search text box 36

      Starting Excel from the Windows 10 Metro view in Tablet mode 36

      Exiting Excel 37

      Help Is on the Way 38

      Using the Tell Me help feature 39

      Chapter 2: Creating a Spreadsheet from Scratch 41

      So What Ya Gonna Put in That New Workbook of Yours? 42

      The ins and outs of data entry 44

      You must remember this 45

      Doing the Data-Entry Thing 45

      It Takes All Types 48

      The telltale signs of text 48

      How Excel evaluates its values 49

      Fabricating those fabulous formulas! 56

      If you want it, just point it out 59

      Altering the natural order of operations 59

      Formula flub-ups 60

      Fixing Those Data Entry Flub-Ups 62

      You really AutoCorrect that for me 62

      Cell editing etiquette 63

      Taking the Drudgery Out of Data Entry 65

      I’m just not complete without you 65

      Fill ’er up with AutoFill 66

      Fill it in a flash 74

      Inserting special symbols 76

      Entries all around the block 76

      Data entry express 77

      How to Make Your Formulas Function Even Better 78

      Inserting a function into a formula with the Insert Function button 79

      Editing a function with the Insert Function button 82

      I’d be totally lost without AutoSum 82

      Sums via Quick Analysis Totals 85

      Making Sure That the Data Is Safe and Sound 86

      Changing the default file location 89

      The difference between the XLSX and XLS file formats 90

      Saving the Workbook as a PDF File 91

      Document Recovery to the Rescue 92

      Part 2: Editing Without Tears 95

      Chapter 3: Making It All Look Pretty 97

      Choosing a Select Group of Cells 98

      Point-and-click cell selections 99

      Keyboard cell selections 104

      Using the Format as Table Gallery 106

      Customizing table formats 109

      Creating a new custom Table Style 110

      Cell Formatting from the Home Tab 112

      Formatting Cells Close to the Source with the Mini-bar 114

      Using the Format Cells Dialog Box 115

      Understanding the number formats 116

      The values behind the formatting 121

      Make it a date! 123

      Ogling some of the other number formats 123

      Calibrating Columns 124

      Rambling rows 125

      Now you see it, now you don’t 126

      Futzing with the Fonts 127

      Altering the Alignment 129

      Intent on indents 130

      From top to bottom 130

      Tampering with how the text wraps...

    Title Information+
    • Publisher
      Wiley
    • Kindle Book
      Release date:
    • OverDrive Read
      Release date:
    • EPUB eBook
      Release date:
    Digital Rights Information+
    • Copyright Protection (DRM) required by the Publisher may be applied to this title to limit or prohibit printing or copying. File sharing or redistribution is prohibited. Your rights to access this material expire at the end of the lending period. Please see Important Notice about Copyrighted Materials for terms applicable to this content.

    Status bar:

    You've reached your checkout limit.

    Visit your Checkouts page to manage your titles.

    Close

    You already have this title checked out.

    Want to go to your Checkouts?

    Close

    Recommendation Limit Reached.

    You've reached the maximum number of titles you can recommend at this time. You can recommend up to 5 titles every 30 day(s).

    Close

    Sign in to recommend this title.

    Recommend your library consider adding this title to the Digital Collection.

    Close

    Enhanced Details

    Close
    Close

    Limited availability

    Availability can change throughout the month based on the library's budget.

    is available for days.

    Once playback starts, you have hours to view the title.

    Close

    Permissions

    Close

    The OverDrive Read format of this eBook has professional narration that plays while you read in your browser. Learn more here.

    Close

    Holds

    Total holds:


    Close

    Restricted

    Some format options have been disabled. You may see additional download options outside of this network.

    Close

    You've reached your library's checkout limit for digital titles.

    To make room for more checkouts, you may be able to return titles from your Checkouts page.

    Close

    Excessive Checkout Limit Reached.

    There have been too many titles checked out and returned by your account within a short period of time.

    Try again in several days. If you are still not able to check out titles after 7 days, please contact Support.

    Close

    You have already checked out this title. To access it, return to your Checkouts page.

    Close

    This title is not available for your card type. If you think this is an error contact support.

    Close

    An unexpected error has occurred.

    If this problem persists, please contact support.

    Close

    Close

    NOTE: Barnes and Noble® may change this list of devices at any time.

    Close
    Buy it now
    and help our library WIN!
    Excel 2019 For Dummies
    Excel 2019 For Dummies
    Greg Harvey
    Choose a retail partner below to buy this title for yourself.
    A portion of this purchase goes to support your library.
    Clicking on the 'Buy It Now' link will cause you to leave the library download platform website. The content of the retail website is not controlled by the library. Please be aware that the website does not have the same privacy policy as the library or its service providers.
    Close
    Close

    There are no copies of this issue left to borrow. Please try to borrow this title again when a new issue is released.

    Close
    Barnes & Noble Sign In |   Sign In

    You will be prompted to sign into your library account on the next page.

    If this is your first time selecting “Send to NOOK,” you will then be taken to a Barnes & Noble page to sign into (or create) your NOOK account. You should only have to sign into your NOOK account once to link it to your library account. After this one-time step, periodicals will be automatically sent to your NOOK account when you select "Send to NOOK."

    The first time you select “Send to NOOK,” you will be taken to a Barnes & Noble page to sign into (or create) your NOOK account. You should only have to sign into your NOOK account once to link it to your library account. After this one-time step, periodicals will be automatically sent to your NOOK account when you select "Send to NOOK."

    You can read periodicals on any NOOK tablet or in the free NOOK reading app for iOS, Android or Windows 8.

    Accept to ContinueCancel