Free Excel Formulas and Functions Online Tutorial
Back | Back To Start | Next
Formulas (Mathematical Operations)
- Formulas are entered into the Formula Bar.
- Formulas must begin with an equal sign "=".
Example - Suppose you wanted to add the total amount of money earned in a bake sale.
The formula =B3+B4+B5 means:
Add:
- B3 (Monday's earnings),
- B4 (Tuesday's earnings),
- B5 (Wednesday's earnings)
Basic Functions
Functions can be a faster way of doing mathematical operations than formulas.
Example - if you wanted to add the values of cells D1 through D10, you could type the formula "=D1+D2+D3+D4+D5+D6+D7+D8+D9+D10".
A shorter way would be to use the SUM function and simply type "=SUM(D1:D10)".
Two popular functions and examples are given in the table below:
| Function | Example | Description |
SUM |
=SUM(A1:100) |
finds the sum of cells A1 through A100 |
AVERAGE |
=AVERAGE(B1:B10) |
finds the average of cells B1 through B10 |
Links to other Excel Online Tutorials:
Excel Full Online tutorials - Excel full tutorial covering most of the functional and operational questions.
MS Excel Very big basic tutorial Tutorial - In this tutorial you get a look into all the required basics. From easy basics of a spreadsheet to charts and graphs.
MS Excel Microsoft Excel - Office 2000 / XP Tutorial - Tutorial covering excel basics including: opening excel, entering data, aligning text, ending a sum and using charts.
MS Excel Tutorials and Projects - Excel spreadsheet creation and projects to help you create your first spreadsheets.
MS Office Training Courseware - Microsoft Office basic programs training and tutorials courseware. Course contains MS Excel, MS Word, MS Access, MS PowerPoint, MS Project and Windows XP Fundamentals. All materials are available for free download.
Merging Cells in Excel - Making your worksheets more "readable" by merging cells.
The Best Chart Types - Choosing a Chart Type For Your Spreadsheet.
Excel Printing - All You Need to Know - How to print properly from excel questions and answers.
Excel Functions and Formulas - This excel tutorial is providing the basics about formulas and functions.
Suggested Reading
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
