Generate Random Numbers that Add Up to Given Amount - Google Sheets

https://youtu.be/Ahtt5yGm16M

In this video, we're going to show you how to use the RAND and RANDBETWEEN in Google Sheets to generate a set of random numbers that add up to a specific value. You'll be able to generate multiple sets of random numbers that add up to any value you want. This can be done with decimal numbers as well as integers. Consider this a hack or workaround to scripting something in Python or JavaScript as a quick solution you can easily put together in Google Sheets.

Extract or Parse JSON Data with Power Query

https://youtu.be/C9rOUvWO7cM

Did you know Power Query can talk JSON? Well no they don’t actually talk to each other….but if you’re trying to pull those name-value JSON pairs from a text file or log file to put into a spreadsheet, you don’t need to write some Python script do this. And hopefully you ARE thinking twice about putting your company’s data into one of those free services on the Internet.

Create a Time Sheet - Google Sheets

https://youtu.be/1JvrbDxekqw

Do you track time sheets for people? Want a quick way to track and add up hours worked? Also want to be able to share or collaborate on the sheet? A good solution is to use Google sheets. The calculations are easy to do, and the sheet is all in the “cloud” and easily shareable. I’ve cover two ways you can track time spent either in decimals so you can multiply by some rate like 10 bucks and hour. Or you can get the time spent in duration like 8 hours 10 minutes.

Create a Time Sheet - Google Sheets

https://youtu.be/1JvrbDxekqw

Do you track time sheets for people? Want a quick way to track and add up hours worked? Also want to be able to share or collaborate on the sheet? A good solution is to use Google sheets. The calculations are easy to do, and the sheet is all in the “cloud” and easily shareable. I’ve cover two ways you can track time spent either in decimals so you can multiply by some rate like 10 bucks and hour. Or you can get the time spent in duration like 8 hours 10 minutes.

Highlight Table Cell based on Dropdown Selection

https://youtu.be/mykydvrDKaI

Sharing data table with someone and wanting to quickly highlight a cell based on some dropdowns? This could be a situation where you’ve got a dashboard or report and you need users to find the main data point after they select something. This video will show you how simple it is to create a dropdown. Not one but two! And once the choice is made, it’ll quickly highlight that part of a table to show the important information.

Filtering and Slicers - Google Sheets

https://youtu.be/JiL4Vr2XXdE

Filtering column data in sheets in another way to help you narrow done on the important stuff of your data. Also something a bit newer called Slicers, and I’ll cover that closer to the end of the video. But did you know you could filter for value, conditions or colors in sheets? There’s all sorts of ways you can tease out the important stuff in your data with filters and you can even hide your filtering when you are collaborating with others in google sheets.

Extract First, Last & Middle Name Excel Power Query

https://youtu.be/-ZFUW5jAwN0

You’ve got names in a column cell and you want to separate first, middle and last names. Easy to do if ALL the values were the simple first…middle… and last name. But what if some didn’t have middle names? What if some had two or three middle names? Easy if it was like 5 to 10 names. 20 names…not that easy...2000 names? Much harder to do. But if you’ve got power query, it’ll only take under 5 minutes to do. Plus once you set it up, you can do it over and over again.