Sunday, October 29, 2023

Excel Hacks: Generate Alphabet Lists in Seconds!


In this short video, I'm going to show you how to generate an alphabet list in seconds using Excel. This is a great hack to use if you need to generate a list of letters quickly!

If you're looking for a quick and easy way to create an alphabet list, then this is the video for you! By following my simple steps, you'll be able to generate your list in seconds! So don't hesitate, watch the video and let us show you how to create an alphabet list in seconds using Excel!

Quickly Combine Tables with VSTACK


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! 

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.