If you want to become proficient at excel (not VBA), I can suggest pick following topics and master them. Spend a day or two on each topic.
1) functions like sumif, countif, sumifs, countifs, nested ifs
2) vlookup, hlookup - using vlookup to reference more than 1 column
3) using...