Excel Formulas Simply Explained

Learn the basics of formulas in Excel: how to write and use them, using absolute and relative references, and using the fill handle with formulas.

Sponsored Links:

Related Topics

How to Show Formulas in Cells and Hide Formulas Completely in Excel 2013
If you are working on an Excel worksheet with a lot of formulas in it, it may become difficult to follow and keep track of all your formulas. Excel provides a simple way of displaying formulas in the cells in addition to the formula bar. This feature also displays the dependencies for each formula in the cells (when selected), so you can track the data being used in each calculation. Displaying formulas in cells helps you to find cells containing formulas and to quickly read through all your formulas and check for errors. You can also print the spreadsheet with the formulas in the cells to help check your work.


29 ways to save time with Excel formulas
Formulas are the bread and butter of Excel, and If you use Excel on a regular basis, I bet you're working with a lot of formulas. But getting formulas working properly is tricky, and too often a problem that seems simple ends up taking far too long. In this article, I share some good tips to save you time when working with formulas in Excel.


Excel 2007 Formulas
Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of a second-order differential equation.


Excel 2007 Formulas
The Excel 2007 formulas tab is for more advanced users. I am going to go through this section quickly, but remember if you have specific questions about using formulas please email me.
The 1st section is the Function Library. This section contains buttons that will help you with all of the different formulas Excel 2007 provides.


Excel 2007 Creating Simple Formulas
Excel can be used to calculate and analyze numerical information; however, you will need to know how to write formulas to maximize Excel's capabilities. A formula is an equation that performs a calculation using values in the worksheet. In this lesson you will learn how to create simple formulas using mathematical operators such as the addition, subtraction, multiplication, and division signs.


Excel 2010 Creating Simple Formulas
Excel can be used to calculate numerical information. In this lesson you will learn how to create simple formulas in Excel to add, subtract, multiply, and divide values in a workbook. Also, you will learn the various ways you can use cell references to make working with formulas easier and more efficient.


Excel Formulas Tutorial
Although many people use the term 'Excel Formulas' to refer to the Excel Built-In Functions, the term 'Excel Formula' actually encompasses a wider range of operations in Excel. Therefore on this site, when we use the term 'Excel Formulas' (or 'Excel Formulae'), we are generally referring to any combination of Excel Operators and/or Excel Functions. This may be as simple as a basic addition (eg. "=A1+B1"), or it could be a complex combination of Excel Operators and multiple nested Excel Functions.


Sumif Examples - Help for Excel functions and Formulas
The Sumif function in microsoft Excel is explained with examples and demonstrations, including a tutorial video.


Excel 2010: Types of Formulas and Guide to Create Formulas
The Excel 2010 Formulas is fantastic! It can do things for us like add numbers, calculate the number of hours worked, lookup a product price, create a label for a report, or tell us whether two accounts are in balance and so on.


Excel 2007 Creating Complex Formulas
Excel is a spreadsheet application and is intended to be used to calculate and analyze numerical information such as household budgets, company finances, inventory, and more. To do this, you need to understand formulas.
In this lesson, we’ll discuss complex formulas that use multiple mathematical operators, and that use absolute and relative references.


Formulas and Functions: Spreadsheet Formulas
This series of tips, tutorials, and articles covers how to create and use formulas and functions in Excel and other spreadsheet programs. The tutorials listed here include how to create formulas to carry out basic mathematical calculations as well as how to create more complex formulas - such as nesting functions and array formulas. Tutorials include step by step examples.


How to enter basic formulas and calculations
At its heart, Excel is a giant calculator. In fact, a simple way to think about Excel is to consider each cell in a worksheet like an individual calculator. An Excel spreadsheet has millions of cells, which means you have millions of individual calculators to work with. Not only that, but you can create formulas that link different cells together (e.g. add the value in this cell to the value in that cell). You can create formulas that link cells in different worksheets together. And you can even create formulas that link cells in different workbooks together.


Excel 2010 Creating Complex Formulas
In this lesson, you will learn how to write complex formulas in Excel following the order of operations. You will also learn about relative and absolute cell references and how to copy and fill formulas containing cell references.


Introducing Excel Formulas
This tutorial introduces formulas and helps you get up to speed with this important element.


Formulas in Excel
This tutorial will teaches you how to use Formulas in Excel.


Formulas (expressions) and Functions (predefined formulas)
Microsoft Excel Tutorial: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.


Show formulas
Ever want to see which formulas are being used in an excel documents? Well, now you can.


Forumulas and Functions
Even when you have written various formulas and functions yourself, coming back to them at a later date often requires that you follow cell references to try to figure out what the formulas are doing. It would be great if you could simply add to the end of your formula some text that wouldn't interfere with the result, but would give you the information you require at a later stage.


Array Formulas
In this lesson you can learn what are and how to use array formulas. The formula (or function) in itself is not an array or non-arrayed. You decide how the Excel formula is treated. Array is not so much a feature of the same formula, but rather the way that Excel interprets the formula specified. Acceptance of a formula using the key combination Ctrl + Shitf + Enter for Excel is the order for carrying it in an "array", having arrays passed as arguments and results obtained.


Using Advanced Counting and Adding Functions
Excel formulas can do a lot of really great things, from helping you get your finances together to helping manage your entire life. You might think of counting and adding formulas as relatively mundane compared to more advanced formulas that are out there, but having a good handle on these functions can help you save a lot of time when you need to collect information about the data in your spreadsheet.