I just started a new job and I'm inquiring because I'm a novice at excel. I know I need to improve my skills and I'm working diligently off the clock and on the job. Just curious how some of you went from not knowing what to do first to mastering excel like a pro?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How did you guys get good at sorting data?
- Thread starter PWil84
- Start date
diddi
Well-known Member
- Joined
- May 20, 2004
- Messages
- 3,337
- Office Version
- 2010
- Platform
- Windows
I am a long way from a pro, but i find i have good luck by concentrating on small sections and getting them right, rather than trying to understand every feature which ends up so superficial it is pretty much useless because you cant do enough to solve your problem. at least that works for me
Upvote
0
Just asking the right questions and getting help here.
VLOOKUP, SUMIF, COUNTIF, IF and INDEX with MATCH are going to be used alot so good to get your head around.
Pivot tables also do alot of heavy lifting and don't get used nearly enough by alot of people.
Wiseowl on YouTube has some really great tutorials too so I'd have a look at his library and see what is there.
VLOOKUP, SUMIF, COUNTIF, IF and INDEX with MATCH are going to be used alot so good to get your head around.
Pivot tables also do alot of heavy lifting and don't get used nearly enough by alot of people.
Wiseowl on YouTube has some really great tutorials too so I'd have a look at his library and see what is there.
Last edited:
Upvote
0
Solution
Similar threads
- Question
- Question
