how to improve excel skills

B

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
846
Office Version
  1. 2013
Platform
  1. Windows
im decent in excel but no where as good as id like to be. thing is i dont even know what i need to learn - like i know i need to brush up on macro's and pivot tables but besides that i dont know what to work on. is there any resource out here that could work? i would really prefer something with exercises at the end to cement in the knowledge.

im going to be learning at work so no youtube please. well if there's something really awesome there then lemme know and i can check it out at home but for the most part id prefer non-audio/video.

thanks!
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Sort by date Sort by votes
bigdan said:
im decent in excel but no where as good as id like to be. thing is i dont even know what i need to learn - like i know i need to brush up on macro's and pivot tables but besides that i dont know what to work on. is there any resource out here that could work? i would really prefer something with exercises at the end to cement in the knowledge.

im going to be learning at work so no youtube please. well if there's something really awesome there then lemme know and i can check it out at home but for the most part id prefer non-audio/video.

thanks!
Click to expand...
It's really simple but it takes some time. A lot of time!

Spend 6 hours a day, every day, in these forums reading posts and trying the solutions provided. Experiment!

After about 4 - 5 years you should be good to go!
 
Upvote 0
haha OK. anything more realistic? i'd like something more linear, this seems very scattered.
 
Upvote 0
You could do worse than spend a lot of time at Debra Dalgleish's site, which has good articles on many tools of the trade (Excel and Excel VBA):
http://www.contextures.com/tiptech.html

Also for Charting (you may like to check out his links page too):
http://peltiertech.com/Excel/Charts/

As for VBA you'll learn that here for sure. It is worthwhile to read a good book such as Excel VBA Programming for Dummies and/or Excel Power Programming, both by John Walkenbach. I also like the titles in the Business Solutions series: VBA and Macros for Microsoft Excel (by our own "Mr Excel" Bill Jelen) and Formulas and Functions with Microsoft Excel (by McFedries)
 
Last edited:
Upvote 0
got it. are there any notable books that come to mind? same as with above, with books id prefer to have end of chapter assignments in order to solidify learning.
 
Upvote 0
those are a bit advanced for me. i want something a bit lower. also im not interested in learning vba to *that* level of sophistication, more like being adequate at it. id think a few chapters would suffice.
 
Upvote 0
Excel VBA for Dummies by Walkenbach is an excellent introduction / first book on Excel VBA.

ξ
 
Upvote 0
Do you use Excel for work? If so you might want to ask if they'll pay for you to take instructor-led courses.

I'm no Excel guru, but I've taken 3 (soon to be 4) at New Horizons and they're awesome for learning the basics. Check out newhorizons.com

Good luck!
 
Upvote 0
You must log in or register to reply here.

Similar threads

MCLIFTO8
  • Question Question
Article / Guide feedback requested. The best way to learn Excel.
Replies
0
Views
2K
MCLIFTO8
MCLIFTO8
R
  • Question Question
Time sheet formulas
Replies
2
Views
360
rodnaaaaay
R
W
  • Question Question
Mediocre Excel User Seeking to Improve on Bills Sheet
Replies
2
Views
203
cooleomter
C
C
  • Question Question
Failing at creating DAX measure calculation :-(
Replies
1
Views
281
Matt Allington
M
T
  • Question Question
How do I write Code for an API key call using Blank Query on legacy Excel/Mac
Replies
1
Views
52
Ron de Bruin
Ron de Bruin

Forum statistics

Threads
1,224,550
Messages
6,179,463
Members
452,915
Latest member
hannnahheileen

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top