Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003


Microsoft Excel 2003 Functions and Formulas

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

- Subscribe!

Search the Site: