The Resource Advanced Excel reporting for management accountants, Neale Blackwood

Advanced Excel reporting for management accountants, Neale Blackwood

Label
Advanced Excel reporting for management accountants
Title
Advanced Excel reporting for management accountants
Statement of responsibility
Neale Blackwood
Creator
Contributor
Author
Provider
Subject
Language
eng
Cataloging source
NhCcYBP
http://library.link/vocab/creatorName
Blackwood, Neale
Illustrations
illustrations
Index
index present
LC call number
HF5657.4
LC item number
.B59 2014
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Wiley Online Library
http://library.link/vocab/subjectName
  • Managerial accounting
  • Electronic spreadsheets
Label
Advanced Excel reporting for management accountants, Neale Blackwood
Instantiates
Publication
Note
Includes index
Carrier category
online resource
Carrier MARC source
rdacarrier
Content category
text
Content type MARC source
rdacontent
Contents
Machine generated contents note: Assumptions -- The Goal of Reporting -- Why Use Excel? -- The Goal of This Book -- Monthly Management Reports -- Macro Policy -- Needs Analysis -- Scope Definition -- Design -- Construction -- Testing -- Operation -- Maintenance -- Time, Effort, and Cost -- Practical Considerations -- Display Tips -- Keyboard Shortcuts -- Mouse Shortcuts -- Keyboard and Mouse Shortcuts -- General Tips -- Structure = Flexibility -- Modular Sheet Design -- Standardised Report Layout -- Table-Based Systems -- Spreadsheet Best Practices -- Terminology -- Data Rules -- Data Structures -- Format as Table -- Data Cleansing Techniques -- External Data -- The Pros and Cons of a Pivot Table -- Creating a Pivot Table -- PowerPivot -- 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 Wizard -- Conditional Summing -- The SUMIF Function -- SUMIF Uses -- Helper Cells -- The SUMIFS Function -- The SUMPRODUCT Function -- 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 Function -- Flexible 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 -- 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 -- Maintenance Instructions -- The Advantages of Using Tables -- Common Issues -- Rolling the Year -- Working with Days -- Simplifying the Interface by Using Controls -- Colour Blindness -- Format Painter -- Less Is More -- Fonts -- Clear and Start Again -- The Format Cells Dialog Box -- Styles -- Conditional Formatting -- Printing Issues -- 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 -- Before and After Charts -- Identifying Errors -- Validations -- Error Tracking -- Identifying New Codes -- Conditional Formatting -- Suggested Validation Structure -- Reasonableness Checks -- Scenario -- Data Requirements -- Processes -- Structure -- Design -- Report Layout -- The Creation Process -- The Reports -- Scenario -- Data Requirements -- Processes -- Structure -- Design -- The Creation Process -- The Reports -- Feedback -- Last Words
Extent
1 online resource ( xv, 424 pages)
Form of item
online
Isbn
9781118777169
Isbn Type
(electronic bk.)
Lccn
2014008177
Media category
computer
Media MARC source
rdamedia
Other physical details
illustrations.
Reproduction note
Electronic reproduction.
Specific material designation
remote
Stock number
  • 99958863685
  • 283C2D6F-C76C-463C-AA08-78DC356DE653
System control number
(NhCcYBP)11072569
Label
Advanced Excel reporting for management accountants, Neale Blackwood
Publication
Note
Includes index
Carrier category
online resource
Carrier MARC source
rdacarrier
Content category
text
Content type MARC source
rdacontent
Contents
Machine generated contents note: Assumptions -- The Goal of Reporting -- Why Use Excel? -- The Goal of This Book -- Monthly Management Reports -- Macro Policy -- Needs Analysis -- Scope Definition -- Design -- Construction -- Testing -- Operation -- Maintenance -- Time, Effort, and Cost -- Practical Considerations -- Display Tips -- Keyboard Shortcuts -- Mouse Shortcuts -- Keyboard and Mouse Shortcuts -- General Tips -- Structure = Flexibility -- Modular Sheet Design -- Standardised Report Layout -- Table-Based Systems -- Spreadsheet Best Practices -- Terminology -- Data Rules -- Data Structures -- Format as Table -- Data Cleansing Techniques -- External Data -- The Pros and Cons of a Pivot Table -- Creating a Pivot Table -- PowerPivot -- 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 Wizard -- Conditional Summing -- The SUMIF Function -- SUMIF Uses -- Helper Cells -- The SUMIFS Function -- The SUMPRODUCT Function -- 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 Function -- Flexible 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 -- 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 -- Maintenance Instructions -- The Advantages of Using Tables -- Common Issues -- Rolling the Year -- Working with Days -- Simplifying the Interface by Using Controls -- Colour Blindness -- Format Painter -- Less Is More -- Fonts -- Clear and Start Again -- The Format Cells Dialog Box -- Styles -- Conditional Formatting -- Printing Issues -- 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 -- Before and After Charts -- Identifying Errors -- Validations -- Error Tracking -- Identifying New Codes -- Conditional Formatting -- Suggested Validation Structure -- Reasonableness Checks -- Scenario -- Data Requirements -- Processes -- Structure -- Design -- Report Layout -- The Creation Process -- The Reports -- Scenario -- Data Requirements -- Processes -- Structure -- Design -- The Creation Process -- The Reports -- Feedback -- Last Words
Extent
1 online resource ( xv, 424 pages)
Form of item
online
Isbn
9781118777169
Isbn Type
(electronic bk.)
Lccn
2014008177
Media category
computer
Media MARC source
rdamedia
Other physical details
illustrations.
Reproduction note
Electronic reproduction.
Specific material designation
remote
Stock number
  • 99958863685
  • 283C2D6F-C76C-463C-AA08-78DC356DE653
System control number
(NhCcYBP)11072569

Library Locations

  • African Studies LibraryBorrow it
    771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Alumni Medical LibraryBorrow it
    72 East Concord Street, Boston, MA, 02118, US
    42.336388 -71.072393
  • Astronomy LibraryBorrow it
    725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US
    42.350259 -71.105717
  • Fineman and Pappas Law LibrariesBorrow it
    765 Commonwealth Avenue, Boston, MA, 02215, US
    42.350979 -71.107023
  • Frederick S. Pardee Management LibraryBorrow it
    595 Commonwealth Avenue, Boston, MA, 02215, US
    42.349626 -71.099547
  • Howard Gotlieb Archival Research CenterBorrow it
    771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Mugar Memorial LibraryBorrow it
    771 Commonwealth Avenue, Boston, MA, 02215, US
    42.350723 -71.108227
  • Music LibraryBorrow it
    771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Pikering Educational Resources LibraryBorrow it
    2 Silber Way, Boston, MA, 02215, US
    42.349804 -71.101425
  • School of Theology LibraryBorrow it
    745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350494 -71.107235
  • Science & Engineering LibraryBorrow it
    38 Cummington Mall, Boston, MA, 02215, US
    42.348472 -71.102257
  • Stone Science LibraryBorrow it
    675 Commonwealth Avenue, Boston, MA, 02445, US
    42.350103 -71.103784
Processing Feedback ...