Hi Guys
I'm starting to utilize excel more often at work than previously and the analysis I need to undertake requires me to know more than just the sum/average functions in excel.
I was wondering if someone was able to suggest some good indepth reading material to master the advanced excel functions to retrieve/manipulate data and produce reports. I am somewhat comfortable with pivot tables however I am finding it challenging to categorize and retreive data that meets specific needs and have so far used functions like min(if) and sumproduct very amateurly to do the job. Is there a book/video that covers such topics in good detail and helps to understand them.
I realize that mastery comes with practice but I'd be interested to get some theoretical understanding of these topics before practicing them.
Thank You
I'm starting to utilize excel more often at work than previously and the analysis I need to undertake requires me to know more than just the sum/average functions in excel.
I was wondering if someone was able to suggest some good indepth reading material to master the advanced excel functions to retrieve/manipulate data and produce reports. I am somewhat comfortable with pivot tables however I am finding it challenging to categorize and retreive data that meets specific needs and have so far used functions like min(if) and sumproduct very amateurly to do the job. Is there a book/video that covers such topics in good detail and helps to understand them.
I realize that mastery comes with practice but I'd be interested to get some theoretical understanding of these topics before practicing them.
Thank You
