Excel Workbook For Dummies (eBook)

Paul McFedries has published over 100 books, with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. He is the author of the recently released Excel Data Analysis For Dummies and Google's G Suite For Dummies. Greg Harvey, PhD was author of over 30 For Dummies titles covering Excel.

Introduction 1

Part 1: Building Worksheets 5

Chapter 1: Getting Familiar with the Excel Interface 7

Chapter 2: Entering the Worksheet Data 21

Chapter 3: Formatting the Worksheet 37

Chapter 4: Printing Worksheet Reports 59

Chapter 5: Modifying the Worksheet 79

Part 2: Using Formulas and Functions 101

Chapter 6: Building Formulas 103

Chapter 7: Copying and Correcting Formulas 123

Chapter 8: Creating Date and Time Formulas 145

Chapter 9: Financial Formulas and Functions 155

Chapter 10: Using Math Functions 167

Chapter 11: Using Common Statistical Functions 179

Chapter 12: Using Lookup Functions 187

Chapter 13: Using Logical Functions 197

Chapter 14: Text Formulas and Functions 209

Part 3: Working with Graphics 217

Chapter 15: Charting Worksheet Data 219

Chapter 16: Adding Graphics to Worksheets 231

Part 4: Managing and Securing Data 249

Chapter 17: Building and Maintaining Tables 251

Chapter 18: Protecting Workbooks and Worksheet Data 271

Part 5: Doing Data Analysis 283

Chapter 19: Performing What-If Analysis 285

Chapter 20: Generating PivotTables 299

Part 6: Macros and Visual Basic for Applications 315

Chapter 21: Using Macros 317

Chapter 22: Using the Visual Basic Editor 327

Part 7: The Part of Tens 341

Chapter 23: Top Ten Features in Excel 343

Chapter 24: Top Ten Tips for Using Excel Like a Pro 347

Index 355