What courses should I take to learn the Data skills/tools I need?

[smartdegree]

I know we have some Data people here, so I am hoping I can get right to the nitty gritty.   I don’t necessarily need a “degree” nor a certification.  But for my job, I think I could refine some of my processes if I could learn these things.   It could be a simple YouTube video.   I have looked for some of this myself, but I am not sure I am finding the right things…..

• Excel - Best utilization for “Queries & Connections”.  How can I update data between various spreadsheets without having to merge through Ablebits.
  
• Excel - Pivot Tables.   I don’t know a dang thing about Pivot tables and if/how to use them.
  
• Excel or Sheets - How can we have a bunch of separate sheets (that are accessed by specific departments/staff) and those sheets merge in to one giant main sheet and Vice Versa?  Is that even possible?
  

For points 1&3, that is easy to do using VBA code.  You don't even need a course for that.  Just google or youtube it or post your question on stackoverflow.com and someone will give you the VBA code you can just cut and paste.   Unfortunately, a lot of this you cannot learn through a standard course, as sometimes what you want to do is very specific and requires a specific script that isn't well known. 

For point 2, think of pivot tables having 3 components: the filter, the metric (or variable) and the slicer.  The filter will allow you to remove or include only some items that fit that criteria.  The metric is what you are looking at - for example, income, sales, headcount, etc.  The slicer is something you use to slice the metric - you can do it by year, location, etc.   As long as you understand those 3 concepts and where to put them in the pivot, it should be straightforward.  However, if you are working on the database the pivot is based on, you need more advanced excel stuff and basics on relational databases such as primary keys, etc.  

Pivot tables are important because they are the first step for many moving towards big data analysis.  Once you understand filters, slicers and relational databases, you can scale the same process over millions of rows and records.  Excel is limited to in terms of rows/columns, and that's where big data comes in - tools like SAS, R, etc actually do a lot of the same things you would do with Excel, except you can go beyond Excel's data size limitations.