Excel Workbook For Dummies

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

Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.

• Excel

Excel textbook; excel manual; learn excel; excel practice; excel practice exercises; excel exercises; excel functions practice; excel formulas practice; excel functions workbook; excel formulas workbook; excel pivot tables; excel charts