Forum menu
Any good crash cour...
 

[Closed] Any good crash courses in excel

Posts: 0
Full Member
Topic starter
 
[#9393710]

Have a job interview coming up and part of the spec is that I'm handy with excel.

I am pretty good at the basics and also some conditional formula etc but pretty week at things liked pivot tables and turning raw data into graphs etc.

Are there any online resources or good books that folk would recommend to get me up to speed in these areas?


 
Posted : 21/06/2017 5:58 pm
Posts: 78495
Full Member
 

Dunno whether it's "the best" but MS do their own online courses, for free.

https://support.office.com/en-us/article/Excel-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?ui=en-US&rs=en-US&ad=US


 
Posted : 21/06/2017 6:09 pm
Posts: 78495
Full Member
 

A quick Google gave me this list:

https://blog.hubspot.com/marketing/learn-excel-resources


 
Posted : 21/06/2017 6:11 pm
Posts: 5346
Free Member
 

http://chandoo.org

Most likely you'll need pivots, as you mentioned, along with

Sum, Vlookup, If, Countif(s), Sumif(s)

Excel's own help files are actually quite helpful these days


 
Posted : 21/06/2017 6:13 pm
Posts: 0
Full Member
Topic starter
 

Thanks all. Will have a read through some stuff.


 
Posted : 21/06/2017 8:19 pm
Posts: 10337
Full Member
 

As cougar said, the MS courses are excellent and worth doing even if you don't have a job interview


 
Posted : 21/06/2017 8:20 pm