Excel 2019 Bible

xxv Contents Searching and Replacing .................................................................................... 438 Se ...

xxvi Contents Surface charts ........................................................................................... 477 Bub ...

xxvii Contents Chapter 22: Creating Sparkline Graphics  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  5 ...

xxviii Contents Chapter 24: Implementing Excel Dashboarding Best Practices  . . . . . . . . . . . . . . . . . . .  567 Preparing ...

xxix Contents Removing extra spaces............................................................................... 596 Removing ...

xxx Contents Preparing the data .................................................................................... 631 Creatin ...

xxxi Contents Formatting the PivotTable.......................................................................... 668 Modifying ...

xxxii Contents Chapter 32: Analyzing Data Using Goal Seeking and Solver. . . . . . . . . . . . . . . . . . . . . .  733 Explorin ...

xxxiii Contents Protecting a VBA Project .................................................................................... 77 ...

xxxiv Contents Utilizing DAX to Create Calculated Columns ......................................................... 822 Identify ...

xxxv Contents Creating Custom Columns ................................................................................... 877 Co ...

xxxvi Contents Recording VBA macros ............................................................................... 924 Recordin ...

xxxvii Contents Debugging Custom Functions .............................................................................. 958 In ...

xxxviii Contents Label ........................................................................................................ ...

xxxix Contents VBA Speed Tips ................................................................................................ 1 ...

xli Introduction W elcome to the world of Excel. Okay, that’s a bit cheesy. But if you look around the busi- ness world, the fin ...

xlii Introduction Software Versions This book was written for the desktop version of Microsoft® Excel 2019 for Windows. Please n ...

xliii Introduction Names of the keys on your keyboard appear in normal type. When two keys should be pressed simultaneously, the ...

xliv Introduction How This Book Is Organized Notice that the book is divided into six main parts. Part I: Getting Started with E ...

xlv Introduction What’s on the Website This book contains many examples, and you can download the workbooks for those exam- ples ...