Once you do a few vlookups and pivot tables you will start to get the hang of it. They are not too advanced and, with practice, become second nature. It's all about first-hand practice with Excel. Watch a video or two on YouTube to see how it works then just open up an excel sheet and start playing around.
Down the road, if you're brave enough, you can try to learn some VBA coding. I typically copy coding from excel blogs posted for the assistance of others and have managed to learn how to adjust the code to my needs. I tried reading a book on coding and made it about 5 pages before I either fell asleep or needed a beer because my brain hurt. Never made it through chapter one… But people that know how to write code can do some really nifty things in excel.
One thing I find useful is just learning the shortcuts on the keyboard. I hardly ever need to use a mouse anymore because I force myself to learn keyboard shortcuts such as:
F2 – drill into formula in cell
F4 – freeze cells (I.e. $A$4)
Ctrl + page up/page down – scroll through worksheet tabs
Shift + F11 – add new tab
Ctrl + Spacebar – highlight entire column
The list goes on and on but these types of shortcuts keep me very efficient. I LOVE excel as you might be able to see 🙂
FAR - 2012 - PASSED (YAEGER)
AUD - 2012 - PASSED (YAEGER + NINJA NOTES)
BEC - 2012 - PASSED (YAEGER + NINJA NOTES)
REG - 2013 - PASSED (YAEGER + NINJA NOTES + NINJA AUDIO)
ETHICS - 2013 - PASSED
DONE!!! Thank you A71 for all the support! Hiya!!!