Using Excel 2013 Functions

View:  
Sorted by:  

Excel Functions You're Likely to Use

Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference [more…]

Excel Text Functions You'll Find Helpful

Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description [more…]

How to Enter a Formula Using Cell Names in Excel 2013

Cell names are a great way to make out the purpose of your formulas in Excel 2013. For example, suppose that you have a simple formula in cell K3 that calculates the total due to you by multiplying the [more…]

How to Create a Constant Formula in Excel 2013

Certain formulas in Excel 2013 use constant values, such as an 8.25% tax rate or a 10% discount rate. If you don’t want to have to enter these constants into a cell of the worksheet in order to use the [more…]

How to Describe a Custom Excel 2013 Function

To help your user understand the purpose of your custom functions in Excel 2013, you can add descriptions that appear in Insert Function and Function Arguments dialog boxes that help explain what the function [more…]

The PMT Function in Excel 2013

The Excel 2013 PMT function on the Financial button’s drop-down menu on the Formulas tab of the Ribbon calculates the periodic payment for an annuity, assuming a stream of equal payments and a constant [more…]

Analysis ToolPak Add-In Financial Functions

By activating the Analysis ToolPak add-in with Excel 2013, you add a whole bunch of powerful financial functions to the Financial button’s drop-down menu on the Formulas tab of the Ribbon. The table shows [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…]

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…]

Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com