Spreadsheets: Most Popular Articles
These articles are the most popular over the last month.
Excel Formulas
This tutorial is intended for those just getting started with Excel. This tutorial covers basic information about formulas and walks you through creating a simple example in Excel.
This tutorial is intended for those just getting started with Excel. This tutorial covers basic information about formulas and walks you through creating a simple example in Excel.
Excel VLOOKUP
Excel’s VLOOKUP function is used to find specific information that has been stored in a table of data in a spreadsheet. This tutorial includes a step by step example of how to use VLOOKUP in Excel.
Excel’s VLOOKUP function is used to find specific information that has been stored in a table of data in a spreadsheet. This tutorial includes a step by step example of how to use VLOOKUP in Excel.
Excel Drop Down List
A drop down list can make data entry easier or limit what data can be added to a worksheet. This tutorial shows you how to create a drop down list in Excel using data located on a separate worksheet.
A drop down list can make data entry easier or limit what data can be added to a worksheet. This tutorial shows you how to create a drop down list in Excel using data located on a separate worksheet.
How to Use Excel
How to Use Excel is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and removing columns and rows, how to create charts, and how to use Excel's format options including autoformat.
How to Use Excel is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and removing columns and rows, how to create charts, and how to use Excel's format options including autoformat.
Excel Line Graph
This tutorial covers how to create a line graph in Microsoft Excel . The tutorial includes a step by step example of how to create a line graph in Excel.
This tutorial covers how to create a line graph in Microsoft Excel . The tutorial includes a step by step example of how to create a line graph in Excel.
Subtract Excel
How to subtract in Excel shows you how easy subtracting numbers in Excel can be. The tutorial includes a step by step example of how to subtract two numbers in Excel.
How to subtract in Excel shows you how easy subtracting numbers in Excel can be. The tutorial includes a step by step example of how to subtract two numbers in Excel.
Excel Sum Function
The Excel SUM function makes it easy to quickly sum columns, rows, or individual cells of data in a worksheet.
The Excel SUM function makes it easy to quickly sum columns, rows, or individual cells of data in a worksheet.
Multiply Excel
How to multiply in Excel shows you how easy multiplying numbers in Excel can be. The tutorial includes a step by step example of how to multiply two numbers in Excel.
How to multiply in Excel shows you how easy multiplying numbers in Excel can be. The tutorial includes a step by step example of how to multiply two numbers in Excel.
Excel Data Validation Step by Step Tutorial
Excel's data validation options include creating a drop down list for data entry. This tutorial includes a step by step example of using Excel's data validation options to create a drop down list.
Excel's data validation options include creating a drop down list for data entry. This tutorial includes a step by step example of using Excel's data validation options to create a drop down list.
Unhide Columns
This article shows you how, with a click of the mouse, you can easily unhide columns in Excel spreadsheets.
This article shows you how, with a click of the mouse, you can easily unhide columns in Excel spreadsheets.
Add Excel
How to add in Excel shows you how easy adding numbers in Excel can be. The tutorial includes a step by step example of how to add two numbers in Excel.
How to add in Excel shows you how easy adding numbers in Excel can be. The tutorial includes a step by step example of how to add two numbers in Excel.
Excel Freeze Panes
Excel Freeze Panes Overview Related tutorial: Freeze Panes in Excel 2003 . When working with very large
Excel Freeze Panes Overview Related tutorial: Freeze Panes in Excel 2003 . When working with very large
Divide Excel
How to divide in Excel shows you how easy it is to dividing numbers in Excel can be. The tutorial includes a step by step example of how to divide two numbers in Excel.
How to divide in Excel shows you how easy it is to dividing numbers in Excel can be. The tutorial includes a step by step example of how to divide two numbers in Excel.
Excel IF Function
The IF function allows for decision making in Excel. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met. This tutorial includes a step by step example of using the IF function in Excel
The IF function allows for decision making in Excel. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met. This tutorial includes a step by step example of using the IF function in Excel
Excel CONCATENATE
The CONCATENATE function is used to join two or more words or text strings together. This tutorial includes a step by step example of using Excel's CONCATENATE function.
The CONCATENATE function is used to join two or more words or text strings together. This tutorial includes a step by step example of using Excel's CONCATENATE function.
Excel 2007 Pivot Table
Pivot tables makes it easy to organize and extract information from a large tables of data without the use of formulas in Excel. A step by step tutorial example is included in the tutorial.
Pivot tables makes it easy to organize and extract information from a large tables of data without the use of formulas in Excel. A step by step tutorial example is included in the tutorial.
Show Formulas
Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.
Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.
Excel Pie Chart Tutorial
This tutorial covers creating a pie chart (pie graph) in Microsoft Excel. The tutorial includes a step by step example of creating a pie chart in Excel.
This tutorial covers creating a pie chart (pie graph) in Microsoft Excel. The tutorial includes a step by step example of creating a pie chart in Excel.
Excel 2007 Column Chart
This tutorial covers creating a column chart in Microsoft Excel 2007 / 2010. The tutorial includes a step by step example of creating a column chart in Excel.
This tutorial covers creating a column chart in Microsoft Excel 2007 / 2010. The tutorial includes a step by step example of creating a column chart in Excel.
Excel Date Page Pt3
The tutorials listed here cover Excel functions that will count the number of days between two dates. Each tutorial includes a step by step example of using the functions.
The tutorials listed here cover Excel functions that will count the number of days between two dates. Each tutorial includes a step by step example of using the functions.
excel-2010-remove-duplicates-Pt-1
This tutorial shows you how to remove rows or records of duplicate data in Excel. The tutorial includes a step by step example of how to remove duplicates in Excel.
This tutorial shows you how to remove rows or records of duplicate data in Excel. The tutorial includes a step by step example of how to remove duplicates in Excel.
Excel 2010 Mid Function
Excel's MID function can be used to extract a substring from a text string containing unwanted characters. This tutorial includes a step by step example of using Excel's MID function to extract a substring from a string containing unwanted characters.
Excel's MID function can be used to extract a substring from a text string containing unwanted characters. This tutorial includes a step by step example of using Excel's MID function to extract a substring from a string containing unwanted characters.
Excel Macro
This step by step tutorial covers how to create simple macros in Excel using the macro recorder.
This step by step tutorial covers how to create simple macros in Excel using the macro recorder.
Excel AVERAGE
Excel's AVERAGE function can be used to find the average value, or arithmetic mean, of values in a selected range of cells.
Excel's AVERAGE function can be used to find the average value, or arithmetic mean, of values in a selected range of cells.
Date Functions Excel
There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This tutorial covers the most common date functions used in Excel.
There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This tutorial covers the most common date functions used in Excel.
Flowchart Template
Among the flow chart templates offered for free by Microsoft is one for creating simple flow charts in Excel. This flow chart template works in all versions from Excel 97 on. A flow chart is a graphical representation of a process. This tutorial walks through how to download and use the flowchart template from Microsoft.
Among the flow chart templates offered for free by Microsoft is one for creating simple flow charts in Excel. This flow chart template works in all versions from Excel 97 on. A flow chart is a graphical representation of a process. This tutorial walks through how to download and use the flowchart template from Microsoft.
Nested IF
Related Tutorial: - Excel Nested IF Function Step by Step Tutorial What the IF function does The IF function
Related Tutorial: - Excel Nested IF Function Step by Step Tutorial What the IF function does The IF function
Basic Excel 2007 / 2010 Tutorial Pt 1
This tutorial covers creating basic spreadsheet formulas in Excel. The topics covered include how to enter data, add rows and creating and using formulas and functions.
This tutorial covers creating basic spreadsheet formulas in Excel. The topics covered include how to enter data, add rows and creating and using formulas and functions.
Excel 2003 OR Function
This article shows you how to use the OR function in Excel. The article includes a step by step example on using the OR function.
This article shows you how to use the OR function in Excel. The article includes a step by step example on using the OR function.
Excel Chart Tutorial
This Excel Chart Tutorial covers creating charts in Microsoft Excel. This tutorial covers all the steps necessary for creating a chart using the Chart Wizard. The tutorial begins by discussing the best practices for entering the chart data and then walks you through each of the four screens of the Chart Wizard.
This Excel Chart Tutorial covers creating charts in Microsoft Excel. This tutorial covers all the steps necessary for creating a chart using the Chart Wizard. The tutorial begins by discussing the best practices for entering the chart data and then walks you through each of the four screens of the Chart Wizard.
Lookup with Multiple Criteria
How to create a Lookup formula that uses multiple criteria in Excel. This tutorial includes a step by step example of creating a lookup function with multiple criteria in Excel.
How to create a Lookup formula that uses multiple criteria in Excel. This tutorial includes a step by step example of creating a lookup function with multiple criteria in Excel.
Excel Duplicate Data
This tutorial shows you how find duplicate data - formulas, numbers, dates, data records - in Excel using conditional formatting. The tutorial includes a step by step example of using conditional formatting to find duplicates in Excel.
This tutorial shows you how find duplicate data - formulas, numbers, dates, data records - in Excel using conditional formatting. The tutorial includes a step by step example of using conditional formatting to find duplicates in Excel.
IF Functions
This series of articles and tutorials the basics of using IF functions to perform calculations in Excel.
This series of articles and tutorials the basics of using IF functions to perform calculations in Excel.
Excel Database
This step by step tutorial shows you how to create a database in Excel . The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.
This step by step tutorial shows you how to create a database in Excel . The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.
Excel 2007 STD DEV Function
The STANDARD DEVIATION function can be used to quickly calculate the standard deviation of a list of numbers. This tutorial includes a step by step example.
The STANDARD DEVIATION function can be used to quickly calculate the standard deviation of a list of numbers. This tutorial includes a step by step example.
Excel DATEDIF Function
The DATEDIF function, can be used to calculate the difference (the number of days, months, or years) between two dates in Excel. This tutorial includes a step by step example of using the DATEDIF function in Excel to calculate the difference between two dates in Excel.
The DATEDIF function, can be used to calculate the difference (the number of days, months, or years) between two dates in Excel. This tutorial includes a step by step example of using the DATEDIF function in Excel to calculate the difference between two dates in Excel.
Excel 2007 TODAY
The TODAY function can be used to add today's date to a spreadsheet. This tutorial includes a step by step example of using Excel's TODAY function.
The TODAY function can be used to add today's date to a spreadsheet. This tutorial includes a step by step example of using Excel's TODAY function.
Excel TRIM Function
This tutorial contains a step by step example of how to remove extra spaces from between words in Excel using the TRIM function.
This tutorial contains a step by step example of how to remove extra spaces from between words in Excel using the TRIM function.
excel-2010-drop-down-list-Pt 2
Excel's data validation options include creating a drop down list using data from another worksheet. This step by step tutorial covers creating a data validation list in Excel using data from another worksheet.
Excel's data validation options include creating a drop down list using data from another worksheet. This step by step tutorial covers creating a data validation list in Excel using data from another worksheet.
Excel SUMIF
The SUMIF function will total cells in a selected range that match user selected criteria. A step by step example is included in this tutorial.
The SUMIF function will total cells in a selected range that match user selected criteria. A step by step example is included in this tutorial.
What is Excel
What is Microsoft Excel? It is an electronic spreadsheet program used for storing, organizing and manipulating data. Excel uses formulas to perform mathematical calculations ranging from the simple to the very complex. The program can also be used for graphing data.
What is Microsoft Excel? It is an electronic spreadsheet program used for storing, organizing and manipulating data. Excel uses formulas to perform mathematical calculations ranging from the simple to the very complex. The program can also be used for graphing data.
Excel 2007 DropDown List Pt 2
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This tutorial shows you how to create a drop down list in Excel sing data from a different worksheet.
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This tutorial shows you how to create a drop down list in Excel sing data from a different worksheet.
Excel Header and Footer
Headers and footers are used to add the same information on every page of the spreadsheet without actually typing the information on each page. Headers and footers often contain company information as well as the date, time and filename of the spreadsheet.
Headers and footers are used to add the same information on every page of the spreadsheet without actually typing the information on each page. Headers and footers often contain company information as well as the date, time and filename of the spreadsheet.
Excel VALUE Function
How to convert text data to numbers in Excel using the VALUE function. This tutorial contains a step by step example of how to convert text data to numbers in Excel using the VALUE function.
How to convert text data to numbers in Excel using the VALUE function. This tutorial contains a step by step example of how to convert text data to numbers in Excel using the VALUE function.
Basic Excel 2007 Formula
An Excel 2007 formula is one of the most useful features of the program. Excel 2007 formulas can be as basic as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel 2007 does all the calculations for you.
An Excel 2007 formula is one of the most useful features of the program. Excel 2007 formulas can be as basic as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel 2007 does all the calculations for you.
Unhide Rows
This tutorial shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.
This tutorial shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.
Formulas - Functions
This series of Excel Tutorials will teach you the basics of using formulas and functions to perform basic calculations in Excel spreadsheets.
This series of Excel Tutorials will teach you the basics of using formulas and functions to perform basic calculations in Excel spreadsheets.
Excel Conditional Formatting
Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells based on the data entered into the cell(s). This tutorial includes an example of using conditional formatting to find above and below average values.
Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells based on the data entered into the cell(s). This tutorial includes an example of using conditional formatting to find above and below average values.
Ribbon
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel 2007. Definition of a ribbon in Excel 2007.
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel 2007. Definition of a ribbon in Excel 2007.
Nested AND-IF Functions
Note: These instructions will work for all versions of Excel from Excel 95 to Excel 2010. Related Tutorial:
Note: These instructions will work for all versions of Excel from Excel 95 to Excel 2010. Related Tutorial:
Worksheet
: A worksheet is a single page or sheet in a spreadsheet program such as Excel. By default, in Excel
: A worksheet is a single page or sheet in a spreadsheet program such as Excel. By default, in Excel
Excel 2010 Concatenate Function
Excel's CONCATENATE function can be used to combine cells of data together. This tutorial includes a step by step example of how to combine cells of data with the CONCATENATE function in Excel.
Excel's CONCATENATE function can be used to combine cells of data together. This tutorial includes a step by step example of how to combine cells of data with the CONCATENATE function in Excel.
Excel Math
These tutorial cover how to carry out basic math operations in Excel using formulas. The tutorials cover how to add, subtract, multiply, or divide numbers in Excel using formulas.
These tutorial cover how to carry out basic math operations in Excel using formulas. The tutorials cover how to add, subtract, multiply, or divide numbers in Excel using formulas.
Excel VLOOKUP How To
This tutorial is a text only version of how to use Excel's VLOOKUP function. It is intended for those familiar with Excel functions.
This tutorial is a text only version of how to use Excel's VLOOKUP function. It is intended for those familiar with Excel functions.
Excel 2007 IF Function
This tutorial covers how to create and use the IF function in Excel. This tutorial includes a step by step example of how to use Excel's IF function.
This tutorial covers how to create and use the IF function in Excel. This tutorial includes a step by step example of how to use Excel's IF function.
Excel 2007 Time Sheet Template
This article shows you how to quickly download and use a free employee time sheet template in Excel.
This article shows you how to quickly download and use a free employee time sheet template in Excel.
Excel 2007 ROUND
The ROUND function, one of Excel's math functions, is used to reduce a number to a specific number of decimal places. This tutorial includes a step by step example of using Excel's ROUND function.
The ROUND function, one of Excel's math functions, is used to reduce a number to a specific number of decimal places. This tutorial includes a step by step example of using Excel's ROUND function.
Absolute Cell Reference
: In Excel and other spreadsheets, an absolute cell reference identifies the location a cell or group
: In Excel and other spreadsheets, an absolute cell reference identifies the location a cell or group
Formula
: Formulas in spreadsheet programs such as Excel are used to perform calculations. Formulas can range
: Formulas in spreadsheet programs such as Excel are used to perform calculations. Formulas can range
Cell Reference
: Related Tutorial: Using Cell References in Excel Formulas In Excel, a cell reference identifies the
: Related Tutorial: Using Cell References in Excel Formulas In Excel, a cell reference identifies the
Data Entry in Excel
Learn how to enter data into an Excel spreadsheet. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.
Learn how to enter data into an Excel spreadsheet. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.
Spreadsheet
: A spreadsheet application is a computer program such as Excel, OpenOffice Calc, or Google Docs Spreadsheets.
: A spreadsheet application is a computer program such as Excel, OpenOffice Calc, or Google Docs Spreadsheets.
Subtract Dates in Excel
There are a number of functions in Excel that can be used to subtract dates. They can be used to subtract days, months, or years. The following tutorials include examples of subtracting two dates in Excel using the different date functions.
There are a number of functions in Excel that can be used to subtract dates. They can be used to subtract days, months, or years. The following tutorials include examples of subtracting two dates in Excel using the different date functions.
Excel REPLACE Function
The REPLACE function is used to replace unwanted characters with good data. The tutorial includes a step by step example.
The REPLACE function is used to replace unwanted characters with good data. The tutorial includes a step by step example.
Lock Cells in Excel
How to protect data in Excel part 1 - lock/unlock cells. This article includes a step by step example of how to lock cells in order to protect data in Excel 2007.
How to protect data in Excel part 1 - lock/unlock cells. This article includes a step by step example of how to lock cells in order to protect data in Excel 2007.
IF Function and Blank Cells
Excel's IF function can be used to leave cells blank when certain conditions are met. This tutorial includes a step by step example of how to leave blank cells in a worksheet using the IF function.
Excel's IF function can be used to leave cells blank when certain conditions are met. This tutorial includes a step by step example of how to leave blank cells in a worksheet using the IF function.
Convert Excel Files to PDF
Convert Excel files to PDF format in Excel 2010. This tutorial shows you how to convert Excel files to PDF format in Excel 2010.
Convert Excel files to PDF format in Excel 2010. This tutorial shows you how to convert Excel files to PDF format in Excel 2010.
Enter Data Using a Form
This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.
This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.
Excel 2010 COUNTIF Function
Excel's COUNTIF function is used to count up the number of times specific data is found in a selected group of cells. This tutorial includes a step by step example of using the COUNTIF function in Excel.
Excel's COUNTIF function is used to count up the number of times specific data is found in a selected group of cells. This tutorial includes a step by step example of using the COUNTIF function in Excel.
DATEDIF and Current Age
One use for the DATEDIF function is to calculate a person's current age in years, months, and days. This tutorial includes a step by step example of using the DATEDIF function to calculate current age.
One use for the DATEDIF function is to calculate a person's current age in years, months, and days. This tutorial includes a step by step example of using the DATEDIF function to calculate current age.
Excel Watermark Tutorial
This tutorial covers how to insert a watermark into an Excel worksheet. The tutorial includes a step by step example of how to insert a watermark in Excel.
This tutorial covers how to insert a watermark into an Excel worksheet. The tutorial includes a step by step example of how to insert a watermark in Excel.
Excel 2010 COUNTIF
Excel's COUNTIF function is used to count up the number of cells in a selected range that meet specified criteria. This tutorial includes a step by step example of using the COUNTIF function in Excel.
Excel's COUNTIF function is used to count up the number of cells in a selected range that meet specified criteria. This tutorial includes a step by step example of using the COUNTIF function in Excel.
Excel 2003 COUNTIF Multiple Criteria
This tutorial uses the SUMPRODUCT function to count up the number of cells in selected ranges that meet multiple criteria in Excel. It can be used in place of COUNTIFS which is not available in Excel 2003 and earlier versions.
This tutorial uses the SUMPRODUCT function to count up the number of cells in selected ranges that meet multiple criteria in Excel. It can be used in place of COUNTIFS which is not available in Excel 2003 and earlier versions.
Excel Goal Seek
Excel's Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can be used when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.
Excel's Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can be used when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.
Excel 2010 SUMIF Function
The SUMIF function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIF function in Excel.
The SUMIF function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIF function in Excel.
Excel VLOOKUP 2 Way Lookup Part 1
Excel’s VLOOKUP function can be used along with the MATCH function to create a two way lookup formula that finds data at the intersection point of a row and column of data. This tutorial includes includes a step by step example of creating a two way lookup formula using VLOOKUP.
Excel’s VLOOKUP function can be used along with the MATCH function to create a two way lookup formula that finds data at the intersection point of a row and column of data. This tutorial includes includes a step by step example of creating a two way lookup formula using VLOOKUP.
Create a Bar Graph
This tutorial covers creating a bar graph (or column chart in Microsoft Excel. This tutorial includes a step by step example of creating a bar graph in Excel.
This tutorial covers creating a bar graph (or column chart in Microsoft Excel. This tutorial includes a step by step example of creating a bar graph in Excel.
Excel Pivot Table
These tutorials cover how to create a pivot table in Excel. Each tutorial includes a step by step example of how to create a pivot table in Excel.
These tutorials cover how to create a pivot table in Excel. Each tutorial includes a step by step example of how to create a pivot table in Excel.
Excel NOW
Excel's NOW function can be used to add the current date and / or time to a worksheet. This tutorial includes a step by step example of how to add the current date and time to a worksheet using the NOW function
Excel's NOW function can be used to add the current date and / or time to a worksheet. This tutorial includes a step by step example of how to add the current date and time to a worksheet using the NOW function
Spreadsheets Terms: Function
: A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed
: A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed
Excel 2007 PMT
The PMT function, one of Excel's Financial functions, can be used to calculate loan repayments or the future value of an investment. This article covers using the PMT function in Excel 2007 to determine loan payments.
The PMT function, one of Excel's Financial functions, can be used to calculate loan repayments or the future value of an investment. This article covers using the PMT function in Excel 2007 to determine loan payments.
Excel DATEDIF Quick
The DATEDIF function can be used to calculate the number of days between dates. This tutorial includes a step by step example of using the DATEDIF function to calculate the number of days between two dates in Excel.
The DATEDIF function can be used to calculate the number of days between dates. This tutorial includes a step by step example of using the DATEDIF function to calculate the number of days between two dates in Excel.
Excel 2010 MATCH Function
The Excel MATCH function finds the position of specified data in a selected range of cells. A step by step example is included with this tutorial.
The Excel MATCH function finds the position of specified data in a selected range of cells. A step by step example is included with this tutorial.
Excel Random Numbers
Rather than getting any random number the RANDBETWEEN function lets you specify a range between two numbers it is to select from.
Rather than getting any random number the RANDBETWEEN function lets you specify a range between two numbers it is to select from.
Excel 2010 COUNTIFS Function
Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.
Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.
Excel COUNT Function
Excel's COUNT function can be used to count up the number of cells containing numbers in a selected range. This tutorial includes a step by step example of using the COUNT function in Excel
Excel's COUNT function can be used to count up the number of cells containing numbers in a selected range. This tutorial includes a step by step example of using the COUNT function in Excel
Excel Fill Down Command
This Excel tip covers using the Fill Down command in Excel using a keyboard shortcut.
This Excel tip covers using the Fill Down command in Excel using a keyboard shortcut.
Excel 2010 ROUNDUP Function
The ROUNDUP function in Excel will always round the last number up to the next highest digit. This tutorial includes a step by step example of using the ROUNDUP function in Excel.
The ROUNDUP function in Excel will always round the last number up to the next highest digit. This tutorial includes a step by step example of using the ROUNDUP function in Excel.
Excel Named Range
This quick tip shows you how to create a named range in Excel. A named range can be used to identify the cells used in charts, functions and formulas. Using named ranges is often easier to use than trying to identify the cell references needed for a formula.
This quick tip shows you how to create a named range in Excel. A named range can be used to identify the cells used in charts, functions and formulas. Using named ranges is often easier to use than trying to identify the cell references needed for a formula.
Excel 2003 COUNT Function
Excel's COUNT function allows you to count up the number of cells containing numbers in a selected range. This tutorial contains a step by step example.
Excel's COUNT function allows you to count up the number of cells containing numbers in a selected range. This tutorial contains a step by step example.
Excel 2007 Freeze Panes
Lock Columns and Rows in Excel 2003 with Freeze Panes Related tutorial: Excel 2007 / 2010 Freeze Panes
Lock Columns and Rows in Excel 2003 with Freeze Panes Related tutorial: Excel 2007 / 2010 Freeze Panes
Excel 2007 VLOOKUP
Excel’s VLOOKUP function can be used to find specific data that is stored in a table of data. This tutorial includes a step by step example of using Excel's VLOOKUP function.
Excel’s VLOOKUP function can be used to find specific data that is stored in a table of data. This tutorial includes a step by step example of using Excel's VLOOKUP function.
Drag Select
: A method used to select a range of cells. To do so, click on a cell with the left mouse button and,
: A method used to select a range of cells. To do so, click on a cell with the left mouse button and,
Timeline Template
Among the templates offered for free by Microsoft is one for creating a timeline in Excel. This template works in all versions from Excel 97 on. This article walks through how to download and use the timeline template in Excel.
Among the templates offered for free by Microsoft is one for creating a timeline in Excel. This template works in all versions from Excel 97 on. This article walks through how to download and use the timeline template in Excel.
IF Function Entering Text
Words or text statements can be used with Excel's IF function. This tutorial includes a step by step example of how to use the IF function to enter text into a worksheet.
Words or text statements can be used with Excel's IF function. This tutorial includes a step by step example of how to use the IF function to enter text into a worksheet.
Hide Columns
This tutorial shows you how, with a click of the mouse, you can easily hide columns in Excel.
This tutorial shows you how, with a click of the mouse, you can easily hide columns in Excel.
Calculate Weighted Average in Excel
This tutorial covers finding the weighted average for data using Excel's SUMPRODUCT function. A step by step example is included with the tutorial.
This tutorial covers finding the weighted average for data using Excel's SUMPRODUCT function. A step by step example is included with the tutorial.
Square Roots in Excel 2007
This article covers finding the square root of numbers in Excel. The article includes a step by step example of finding square roots in Excel.
This article covers finding the square root of numbers in Excel. The article includes a step by step example of finding square roots in Excel.
Excel 2010 COUNTIFS
The COUNTIFS function, similar to Excel's COUNTIF function, is used to count up the number of cells in selected ranges that meet multiple criterion. This tutorial contains a step by step example of using COUNTIFS in Excel.
The COUNTIFS function, similar to Excel's COUNTIF function, is used to count up the number of cells in selected ranges that meet multiple criterion. This tutorial contains a step by step example of using COUNTIFS in Excel.
Excel 2010 LEFT Function
Excel's LEFT function can be used to remove unwanted characters from imported data or truncate text data. This tutorial includes a step by step example of using Excel's LEFT function to truncate imported text data.
Excel's LEFT function can be used to remove unwanted characters from imported data or truncate text data. This tutorial includes a step by step example of using Excel's LEFT function to truncate imported text data.
Excel Tutorial hub
Each tutorial in this free series covers either an introductory or intermediate level topic in Microsoft Excel. The tutorials include step by step examples related to each topic.
Each tutorial in this free series covers either an introductory or intermediate level topic in Microsoft Excel. The tutorials include step by step examples related to each topic.
Free Excel Formatting Tutorial
This tutorial covers using a variety of format options including number, text, and worksheet formatting in Excel.
This tutorial covers using a variety of format options including number, text, and worksheet formatting in Excel.
Excel 2007 ROUNDUP
The ROUNDUP function, one of Excel's math functions, is used to round a number upwards towards the next highest number. This tutorial includes a step by step example of using Excel's ROUNDUP function.
The ROUNDUP function, one of Excel's math functions, is used to round a number upwards towards the next highest number. This tutorial includes a step by step example of using Excel's ROUNDUP function.
Basic Excel Tutorial
This tutorial covers creating a basic spreadsheet in Excel. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.
This tutorial covers creating a basic spreadsheet in Excel. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.
Excel Formulas Overview
This tutorial gives an overview of using formulas in Excel - how they work and tips on the best way to create one. The tutorial also contains links to step by step tutorials on creating formulas in Excel.
This tutorial gives an overview of using formulas in Excel - how they work and tips on the best way to create one. The tutorial also contains links to step by step tutorials on creating formulas in Excel.
Shortcut Keys Add the Current Date
This Excel shortcut keys tutorial shows you how to add the current date to a worksheet using a keyboard key combination.
This Excel shortcut keys tutorial shows you how to add the current date to a worksheet using a keyboard key combination.
Sort by Date in Excel
This tutorial covers how to sort by dates in Excel. A step by step example is included.
This tutorial covers how to sort by dates in Excel. A step by step example is included.
Excel 2007 Nested IF Function
A nested function refers to one function being placed inside another. This tutorial includes a step by step example of how to nest one IF function inside another in Excel.
A nested function refers to one function being placed inside another. This tutorial includes a step by step example of how to nest one IF function inside another in Excel.
Excel Sort By Cell Color
This tutorial uses a step by step example to show you how to sort data by cell color in Excel.
This tutorial uses a step by step example to show you how to sort data by cell color in Excel.
Excel 2007 TRANSPOSE
The TRANSPOSE function is used to transfer data located in a row into a column or data located in a column into a row. This tutorial includes a step by step example of using Excel's TRANSPOSE function
The TRANSPOSE function is used to transfer data located in a row into a column or data located in a column into a row. This tutorial includes a step by step example of using Excel's TRANSPOSE function
Sort Data in Excel 2007
Using Excel's sort feature to sort data in ascending or descending order.
Using Excel's sort feature to sort data in ascending or descending order.
Excel ISBLANK
The ISBLANK function's job is to check to see if a certain cell is empty or not. This tutorial includes an example of how to use this function.
The ISBLANK function's job is to check to see if a certain cell is empty or not. This tutorial includes an example of how to use this function.
Cell
: In any spreadsheet program such as Excel, each rectangular box in a row worksheet is referred to as
: In any spreadsheet program such as Excel, each rectangular box in a row worksheet is referred to as
How to Use HLOOKUP in Excel
How to Use the HLOOKUP Function in Excel. This step by step tutorial shows you how to create and use the HLOOKUP function in Excel.
How to Use the HLOOKUP Function in Excel. This step by step tutorial shows you how to create and use the HLOOKUP function in Excel.
Protect Worksheet Excel
How to protect worksheet data in Excel step 2 - protect the worksheet. Includes a step by step example.
How to protect worksheet data in Excel step 2 - protect the worksheet. Includes a step by step example.
Excel 2010 VLOOKUP Function
Excel's VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This tutorial includes a step by step example.
Excel's VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This tutorial includes a step by step example.
Change Column Widths Excel 2003
There are a number of ways to change column widths in Excel spreadsheets. This step by step tutorial shows you three ways to change column widths in Excel.
There are a number of ways to change column widths in Excel spreadsheets. This step by step tutorial shows you three ways to change column widths in Excel.
Excel Formatting
Excel Formatting is a way to make your spreadsheets easier to read and understand the important data. This series of Excel articles and tutorials, takes you through the process of formatting your Excel spreadsheets.
Excel Formatting is a way to make your spreadsheets easier to read and understand the important data. This series of Excel articles and tutorials, takes you through the process of formatting your Excel spreadsheets.
Excel Custom Header
In Excel, a header can be used to add descriptive information to every page in the spreadsheet. A custom header can be used to include such things as company information, a spreadsheet title, or spreadsheet author.
In Excel, a header can be used to add descriptive information to every page in the spreadsheet. A custom header can be used to include such things as company information, a spreadsheet title, or spreadsheet author.
Excel 2010 ROUND Function
Rounding numbers in Excel can be accomplished with a number of different functions - depending on the results you want. The ROUND function can be used to round a value either up or down a specific number of decimal places. This tutorial includes a step by step example of using Excel's ROUND function.
Rounding numbers in Excel can be accomplished with a number of different functions - depending on the results you want. The ROUND function can be used to round a value either up or down a specific number of decimal places. This tutorial includes a step by step example of using Excel's ROUND function.
Excel's Go To Feature
The Go To feature in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells.
The Go To feature in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells.
Excel 2007 Flowchart Template
This article walks through how to download and use the free flowchart template available from Microsoft. The article covers how to use the flowchart template in Excel 2007 / 2010.
This article walks through how to download and use the free flowchart template available from Microsoft. The article covers how to use the flowchart template in Excel 2007 / 2010.
Free Excel Templates
This article covers templates in Excel: how to make your own as well as free templates that you can download.
This article covers templates in Excel: how to make your own as well as free templates that you can download.
How to Use Excel 2003
How to Use Excel 2003 is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and removing columns and rows, how to create charts with the Excel Chart Wizard, and how to use Excel's format options.
How to Use Excel 2003 is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and removing columns and rows, how to create charts with the Excel Chart Wizard, and how to use Excel's format options.
Excel UPPER Function
The UPPER function is used to convert text to all upper case or capital letters. An example of using this function is included in the tutorial.
The UPPER function is used to convert text to all upper case or capital letters. An example of using this function is included in the tutorial.
Parts of the Excel 2010 Screen
This labeled diagram shows the main parts of the Excel screen. Descriptions for each screen part is included.
This labeled diagram shows the main parts of the Excel screen. Descriptions for each screen part is included.
Excel RANK Function
The RANK function ranks the size of a number compared to other numbers in a list. A step by step example is included.
The RANK function ranks the size of a number compared to other numbers in a list. A step by step example is included.
Google Spreadsheet IF Functio
The IF function in Google Spreadsheet tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using Google Spreadsheets' IF function.
The IF function in Google Spreadsheet tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using Google Spreadsheets' IF function.
Excel 2010 AVERAGEIF Function
The AVERAGEIF function finds the average value for a range of cells - but only if those values meet specific criteria. This tutorial includes a step by step example of using Excel's AVERAGE IF function.
The AVERAGEIF function finds the average value for a range of cells - but only if those values meet specific criteria. This tutorial includes a step by step example of using Excel's AVERAGE IF function.
Range
: A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells
: A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells
Excel INDEX Function
The Excel INDEX function uses row and column numbers from an array to return the name of a specific item of data. This tutorial includes a step by step example.
The Excel INDEX function uses row and column numbers from an array to return the name of a specific item of data. This tutorial includes a step by step example.
Formula Bar
: The formula bar in Excel is located above the work area of the spreadsheet . The formula bar displays
: The formula bar in Excel is located above the work area of the spreadsheet . The formula bar displays
AutoSum
The Excel AutoSUM is a shortcut to using the SUM function. By using the icon on the standard toolbar, you can quickly enter the SUM function into your spreadsheet.
The Excel AutoSUM is a shortcut to using the SUM function. By using the icon on the standard toolbar, you can quickly enter the SUM function into your spreadsheet.
IF Function Calculations
The IF function is one of Excel's most useful functions. What it does is test to see whether a certain condition is true or false. This tutorial covers using the IF function to perform calculations on spreadsheet data.
The IF function is one of Excel's most useful functions. What it does is test to see whether a certain condition is true or false. This tutorial covers using the IF function to perform calculations on spreadsheet data.
Formatting Numbers
Formatting numbers in Excel spreadsheets is used to change the look of the numbers in the cell. The most common formatting options are currency, comma, date, accounting and percent, although there are more options available.
Formatting numbers in Excel spreadsheets is used to change the look of the numbers in the cell. The most common formatting options are currency, comma, date, accounting and percent, although there are more options available.
Print Gridlines in Excel 2007
This article shows you how to print gridlines and headings in Excel. A step by step example is included showing you how to print gridlines and headings in Excel.
This article shows you how to print gridlines and headings in Excel. A step by step example is included showing you how to print gridlines and headings in Excel.
Excel LEFT Function
The LEFT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This tutorial includes a step by step example of how to use the LEFT function in Excel.
The LEFT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This tutorial includes a step by step example of how to use the LEFT function in Excel.
Excel Insert Rows
This tutorial shows you how to easily insert rows into an Excel worksheet
This tutorial shows you how to easily insert rows into an Excel worksheet
Dialog Box
: A dialog box in Excel is a form that allows users to input information and make choices about different
: A dialog box in Excel is a form that allows users to input information and make choices about different
Rounding Numbers in Excel
Rounding numbers and rounding decimals is easy to accomplish in Excel. The ROUND function is one of the math functions available in Microsoft Excel 97 to Excel 2007. This article includes an example to walk you through using the ROUND function.
Rounding numbers and rounding decimals is easy to accomplish in Excel. The ROUND function is one of the math functions available in Microsoft Excel 97 to Excel 2007. This article includes an example to walk you through using the ROUND function.
Excel SUMPRODUCT Count Cells
The SUMPRODUCT function in Excel can be used to count the number of cells containing data that meets one or more criteria. This tutorial includes a step by step example.
The SUMPRODUCT function in Excel can be used to count the number of cells containing data that meets one or more criteria. This tutorial includes a step by step example.
Basic Excel 2010 Tutorial Pt 2
The Excel format tutorial covers a number of format topics such as shading alternate rows, widening columns, applying number formats, and merging and centering headings. This tutorial includes step by step examples of how to apply basic format techniques in Excel.
The Excel format tutorial covers a number of format topics such as shading alternate rows, widening columns, applying number formats, and merging and centering headings. This tutorial includes step by step examples of how to apply basic format techniques in Excel.
Remove Duplicate Data in Excel
This tutorial covers how to remove rows or records of duplicate data in Excel. The tutorial includes a step by step instructions on how to remove duplicate data records in Excel.
This tutorial covers how to remove rows or records of duplicate data in Excel. The tutorial includes a step by step instructions on how to remove duplicate data records in Excel.
Data Definition
: Data is information that is stored in any spreadsheet program such as Excel. Data is stored in cells
: Data is information that is stored in any spreadsheet program such as Excel. Data is stored in cells
Name Box Definition
: The Name Box is located next to the formula bar above the worksheet area. The Name Box displays the
: The Name Box is located next to the formula bar above the worksheet area. The Name Box displays the
Excel SUM IF Array Formula
Using a nested SUM and IF array formula count when multiple conditions are met in a table of data. A step by step example is included with this tutorial.
Using a nested SUM and IF array formula count when multiple conditions are met in a table of data. A step by step example is included with this tutorial.
Excel NETWORKDAYS Function
The NETWORKDAYS function can be used to calculate the number of whole working days between two dates. This tutorial includes a step by step example on using the NETWORKDAYS function in Excel.
The NETWORKDAYS function can be used to calculate the number of whole working days between two dates. This tutorial includes a step by step example on using the NETWORKDAYS function in Excel.
Excel Limit Rows and Columns
This tutorial shows you how to limit the number of rows and columns that can be used in an Excel worksheet. This tutorial includes a step by step example of how to limit the number of rows and columns that can be used in an Excel worksheet.
This tutorial shows you how to limit the number of rows and columns that can be used in an Excel worksheet. This tutorial includes a step by step example of how to limit the number of rows and columns that can be used in an Excel worksheet.
Excel 2010 SUMIFS Function
The Excel SUMIFS function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIFS function in Excel.
The Excel SUMIFS function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIFS function in Excel.
Relative Cell Reference
: In Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group
: In Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group