QuickTips Index

Add Columns to Excel Worksheets
This article shows you how, with a click of the mouse, you can easily add columns to Excel worksheets.

Hide Columns in Excel
This article shows you how, with a click of the mouse, you can easily hide columns in Excel spreadsheets.

Adding/Formatting Borders in Excel 2007
This article shows you how to add and format borders to a spreadsheet. Both the preset and draw borders options are covered. A step by step example of formatting borders is included.

Excel 2007 EDATE Function
The EDATE function can be used to calculate a due date of a project or investment that fall on the same day of the month as the date it was issued. This article includes an example of using the EDATE function to calculate a due date in Excel 2007.

Excel 2007 Negative Number Format
This tutorial covers how to format a negative number in Excel 2007. The tutorial includes a step by step example of how to format a negative number in Excel 2007.

Excel 2003 AVERAGE Function
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.

Using Cell References in Excel Formulas
Cell references describe the location of a cell in an Excel spreadsheet. These cell references can be used in formulas. Excel will calculate the answer for the formula using the data located in the cell.

Excel 2007 AutoFormat
Excel 2007's Autoformat option gives you 17 AutoFormat styles to use to give your spreadsheets a professional look. Instructions on how to apply an autoformat style are included.

Excel 2003 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.

Find an Excel Toolbar
This quick tip shows you how to find and show a toolbar that isn't visible in Excel. Good for finding a toolbar in Excel 97 to Excel 2003.

Customize the Quick Access Toolbar in Excel 2007
The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the autoformat button to the Quick Access Toolbar.

Customize the Quick Access Toolbar in Excel 2007
The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the data form button to the Quick Access Toolbar.

Excel 2003 MIN Function
The MIN function is used to find the smallest or minimum value in a given list of numbers. This article includes an example to walk you through using the MIN function in Excel.

Excel 2003 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.

Excel 2007 HLOOKUP Function
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 walks you through using the HLOOKUP function in Excel 2007.

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.

Date Functions in Excel 2003
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 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.

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.

Count Days Between Two Dates in Excel
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.

Sort By Multiple Columns of Data in Excel
Sort by multiple columns of data using Excel 2007's custom sort feature. Step by step example of how to sort by multiple columns of data in Excel 2007.

Sort Data in Excel 2007
Using Excel 2007's sort feature. Step by step example of sorting data in Excel 2007.

Sort by Date in Excel 2007
Sort by Date using Excel 2007's sort feature. Step by step example of how to sort by date in Excel 2007.

Excel 2007 Conditional Formatting for a Date
This article shows you how apply conditional formatting to a date in Excel 2007. The article includes an example of using conditional formatting for a date in Excel 2007.

Finding Below Average Values with Conditional Formatting
This article shows you how apply conditional formatting to cells in Excel. The article includes an example of using conditional formatting in Excel .