Microsoft Excel 2003 Functions and Formulas
Help and Tips

#1: Spreadsheet Modification Slow - Switch to Manual Calculation
Speed up slow Microsoft Excel 2003 spreadsheets by only calculating formulas manually, not in the background.
 
#2: 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.
 
#3: Installing the Analysis ToolPak Add-In
Install support in Microsoft Excel 2003 for advanced analytical operations.
 
#4: Generate Random Numbers
Use the RANDBETWEEN function instead of RAND to more easily generate random numbers in your Microsoft Excel 2003 spreadsheet.
 
#5: Display the Most Common Value in a Series
This Excel 2003 function calculates the most frequent value in a series.
 
#6: Comparing Strings
Use the =exact function to compare strings inside a Microsoft Excel 2003 spreadsheet.
 
#7: Determine the Largest or Smallest Value in a Series
These formulas automatically determine the minimum and maximum values in an Excel 2003 data series.
 
#8: Display Formulas Instead of Their Results
Debug formulas in complex Microsoft Excel 2003 spreadsheets.
 
#9: Wizard to Display and Fix Worksheet Errors
Easily display and fix possible errors in your Microsoft Excel 2003 worksheets.
 
#10: Round Numbers to the Nearest Integer
Round numbers in your Microsoft Excel 2003 spreadsheets to the nearest dollar.
 
#11: 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?
 
#12: Get the Average of a Series
Display the average value of grades, monthly profits, yearly expenses, etc. in a Microsoft Excel 2003 spreadsheet.
 
#13: Switching Between Numbering Systems
Converting numbers in a Microsoft Excel 2003 spreadsheet between decimal, binary, octal, and hexadecimal numbering systems.
 
#14: =IF Function for Value or Calculation Based on Criteria
Perform condition-based tasks depending on cell values in a Microsoft Excel 2003 spreadsheet.
 
#15: Return a Number Without the Negative Sign
Display the absolute value of a number inside a Microsoft Excel 2003 spreadsheet.
 
#16: Convert a Cell's Value to Uppercase or Lowercase
Convert text values inside Microsoft Excel 2003 spreadsheets to uppercase or lowercase.
 
#17: Get the Square Root of a Number
Microsoft Excel 2003's =SQRT function calculates the square root of a value or cell.
 
#18: Check for Errors
Determine if formula result errors exist in your Microsoft Excel 2003 spreadsheets.
 
#19: Return the Remainder of a Division Function
Display the remainder of a division function in Excel.
 
#20: Count Number of Actual Arguments in a Series
Display how many cells inside a series in an Excel spreadsheet actually hold data.
 
#21: Logarithmic Functions
Perform natural, base-10, and base-n log functions in Excel 2003 spreadsheets.
 
#22: Create Internet Hyperlink
Create a web or e-mail hyperlink in your Microsoft Excel 2003 spreadsheet.
 
#23: Using Excel to Convert to Roman Numerals
Need to convert MM to 2000? Use this Excel function.
 
#24: Trigonometric Functions
Use Excel to perform sine, cosine, tangent, and other trigonometric functions.
 
#25: Exponentiation
Two ways to raise numbers to powers inside Microsoft Excel 2003 spreadsheets.
 

Next (26 - 27) ->

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