QuickTips Index - page 2

Unhide Rows in Excel
This Excel tip covers how to unhide rows in Excel using a keyboard shortcut.

Hide Columns in Excel
This Excel tip covers how to hide columns of data in Excel using a keyboard shortcut.

Formatting the Date
This Excel tip covers formatting the date (day, month, year format) in Excel using a keyboard shortcut.

Adding the Current Time
This Excel tip covers adding the current time to Excel using a keyboard shortcut.

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

How to Divide 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.

Nested IF Functions in Excel
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.

Using the IF Function to 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.

Using the IF Function to Enter 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.

Leaving Blank Cells 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.

Performing Calculations with the Excel 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. This article covers using the IF function to perform calculations on spreadsheet data.

Changing Excel 2003's Default Chart Type
If you don't like the default Excel chart type you can change it. With to change the default chart type in Excel.

Create a 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.

How to Add in Excel
How to add in Excel is a quick tip that shows you how easy it is to add numbers in Excel.

Custom Excel Graph
This article covers creating a custom Excel graph. 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 graph.

Add and Delete Columns and Rows in Excel
This article shows you how, with a click of the mouse, you can easily add or delete rows and columns in Excel.

Logic Function 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.

One Touch Excel Charts
You can create an Excel Chart with one keystroke. If you ever need a chart in a hurry or you just want to check on certain trends in your data, you can quickly create a chart in Excel that uses all the default chart settings.

Show Excel Toolbars on Two Rows
The default setting for Excel toolbars is to display them on a single row, thereby hiding many of the toolbar buttons. It is quite easy to change the default settings to show Excel toolbars on two rows, making for a easier time formatting your spreadsheet.

1 | 2