Most Useful Excel Capabilities

[tarak79]

Hi! I recently went back to work after over 10 years out of the workforce. Excel has changed quite a bit in that time and I'm just starting to learn some of the new functionality. I was just wondering what tools people use the most and which you think are the most important to master. I'm assuming vlookup is a big one. What else?

 

[footoo]

It depends what you're cooking. Onions are a standard item but are useless to a dessert pastry chef.

 

[tarak79]

Ha! Good point! I'm an accountant and have pretty sad Excel skills. I know we use vlookup and pivot tables a lot but the reality is, I don't even know all the things Excel can do. I learned Flash Fill the other day, it blew my mind. Yes, it's really that bad.

 

[hiker95]

Ha! Good point! I'm an accountant and have pretty sad Excel skills. I know we use vlookup and pivot tables a lot but the reality is, I don't even know all the things Excel can do. I learned Flash Fill the other day, it blew my mind. Yes, it's really that bad.

tarak79,

Welcome to the MrExcel forum.


See if something, in the below link(s), of my most up to date list will help you:

Training / Books / Sites as of 03/20/2017


See reply #3 at the next link:

https://www.mrexcel.com/forum/excel-questions/999340-how-become-excel-master.html#post4796104