Excel 2013 Formulas & Functions

Sorted by:  

How to Control Formula Recalculation in Excel 2013

Normally, Excel 2013 recalculates your worksheet automatically as soon you change any entries, formulas, or names on which your formulas depend. This system works fine as long as the worksheet is not too [more…]

White-Out Errors with Conditional Formatting in Excel 2013

Instead of creating logical formulas in Excel 2013 to suppress the display of potential error values, you can use Conditional Formatting to deal with them. All you have to do is create a new conditional [more…]

Excel 2013's Formula-Auditing Tools

Excel 2013 offers some very effective formula-auditing tools for tracking down a cell that’s causing your error woes by tracing the relationships between the formulas in the cells of your worksheet. By [more…]

Error-Checking Options in Excel 2013

When you choose Error Checking Options from the alert options drop-down menu attached to a cell with an error value or click the Options button in the Error Checking dialog box, Excel 2013 opens the Formulas [more…]

Time Functions in Excel 2013

Excel 2013 offers far fewer Time functions when compared with the wide array of Date functions. Like the Date functions, however, the Time functions enable you to convert text entries representing times [more…]

Special Date Functions in Excel 2013

Excel 2013 includes other special Date functions in the Date and Time category in the Insert Function dialog box. These particular Date functions expand your abilities to do date calculations in the worksheet [more…]

How to Calculate the Present Value in Excel 2013

The PV (Present Value) function in Excel 2013 is found on the Financial button’s drop-down menu on the Ribbon’s Formulas tab (Alt+MI). The PV function returns the present value of an investment, which [more…]

How to Calculate the Net Present Value in Excel 2013

The Net Present Value (NPV) function in Excel 2013 calculates the net present value based on a series of cash flows. The syntax of this function is [more…]

How to Calculate the Future Value in Excel 2013

The Future Value (FV) function in Excel 2013 is found on the Financial button’s drop-down menu on the Ribbon’s Formulas tab (Alt+MI). The FV function calculates the future value of an investment. The syntax [more…]

How to Use the Database Functions in Excel 2013

Excel 2013 includes a number of database functions that you can use to calculate statistics, such as the total, average, maximum, minimum, and count in a particular field of the data list only when the [more…]

What Are Formulas in Excel?

Math. Excel 2013 is really good at it, and it’s what makes Excel more than just data storage. Even if you hated math in school, you might still like Excel because it does the math for you. [more…]

How to Write Formulas in Excel 2013

Excel formulas can do everything that a basic calculator can do, so if you’re in a hurry and don’t want to pull up the Windows Calculator application, you can enter a formula in Excel to get a quick result [more…]

Move and Copy Formulas in Excel 2013

In Excel 2013 you can move and copy text and numbers between cells, but when it comes to copying formulas, beware of a few gotchas. The following sections explain relative and absolute referencing in formulas [more…]

What Are Functions in Excel 2013?

Sometimes, as you’re working in an Excel 2013 spreadhseet, it’s awkward or lengthy to write a formula to perform a calculation. For example, suppose you want to sum the values in cells A1 through A10. [more…]

How to Use Functions in Excel 2013

Functions in Excel 2013 perform complex math operations on cell content. Here is how you can insert a function in a cell, and a list of some common, useful functions. [more…]

Quick Tips for Using Formulas in Excel 2013

If you need your Excel 2013 spreadsheets to include mathematical calculations, you can use any number of Excel formulas. Excel formulas can do everything that a basic calculator can do, so check out these [more…]

Excel Dashboards and Reports: The VLOOKUP Function

Building cool Excel dashboard components won’t do you any good if you can’t effectively manage your data models. The VLOOKUP function is the king of all lookup functions in Excel. The purpose of VLOOKUP [more…]

Excel Dashboards and Reports: List Box Example

One of the more useful ways to use a list box in your Excel dashboards and reports is to control multiple charts with one selector. The following figure illustrates an example of this. As a region selection [more…]

Creating and Editing Excel Formulas

An Excel spreadsheet is simply a collection of cells that you can use to enter data. Each cell is given a name based on its position in the spreadsheet. The top-leftmost cell is called cell A1. It’s the [more…]

Formula Operators in Excel

You can use symbols known as operators to define the operation your Excel formula will accomplish. Some of these operators are mathematical operators that simply add, subtract, and multiply. Other operators [more…]

The Order of Operator Precedence in Excel Formulas

It’s important to understand that when you create a formula with several operators, Excel evaluates and performs the calculation in a specific order. For instance, Excel always performs multiplication [more…]

Using Nested Parentheses in Excel Formulas

It’s a best practice to use parentheses whenever you can in Excel formulas, even if the use of parentheses seem to be superfluous. The liberal use of parentheses can not only help you avoid calculation [more…]

Relative versus Absolute Excel Cell References

Imagine that you go to C1 in an Excel worksheet and enter the formula =A1+B1. Your human eyes will define that as the value in A1 added to the value in B1. [more…]

Using External Cell References in Excel

You may find that you have data in one Excel workbook that you want to reference in a formula within another workbook. In such a situation, you can create a link between the workbooks using an external [more…]

Excel Formula Calculation Modes

By default, Excel is set to recalculate automatically. If you change any of the cells referenced in a particular formula, Excel automatically recalculates that formula so that it returns a correct result [more…]


Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com