Comparing Lists of Values in Excel using Array Formulas
Last week, we had a home work on Calculating Donation Summaries using Excel Formulas. This is a good case where array formulas can help us. So today, we will learn how we can use Array Formulas to compare lists of values and calculate summaries. Towards the end of this post, you can see a video that explains the solution to Donation Summary Calculation problem.
Amount Donated vs. Pledged [Excel Formula Homework]
We have some home work folks! Today, lets test your Excel formula skills by giving some data related to a fund.
The problem:
You manage a fund for a non-profit. You have donors who pledge certain amount at the start of the year. As you go thru the year, the donors donate money to your fund. At the end of the year, you have a table like above. And you need to summarize the fund’s performance by calculating various statistics.
Go
How to create a Win-Loss Chart in Excel? [Tutorial & Template]
Win Loss Charts are an interesting way to show a range of outcomes. Lets say, you have data like this:
win, win, win, loss, loss, win, win, loss, loss, win
The Win Loss chart would look like this:
Today, we will learn, how to create Win Loss Charts in Excel.
We will learn how to create Win Loss charts using Conditional Formatting and using In-cell Charts.
10 Excel Formula Myths – Busted!
Many of us start using Excel to keep track of something. And along way, we realize that Excel has a powerful feature called formulas, using which we can automate a lot of things. BOOM! Before we realize, we are in the thick of VLOOKUPs and SUMIFs.
But, along way, we also pick up a few bad habits or believe a few myths. Today, lets bust 10 Excel formula myths that we hear often.
Read this post to learn what these myths and why you should not trust them.
Do you want to attend an Excel Workshop in Singapore? [Survey]
I have happy news for you.
Paramdeep (from Financial Modeling School) and I am going to organize an Excel Workshop in Singapore during first (or second) week of July.
We want to know if you are interested in this. So please take a few minutes and go thru this small post.
Who is this workshop for?
If you are a financial or business analyst, this workshop is for you. We will be discussing various Excel & Financial Modeling topics during the 12 hour workshop (spread across 2-3 days)
Switch Scenarios Dynamically using Slicers
Slicers are my new favorite feature in Excel. Introduced in Excel 2010, Slicers are like visual filters.
Now, we can use slicers creatively to make an interactive scenario manager in Excel, as you can see below. We will learn how to create this in Excel in today’s post.