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

Basics of a Spreadsheet

Basics of a Spreadsheet

Understand what a spreadsheet is, and what parts make it up.


Views: 1523 | Rating star | by Colin
MS Excel - Basics

Types of Data

Types of Data

In a spreadsheet there are three basic types of data that can be entered.


Views: 1435 | Rating star | by Stephen
MS Excel - Basics

Formulas in Excel

Formulas in Excel

Formulas are entries that have an equation that calculates the value to display. We DO NOT type in the numbers we are looking for; we type in the...


Views: 1360 | Rating star | by Mark
MS Excel - Basics

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

Average Function

Average Function

The average function finds the average of the specified data.


Views: 1449 | 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: 1518 | 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: 1500 | 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: 1516 | 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: 1520 | 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: 1492 | 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: 1412 | 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: 1417 | 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: 1494 | Rating star | by David
MS Excel - Functions

Copy Forumulas: Fill Down

Copy Forumulas: Fill Down

Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is...


Views: 1414 | Rating star | by Slicer
MS Excel - Basics

Copy Forumulas: Absolute Positioning

Copy Forumulas: Absolute Positioning

Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the...


Views: 1444 | Rating star | by Jason
MS Excel - Basics

Copy Forumulas: Fill Right

Copy Forumulas: Fill Right

We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu -- Fill and Right.


Views: 1347 | Rating star | by Mark
MS Excel - Basics

Formatting Text

Formatting Text

Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the...


Views: 1420 | Rating star | by Mathew
MS Excel - Formatting

Formatting Numbers

Formatting Numbers

We often need to format the numbers to display the appropriate number of decimals, dollar signs, percentage, red (for negative dollars), etc. It is...


Views: 1342 | Rating star | by Amy
MS Excel - Formatting

Column Width

Column Width

A question that everyone (who has ever worked on a spreadsheet) has asked at one time or another is, 'Where did all my numbers go?' or...


Views: 1448 | Rating star | by Simon
MS Excel - Formatting