LEADER 06122nam 2200673 450 001 9910132199703321 005 20230803202846.0 010 $a1-118-65818-3 010 $a1-118-77716-6 010 $a1-118-65819-1 035 $a(CKB)3710000000123924 035 $a(EBL)1672806 035 $a(SSID)ssj0001222340 035 $a(PQKBManifestationID)11749669 035 $a(PQKBTitleCode)TC0001222340 035 $a(PQKBWorkID)11200585 035 $a(PQKB)10917322 035 $a(MiAaPQ)EBC1672806 035 $a(DLC) 2014008177 035 $a(Au-PeEL)EBL1672806 035 $a(CaPaEBR)ebr10943471 035 $a(CaONFJC)MIL769949 035 $a(OCoLC)871228580 035 $a(EXLCZ)993710000000123924 100 $a20141008h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aAdvanced Excel reporting for management accountants /$fNeale Blackwood 210 1$aHoboken, New Jersey :$cWiley,$d2014. 210 4$dİ2014 215 $a1 online resource (753 p.) 225 1 $aWiley corporate F&A 300 $aDescription based upon print version of record. 311 $a1-118-65772-1 327 $aCover; Series; Titlepage; Copyright; Dedication; Preface; Acknowledgments; Introduction; CHAPTER 1 Management Accounting and Excel; Assumptions; The Goal of Reporting; Why Use Excel?; The Goal of This Book; Monthly Management Reports; Macro Policy; CHAPTER 2 Building Reporting Models; Needs Analysis; Scope Definition; Design; Construction; Testing; Operation; Maintenance; Time, Effort, and Cost; Practical Considerations; CHAPTER 3 Building Tips; Display Tips; Keyboard Shortcuts; Mouse Shortcuts; Keyboard and Mouse Shortcuts; General Tips; CHAPTER 4 Design and Structure 327 $aStructure = FlexibilityModular Sheet Design; Standardised Report Layout; Table-Based Systems; Spreadsheet Best Practices; CHAPTER 5 Setting the Foundation; Terminology; Data Rules; Data Structures; Format as Table; Data Cleansing Techniques; External Data; CHAPTER 6 Pivot Tables (Do-It-Yourself Reporting); The Pros and Cons of a Pivot Table; Creating a Pivot Table; PowerPivot; CHAPTER 7 Tools of the Trade: Summing Functions; Range Names; Using Cells and Ranges in Formulas; The Humble SUM Function; Advanced SUM and 3D Formulas; Subtotaling; The SUBTOTAL Function; The AGGREGATE Function 327 $aFunction WizardConditional Summing; The SUMIF Function; Sumif Uses; Helper Cells; The SUMIFS Function; The SUMPRODUCT Function; CHAPTER 8 Accessories: Other Reporting Functions and Features; Helper Cells; Logic Functions; The IF Function; The AND and OR Functions; Lookup Functions; The VLOOKUP Function; The HLOOKUP Function; An Alternative to VLOOKUP; The INDEX and MATCH Functions; The MATCH Function; The INDEX Function; The INDEX-MATCH Combination; Error Handling Functions; The IFERROR Function; Handling Specific Errors; Text-Based Functions; The TEXT Function; LEFT and RIGHT Functions 327 $aThe MID FunctionFlexible Text Manipulations; The SEARCH Function; The LEN Function; Flexible Splitting; The SUBSTITUTE Function; Converting Text to Numbers; Date Functions; The DATE Function; Other Useful Functions; Array Formulas; CHAPTER 9 Range Names; Advantages; Disadvantages; Creating a Range Name; Using Range Names; Name Manager; Naming a Range; Creating Names Automatically; Name Intersections; Dynamic Range Names; Using Structure in Range Names; INDIRECT and Range Names; Listing Range Names; CHAPTER 10 Maintenance Issues; Maintenance Instructions; The Advantages of Using Tables 327 $aCommon IssuesRolling the Year; Working with Days; Simplifying the Interface by Using Controls; CHAPTER 11 Choosing the Right Format; Colour Blindness; Format Painter; Less Is More; Fonts; Clear and Start Again; The Format Cells Dialog Box; Styles; Conditional Formatting; Printing Issues; CHAPTER 12 Picture Perfect: Charting Techniques; Chart versus Graph; Chart Basics; Charts for Reports; Automating Charts; Mixing Chart Types; Dual-Axis Charts; Handling Missing Data; Labeling Highs and Lows; Trendlines and Moving Averages; Plotting the Variance; Dashboard Techniques; Text in a Chart 327 $aThe Data Series Formula 330 $a"The advanced tools accountants need to build automated, reliable, and scalable reports using ExcelLearn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants. Explore the structures that simplify the report creation process and make the reports more maintainable Learn techniques to "cleanse" data so that it is ready for use in Pivot Tables and formula-based reports Find out the tips and tricks that can make the creation process quicker and easier Discover all you need to know about Excel's summing functions and how versatile they can be Written in a hands-on style that works towards the completion of two reporting case studies, Advanced Excel Reporting for Management Accountants explains and demonstrates techniques so that Management Accountants can learn how to automate many aspects of the reporting process"--$cProvided by publisher. 410 0$aWiley corporate F & A series. 606 $aManagerial accounting$xComputer programs 606 $aElectronic spreadsheets$xComputer programs 615 0$aManagerial accounting$xComputer programs. 615 0$aElectronic spreadsheets$xComputer programs. 676 $a005.54024/6581511 686 $aBUS001040$2bisacsh 700 $aBlackwood$b Neale$0934060 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910132199703321 996 $aAdvanced Excel reporting for management accountants$92103019 997 $aUNINA