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.
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.