Excel Basics Calculations Special Features
Format Cells Sum, Average, Countif Functions Charts (Graphs)
Worksheets Quick Functions Excel Sort
Edit Cells The IF Statement Excel Filter
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Sumif Function Pivot Table
The Fill Handle Excel Formulas Create a Drop Down List
Excel Keyboard Shortcuts First Aid
MS Office Training
Excel Training
Microsoft Word Training
PowerPoint Training
Excel Formulas Book
Office 2010 Books
Free Training Courses
A Full Excel Course

Math Games
Math Games
Rounding Games
Place Value

More Info
About
Guestbook

microsoft word training

Excel Formulas - Tutorial Videos with Examples
The very basics of formulas
Two simple examples
Using the fill handle with formulas
Understanding absolute and relative referencing
Simple examples with absolute referencing
       (calculating tax, and bank deposit interest)
Using cells from other worksheets inside a formula

More Excel videos are in the full course here.


What is a formula in Excel?

A formula is a way for you to make calculations based upon data written in the spreadsheet.

What’s best about formulas is that they are linked to the data in such a way that if the data changes, the formula gives an updated result, reflecting the change.

The fill handle is especially useful, as often you need to repeat the same formula many times. In such cases using the handle can be a great time saver.

One of the important parts of learning formulas is understanding the concepts of absolute referencing and relative referencing. Take the time to watch the video dealing with it, and the next one with simple examples demonstrating how it is been implemented in the formulas.

The data used in the formulas does not have to appear only in the same worksheet. You can use values from cells from other worksheets inside a formula. Actually every formula can use data from multiple worksheets.




math games