In this video, we'll show you how to use Solver to transform your finances. Solver can help you solve complex financial problems, no matter how tough they might seem. It's an Excel add-in that can optimize financial decisions. Solver can help you with budgeting, investing, loaning, and retiring.
Solver can find the optimal value for a formula in one cell, called the objective cell, subject to constraints or limits on the values of other formula cells on a worksheet.
If you're looking to transform your finances or take control of your money, then this video is for you! We'll show you how to use Solver to solve complex financial problems and unlock its power to help you reach your goals. So watch and learn!
Tuesday, November 14, 2023
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.
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.
Subscribe to:
Posts (Atom)