Explore BrainMass

Basic Formulas in Excel 2010

37 Pages | 4,912 Words
Aaron Barbee, MBA (#105647)

This book provides an introductory look at formulas in Excel 2010, including different methods for inserting or inputting formulas into your workbook. Microsoft often provides various methods for each process or function; formulas are no different. For each process discussed, there are often other ways to achieve the same result. Readers will then have the opportunity to decide which method works best for their learning style.

This eBook is aimed at high school or college students who are not very familiar with the program but are facing the fact that they need to use Excel 2010 for a class. If they have used it before, it was quite some time ago and they need help beyond just the basics of getting around in Excel.

An Introduction to Basic Formulas in Excel 2010

Formulas are the core of Excel 2010. Without it, the workbook would essentially be a piece of electronic graph paper. Users would be left with a well-organized system of columns and rows with which to enter text or be forced to manually calculate results (based on data) outside of Excel.

Plus, for users new to Excel, it can seem intimidating at first. A quick visit to the Formulas tab in the ribbon reveals dozens of very complex formulas that are readily available. This eBook hopes to ease those concerns by tackling the concept of Excel formulas from a basic standpoint, eventually leaving the door open for a more advanced look in future eBooks.

While several functions performed by Excel can be executed on a calculator, having the ability to adjust your formula in Excel, maybe to account for different factors or scenarios, allows users more flexibility and efficiency. For example, calculating a monthly payment for a car loan/note could easily be performed on a calculator. But, the convenience of seeing the results on-screen in Excel allows for its users to truly analyze the different factors that impact that final payment amount.

About the Author

Aaron Barbee, MBA

Active since Feb 2007

Aaron has been in the education and training field since 2004 starting with computer, business, and career development classes at the college level. After having taught every program in the Microsoft Office XP and 2003 suites, and even teaching some Customer Service and Interpersonal Communications classes, he moved on to an international law firm where he continues to provide technical and soft-skills training and development for over 1,000 attorneys, paralegals and other support staff. Aaron is extremely upbeat and strives to find the positive in everything in life.

Aaron's BrainMass Profile