Hello, I have just got a new job and it requires a lot of analysis, extraction, a lot of data work etc in general (Business Work). I have very large volume datas and I see myself that I am not enough experienced.
So please could you tell me which FUNCTIONS and FORMULAS should I manage well to be considered a skilled user for data analysys and management. I mean from basic to advanced useful and powerful, the most necessary ones for day by day on Business enviroment work. Thanks in advance.
Hi Vegeta,
There is an Analysis Tool Pack that gives extra functions to Excel that might be useful, although I have no idea what you will be required to do. Here is a link to installing it.
https://technet.microsoft.com/en-us/.../ff969363.aspx
When you said you have a very large volume of data, I'd suggest you learn Pivot Tables.
Here is a starting point but Pivots do so much more.
http://www.addictivetips.com/windows...-pivot-tables/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks