Best Tutorials website
Latest tutorials

Advertisment

How to convert my PDF file to Excel spreadsheet?

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: 3710 | Rating star | by RaneeQ
MS Excel - Functions

Sum Function

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: 1461 | Rating star | by Adam
MS Excel - Functions

Average Function

Average Function

The average function finds the average of the specified data.


Views: 1444 | Rating star | by Marry
MS Excel - Functions

Max Function

Max Function

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


Views: 1507 | Rating star | by Troy
MS Excel - Functions

Min Function

Min Function

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


Views: 1491 | Rating star | by Tutorial
MS Excel - Functions

Count Function

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: 1509 | Rating star | by John
MS Excel - Functions

CountA Function

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: 1513 | Rating star | by Colin
MS Excel - Functions

IF Function

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: 1485 | Rating star | by Troy
MS Excel - Functions

PMT (loan stuff) Function

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: 1408 | Rating star | by Donald
MS Excel - Functions

SIN COS TAN etc. 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: 1414 | Rating star | by Brad
MS Excel - Functions

Function Wizard

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: 1488 | Rating star | by David
MS Excel - Functions

About Spreadsheets

About Spreadsheets

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


Views: 1182 | Rating star | by Steve
MS Excel - Functions

Select a random sample of rows in Excel

Select a random sample of rows in Excel

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


Views: 1435 | Rating star | by Source
MS Excel - Functions

Forumulas and 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: 1176 | Rating star 3 | by Sean
MS Excel - Functions

Address Data by Name

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: 1170 | Rating star | by Adam
MS Excel - Functions

Load an XML Document ito Excel

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: 1167 | Rating star | by Nick
MS Excel - Functions

Access SOAP Web Services from Excel

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: 1150 | Rating star | by Sean
MS Excel - Functions

Create Excel Spreadsheets Using Other Environments

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: 1133 | Rating star | by Sarah
MS Excel - Functions

Save To SpreadsheetML And Extracting Data

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: 1110 | Rating star | by Brad
MS Excel - Functions

Import Data Directly into Excel

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: 1149 | Rating star | by Slicer
MS Excel - Functions