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.

Auteur

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.

Contenu

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 131

Reorienting cell entries 132

Shrink to fit 134

Bring on the borders! 134

Applying fill colors, patterns, and gradient effects to cells 136

Doing It in Styles 137

Creating a new style for the gallery 137

Copying custom styles from one workbook into another 138

Fooling Around with the Format Painter 139

Conditional Formatting 140

Formatting with scales and markers 141

Highlighting cells ranges 142

Formatting via the Quick Analysis tool 143

Chapter 4: Going Through Changes 145

Opening Your Workbooks for Editing 146

Opening files in the Open screen 147

Operating the Open dialog box 148

Changing the Recent files settings 150

Opening multiple workbooks 151

Find workbook files 151

Using the Open file options 152

Much Ado about Undo 152

Undo is Redo the second time around 153

What to do when you can't Undo? 153

Doing the Old Drag-and-Drop Thing 154

Copies, drag-and-drop style 156

Insertions courtesy of drag and drop 157

Copying Formulas with AutoFill 158

Relatively speaking 159

Some things are absolutes! 160

Cut and Paste, Digital Style 162

Paste it again, Sam 163

Keeping pace with Paste Options 164

Paste it from the Clipboard task pane 166

So what's so special about Paste Special? 167

Let's Be Clear About Deleting Stuff 169

Sounding the all clear! 170

Get these cells outta here! 170

Staying in Step with Insert 171

Stamping Out Your Spelling Errors 172

Eliminating Errors with Text to Speech 174

Chapter 5: Printing the Masterpiece 177

Previewing Pages in Page Layout View 178

Using the Backstage Print Screen 180

Printing the Current Worksheet 183

My Page Was Set Up! 184

Using the buttons in the Page Setup group 185

Using the buttons in the Scale to Fit group 190

Using the Print buttons in the Sheet Options group 192

From Header to Footer 192

Adding an Auto Header and Footer 193

Creating a custom header or footer 194

Solving Page Break Problems 199

Letting Your Formulas All Hang Out 201

Part 3: Getting Organized and Staying That Way 203

Chapter 6: Maintaining the Worksheet 205

Zooming In and Out 206

Splitting the Worksheet into Window Panes 209

Fixed Headings with Freeze Panes 210

Electronic Sticky Notes 213

Adding a comment to a cell 214

Comments in review 215

Editing comments in a worksheet 216

Getting your comments in print 217

The Range Name Game 217

If I only had a name 217

Name that formula! 220

Naming constants 221

Seek and Ye Shall Find 222

Replacing Cell Entrie…