Suggestions for excel training

[Johnagall]

Hi guys,

I'm a manager at a company where we're not using utilising data enough to demonstrate the impact of the work we're doing. I'd like to do some excel training to develop skills that will help.

I'm a fairly basic user that knows some formulas mainly around home finances. Autosum and other basics. I don't know an awful lot about vlookup and other functions sumif, index, pivot tables though I obviously know of this functions.

Could somebody recommend a site (im happy to pay if needed) or training course for me to improve my skills?

Thanks in advance

 

[DRSteele]

I can recommend a free method. Watch videos on youtube from these two excellent channels. You will learn at a geometric rate if you devote a couple hours per day to observation and practice --- guaranteed.

MrExcel: https://www.youtube.com/channel/UCXbicpVq_ALWG4ijPKsR7ZQ
ExcelIsFun: https://www.youtube.com/channel/UCkndrGoNpUDV-uia6a9jwVg

The ExcelIsFun channel contains links in the video description that allow you to download the very workbooks Mike is using in the videos.

You can also use sample data of your own to learn the principles and techniques. Then come back to this forum to have your questions answered. You can download sample data that lends itself well to learning purposes from all kinds of websites: I choose to learn by tinkering with stock market data, weather data and sports data.

Start here for s splendid primer: https://www.youtube.com/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
and here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw

Feed your head.

 

[hiker95]

Johnagall,

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

Training / Books / Sites as of 5/30/2018

https://www.mrexcel.com/forum/excel...lding-software-excel-shipper.html#post5079095