How to do CAGR

https://youtu.be/QwxyXKyAcCIK

Know what a CAGR is? It stands for Compound Annual Growth Rate and it shows the rate of return of an investment over a certain period of time as a percent. You'll see it a lot in business presentations or out the mouth of wall street types. It's a formula but there's a quick and easy function in Excel that will calculate it.

How to Add or Multiply Numbers in a Cell [No FORMULAS]

https://youtu.be/BVu3g91_xg8

Quickly add multiply or do math on numbers in your table data with this tip. You don't need a helper column with a formula where you cut and paste and then delete the extra column. All you need is the value you want to do the calculation in a temporary location and use Paste Special to do the magic.

Data Analysis Made Easy: Compare Population Data in Excel

https://youtu.be/2PaxqmzaCsI?si=bly10yLgGSxnxEtg

Unlock the power of effortless data analysis with this charting hack! No longer will you be bogged down by complex data comparisons. I’ll walk you through the process of comparing population data like a seasoned pro with this simple trick. With just a few clicks, you'll gain valuable insights, spot trends, and make data-driven decisions. Whether you're a data enthusiast or a business professional, mastering this simple yet effective data analysis technique will save you time and effort, allowing you to focus on what truly matters - leveraging data to drive success. 

Multiple Pivot Table Views Values Section Total & Percentage

https://youtu.be/yRHSIfXwLcQ

Pivot Tables are one of THE best ways to analyze and show your data. But sometimes you want to show different views of the same data like the counts and then percentage from totals. Were you used to having two pivot tables? One with the count and one with percentages? Takes out a lot of space? We put it on one table and still make it look good. You don’t have to have separate pivot tables to show different views of the same data. You can combine them into one pivot table and still have it look presentable. This gives you a way to make your data insightful and look good at the same time.

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.