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.
Sunday, September 17, 2023
Monday, August 21, 2023
Multiple Pivot Table Views Values Section Total & Percentage
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.
Monday, August 14, 2023
Generate Random Numbers that Add Up to Given Amount - Google Sheets
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.
Monday, August 7, 2023
Extract or Parse JSON Data with Power Query
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.
Monday, July 31, 2023
Create a Time Sheet - Google Sheets
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.
Monday, July 24, 2023
Create a Time Sheet - Google Sheets
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.
Monday, July 17, 2023
Highlight Table Cell based on Dropdown Selection
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.
Subscribe to:
Posts (Atom)