I'm an analyst and excel is my saviour these days. I've never really used excel for complex data manipulation so I really hope this forum will help.
The issue I run into with excel is that I'm not very familiar with the core functions that are used to manipulate data. I have a pretty decent understanding of "VLookup", "IF", "AND", "OR" but would like to learn more.
Can anyone share a list of functions that they find most useful when dealing with large amounts of data?
thank you all!