Advertisment

How to convert my PDF file to Excel spreadsheet?

Convert PDF to Excel is so easy now! You don't need to copy and paste from PDF to Excel for further calculation work. This tutorial will teach...

Views: 3695 | | by RaneeQ
MS Excel - Functions

Sum Function

Probably the most popular function in any spreadsheet is the SUM function. The Sum function takes all of the values in each of the specified cells...

Views: 1452 | | by Adam
MS Excel - Functions

Average Function

The average function finds the average of the specified data.

Views: 1432 | | by Marry
MS Excel - Functions

Max Function

The MAX function in Excel will return the largest (max) value in the selected range of cells.

Views: 1487 | | by Troy
MS Excel - Functions

Min Function

The MIN function in Excel will return the smallest (Min) value in the selected range of cells.

Views: 1480 | | by Tutorial
MS Excel - Functions

Count Function

The Count function in Excel will return the number of entries (actually counts each cell that contains number data) in the selected range of cells.

Views: 1498 | | by John
MS Excel - Functions

CountA Function

The CountA function in Excel will return the number of entries (actually counts each cell that contains number data OR text data) in the selected...

Views: 1504 | | by Colin
MS Excel - Functions

IF Function

The IF function will check the logical condition of a statement and return one value if true and a different value if false.

Views: 1475 | | by Troy
MS Excel - Functions

PMT (loan stuff) Function

The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used...

Views: 1397 | | by Donald
MS Excel - Functions

SIN COS TAN etc. Functions

Excel has most of the math and trig functions built into it. If you need to use the SIN, COS, TAN functions, they can be typed into any cell.

Views: 1403 | | by Brad
MS Excel - Functions

Function Wizard

In Excel there is a help tool for functions called the Function Wizard. Learn how to easily use functions with the function wizard.

Views: 1477 | | by David
MS Excel - Functions

About Spreadsheets

This Excel tutorial shows you step-by-step how to use AutoFill to fill in common sequences, number patterns, and formulas.

Views: 1170 | | by Steve
MS Excel - Functions

Select a random sample of rows in Excel

Use the excel random number generator to get random sample data from a spreadsheet.

Views: 1424 | | by Source
MS Excel - Functions

Forumulas and Functions

Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of...

Views: 1165 | | by Sean
MS Excel - Functions

Address Data by Name

Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity,...

Views: 1159 | | by Adam
MS Excel - Functions

Load an XML Document ito Excel

If XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into...

Views: 1155 | | by Nick
MS Excel - Functions

Access SOAP Web Services from Excel

If your spreadsheet needs to access constantly updated data, or if you need to access services hosted on another computer, Excel's Web...

Views: 1138 | | by Sean
MS Excel - Functions

Create Excel Spreadsheets Using Other Environments

Although Excel and other spreadsheet programs are the traditional interfaces for creating and reading spreadsheets, sometimes you might need to...

Views: 1121 | | by Sarah
MS Excel - Functions

Save To SpreadsheetML And Extracting Data

Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with...

Views: 1098 | | by Brad
MS Excel - Functions

Import Data Directly into Excel

This tutorial relies on Excel's ability to perform web queries, so you'll need Excel 97 or higher. Excel's Web Queries tool...

Views: 1137 | | by Slicer
MS Excel - Functions