Excel 2013 All-in-One For Dummies

Introduction.................................................................. 1

About This Book...............................................................................................1

Foolish Assumptions........................................................................................2

How This Book Is Organized...........................................................................3

Book I: Excel Basics................................................................................3

Book II: Worksheet Design.....................................................................3

Book III: Formulas and Functions.........................................................4

Book IV: Worksheet Collaboration and Review..................................5

Book V: Charts and Graphics................................................................5

Book VI: Data Management....................................................................6

Book VII: Data Analysis..........................................................................6

Book VIII: Macros and VBA....................................................................6

Conventions Used in This Book......................................................................7

Icons Used in This Book..................................................................................8

Where to Go from Here....................................................................................9

Book I: Excel Basics..................................................... 11

Chapter 1: The Excel 2013 User Experience . 13

Excel 2013’s New Look and Feel...................................................................14

Excel’s Start Screen........................................................................................14

Excel’s Ribbon User Interface.......................................................................16

Going behind the scenes to Excel’s Backstage view........................17

Ripping through the Ribbon................................................................21

Adjusting to the Quick Access toolbar..............................................26

Fooling around with the Formula bar................................................27

What’s up with the Worksheet area?.................................................28

Taking a tour of the Status bar............................................................33

Getting Help.....................................................................................................34

Launching and Quitting Excel.......................................................................36

Starting Excel from the Windows 8 Start screen..............................36

Starting Excel from the Windows 7 Start menu................................37

When it’s quitting time.........................................................................39