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

[Vle045]

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?