Articles Index
Excel 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.
Unhide Rows in Excel
This tutorial shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.
Excel CONCATENATE Function
The CONCATENATE function is used to join two or more words or text strings together. This tutorial includes a step by step example of using Excel's CONCATENATE function.
Find Above or Below Average Numbers in Excel
Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells based on the data entered into the cell(s). This tutorial includes an example of using conditional formatting to find above and below average values.
Excel 2003 Conditional Formatting
This tutorial shows you how to use conditional formatting to find above and below average numbers in Excel. A step by step example is included.
Select All Cells in Excel
This Excel tip covers how to select all cells in Excel using a keyboard shortcut.
Apply Number Formatting
This Excel shortcut keys tutorial shows you how to quickly applying number formatting to selected cells using just the keyboard.
Apply Currency Formatting
This Excel shortcut keys tutorial shows you how to quickly applying currency formatting to selected cells using just the keyboard.
Insert Columns to Excel Worksheets
This tutorial shows you how, with a click of the mouse, you can easily insert additional columns to Excel worksheets.
Insert Rows into Excel Worksheets
This tutorial shows you how to easily insert rows into an Excel worksheet
Excel PRODUCT Function
Multiplying numbers in Excel can be done with the PRODUCT function. This tutorial shows you how to use the Product function to multiply numbers in Excel.
Excel AVERAGE Function
Excel's AVERAGE function can be used to find the average value, or arithmetic mean, of values in a selected range of cells.
Excel MEDIAN Function
The MEDIAN function gives you the middle value from a list of numbers. This tutorial includes a step by step example to walk you through using Excel's MEDIAN function.
Excel 2007 MODE Function
The MODE function shows you the most frequently occurring value in a list of numbers. This tutorial includes a step by step example of using Excel's MODE function.
Excel MODE.SNGL Function
The MODE.SNGL function in Excel shows you the most frequently occurring value in a list of numbers. This tutorial includes a step by step example of using Excel's MODE.SNGL function.
Excel FLOOR Function
Excel's FLOOR function can be used to round numbers down to the nearest multiple of a specified value such as the nearest one tenth or one one hundredth. A step by step example is included with this tutorial.
When the TRIM Function Doesn't Work
In certain circumstances the TRIM function remove extra spaces from a text entry. This tutorial covers an alternative for removing extra spaces between data in Excel.
Excel MAX IF Array Formula Tutorial
By combining the MAX and the IF functions in an array formula in Excel, we can find the largest or maximum value for a range of data when a specific criterion is met. A step by step example is included on how to create a MAX IF array formula.
Excel MEDIAN IF Array Formula Tutorial
By combining the MEDIAN and the IF functions in an array formula in Excel, we can find the middle value for a range of data when a specific criterion is met. A step by step example is included on how to create a MEDIAN IF array formula.
Excel SUMPRODUCT Count Cells
The SUMPRODUCT function in Excel can be used to count the number of cells containing data that meets one or more criteria. This tutorial includes a step by step example.
Type on Multiple Lines in a Single Cell
This Excel shortcut keys tutorial shows you how to wrap text on to multiple lines in a single cell in a worksheet.
Excel RANDBETWEEN Function
Rather than getting any random number the RANDBETWEEN function lets you specify a range between two numbers it is to select from.
Random Numbers in Excel
Generate random numbers in Excel using the RAND function. This tutorial includes a step by step example.
Unhide Columns in Excel
This Excel shortcut keys tutorial shows you how to quickly unhide columns in Excel using just the keyboard.
Excel MOD Function
The MOD function, is used to divide numbers in Excel. All it returns, however, is the remainder. This tutorial includes a step by step example of using the MOD function in Excel.