Dynamic Drop-Down Lists in Excel

---

https://www.myonlinetraininghub.com/dynamic-drop-down-lists-in-excel - Dynamic Drop-Down Lists in Excel

https://youtu.be/ 2YEXzHIy_l8 - Title Goes Here

---

Automatically Highlight Key Data Video

---

From https://www.myonlinetraininghub.com/automatically-highlight-key-data-in-excel?awt_a=f2Zj&awt_l=el1rKn&awt_m=gZ6VIDi3J9VR.Zj comes this intriquing idea. I was initially curious by the title as, in my mind, I was thinking about my MP3s that have names like this:

1. 01_Enter Sandman_Metallica_Metallica_Spindle-G-GGGG.mp3
2. 01_Enter Sandman_Metallica_Metallica_Spin-G-GGGG.mp3
3. 01_Enter Sandman_Metallica_Metallica_Spindle-G-GGGG-MP3.mp3
4. 01_Enter Sandman_Metallica_Metallica_Spindle-G-0000.mp3
5. 01_Enter Sandman_Metallica_Metallica_Spin-G-0000.mp3

What I am showing in the above example is the messy state of my MP3s. The above example reflects the multiple naming conventions I have tried to implement while never fully getting the job done. I thought, by the title of this article, I would be able to flag all but #5, which, I thought, I could specify, somehow, as being the standard to be followed in a file name after the 4th underscore. I'm not a super-duper proficient analyzer of data and every morsel of my analytical skills come from working as a Technical Writer since 2-10-1995, a mere 10987 days (30 years, 1 month, 1 day) ago.

---

https://youtu.be/ n5HJ4eymAOA - Automatically Highlight Key Data Video

---

Extract Data to Separate Sheets the Right Way

Download the Excel file here: https://www.myonlinetraininghub.com/excel-pivot-tables-to-extract-data

---

https://youtu.be/ _ys8qNq1soM - Extract Data to Separate Sheets the Right Way

---

How to Use Python in Excel Natively

I'm convinced that there's a reason why I should learn Python. In my role as a Senior Technical Writer, I've learned that Python exists and that a lot of people have created resources for me to learn Python. Case in point, there's this article https://www.myonlinetraininghub.com/python-in-excel - How to Use Python in Excel Natively.

Hit a Dead End on a Quest

I found the following file - 2010-10-2523-03-37_timesheet_m.xlsx - on one of my EHDs. I attempted to open the file - because I didn't know what it was - and saw that it was password-protected. I don't remember the password as it was assigned to this file 4613 days (12 years, 7 months, 2 weeks, 4 days) ago. It could be a container for "useful" information; it could be a container for "unuseful" information. I don't know. I can't open the file.
I turned to Google. I found this video:

---

---

and noticed that the video includes a link for "written instructions" so I clicked it: https://www.myonlinetraininghub.com/easily-remove-excel-password-protection. In the last section of this page, I read the following:

---

---

I've reached the dead end on this quest. I will continue to look for another resource.

Using Microsoft Power Query

While I have no current need to learn Microsoft Power Query, I think it would be neat to learn.

---

---

Editor's Note: There are sample files to download to follow along with the video - do not forget you nearly 51 year-old OLD MAN!

6 new powerful Excel functions *I* need to know

This is for when I upgrade (someday) to Excel 2019.

---

---

10 Features Every Excel User Should Know

---

---

Partially Stack Data

---

---

Unstack Data In Excel With Power Query

---

---

Because Who Doesn't Need an Excel Tip

---

---

15 Keyboard Shortcuts to Navigate Excel Fast!

---

---