Modeling Basics
COUNTA, COUNTIF, and COUNTIFS Tutorial
![COUNTA, COUNTIF, and COUNTIFS Tutorial COUNTA, COUNTIF, and COUNTIFS Tutorial](http://www.financialmodelinginexcel.com/wp-content/uploads/2016/06/Count-Countif-Countifs-Slide-300x200.jpg)
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
![VLOOKUP Tutorial VLOOKUP Tutorial](http://www.financialmodelinginexcel.com/wp-content/uploads/2016/05/Cover-Slide-300x200.jpg)
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
![The Financial Modeling Process The Financial Modeling Process](http://www.financialmodelinginexcel.com/wp-content/uploads/2015/10/Financial-Modeling-Process-300x229.png)
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 […]