So basically I'm doing an excel project under the premise that that I'm, as an employee of the company, creating a workbook for my boss to use an an analysis and projection tool for the company. One of the ways to earn points on this project is go beyond what's been learned inside the class and find useful things to add to the workbook. It's based around a customer database centered on accounts receivables and around an income statement. I'm looking for useful obscure things that most people might not realize could be done with excel. I've already incorporated pivot tables, advanced filter (w/ wildcards), goal seek, vlookup, if analysis and things such as macros, customer ribbon, data validations, etc. that were learned in class.
Bookmarks