LEADER 05319nam 22006494a 450 001 9910819430103321 005 20240405011737.0 010 $a1-280-35184-5 010 $a9786610351848 010 $a0-7645-5756-4 035 $a(CKB)111087027802674 035 $a(EBL)175945 035 $a(OCoLC)53908062 035 $a(SSID)ssj0000151695 035 $a(PQKBManifestationID)11181986 035 $a(PQKBTitleCode)TC0000151695 035 $a(PQKBWorkID)10318145 035 $a(PQKB)10160774 035 $a(MiAaPQ)EBC175945 035 $a(Au-PeEL)EBL175945 035 $a(CaPaEBR)ebr10114224 035 $a(CaONFJC)MIL35184 035 $a(EXLCZ)99111087027802674 100 $a20030416d2004 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel best practices for business /$fLoren Abdulezer 205 $a1st ed. 210 $aIndianapolis, IN $cWiley Pub.$dc2004 215 $a1 online resource (547 p.) 300 $a"Covers Excel 2003, 2002, and 2000"--Cover. 300 $aCD-ROM includes sample components and spreadsheets and Mathematica version 5 evaluation. 300 $aIncludes index. 311 $a0-7645-4120-X 327 $aExcel Best Practices for Business; About the Author; Credits; Preface; Acknowledgments; Contents at a Glance; Contents; Introduction; How to Use This Book; What You Need to Use This Book; What This Book Covers; Conventions Used in this Book; Icons Used in the Book; How This Book Is Organized; Part I: Best Practice Essentials; Chapter 1: A Foundation for Developing Best Practices; Preliminaries; Working with Different Ways To Compute a Number in Excel; Understanding Alternative Ways to Represent Cells; Computing a Number in Excel; Excel Functions; Closing Thoughts 327 $aChapter 2: Mastering Spreadsheet Construction Techniques One Size Does Not Fit All; Understanding Simple Spreadsheets; Building a Spreadsheet: A Simple Example; Complex Spreadsheets; Closing Thoughts; Chapter 3: Your Handy Reference for Manipulating Data; Excel String Manipulation Functions You Need to Know; Sorting Techniques; First Steps to Tidying Up Your Data; The Sentinel Look Ahead Technique; Other Functions for Effective Data Manipulation; Useful Sorting Techniques; Data Surgery and Data Manipulation; Closing Thoughts; Chapter 4: Compiling, Managing, and Viewing Your Data; Preliminaries 327 $aThe Number Line-Up Putting Data into Perspective with Pivot Tables; Preparing Your Data; Closing Thoughts; Part II: Spreadsheet Ergonomics; Chapter 5: Scaling the Peaks of Mt. Data; The Art of Data Slogging; Climbing Past the Foothills; Closing Thoughts; Chapter 6: Let the Data Speak for Itself: Viewing and Presenting Data; They Threw In the Kitchen Sink; Using Excel Filters; Presentation Tear Sheets; Advanced Filters; Tips for Spreadsheet Comments; Closing Thoughts; Chapter 7: Creating and Using Smart Data; What Is Smart Data, Anyhow?; Conditional Formatting 327 $aFrom RAGs to Riches: An Interactive Array of Colors Perimeter Surveillance: Smart Borders; Miscellaneous Topics; Closing Thoughts; Chapter 8: Analyzing Data; Charting Your Course in a Sea of Data; Quantifying Uncertainty: Techniques and Rules; Data Sculpting: Crafting Data with the Excel Goal Seek and Solver Tools; Suggestions for Further Reading; Closing Thoughts; Chapter 9: How Not to Get Stuck in the MUD ( Messed-Up Data); Ambiguous and Incomplete Data; Inconsistent Data and Computations; Square Peg/Round Hole Scenario; Analyses/Reports Built on Too Much White Noise or Static 327 $aClosing Thoughts Part III: Special Topics: Getting the Numbers Right; Chapter 10: Going for the Face lift: Spreadsheet Makeovers; Spreadsheet Makeover Techniques; A Hands-On Example of a Spreadsheet Makeover; Alternative Approaches; Closing Thoughts; Chapter 11: Spreadsheet Auditing: Challenging the Numbers of Others; Structural Analysis of Spreadsheets; Off-Spreadsheet Analysis; State Transition Analysis; Testing the Reasonableness of Spreadsheets; Closing Thoughts; Chapter 12: Spreadsheet Portals, XML, and Web Services; Spreadsheet Portals and Desktop Client Portals; Simple Client Portals 327 $aComplex Spreadsheet Portals 330 $aSpreadsheets have become the de facto standard for communicating business information and the preferred tool for analyzing business data. In this current climate, the accuracy and clarity of spreadsheets are paramount. However, busy managers have little time to sift through heaps of reference books to extrapolate techniques for making polished spreadsheets. Even with finished spreadsheets in hand, managers and business professionals still need a book which holds up a mirror to their real world situations and reflects hidden flaws; and then takes the next step and guides the reader in specific 606 $aBusiness$xComputer programs 606 $aElectronic spreadsheets 615 0$aBusiness$xComputer programs. 615 0$aElectronic spreadsheets. 676 $a005.54 700 $aAbdulezer$b Loren$01647212 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910819430103321 996 $aExcel best practices for business$93994651 997 $aUNINA