Toggle navigation
Toggle navigation
Home
DCUM Forums
Nanny Forums
Events
About DCUM
Advertising
Search
Recent Topics
Hottest Topics
FAQs and Guidelines
Privacy Policy
Your current identity is: Anonymous
Login
Preview
Subject:
Forum Index
»
Jobs and Careers
Reply to "Best (and quickest) way to improve EXCEL knowledge/skills"
Subject:
Emoticons
More smilies
Text Color:
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Violet
White
Black
Font:
Very Small
Small
Normal
Big
Giant
Close Marks
[quote=Anonymous]I found the best way to sharpen my skills was to need them for the specific job I was doing. There are TONS of quick tutorials for every Excel function. I don't use, for example, INDEX-MATCH functions on a daily basis, but whenever I need to, I can look them up. You need to practice. You also need to make sure every single thing you do passes the sniff test. Check your pivot table against your data to make sure it makes sense. If it seems off, run it again in on a new sheet and futz with the parameters until it seems right. Build in checks and balances -- if your table tells you there are 25 instances of value X, then go run a "find" search on the data and see if it returns 25.[/quote]
Options
Disable HTML in this message
Disable BB Code in this message
Disable smilies in this message
Review message
Search
Recent Topics
Hottest Topics