Articles Index
Entering Data 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.
Excel Conditional Formatting Date Formula
Using formulas to customize conditional formatting rules in Excel. This tutorial uses a date formula and conditional formatting to highlight past due dates. A step by step example is included.
Create a Pictograph in Excel
In a pictograph, pictures replace the colored columns or bars in a regular column chart or bar graph. This step by step tutorial shows you how to create a pictograph in Excel.
Excel Conditional Formatting Data
Conditional formatting allows you to emphasis data that meets certain conditions - such as equal to, greater than, or less than - that you set. If the data meets the set conditions, formatting options - such as changing cell or font color - are activated, This tutorial includes a step by step example.
Excel SUM OFFSET Formula Tutorial
By combining Excel's OFFSET function with the SUM function you can create formulas that will find totals for dynamic ranges of data. This tutorial includes a step by step example.
Excel LOOKUP Function Tutorial
The Excel MATCH function finds the position of specified data in a selected range of cells. This tutorial includes a step by step example of using the MATCH function in Excel to find the position of specific data.
Excel OFFSET Function Tutorial
Excel's OFFSET function can be used to refer to the location of specific data in an Excel worksheet. The function is usually combined with other functions to create more complex formulas such as SUM, COUNT, and MATCH. This tutorial includes a step by step example.
Excel MATCH Function Tutorial
The Excel MATCH function finds the position of specified data in a selected range of cells. A step by step example is included with this tutorial.
Excel ROW Function Tutorial
The Excel ROW function can be used to either find the row number for the cell where the function is located in the worksheet or find the row number for a given cell reference. A step by step example is included with this tutorial.
Excel COLUMN Function Tutorial
The Excel COLUMN function uses include finding the column number for the cell where the function is located in the worksheet or finding the number for a column of a given cell reference. A step by step example is included with this tutorial.
Excel Data Validation List 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 MODE.MULT Function Tutorial
The MODE.MULTI function - first available in Excel 2010 - can be used to find out if there are multiple values - or multiple modes - that occur most frequently in a range of data. This tutorial includes a step by step example of using the MODE.MULT function.
Calculate a Project End Date in Excel
The NETWORKDAYS.INTL function can be used to calculate the number of days between two dates in Excel. A step by step example is included with this tutorial.
Calculate a Project End Date in Excel
The NETWORKDAYS.INTL function can be used to calculate the number of days between two dates in Excel. A step by step example is included with this tutorial.
Calculate a Project End Date in Excel
Use Excel's WORKDAY.INTL function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example of how to find the start or end date of a project given a set number of work days using the WORKDAY.INTL function.
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 FLOOR Function
The FLOOR function is used to round a number downwards to a set number of significant digits. This tutorial includes a step by step example of using the FLOOR function in Excel.
Excel VLOOKUP Array Formula Tutorial
How to create a VLOOKUP array. This tutorial includes a step by step example of how create a VLOOKUP array formula in Excel.
Excel INDEX Function - Array Form
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.
Excel EVEN Function Tutorial
The TODAY function, one of Excel's date functions, 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 to add today's date to a spreadsheet.
Excel ODD Function Tutorial
The TODAY function, one of Excel's date functions, 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 to add today's date to a spreadsheet.
Sum Data in Excel Using Shortcut Keys
This Excel shortcut covers how to save an Excel file using a keyboard shortcut. This tutorial includes instructions on how to save an Excel file using a keyboard shortcut.
Excel CODE Function Step by Step Tutorial
The Excel MATCH function finds the position of specified data in a selected range of cells. This tutorial includes a step by step example of using the MATCH function in Excel to find the position of specific data.
Excel CHAR Function Step by Step Tutorial
The Excel MATCH function finds the position of specified data in a selected range of cells. This tutorial includes a step by step example of using the MATCH function in Excel to find the position of specific data.
Excel DMIN Function Tutorial
The DMAX function is one of Excel's database functions. It is used to find the largest or maximum number in a database or table of data. A step by step example is included in this tutorial.