Excel All-in-One For Dummies

Excel All-in-One For Dummies

Harvey, Greg; McFedries, Paul

John Wiley & Sons Inc

03/2022

784

Mole

Inglês

9781119830726

15 a 20 dias

1032

Descrição não disponível.
Introduction 1

Book 1: Excel Basics 7

Chapter 1: Excel: The 50-Cent Tour 9

Chapter 2: Customizing Excel 39

Book 2: Worksheet Design 75

Chapter 1: Building Worksheets 77

Chapter 2: Formatting Worksheets 131

Chapter 3: Editing and Proofing Worksheets 187

Chapter 4: Managing Worksheets 229

Chapter 5: Printing Worksheets 265

Book 3: Formulas and Functions 291

Chapter 1: Building Basic Formulas 293

Chapter 2: Logical Functions and Error Trapping 337

Chapter 3: Date and Time Formulas 363

Chapter 4: Finagling Financial Formulas 377

Chapter 5: Math and Statistical Formulas 393

Chapter 6: Lookup, Information, and Text Formulas 411

Book 4: Worksheet Collaboration and Review 439

Chapter 1: Protecting Workbooks and Worksheet Data 441

Chapter 2: Preparing a Workbook for Distribution 461

Chapter 3: Sharing Workbooks and Worksheet Data 475

Book 5: Charts and Graphics 501

Chapter 1: Charting Worksheet Data 503

Chapter 2: Adding Graphic Objects 533

Book 6: Data Management 561

Chapter 1: Building and Maintaining Tables 563

Chapter 2: Filtering and Querying a Table 583

Book 7: Data Analysis 617

Chapter 1: Performing What-If Analysis 619

Chapter 2: Performing Large-Scale Data Analysis 641

Book 8: Macros and VBA 685

Chapter 1: Recording and Running Macros 687

Chapter 2: VBA Programming 701

Index 725
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.
Excel for dummies; excel basics; excel guide; excel handbook; excel tutorial; excel help; how do I use excel?; should I use excel?; excel strategies; excel formulas; excel functions help; excel formulas help; excel data analysis help; excel macros