Our Other Brands
Individuals & Teams Las Vegas • Nov 30 - Dec 2, 2026 Excel Esports Hyperx arena Prize Fund • $34,050 Individuals & Teams Las Vegas • Nov 30 - Dec 2, 2026 Excel Esports hyperx arena Prize Fund • $34,050
Get Hyped →

2024 PERSONAL FINANCE TRAINING – BUDGET ANALYSIS (APRIL)

 

Here is a comprehensive walkthrough guide for the 2024 Personal Finance Training – Budget Analysis (April) provided by one of our faculty fellows, David Brown. The challenge is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos.

TASK
In this Challenge, you will analyze your recent budget transactions to better understand your spending habits. Being knowledgeable about where your money is going is an important step towards making wise financial decisions. You will use a number of Excel functions in this Challenge, including COUNT, COUNTIF, SUMIFS, and AVERAGEIFS. You will review XLOOKUP and MIN and also have a look at FILTER, UNIQUE, and IFERROR. Building a solid understanding of these Excel functions and getting into the habit of analyzing your spending habits are essential skills as you enter the workforce.

WALKTHROUGH VIDEO PROVIDED BY ERIC KELLEY 

In this session, David delves into analyzing recent budget transactions to enhance your understanding of spending habits. You’ll learn to:

  • Utilize COUNT, COUNTIF, SUMIF, AVERAGEIF, and XLOOKUP functions.
  • Explore FILTER, UNIQUE, and IFERROR functions.
  • Analyze spending patterns efficiently.
0
0
Your Cart
Your cart is emptyReturn to Shop