This is a sample fictional budget to demonstrate how to use the format cell function, auto sum and simple equations in Excel. I demonstrate how to calculate a budget of monthly bills and extend the calculation to determine the cost of bills per year.

Download Microsoft Excel Now

These are standard formulas and functions everyone should know to make using Excel more efficient.

Tutorial was done in Excel 2010 but alternative options were shown for previous versions of Excel.

Video created using Cam Studio (

Learn Everything There is to Know About Microsoft Excel