Excel 2019 For Dummies

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.

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

H