
EXCEL FORMULAS
Download the associated Workbook for this lesson
In this lesson we will Start to take a look at what Excel does best and that is; work with formulas.
There aren’t too many spreadsheets about that do not contain formulas of some kind. Excel is regarded by many (including myself) as the number one spreadsheet package in the world today. In fact it has held this title for many years now and not without good reason. Once you become proficient in using Excel and become familiar with its capabilities, you too will no doubt wonder how you ever got by without it!
In this lesson we will look only at what I consider the bare minimum you should know about Excel and formulas. Once we have covered this we can move on to slightly more complex formulas and functions. You may or may not have heard the terms; formulas and functions used in reference to Excel before and wondered what’s the difference? The truth is they are more often than not used out of context. This is no doubt because the difference is quite subtle, though simple. Functions
Excel has over 300 builtin Functions installed by default (there are more, but 300 will do for now) which are divided into ten separate categories:
 Financial
 Date & Time
 Math & Trig
 Statistical
 Lookup & Reference
 Database
 Text
 Logical
 Information
 Engineering
Possibly two of the most popular Functions (and easiest to use) are the SUM , which is categorized under Math & Trig and the COUNT. The SUM function simply adds together numbers and returns the total sum of the numbers. The COUNT simply counts numbers in any given range of cells. So a Function is a single predefined formula that is built into Excel. Formulas
Once we have used one of Excels functions on a Worksheet we have created a formula. As we become more confident in using Excel we can Start to join functions together to create different formulas. For example we might use the SUM and the COUNT function together in the same cell to create what would then become a formula.
So in a nutshell we can use a Function or Functions to create what then becomes a Formula.
Formula and Function Rules
There are only two rules when using functions to create formulas in Excel and these are:
Don’t confuse point 2 as meaning all formulas must have open and closing parenthesis, as this not always true. What is does mean is, all of Excels builtin Functions use at least one set of open and closing parenthesis. These are the two rules that we must adhere to.
There is also a valuable tip that is good practice to get into also and that is that whenever you type in a function name, always type it in lower case. The reason for this is that if you have spelt the Function name correctly, Excel will automatically convert it to uppercase. Therefore you can use it as an error checking tool.
Go To Free Excel Training Lesson 16 . Back to Previous Lesson
Go to Excel Basic/Level 1 Training Index
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages  Trading In Excel  Construction Estimators  Finance Templates & Addins Bundle  CodeVBA  SmartVBA  PrintVBA  Excel Data Manipulation & Analysis  Convert MS Office Applications To......  Analyzer Excel  Downloader Excel
 MSSQL Migration
Toolkit 
Monte Carlo Addin 
Excel
Costing Templates