ASCII Electronics
The 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, a powerful alternative when you need to analyze, sort, count, summarize, and organize large amounts of data.
Collection: IESE (España)
Ref: AD-328-E
Format: PDF
Number of pages: 6
Publication Date: Sep 26, 2011
Language: English
What material is included in this case:
Description
The 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, a powerful alternative when you need to analyze, sort, count, summarize, and organize large amounts of data.
Read more
Year: 2011
Leave your rating
"ASCII Electronics"
Register for free with IESE Publishing and enjoy all the advantages
What type of account do you want to create?
Choose account type
Professors
Academic Institutions
Companies
Individuals