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

---

Multi-level Dependent Drop-down Lists

---

From https://www.myonlinetraininghub.com/multi-level-dependent-drop-down-lists?awt_a=f2Zj&awt_l=el1rKn&awt_m=giF57GPw89VR.Zj:
The majority of Excel users struggle with this one thing.
They set up drop-down lists manually.
They waste time updating them.
They think dynamic dependent lists are complicated.
But what if I told you there’s a formula that does all the heavy lifting for you?
- It updates automatically when you add new data.
- It removes the guesswork.
- And yes, it’s way easier than you think.
In this video, you’ll discover two game-changing ways to create dependent drop-down lists in Excel: one is super simple, and the other? A total mind-blower!
Download the sample file here!
https://www.myonlinetraininghub.com/multi-level-dependent-drop-down-lists?awt_a=f2Zj&awt_l=el1rKn&awt_m=giF57GPw89VR.Zj - Multi-level Dependent Drop-down Lists

---

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

---

Excel Logical Functions

---

https://www.myonlinetraininghub.com/excel-logical-functions - Excel Logical Functions

---

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.

Look at the Third Alternative to Excel

Per https://www.techrepublic.com/article/free-alternatives-to-microsoft-excel, an alternative to using Microsoft Excel is to use ... Microsoft Excel?

1. Google Sheets: Best for offline editing and collaboration - Google Sheets: Best for offline editing and collaboration
2. Zoho Sheet: Best for automation - Zoho Sheet: Best for automation
3. Microsoft Office Excel Online: Best for users who prefer Excel's interface - Microsoft Office Excel Online: Best for users who prefer Excel's interface
4. Apache OpenOffice Calc: Best for customization - Apache OpenOffice Calc: Best for customization
5. LibreOffice Calc: Best Excel alternative for features - LibreOffice Calc: Best Excel alternative for features
6. WPS Office Spreadsheets: Best Excel alternative for ease of use - WPS Office Spreadsheets: Best Excel alternative for ease of use

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.

Learn Excel

I feel like I just posted about how learning a specific software - perhaps it was Excel - would be cool, but I wouldn't use it in my daily work as a Technical Writer. This is info about learning Excel.

---

https://www.techrepublic.com/article/learn-microsoft-excel-courses/ - Learn Excel

---

12 Default Microsoft Excel Settings You Should Change

12 Default Microsoft Excel Settings You Should Change

6 new powerful Excel functions *I* need to know

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

---

---