Spreadsheets: Most Popular Articles
These articles are the most popular over the last month.
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.
Excel Formulas
This tutorial will work for versions of Excel from Excel 97 to Excel 2010. 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 2010. 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, 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.
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 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.
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.
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.
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.
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 2007 / 2010 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 the IF function in Excel 2007 and 2010 .
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 the IF function in Excel 2007 and 2010 .
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.
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.
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.
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.
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 Freeze Panes
Using the Excel Freeze Panes Feature Related tutorial: Excel 2007 / 2010 Freeze Panes . It is sometimes
Using the Excel Freeze Panes Feature Related tutorial: Excel 2007 / 2010 Freeze Panes . It is sometimes
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
Excel 2010 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. This tutorial contains a step by step example of using the SUMIF function in Excel.
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. This tutorial contains a step by step example of using the SUMIF function 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 Macro
This step by step tutorial covers how to create simple macros in Excel 2007 / 2010 using the macro recorder.
This step by step tutorial covers how to create simple macros in Excel 2007 / 2010 using the macro recorder.
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 tutorial includes a step by step example of 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 tutorial includes a step by step example of using Excel's CONCATENATE function.
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.
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.
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.
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 2010.
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 2010.
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 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 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 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.
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 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.
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.
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 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.
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.
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.
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.
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 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.
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.
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.
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.
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.
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.
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 2010.
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 2010.
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.
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.
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 2007 STD DEV Function
One of Excel's statistical functions is the STANDARD DEVIATION function. It can be used to quickly calculate the standard deviation of a list of numbers. This tutorial includes a step by step example of using Excel's STANDARD DEVIATION function.
One of Excel's statistical functions is the STANDARD DEVIATION function. It can be used to quickly calculate the standard deviation of a list of numbers. This tutorial includes a step by step example of using Excel's STANDARD DEVIATION function.
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.
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
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.
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.
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.
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.
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.
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 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.
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.
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.
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 2007 Pivot Table
A pivot table makes it easy to organize and extract information from a large table of data without the use of formulas in Excel. The tutorial includes a step by step tutorial example of how to create a pivot table in Excel.
A pivot table makes it easy to organize and extract information from a large table of data without the use of formulas in Excel. The tutorial includes a step by step tutorial example of how to create a pivot table 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 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 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 tutorial includes an example of using conditional formatting in Excel 2003.
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.
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.
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.
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 2007 Nested IF Function
How a Nested IF Function Works. This tutorial includes a step by step example of how to use a nested IF function in Excel.
How a Nested IF Function Works. This tutorial includes a step by step example of how to use a nested IF function in Excel.
Excel 2010 SUM Function
The SUM function in Excel can be used to quickly sum columns or rows of numbers . This tutorial includes a step by step example of using the SUM function to sum columns of data in Excel.
The SUM function in Excel can be used to quickly sum columns or rows of numbers . This tutorial includes a step by step example of using the SUM function to sum columns of data 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.
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.
Excel 2007 Merge and Center
The Merge and Center formatting feature in Excel is a handy option to quickly format titles and headings in Excel Spreadsheets. This tip will show you how to do it.
The Merge and Center formatting feature in Excel is a handy option to quickly format titles and headings in Excel Spreadsheets. This tip will show you how to do it.
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.
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.
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.
Excel 2010 SUMIF Function
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. This tutorial contains a step by step example of using the SUMIF function in Excel.
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. This tutorial contains a step by step example of using the SUMIF function in Excel.
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.
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
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 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.
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.
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.
Excel 2010 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 2010.
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 2010.
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 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.
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.
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 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.
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.
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 2010 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 of using Excel's 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 of using Excel's COUNT function.
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 of using Excel's 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 of using Excel's VLOOKUP function.
Excel 2003 COUNTIF Multiple Criteria
How to count up the number of cells in selected ranges that meet multiple criteria in Excel. This tutorial includes a step by step example of how to count up the number of cells in selected ranges that meet multiple criteria in Excel.
How to count up the number of cells in selected ranges that meet multiple criteria in Excel. This tutorial includes a step by step example of how to count up the number of cells in selected ranges that meet multiple criteria in Excel.
Sort Data in Excel 2007
Using Excel 2007's sort feature. Step by step example of sorting data in Excel 2007.
Using Excel 2007's sort feature. Step by step example of sorting data in Excel 2007.
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.
Basic Excel 2010 Tutorial Pt 2
Excel's merge and center option allows you to merge a number of cells in a worksheet and center text across the merged cells. This step by step tutorial includes an example showing you how to merge cells and center text in Excel.
Excel's merge and center option allows you to merge a number of cells in a worksheet and center text across the merged cells. This step by step tutorial includes an example showing you how to merge cells and center text in Excel.
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 2003 COUNT Function
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. This tutorial contains a step by step example of using the COUNT function in Excel
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. This tutorial contains a step by step example of using the COUNT function in Excel
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 to round numbers up.
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 to round numbers up.
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 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 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.
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.
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.
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 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 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 2010 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 of using the INDEX function in Excel to return the name of a specific item of data.
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 of using the INDEX function in Excel to return the name of a specific item of data.
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.
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 Sort By Cell Color
Sort data by cell color in Excel 2007. Included is a step by step example of how to sort data by cell color in Excel 2007.
Sort data by cell color in Excel 2007. Included is a step by step example of how to sort data by cell color in Excel 2007.
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 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
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.
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 AutoSUM button. This step by step tutorial walks through how to use Excel's SUM function and the AutoSUM 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 AutoSUM button. This step by step tutorial walks through how to use Excel's SUM function and the AutoSUM feature to perform spreadsheet calculations.
Data List in Excel
Create the list Once the data has been entered into the table, it can be converted to a list . To do
Create the list Once the data has been entered into the table, it can be converted to a list . To do
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.
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.
Shortcut Keys Add the Current Date
This Excel shortcut keys tutorial shows you how to quickly add the current date to a worksheet using just the keyboard.
This Excel shortcut keys tutorial shows you how to quickly add the current date to a worksheet using just the keyboard.
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 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.
Cell
: In any spreadsheet program such as Excel, each rectangular box is referred to as a cell. A cell is
: In any spreadsheet program such as Excel, each rectangular box is referred to as a cell. A cell is
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.
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 reduce a value to a specific number of decimal places. This tutorial includes a step by step example of rounding numbers in Excel with the 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 reduce a value to a specific number of decimal places. This tutorial includes a step by step example of rounding numbers in Excel with the ROUND 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 2007 Custom Footer
In Excel 2007, a footer can be used to add descriptive information to every page in the spreadsheet. A custom footer can be used to include such things as company information, a spreadsheet title, or spreadsheet author.
In Excel 2007, a footer can be used to add descriptive information to every page in the spreadsheet. A custom footer can be used to include such things as company information, a spreadsheet title, or spreadsheet author.
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.
Excel 2007 VALUE Function
The VALUE function, one of Excel's text functions, is used to convert text to numbers. 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 numbers. Doing so allows them to be used in calculations. This article includes an example to walk you through using Excel's VALUE function.
Excel Range Name Overview
Using a Range Name in a formula can make it easier to copy that formula to other cells in the worksheet. This tutorial gives an overview of using a range name in an Excel formula.
Using a Range Name in a formula can make it easier to copy that formula to other cells in the worksheet. This tutorial gives an overview of using a range name in an Excel formula.
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 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.
Excel RIGHT Function
The RIGHT function is used to truncate text strings in Excel by removing unwanted characters from the right side of a data entry. This tutorial includes an example of truncating a text string using Excel's RIGHT function.
The RIGHT function is used to truncate text strings in Excel by removing unwanted characters from the right side of a data entry. This tutorial includes an example of truncating a text string using Excel's RIGHT function.
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.
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 2010 AVERAGEIF Function
The AVERAGE IF 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 AVERAGE IF 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.
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.
Hide the Ribbon in Excel 2007
In Excel 2007 the Ribbon , which has replaced the menus and toolbars found in earlier versions of Excel,
In Excel 2007 the Ribbon , which has replaced the menus and toolbars found in earlier versions of Excel,
Conditional Formatting Dates
This tutorial covers how apply conditional formatting for dates in Excel. The tutorial includes an example of using conditional formatting for dates in Excel.
This tutorial covers how apply conditional formatting for dates in Excel. The tutorial includes an example of using conditional formatting for dates in Excel.
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'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 MOD Function
The MOD function, one of Excel’s math functions, is used to divide numbers in Excel. All it returns is the remainder. This tutorial includes a step by step example of using the MOD function in Excel.
The MOD function, one of Excel’s math functions, is used to divide numbers in Excel. All it returns is the remainder. This tutorial includes a step by step example of using the MOD 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 Formatting Tutorial Pt 2
Naming a range in Excel spreadsheets speeds up the process of creating formulas.
Naming a range in Excel spreadsheets speeds up the process of creating formulas.
NETWORKDAYS Function
The NETWORKDAYS function can be used to count the number of working days between two dates in Excel. This tutorial includes a step by step example of using the NETWORKDAYS function to count days between two dates in Excel .
The NETWORKDAYS function can be used to count the number of working days between two dates in Excel. This tutorial includes a step by step example of using the NETWORKDAYS function to count days between two dates in Excel .
Excel 2007 VLOOKUP Array
Excel VLOOKUP Array Overview. This tutorial includes a step by step example of how create a VLOOKUP array formula in Excel.
Excel VLOOKUP Array Overview. This tutorial includes a step by step example of how create a VLOOKUP array formula in Excel.
Syntax
: The syntax of an Excel function refers to the layout and order of the function and its arguments .
: The syntax of an Excel function refers to the layout and order of the function and its arguments .
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.
Excel 2010 MATCH Function
The MATCH function finds the position of specified data in a selected range of cells in an Excel worksheet. This tutorial includes a step by step example of using the MATCH function in Excel to find the position of specific data.
The MATCH function finds the position of specified data in a selected range of cells in an Excel worksheet. This tutorial includes a step by step example of using the MATCH function in Excel to find the position of specific data.