Macros & Pivot tables
IB
Tags:
(Baboon, 154
Points)
on 8/20/07 at 12:15pm
For what functions do you guys use macros and pivot tables for.
I know what both are, and how to create them, but I am asking specifically, where do you usually find yourself applying these.





Macros: loads of threads on
Macros: loads of threads on this
Pivot Tables: mainly analysing shareholding profiles, debt maturities
agree, there are plenty of
agree, there are plenty of sources for macro info, but generally they're great for anything that's repetitive
i'll usually use a macro for tasks like paste special when i know i'll be doing them a ton in a worksheet since it's easier to assign it one key than to have to press a multi-key shortcut each time. also macros are awesome if you have to regularly compile reports/summaries from any source data (i have to make a few weekly summaries for the higher ups and now i can do it in a couple minutes)
pivot tables are useful anytime you have a large amount of data that you want to be able to rearrange/manipulate easily. i generally hate the new Office but pivot tables in excel 07 have a couple of useful features
thanks
for the input fellas
do interviewers ever ask
do interviewers ever ask questions on how to create macros and pivot-tables...
or is knowing what they
or is knowing what they basically are and what they can be used for good enough?