Spreadsheets: Most Popular Articles
These articles are the most popular over the last month.
Excel Formulas
This tutorial will work for versions of Excel from Excel 97 to Excel 2007. Spreadsheet formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. This tutorial walks you through creating formulas in Excel.
This tutorial will work for versions of Excel from Excel 97 to Excel 2007. Spreadsheet formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. This tutorial walks you through creating formulas in Excel.
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 with the Excel Chart Wizard, 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 with the Excel Chart Wizard, and how to use Excel's format options including autoformat.
Excel 2007 Line Graph
This tutorial covers creating a line graph in Microsoft Excel 2007. The tutorial includes a step by step example of creating a line graph in the latest version of Excel.
This tutorial covers creating a line graph in Microsoft Excel 2007. The tutorial includes a step by step example of creating a line graph in the latest version of Excel.
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.
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 article 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 article walks through how to download and use the flowchart template from Microsoft.
Excel 2007
How to Use Excel 2007 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 2007 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 2007 Drop Down List
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This article shows you how to create a drop down list in Excel 2007 with 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 article shows you how to create a drop down list in Excel 2007 with data from a different worksheet.
IF Functions
IF functions are one of the most versatile functions available in the Excel. This series of articles and tutorials will teach you the basics of using IF functions to perform calculations in Excel spreadsheets.
IF functions are one of the most versatile functions available in the Excel. This series of articles and tutorials will teach you the basics of using IF functions to perform calculations in Excel spreadsheets.
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.
Excel IF Function
The Excel IF function is one of the most useful functions available. The IF function allows for decision making in a spreadsheet. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met.
The Excel IF function is one of the most useful functions available. The IF function allows for decision making in a spreadsheet. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met.
Excel Database
This step by step tutorial shows you how to create a database in Excel 2003. 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 2003. The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.
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.
Divide Excel
How to divide in Excel is a quick tip that shows you how easy it is to carry out division operations in Excel.
How to divide in Excel is a quick tip that shows you how easy it is to carry out division operations in Excel.
Parts of the Excel Screen
This labeled picture shows the main parts of the Micorosft Excel 2007 screen. Components include the Office button, ribbons, active cell, name box, column letter, row number, formula bar and sheet tabs.
This labeled picture shows the main parts of the Micorosft Excel 2007 screen. Components include the Office button, ribbons, active cell, name box, column letter, row number, formula bar and sheet tabs.
Excel VLOOKUP
Excel’s VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article covers how to create a VLOOKUP function in Excel, including an 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 article covers how to create a VLOOKUP function in Excel, including an example.
Subtract Excel
How to subtract in Excel is a quick tip that shows you how easy it is to subtract numbers in Excel.
How to subtract in Excel is a quick tip that shows you how easy it is to subtract numbers in Excel.
Excel 2007 Column Chart
This tutorial covers creating a column chart in Microsoft Excel 2007. This tutorial includes a step by step example of creating a column chart in the latest version of Excel.
This tutorial covers creating a column chart in Microsoft Excel 2007. This tutorial includes a step by step example of creating a column chart in the latest version of Excel.
Basic Excel 2007 Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2007. 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 2007. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.
Excel 2007 IF Function
The IF function, one of Excel's logical functions, tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using Excel 2007's IF function.
The IF function, one of Excel's logical functions, tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using Excel 2007's IF function.
Excel IF Functions
One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If it does, one result will happen, if not, a different action can occur. This article covers how to write an IF function.
One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If it does, one result will happen, if not, a different action can occur. This article covers how to write an IF function.
Excel 2007 Pie Chart
This free tutorial covers creating a pie chart (pie graph) in Microsoft Excel 2007. The tutorial includes a step by step example of creating a pie chart in Excel.
This free tutorial covers creating a pie chart (pie graph) in Microsoft Excel 2007. The tutorial includes a step by step example of creating a pie chart in Excel.
Basic Excel 2003 Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2003. 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 2003. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.
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.
Add Excel
How to add in Excel is a quick tip that shows you how easy it is to add numbers in Excel.
How to add in Excel is a quick tip that shows you how easy it is to add numbers in Excel.
Cell Reference
Definition of the term cell reference as used in spreadsheets such as Excel.
Definition of the term cell reference as used in spreadsheets such as Excel.
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.
Formula
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel. Definition of a spreadsheet formula.
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel. Definition of a spreadsheet formula.
Nested IF
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. To increase the flexibility of the function, one IF function can be "nested" inside another. This article covers nesting one IF function inside another.
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. To increase the flexibility of the function, one IF function can be "nested" inside another. This article covers nesting one IF function inside another.
Excel Math
These articles on Excel Math cover how to carry out basic math operations Microsoft Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these tutorials will show you how.
These articles on Excel Math cover how to carry out basic math operations Microsoft Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these tutorials will show you how.
Excel Macro
This step by step tutorial covers how to create simple macros in Excel 2007 using the macro recorder.
This step by step tutorial covers how to create simple macros in Excel 2007 using the macro recorder.
Spreadsheet
Spreadsheet definition. This glossary item defines electronic spreadsheets such as Excel, Google Spreadsheets, and OpenOffice Calc.
Spreadsheet definition. This glossary item defines electronic spreadsheets such as Excel, Google Spreadsheets, and OpenOffice Calc.
Free Excel Formatting Tutorial
This tutorial on how to format Excel spreadsheets covers using a variety of formatting options including number, text, and worksheet formatting. This is the first part of a step by step tutorial, using these types of formatting effectively to enhance your spreadsheets.
This tutorial on how to format Excel spreadsheets covers using a variety of formatting options including number, text, and worksheet formatting. This is the first part of a step by step tutorial, using these types of formatting effectively to enhance your spreadsheets.
Lock Cells 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.
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.
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.
Multiply Excel
How to multiply in Excel is a quick tip that shows you how easy it is to multiply numbers in Excel.
How to multiply in Excel is a quick tip that shows you how easy it is to multiply numbers in Excel.
What is Excel
What is Microsoft Excel? It is an electronic spreadsheet program that people use for storing, organizing and manipulating data. The types of data that Excel can use includes numbers, text and formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.
What is Microsoft Excel? It is an electronic spreadsheet program that people use for storing, organizing and manipulating data. The types of data that Excel can use includes numbers, text and formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.
Excel 2007 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 article walks you through using the VLOOKUP function in Excel.
Excel's VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article walks you through using the VLOOKUP function in Excel.
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 article shows you how to create a drop down list in Excel 2007.
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This article shows you how to create a drop down list in Excel 2007.
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.
Worksheet
Spreadsheet definition - Worksheet. This glossary entry defines "worksheet" as it pertains to Microsoft Excel
Spreadsheet definition - Worksheet. This glossary entry defines "worksheet" as it pertains to Microsoft Excel
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.
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.
Range
Definition of the term range as used in spreadsheets such as Excel.
Definition of the term range as used in spreadsheets such as Excel.
Excel 2007 SUMIF
The SUMIF function, one of Excel's MATH functions, is used to sum up the number of cells in a selected range that meet certain criteria.
The SUMIF function, one of Excel's MATH functions, is used to sum up the number of cells in a selected range that meet certain criteria.
Spreadsheets Terms: Function
Spreadsheets Terms - Definition of the term Function as used in spreadsheets such as Excel.
Spreadsheets Terms - Definition of the term Function as used in spreadsheets such as Excel.
Date Functions Excel
There are a number of date functions available in Excel 2003. 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 article covers the most common date functions used in Excel.
There are a number of date functions available in Excel 2003. 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 article covers the most common date functions used in Excel.
Create a Bar Graph
This tutorial covers creating a bar graph in Microsoft Excel. This tutorial covers all the steps necessary for creating a bar graph using the Chart Wizard. The tutorial begins by discussing the best practices for entering the data and then walks you through each of the four screens of the Chart Wizard.
This tutorial covers creating a bar graph in Microsoft Excel. This tutorial covers all the steps necessary for creating a bar graph using the Chart Wizard. The tutorial begins by discussing the best practices for entering the data and then walks you through each of the four screens of the Chart Wizard.
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.
Absolute Cell Reference
Absolute Cell Reference. Spreadsheets Terms - Definition of the term Absolute cell reference as used in spreadsheets such as Excel.
Absolute Cell Reference. Spreadsheets Terms - Definition of the term Absolute cell reference as used in spreadsheets such as Excel.
Excel 2007 Merge and Center
The Merge and Center formatting feature in Excel 2007 is a handy option to quickly format titles and headings in Excel 2007 Spreadsheets. This tip will show you how to do it.
The Merge and Center formatting feature in Excel 2007 is a handy option to quickly format titles and headings in Excel 2007 Spreadsheets. This tip will show you how to do it.
Excel Graph Uses
Scatter Plot graphs are one of the most common types of graph used in Excel. This article covers the uses for Scatter Plot graphs in Excel.
Scatter Plot graphs are one of the most common types of graph used in Excel. This article covers the uses for Scatter Plot graphs in Excel.
Excel Freeze Panes
Excel's freeze panes feature will keep the headings at the top and down the side of the sheet from disappearing when you scroll awau from the top left corner of the sheet. This tutorial shows you how to "freeze" those sections of the screen containing titles so that they remain visible at all times.
Excel's freeze panes feature will keep the headings at the top and down the side of the sheet from disappearing when you scroll awau from the top left corner of the sheet. This tutorial shows you how to "freeze" those sections of the screen containing titles so that they remain visible at all times.
Excel 2007 COUNTIF
The COUNTIF function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet certain criteria.
The COUNTIF function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet certain criteria.
Excel SUM
The Excel SUM function is probably the most often used function in Excel spreadsheets. A short cut to using the SUM function is the Auto SUM button. This step by step tutorial walks through how to use Excel's SUM function and the Auto SUM feature to perform spreadsheet calculations.
The Excel SUM function is probably the most often used function in Excel spreadsheets. A short cut to using the SUM function is the Auto SUM button. This step by step tutorial walks through how to use Excel's SUM function and the Auto SUM feature to perform spreadsheet calculations.
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.
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.
Excel 2003 AVERAGE
Excel's AVERAGE function is one of the Statistical Functions that are included with the program. The 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 is one of the Statistical Functions that are included with the program. The AVERAGE function can be used to find the average value, or arithmetic Mean, of values in a selected range of cells.
Excel Tutorial
Each free Excel tutorial covers either an introductory or intermediate level topic in Microsoft Excel 2003 or 2007. Each tutorial will give you a good understanding of how to use Excel and what you can accomplish with the program.
Each free Excel tutorial covers either an introductory or intermediate level topic in Microsoft Excel 2003 or 2007. Each tutorial will give you a good understanding of how to use Excel and what you can accomplish with the program.
Unhide Rows
This article shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.
This article shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.
Protect Worksheet Excel 2007
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 2007 AVERAGE IF
The AVERAGE IF function, one of Excel's statistical functions, is used to find the average of values in cells that meet certain criteria.
The AVERAGE IF function, one of Excel's statistical functions, is used to find the average of values in cells that meet certain criteria.
Formula Bar
The formula bar in Excel is located above the work area of the spreadsheet. The formula bar displays the data or formula stored in the active cell.
The formula bar in Excel is located above the work area of the spreadsheet. The formula bar displays the data or formula stored in the active cell.
Excel Formula FAQ
Excel formulas are one of the most useful features available in a spreadsheet. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating an Excel formula, the program does all the calculations for you.
Excel formulas are one of the most useful features available in a spreadsheet. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating an Excel formula, the program does all the calculations for you.
Excel 2003 AND Function
The AND function is one of Excel’s “Logical Functions”. Like most logical functions, the AND function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.
The AND function is one of Excel’s “Logical Functions”. Like most logical functions, the AND function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.
Active Cell
In an Excel worksheet, the active cell is the cell with the black border. Data can only be entered into the active cell.
In an Excel worksheet, the active cell is the cell with the black border. Data can only be entered into the active cell.
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 2007 CONCATENATE
The CONCATENATE function, one of Excel's text functions, is used to join two or more words or text strings together. This article includes an example to walk you through using Excel's CONCATENATE function.
The CONCATENATE function, one of Excel's text functions, is used to join two or more words or text strings together. This article includes an example to walk you through using Excel's CONCATENATE function.
Drag Select
Drag select is a term used to describe the method of selecting a range of cells by dragging the mouse over a block of cells, or range, in the spreadsheet.
Drag select is a term used to describe the method of selecting a range of cells by dragging the mouse over a block of cells, or range, in the spreadsheet.
Name Box Definition
The Name Box displays the cell reference of the active cell. It will also show the name assigned to a cell or range of cells.
The Name Box displays the cell reference of the active cell. It will also show the name assigned to a cell or range of cells.
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.
Printing in Excel 2003
This tutorial on Excel Printing covers how to Use the print options in Excel to print entire spreadsheets or just selected areas.
This tutorial on Excel Printing covers how to Use the print options in Excel to print entire spreadsheets or just selected areas.
Data Definition
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel. Definition of data as it is used in spreadsheets like Excel.
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel. Definition of data as it is used in spreadsheets like Excel.
Excel 2003 Line Graph Tutorial
This tutorial covers creating a line graph in Microsoft Excel 2003. The tutorial includes a step by step example of creating a line graph in Excel using the Chart Wizard.
This tutorial covers creating a line graph in Microsoft Excel 2003. The tutorial includes a step by step example of creating a line graph in Excel using the Chart Wizard.
Excel 2003 HLOOKUP
Excel’s HLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article covers how to create a HLOOKUP function in Excel, including an example.
Excel’s HLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article covers how to create a HLOOKUP function in Excel, including an example.
IF Function Entering Text
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. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. One option for using the IF function is to have it enter different words into a cell, depending on whether the tested condition is true or false. This article covers using the IF function to entering text into a spreadsheet.
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. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. One option for using the IF function is to have it enter different words into a cell, depending on whether the tested condition is true or false. This article covers using the IF function to entering text into a spreadsheet.
IF Function and Blank Cells
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. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. One option for using the IF function is to have it leave cells blank, depending on whether the tested condition is true or false. This article covers leaving cells blank when using the IF function.
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. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. One option for using the IF function is to have it leave cells blank, depending on whether the tested condition is true or false. This article covers leaving cells blank when using the IF function.
Excel COUNT
Excel's COUNT function is a very useful function. What it does is count up the number of cells containing numbers in a selected range.
Excel's COUNT function is a very useful function. What it does is count up the number of cells containing numbers in a selected range.
Excel 2007 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.
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.
Relative Cell Reference
Relative Cell Reference. Spreadsheets Terms - Definition of the term relative cell reference as used in spreadsheets such as Excel.
Relative Cell Reference. Spreadsheets Terms - Definition of the term relative cell reference as used in spreadsheets such as Excel.
Cell
Spreadsheet glossary terms. Definition of a "cell".
Spreadsheet glossary terms. Definition of a "cell".
Workbook
Spreadsheet definition - Workbook. This glossary entry defines "workbook" as it pertains to Microsoft Excel.
Spreadsheet definition - Workbook. This glossary entry defines "workbook" as it pertains to Microsoft Excel.
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 article 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 article covers using the IF function to perform calculations on spreadsheet data.
Row
Rows run horizontally in an Excel worksheet. They are identified by a number in the row header.
Rows run horizontally in an Excel worksheet. They are identified by a number in the row header.
Excel Pivot Table
This tutorial covers how to create a pivot table in Excel 2007. The step by step tutorial includes an example how to create a pivot table in Excel 2007.
This tutorial covers how to create a pivot table in Excel 2007. The step by step tutorial includes an example how to create a pivot table in Excel 2007.
Excel 2007 NOW
The NOW function, one of Excel's date and time functions, is used to add the current time and date to a spreadsheet.
The NOW function, one of Excel's date and time functions, is used to add the current time and date to a spreadsheet.
Comparison Operators
The logic test section of an Excel Logic function is always a comparison between two values. This article is a handy list of the different comparison operators that can be used in Excel logic functions.
The logic test section of an Excel Logic function is always a comparison between two values. This article is a handy list of the different comparison operators that can be used in Excel logic functions.
Calculate Days Between Dates
The DATEDIF function, can be used to calculate the number of days between dates. This article includes a step by step example of using the DATEDIF function in Excel to calculate the number of days between two dates.
The DATEDIF function, can be used to calculate the number of days between dates. This article includes a step by step example of using the DATEDIF function in Excel to calculate the number of days between two dates.
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 articles 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 articles include examples of subtracting two dates in Excel using the different date functions.
Excel 2007 Template
This tip shows you how to quickly create a template in Microsoft Office Excel 2007.
This tip shows you how to quickly create a template in Microsoft Office Excel 2007.
Spreadsheets - QuickTips
An index of QuickTips for the Spreadsheets guide site.
An index of QuickTips for the Spreadsheets guide site.
Excel MAX Function
The MAX function, is used to find the largest or maximum number in a given list of values. This article includes an example to walk you through using the MAX function.
The MAX function, is used to find the largest or maximum number in a given list of values. This article includes an example to walk you through using the MAX function.
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 Labels
Using labels in functions and formulas in Excel is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as "January".
Using labels in functions and formulas in Excel is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as "January".
Excel 2007 TODAY
The TODAY function, one of Excel's date functions, is used to add today's date to a spreadsheet.
The TODAY function, one of Excel's date functions, is used to add today's date to a spreadsheet.
Excel 2007 Custom Header
In Excel 2007, 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 2007, 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.
Chart Wizard
The Chart Wizard in Excel spreadsheets, is composed of a series of dialog boxes that give you all the available options for creating a chart quickly.
The Chart Wizard in Excel spreadsheets, is composed of a series of dialog boxes that give you all the available options for creating a chart quickly.
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 Bar Graph
These tutorials cover creating a bar graph in Excel. Each tutorial includes a step by step example of creating a bar graph in Excel 2007 or Excel 2003.
These tutorials cover creating a bar graph in Excel. Each tutorial includes a step by step example of creating a bar graph in Excel 2007 or Excel 2003.
Data List in Excel
Once the data has been entered properly into Excel, it can be converted to a "list". A list is a special feature that allows for easy access to Excel's sorting and filtering tools.
Once the data has been entered properly into Excel, it can be converted to a "list". A list is a special feature that allows for easy access to Excel's sorting and filtering tools.
Custom Excel 2003 Chart
This article covers creating a custom Excel chart. If you have created a chart in Excel, complete with custom formatting, that you would like to use again with other charts save it as a custom chart type.
This article covers creating a custom Excel chart. If you have created a chart in Excel, complete with custom formatting, that you would like to use again with other charts save it as a custom chart type.
Syntax
Spreadsheet definition - Syntax. This glossary entry defines "syntax" as it pertains to spreadsheet programs.
Spreadsheet definition - Syntax. This glossary entry defines "syntax" as it pertains to spreadsheet programs.
Argument
Spreadsheet definition - Argument. This glossary entry defines "argument" as it pertains to spreadsheet programs.
Spreadsheet definition - Argument. This glossary entry defines "argument" as it pertains to spreadsheet programs.
Excel Random Numbers
Generate random numbers in Excel using the RAND function. This tutorial has a step by step example.
Generate random numbers in Excel using the RAND function. This tutorial has a step by step example.
OpenOffice Calc Formulas
This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.
This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.
Excel 2007 TRIM Function
The TRIM function, one of Excel's text functions, is used to remove extra spaces from a text entry. This article includes an example to walk you through using Excel's TRIM function.
The TRIM function, one of Excel's text functions, is used to remove extra spaces from a text entry. This article includes an example to walk you through using Excel's TRIM function.
Chart
Charts are what we call graphs in math class. They are visual representations of worksheet data. In spreadsheet programs such as Lotus 1-2-3 and Quattro Pro they are called graphs. Only in Microsoft Excel are they called charts.
Charts are what we call graphs in math class. They are visual representations of worksheet data. In spreadsheet programs such as Lotus 1-2-3 and Quattro Pro they are called graphs. Only in Microsoft Excel are they called charts.
Create a Pictograph
This step by step tutorial shows you how to create a pictograph in Excel 2007.
This step by step tutorial shows you how to create a pictograph in Excel 2007.
Excel 2007 COUNT
Excel 2007's COUNT function allows you to count up the number of cells containing numbers in a selected range.
Excel 2007's COUNT function allows you to count up the number of cells containing numbers in a selected range.
Change Column Widths
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.
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.
Excel Tips III - Formulas
This list of Excel tips on formulas will give you straightforward answers on how to carry out a variety of tasks related to formulas in Microsoft Excel.
This list of Excel tips on formulas will give you straightforward answers on how to carry out a variety of tasks related to formulas in Microsoft Excel.
Excel 2007 SUMIFS
The SUMIFS function, similar to Excel's SUMIF function, is used to add up the contents of cells in a selected range that meet multiple criterion. This article includes an example of using the SUMIFS function in Excel.
The SUMIFS function, similar to Excel's SUMIF function, is used to add up the contents of cells in a selected range that meet multiple criterion. This article includes an example of using the SUMIFS function in Excel.
Learn Excel
This series of tutorials will help you learn the small things in Excel 2007 that are often overlooked in other tutorials. Learn how to how to add a new worksheet, how to wrap text in a cell, learn how to quickly undo mistakes you just made. Each tutorial in Learn Excel includes a step by step example.
This series of tutorials will help you learn the small things in Excel 2007 that are often overlooked in other tutorials. Learn how to how to add a new worksheet, how to wrap text in a cell, learn how to quickly undo mistakes you just made. Each tutorial in Learn Excel includes a step by step example.
Excel 2007 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 article includes an example to walk you through using Excel's 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 article includes an example to walk you through using Excel's LEFT function.
Excel 2007 TRANSPOSE
The TRANSPOSE function, one of Excel's Lookup & Reference functions, is used to transfer data located in a row into a column or data located in a column into a row.
The TRANSPOSE function, one of Excel's Lookup & Reference functions, is used to transfer data located in a row into a column or data located in a column into a row.
Excel AutoFormat
The Excel Autoformat option gives you 17 AutoFormat styles to use to give your spreadsheets a professional look that makes them easy to read.
The Excel Autoformat option gives you 17 AutoFormat styles to use to give your spreadsheets a professional look that makes them easy to read.
CountA
Excel's COUNTA function is a very useful, yet little known function. What it does is count up the number of cells containing data – either numbers or labels in a selected range.
Excel's COUNTA function is a very useful, yet little known function. What it does is count up the number of cells containing data – either numbers or labels in a selected range.
Excel Chart Wizard
The Excel Chart Wizard makes the process of creating charts or graphs in Excel a very simple procedure. There are four steps to the Chart Wizard. These steps contain a number of options that allow you to pick a chart type, choose your data, and add titles and formatting to produce a finished chart.
The Excel Chart Wizard makes the process of creating charts or graphs in Excel a very simple procedure. There are four steps to the Chart Wizard. These steps contain a number of options that allow you to pick a chart type, choose your data, and add titles and formatting to produce a finished chart.
IF Function Enter Data
The IF function is one of Excel’s most useful functions. One option for using the IF function is to have it enter values into target cells, depending on whether the tested condition is true or false. This article covers using the IF function to enter values into a spreadsheet.
The IF function is one of Excel’s most useful functions. One option for using the IF function is to have it enter values into target cells, depending on whether the tested condition is true or false. This article covers using the IF function to enter values into a spreadsheet.
Excel Tips
This list of Excel tips will give you straightforward answers on how to carry out a variety of tasks in Microsoft Excel. Examples are included to make understanding the steps involved even easier to follow. The list keeps growing so check back often to see what new Excel tips have been added.
This list of Excel tips will give you straightforward answers on how to carry out a variety of tasks in Microsoft Excel. Examples are included to make understanding the steps involved even easier to follow. The list keeps growing so check back often to see what new Excel tips have been added.
Microsoft Works Spreadsheets
Beginners Guide to Microsoft Works Spreadsheets is a series of articles and tutorials for the absolute beginner. Learn about the parts of the Microsoft Works Spreadsheets screen, how to enter data, how to use formulas and functions, adding and removing columns and rows, how to create charts, and how to use the program's format options.
Beginners Guide to Microsoft Works Spreadsheets is a series of articles and tutorials for the absolute beginner. Learn about the parts of the Microsoft Works Spreadsheets screen, how to enter data, how to use formulas and functions, adding and removing columns and rows, how to create charts, and how to use the program's format options.
Excel 2007 Options Button
Since there is no longer a tool's menu, or even a tool's tab on the Ribbon, you have to look elsewhere for the Excel Options feature in Excel 2007.
Since there is no longer a tool's menu, or even a tool's tab on the Ribbon, you have to look elsewhere for the Excel Options feature in Excel 2007.
Excel 2007 REPLACE Function
The REPLACE function, one of Excel's text functions, is used to replace unwanted characters from a data entry. This article includes an example to walk you through using Excel's REPLACE function.
The REPLACE function, one of Excel's text functions, is used to replace unwanted characters from a data entry. This article includes an example to walk you through using Excel's REPLACE function.
Excel 2007 RANK Function
The RANK function, one of Excel's statistical functions, ranks the size of a number compared to other numbers in a list. This article includes an example to walk you through using Excel's RANK function.
The RANK function, one of Excel's statistical functions, ranks the size of a number compared to other numbers in a list. This article includes an example to walk you through using Excel's RANK function.
Excel 2007 SUM Function
The Excel SUM function is used to quickly add up the values in a range of cells. This article shows you how to use this function.
The Excel SUM function is used to quickly add up the values in a range of cells. This article shows you how to use this function.
Excel Functions
This series of tutorials and articles will teach you the basics of using Excel functions to perform a variety of tasks in Excel spreadsheets.
This series of tutorials and articles will teach you the basics of using Excel functions to perform a variety of tasks in Excel spreadsheets.
Cell Address
Spreadsheet definition - Excel Cell Address. This glossary entry defines "Cell Address" as it pertains to spreadsheet programs.
Spreadsheet definition - Excel Cell Address. This glossary entry defines "Cell Address" as it pertains to spreadsheet programs.
NETWORKDAYS Function
The NETWORKDAYS function can be used to count the number of working days between two dates. This article includes an example of using the NETWORKDAYS function to count days in Excel 2007.
The NETWORKDAYS function can be used to count the number of working days between two dates. This article includes an example of using the NETWORKDAYS function to count days in Excel 2007.
Formatting Style in Excel 2007
This tip shows you how to quickly create a custom formatting style in Excel 2007.
This tip shows you how to quickly create a custom formatting style in Excel 2007.
Excel 2007 AVERAGE Function
The AVERAGE function, one of Excel's statistical functions, is used to find the average value in a given list of arguments. This article includes an example to walk you through using Excel's AVERAGE function.
The AVERAGE function, one of Excel's statistical functions, is used to find the average value in a given list of arguments. This article includes an example to walk you through using Excel's AVERAGE function.
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 article includes an example of using conditional formatting in Excel 2003.
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 article includes an example of using conditional formatting in Excel 2003.
Excel 2007 DATE
The DATE function, one of Excel's date and time functions, can be used to add a date to a spreadsheet. This article includes an example of using the DATE function.
The DATE function, one of Excel's date and time functions, can be used to add a date to a spreadsheet. This article includes an example of using the DATE function.
2007 Fill Handle
The fill handle can be used to copy formulas from one cell to other cells in the spreadsheet. This article covers the steps to follow to use the auto fill handle in Excel.
The fill handle can be used to copy formulas from one cell to other cells in the spreadsheet. This article covers the steps to follow to use the auto fill handle in Excel.
Add Columns
This article shows you how, with a click of the mouse, you can easily add columns to Excel worksheets.
This article shows you how, with a click of the mouse, you can easily add columns to Excel worksheets.
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.
The ROUND function, one of Excel's math functions, is used to reduce a number to a specific number of decimal places.
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.
#REF!
A #REF! error message in Excel refers to an invalid cell reference. Read the article to find the causes and cures for this common problem.
A #REF! error message in Excel refers to an invalid cell reference. Read the article to find the causes and cures for this common problem.
Excel 2007 RIGHT Function
The RIGHT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This article includes an example to walk you through using Excel's RIGHT function.
The RIGHT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This article includes an example to walk you through using Excel's RIGHT function.
Format Painter
Excel's format painter allows you to quickly copy formatting from one cell or group of cells to another part of the spreadsheet. It is very useful when extending a spreadsheet to accommodate new data and you need to format the new cells to match the original data area.
Excel's format painter allows you to quickly copy formatting from one cell or group of cells to another part of the spreadsheet. It is very useful when extending a spreadsheet to accommodate new data and you need to format the new cells to match the original data area.
Excel Sum Function
The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.
The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.
Excel 2007 CONVERT
The CONVERT function, one of Excel's engineering functions, is used to convert measurement data from one set of units to another.
The CONVERT function, one of Excel's engineering functions, is used to convert measurement data from one set of units to another.
Excel 2007 VALUE Function
The VALUE function, one of Excel's text functions, is used to convert text to values. Doing so allows them to be used in calculations. This article includes an example to walk you through using Excel's VALUE function.
The VALUE function, one of Excel's text functions, is used to convert text to values. Doing so allows them to be used in calculations. This article includes an example to walk you through using Excel's VALUE function.
Column
Columns are a fundamental part of any spreadsheet program such as Excel. Columns run vertically in a spreadsheet and help to identify the location of data.
Columns are a fundamental part of any spreadsheet program such as Excel. Columns run vertically in a spreadsheet and help to identify the location of 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.
Hide Columns
This article shows you how, with a click of the mouse, you can easily hide columns in Excel spreadsheets.
This article shows you how, with a click of the mouse, you can easily hide columns in Excel spreadsheets.
Excel 2007 OR Function
The OR function is one of Excel's Logical Functions. Like most logical functions, the output from the OR function is either the word TRUE or FALSE. This article walks you through how to use this function in Excel 2007
The OR function is one of Excel's Logical Functions. Like most logical functions, the output from the OR function is either the word TRUE or FALSE. This article walks you through how to use this function in Excel 2007
Other Excel Date Options
Working with the Date in Excel - how to sort by date, conditional format for date, and other tutorials are included in this list. Each tutorial listed below includes a step by step example of working with dates in Excel 2007.
Working with the Date in Excel - how to sort by date, conditional format for date, and other tutorials are included in this list. Each tutorial listed below includes a step by step example of working with dates in Excel 2007.
Spreadsheet Lessons
Spreadsheet lessons cover how to carry out basic operations in a spreadsheet program such as Excel. The topics deal with how to perform basic math with a spreadsheet - such as addition or subtraction; how to format your spreadsheet; how to create a chart; and how to print a spreadsheet.
Spreadsheet lessons cover how to carry out basic operations in a spreadsheet program such as Excel. The topics deal with how to perform basic math with a spreadsheet - such as addition or subtraction; how to format your spreadsheet; how to create a chart; and how to print a spreadsheet.
Excel 2003 PRODUCT Function
In Excel, the PRODUCT function can be used for multiplying numbers or a range of values together. A function is just a built-in formulas. Functions have been added to simplify performing specific mathematical operations in the spreadsheet.
In Excel, the PRODUCT function can be used for multiplying numbers or a range of values together. A function is just a built-in formulas. Functions have been added to simplify performing specific mathematical operations in the spreadsheet.
Excel Formula What if Question
"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions are very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.
"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions are very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.
Excel 2007 Time Sheet Template
This article shows you how to quickly download and use a free employee time sheet template in Excel 2007.
This article shows you how to quickly download and use a free employee time sheet template in Excel 2007.