Mastering Excel: Formula Tips and Tricks

Excel is all about formulas. Think through how to do a calculation once, make sure it is correct, then copy it to other cells and use it as many times as you need to. In this lesson, we go through some of the most popular (and few not so popular) formulas, we review their syntax, how to use them, and we will also learn some other non-formula tricks that will make our Excel files do all the work for us. Some formulas we review are common, some not so common but all of them are explained step-by-step with not technical jargon. Just plain English so everyone (even the math averse) can easily grasp the concepts. There is also a follow along workbook you can download so you can work through the formulas as you read the lesson. All images and exercises were created using Excel 2010 for Windows. Some exercises will appear different in prior versions. Some formulas are not available in Excel 2003.