How to Learn Microsoft Excel Formulas

by Andrew Smith

Microsoft Excel is a software program that allows users to create various types of spreadsheets. When using Excel, an individual can enter a formula into a grid instead of a value. This formula will then perform the calculations for you, saving you time while creating your document. Since there are numerous simple and complex Excel formulas, you can feel overwhelmed when using the program.

1

Log onto the University of South Dakota Excel tutorial. Scroll down the page and then click the "Formulas" link. Once you do, you will be able to read about the basics of using formulas in Excel. Click on the right arrow located on the page to get to the next lesson (each page is a new lesson). After the fifth page, you will begin to find specific Excel formulas.

2

Visit the Microsoft Office Excel "Examples of commonly used formulas" Web page. On this page, you will be able to learn Excel formulas by different types of formulas, such as "Date and Time," "Math" and "Financial." Click on one of the links located under the "Example" heading. After you click the link, you will find different formulas for the specific task that you selected on the previous page.

3

Go to the Excel Tip homepage. Click on the "By Category" tab and a list of options will appear. Click the "Excel Formula and Function" option and you will be taken to over a dozen different links. These links will allow you to locate Excel formulas by type, such as "Summing," "Counting" and Logical Formulas." Click on one of these links and you will find different formulas and tips on the next page.

4

Purchase "Get the Most Out of Excel Formulas & Functions: The Ultimate Excel Formulas & Functions Help Guide." This book contains hundreds of different solutions individuals wanting to learn Excel formulas. In this book, you will find formulas for calculating wages, taxes and much more. A CD also comes up with the book. This CD contains the formulas listed in the book as well as additional tips that can assist you in learning and using the Excel formulas.

About the Author

Andrew Smith has been a freelance writer since 2006, specializing in sports and technology. His work has appeared on various online sites. Smith has a Bachelor of Arts in political science from Pennsylvania State University.