“Analysis via Pivot Tables” Please respond to the following:
Describe a situation where pivot tables could be used to aid a business decision. Specify the question / problem management needs to resolve, and explain the manner in which the pivot table results will provide a solution. You may use one (1) of the homework exercises as a basis for your response, or a company with which you are familiar.
“Macro Efficiency Please respond to the following:
Describe a situation in a work environment where the use of macros would improve efficiency in processing data in Excel. Identify the likely challenge(s) you would face in developing the macros, and suggest a plan for addressing the challenge.