A Beginners Guide To Formulas In Excel
32705
Computers > Software
May 23, 2007
microsofttraining
A Beginners Guide To Formulas In Excel
One of the most useful tools in Microsoft Excel is the capability to apply formulas to the data within your spreadsheet. This tool is also one of the least understood. Just a little excel software training will help you to understand some of the basic functions available, allowing you to produce useful models and perform some complex calculations. How does a formula work? Formulas are equations that will perform calculations on the values you have entered into your spreadsheet. A formula in Excel will always begin with a equals sign, this tells Excel that the characters following it constitute a formula. Following the equals sign are the elements of a calculation separated by calculation operators. A formula may contain any or all of the following, functions, references, constants and operators. An example of a simple formula is given below; =PI()*(C6+5) The above example contains each of these elements. We will now consider the role of each of these to understand how the formula works. Functions Functions are predefined formulas that perform calculations by using specific values in a particular order or structure. A function begins with an equals sign followed by the function name, an opening bracket, the arguments for the function separated by commas and then a closing bracket. For example, the PI() function returns the value of pi i.e. 3.142. Operators An operator is a sign or symbol that specifies the type of calculation that you want to perform on the elements of the formula. Operators may be of four types, mathematical e.g. * (multiplication sign), comparison e.g. greater than, logical e.g. & (and) and reference e.g. : (colon). References A reference identifies a cell or range of cells in a worksheet and tells Excel where to look for the data you want to use in the formula. You can refer to cells within the worksheet, in other sheets in the same workbook and even to other workbooks. For example, the reference A2 would return the value in the cell A2. Constants A constant is a value that is not calculated and therefore does not change, for example the date 3/10/06 or the number 105. If you use constant values in a formula instead of references to cells the result will only change if you modify the formula yourself. Formulas calculate values in a specific order. Excel calculates the formula from left to right. If you combine more than one operator in a formula, for example both a multiplication and plus operator, you may want to specify the order in which these operations is completed. This is done by adding brackets around the part of the formula which is to be calculated first. An example formula We can now return to our original formula and look again at the elements within it. =PI()*(C6+5) PI() = a function that will return the value of PI (3.142) * = the mathematical operator for multiplication C6 = a reference which will look up the value in cell C6 + = the mathematical operator for addition 5 = a constant value If the value in cell C6 is 10 then this formula will first add 10 to 5, and then multiply the resultant (15) by 3.142 to return the value 47.12. The above provides just a very simple example to provide a basic overview of the way formulas work. There are numerous other functions and operators that can be applied together with many ways of referencing data. By undertaking some basic excel training you can quickly gain the knowledge to put all these functions to use and get Excel to do the hard work for you.
Author is a trainer with a Microsoft Office training company, the UK industry leader in its sector. For more information on Excel training, visit http://www.MicrosoftTraining.net.
send email to microsofttraining
Write a Review
Add to My Favorite
Refer it to Friend
Report Article
Other links owned by this user
We've all seen them... blinking, flashing, clip-art ridden PowerPoint presentations that look as if they belong on the marquis of a club several streets off the main strip in Vegas. On the other hand, there are PowerPoint presentations so plain that it wo
Category:
One of the most useful tools in Microsoft Excel is the capability to apply formulas to the data within your spreadsheet. This tool is also one of the least understood. Just a little excel software training will help you to understand some of the basic fun
Category:
It seems to me that project management is all about expertly juggling lots of different balls whilst taking care to catch them all at the right time. Consequently, it appears logical that great benefits will come from using a tool that can aid this juggli
Category:
Just take a moment if you will, to imagine being a contestant on a popular quiz show. I am sure you would feel quite confident if the first question to appear on your screen asked you to explain what is Microsoft Excel?.
Category:
At some time or other in our lives we are likely to set ourselves personal goals, whether it is a New Year's resolution to get fit or a wish to gain a promotion and a pay rise. Regardless of our choice of target, a plan of action must be put in place to h
Category:
It's difficult to remember a time when the workplace was not dominated by the desktop computer. With 90% of the world's computers now installed with Microsoft Office many employers require at least a basic familiarity with this suite of software packages.
Category:
Microsoft Excel is a spreadsheet creation and analysis tool that gives you the tools you need to manage critical business data and the power to get the most out of your information. Excel provides you with the tools to easily access, process, analyse, sha
Category:
You finish Microsoft Access database training and head back to work, confident you can create powerful databases that will make your job easier. You quickly discover that the workplace is not the classroom and things aren't as easy as when the instructor
Category:
Microsoft Excel spreadsheets are an indispensable tool for accountants, being widely used to create financial statements as well as to produce many other types of financial reports including budgets, forecasts, cash flow and financial models.
Category:
Studies have shown that companies that implement a Microsoft Office Specialist (MOS) certification program see wide ranging benefits. Employees have the training to improve their productivity and are made to feel valuable with a company-financed professio
Category:
Editing a document can be a time consuming, laborious task. Microsoft Word has a large array of editing features which can speed up and simplify this process. A few examples of these, with tips on how to use them, are given below.
Category:
Looking after domestic finances can cause much anxiety. Often you are anxious because you find it difficult to keep track of your finances and so do not feel you are in control. Using Microsoft Excel to record, monitor and control your domestic finances c
Category:
13. Best Training Expands Support Forum to Handle Influx of Confusion Following Office 2007's Release
Microsoft Training company offers support forum to the public to handle the sudden wave of questions following the release of Office 2007. The once paid-members only support forum is now free to all internet users who seek answers from Microsoft Training
Category:
Most Microsoft Word users spend over an hour a week completing tasks that could be accomplished virtually instantly by applying tools which are built into Word. This is either because they do not know that these tools exist or they have had no training in
Category:
Studies have shown that a clearly defined business plan can be the difference between success and failure for all businesses, regardless of size or history. Creating and managing a plan can be a difficult endeavor even for experienced managers.
Category:
With a new baby on the way life can feel very full. From birth announcements and a photo-based Website about your new arrival to growth charts and christening invitations, Microsoft Office can help make everything run smoothly.
Category:
Other links at Computers > Software
Microsoft Excel offers extremely powerful numerical and statistical data manipulation. However, such a powerful program can seem a little intimidating when all you need are some simple statistical results.
Category:
Backup is important and it is usually ignored. It is ignored until some malware wipes out a critical document, a power surge burns the PC, or you look away for a minute at the airport and find your laptop is missing. Let's look at what you can do to
Category:
It is true a new computer should out perform an older model by a wide margin. However, even the newest, right off the assembly line, Dual Core P4 will slow down very quickly if some essential steps are not taken!
Category:
With the growing amount of internet hackers popping up all over the world, it is getting much harder to keep your private life private, especially over the internet.
Category:
There was a time in the not so far away over when video image editing was a wholly professional field. Then home movie editing made its appearance, but still it remained something which only older folk could do.
Category:
Site Sponsor
Directory Statistics
Articles: 68252
Categories: 501
Yahoo Entertainment
