Modeling Basics
COUNTA, COUNTIF, and COUNTIFS Tutorial
In this tutorial, I demonstrate the various ways you can count different cells. I use a simple example of a birthday party where each partygoer gets a goodie bag, a blue or pink plate based on whether they are a boy or a girl, and either a cupcake or ice cream for dessert. We use […]
VLOOKUP Tutorial
The VLOOKUP formula is one of the most widely used formulas, unfortunately, it is also one that can be challenging to learn. Have you ever had a data table, and were trying to match the data in that table to another table based on a shared criteria? If that sounds confusing, you are definitely not alone. […]
The Financial Modeling Process
First and foremost, thank you for visiting my website. I am happy to share all I have learned by using Microsoft Excel for nearly 20 years. I have found my knowledge of finance combined with my knowledge of Excel as a distinct competitive advantage in the work place. I hope you find the information I […]