This website uses technical, customisation and analytical cookies, both first-party and third-party, to anonymously facilitate browsing and analyse statistics on use of the website. Learn more
Search results
-
Grenarello Gardens Preservation Foundation
de Santiago, RafaelCase AD-327-EAccounting and Control, Finance, Service and Operations ManagementThe case describes the recent creation of an Italian foundation whose mission is to foster and promote the preservation of historic gardens and parks. When the manager is asked to brief the City Council about the foundation¿s financial situation, he creates a tool to generate the financial reports simplifying the accounting process to a minimum. The case is meant to exploit the power of Microsoft Excel PivotTables and advanced Excel functions.Starting at €8.20
-
ASCII Electronics
de Santiago, RafaelCase AD-328-EAccounting and Control, FinanceThe case describes a small electronics company whose manager needs to analyze the financial information available at the end of the year in order to improve operations and determine his employees' bonuses. With so many records in the spreadsheet, he needs to summarize the information in such a way that his analysis is meaningful. The case is meant to use some advanced Excel functions (like VLOOKUP, MATCH and OFFSET), and to introduce Pivot Tables...Starting at €8.20
-
PivotTables in Excel 2010
de Santiago, RafaelTechnical Note ADN-277-EAccounting and Control, Service and Operations ManagementThis technical note provides an introduction to using PivotTables in Microsoft Excel 2010. A PivotTable is a powerful tool that allows the user to analyze, sort, count, summarize, and organize data from a spreadsheet. A PivotTable is especially useful when you have a long list of figures to sum, and aggregated data or subtotals would help you look at the data from different perspectives and compare figures of similar data. This note is an updated...Starting at €8.20