Tips & Insights provides advice on and examples of technology used to simplify and streamline IR activities, as well as real world examples of visual displays of data (e.g., charts, graphs, maps, tables, pictures). These eAIR features are developed by members.
When we report large numbers (especially related to financials), the default number formatting in Excel does not show up nicely in tables or charts, making it hard to read in a glance. One way to address this is to use c...Read Moreabout: Formatting Numeric Data to “Millions” in Excel
Learn how to make Pivot Tables, VLOOKUP, and absolute/relative formula references work harder. I’m sure we’ve all been faced with the need to create a quick analysis/fishing expedition of some sort, and the ...Read Moreabout: Pivot Tables, VLOOKUP, and Absolute/Relative Formula References
Many of us use Microsoft Access to extract data from Banner or other enterprise systems, or to store data that doesn’t fit in our enterprise system. This tip provides an overview of the criteria field in Access que...Read Moreabout: Using the Criteria Field in Microsoft Access