Advanced Excel reporting for management accountants / / Neale Blackwood |
Autore | Blackwood Neale |
Pubbl/distr/stampa | Hoboken, New Jersey : , : Wiley, , 2014 |
Descrizione fisica | 1 online resource (753 p.) |
Disciplina | 005.54024/6581511 |
Collana | Wiley corporate F&A |
Soggetto topico |
Managerial accounting - Computer programs
Electronic spreadsheets - Computer programs |
ISBN |
1-118-65818-3
1-118-77716-6 1-118-65819-1 |
Classificazione | BUS001040 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Structure = 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 Function 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 The 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 Common 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 The Data Series Formula |
Record Nr. | UNINA-9910132199703321 |
Blackwood Neale | ||
Hoboken, New Jersey : , : Wiley, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Advanced Excel reporting for management accountants / / Neale Blackwood |
Autore | Blackwood Neale |
Pubbl/distr/stampa | Hoboken, New Jersey : , : Wiley, , 2014 |
Descrizione fisica | 1 online resource (753 p.) |
Disciplina | 005.54024/6581511 |
Collana | Wiley corporate F&A |
Soggetto topico |
Managerial accounting - Computer programs
Electronic spreadsheets - Computer programs |
ISBN |
1-118-65818-3
1-118-77716-6 1-118-65819-1 |
Classificazione | BUS001040 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; 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
Structure = 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 Function 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 The 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 Common 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 The Data Series Formula |
Record Nr. | UNINA-9910814716203321 |
Blackwood Neale | ||
Hoboken, New Jersey : , : Wiley, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|