Tips for Spreadsheets

*Microsoft Excel 2003 function and formula help, including writing and debugging functions such as AVERAGE, ROUND, and SUM.*

*** Convert Dollar Amounts to Words**

Convert dollar amounts into their English equivalents.

*** Display Top or Bottom Quarter of a Set**

Use the quartile function to display the max, min, median, or top or bottom 25% of a group of numbers.

*** Determine if a Particular Cell is Blank**

Determine whether or not a particular cell contains any information.

*** Trim Extra Spaces from Text**

Trim extraneous text inside and surrounding text values.

*** Display the Version of Excel**

Display the version of Excel currently used when viewing a spreadsheet.

*** Check if a Value is a Number**

Prevent Spreadsheet errors in Excel 2003 by ensuring entered values are actually numbers.

*** Calculate the Median of a Group of Numbers**

Determine the middle number of a series in an Excel 2003 spreadsheet.

*** Determine the Number of Blank Cells**

Use the countblank function to determine the number of cells in a range that are blank.

*** Combine Strings Together**

Two methods in Excel 2003 spreadsheets for combining strings together.

*** Determine if a Number is Odd or Even**

A quick Excel 2003 worksheet function for determining whether or not a cell value is odd or even.

*** Convert a Cell's Value to Uppercase or Lowercase**

Convert text values inside Microsoft Excel 2003 spreadsheets to uppercase or lowercase.

*** Using Excel to Convert to Roman Numerals**

Need to convert MM to 2000? Use this Excel function.

*** Determine the Largest or Smallest Value in a Series**

These formulas automatically determine the minimum and maximum values in an Excel 2003 data series.

*** Round Numbers to the Nearest Integer**

Round numbers in your Microsoft Excel 2003 spreadsheets to the nearest dollar.

*** Installing the Analysis ToolPak Add-In**

Install support in Microsoft Excel 2003 for advanced analytical operations.

*** Get the Average of a Series**

Display the average value of grades, monthly profits, yearly expenses, etc. in a Microsoft Excel 2003 spreadsheet.

*** Get the Square Root of a Number**

Microsoft Excel 2003's =SQRT function calculates the square root of a value or cell.

*** Return the 2nd Largest or Smallest Value in a Series**

Inside a Microsoft Excel 2003 spreadsheet, need to display the 2nd-highest profit-grossing month of a year, or the 2nd-worst?

*** =IF Function for Value or Calculation Based on Criteria**

Perform condition-based tasks depending on cell values in a Microsoft Excel 2003 spreadsheet.

*** Formula to Sum Up All Values in Column**

Quickly calculate the summed value of all cells in a column of a Microsoft Excel 2003 spreadsheet.

*** Return a Number Without the Negative Sign**

Display the absolute value of a number inside a Microsoft Excel 2003 spreadsheet.

*** Return the Remainder of a Division Function**

Display the remainder of a division function in Excel.

*** Logarithmic Functions**

Perform natural, base-10, and base-n log functions in Excel 2003 spreadsheets.

*** Display the Most Common Value in a Series**

This Excel 2003 function calculates the most frequent value in a series.

*** Generate Random Numbers**

Use the RANDBETWEEN function instead of RAND to more easily generate random numbers in your Microsoft Excel 2003 spreadsheet.

*** Exponentiation**

Two ways to raise numbers to powers inside Microsoft Excel 2003 spreadsheets.

*** Count Number of Actual Arguments in a Series**

Display how many cells inside a series in an Excel spreadsheet actually hold data.

*** Find a Conditional Sum**

Use Microsoft Excel 2003 to find the sum of numbers that meet a certain condition.

*** Create Internet Hyperlink**

Create a web or e-mail hyperlink in your Microsoft Excel 2003 spreadsheet.

*** Switching Between Numbering Systems**

Converting numbers in a Microsoft Excel 2003 spreadsheet between decimal, binary, octal, and hexadecimal numbering systems.

*** Trigonometric Functions**

Use Excel to perform sine, cosine, tangent, and other trigonometric functions.

*** Check for Errors**

Determine if formula result errors exist in your Microsoft Excel 2003 spreadsheets.

*** Comparing Strings**

Use the =exact function to compare strings inside a Microsoft Excel 2003 spreadsheet.

*** Display Formulas Instead of Their Results**

Debug formulas in complex Microsoft Excel 2003 spreadsheets.

*** Spreadsheet Modification Slow - Switch to Manual Calculation**

Speed up slow Microsoft Excel 2003 spreadsheets by only calculating formulas manually, not in the background.

*** Count the Number of Cells That Meet a Condition**

Count the number of cells in a range that meet a specified criterion.

*** Wizard to Display and Fix Worksheet Errors**

Easily display and fix possible errors in your Microsoft Excel 2003 worksheets.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Return to: Microsoft Excel 2003

Search the Site: