In this quick and handy tutorial, I'm going to show you how to combine tables using the awesome VSTACK function. Picture this: you have two separate tables in Excel, and you want to effortlessly stack them together to create one big, beautiful table. With VSTACK, it's as easy as pie. Just follow along as I guide you through the simple steps. By the end of this video, you'll be a pro at merging tables like a boss. So grab your favorite beverage, sit back, and let's dive into the world of combining tables using the VSTACK function in Excel!
Sunday, October 29, 2023
Monday, October 16, 2023
Find Cells with Conditional Formatting
Are you trying to get a distinct count in your values section of a Pivot Table? You know that by default the values section does a count of the values in the field you put there, but there's a way for you to get a distinct count. But it's an extra step.
Get Distinct Count (Ignore Duplicates) in Pivot Table
Are you trying to get a distinct count in your values section of a Pivot Table? You know that by default the values section does a count of the values in the field you put there, but there's a way for you to get a distinct count. But it's an extra step. Check out the video to learn more.
Monday, October 2, 2023
How to do CAGR
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.
Monday, September 25, 2023
How to Add or Multiply Numbers in a Cell [No FORMULAS]
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.
Sunday, September 17, 2023
Data Analysis Made Easy: Compare Population Data in Excel
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.
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.
Subscribe to:
Posts (Atom)