For business users of Microsoft Excel.
For business users of Microsoft Excel.

 

Home > Excel Help Portal > Using Excel Formulas

<<  (Page 3)  Previous              Next  (Page 5)  >>

Using Excel Formulas


The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to use Microsoft
Excel formulas.

  1. Help using Excel spreadsheet functions - vlookup, isna, match
  2. How to Use the INDIRECT Function to Create References
  3. How to Restrict Numeric Entry to Only One Cell in a Range
  4. Excel Frequency function
  5. How to Use Data Validation to Prevent Duplicate Entries
  6. Days of the Week Before March 1, 1900 Are Incorrect
  7. Displays a Tooltip with Duplicate of Number in DDE Link
  8. How to Use the INDEX Function to Find Data in a Table
  9. How to use Functions in Formulas in Excel 2000
  10. How to force Excel to Always Reference the Same Cell in Excel 2000
  11. How to Create a Conditional Format to Hide Errors
  12. Excel -- Combining Data
  13. Custom Function Returns #VALUE! If Returning Array Larger Than 5,461 Elements
  14. An Overview of Data Tables in Microsoft Excel
  15. InputBox and MsgBox
  16. Excel Filters -- Advanced Filter -- Complex Criteria
  17. #REF! Error Recalculating Worksheet with Defined Name
  18. How to work with Serial Number Dates and Julian Dates in Microsoft Excel 2000
  19. Using Data Validation to check for repeated values
  20. The Excel DATEDIF function
  21. How to preserve Formulas If You Save a Document As a Text File in Excel 2000
  22. How to Change the Case of Text
  23. Excel -- Pivot Tables -- GetPivotData
  24. "Do You Want to Save the Changes You Made to { ?" in French Excel 2000
  25. Names
  26. An Excel VBA macro and button to select another workbook
  27. How to suppress #DIV/0! Error Value in Division in Excel 2000
  28. How to use the Error Checking Options Button in Excel 2002
  29. Color, Sorting on Color
  30. Help using Excel database functions
  31. Custom Function to Average a Range Without Highest and Lowest Values
  32. Move, Copy, Replace, Populate
  33. How to sort Cells Without Sorting Linked Cells in Excel 2000
  34. How to Force MS Excel to Always Reference the Same Cell
  35. Excel -- Data Validation -- Use List from Another Workbook
  36. Excel -- Data Entry
  37. How to Suppress #DIV/0! Error Value in Division
  38. How to Break Links Between a Chart and a Worksheet
  39. Excel site index
  40. How to use Shared Workbooks with Different Versions of Excel, Including Excel 2000
  41. Cannot Suspend Computer with Windows 2000 Offline Files Open
  42. How to Preserve Formulas When Saving as a Text File
  43. A macro to fill in blank rows
  44. Error Message: The Document Caused a Serious Error the Last Time It Was Opened
  45. Delete Links Wizard Available
  46. Excel -- Data Entry -- Fill Blanks
  47. Parameter Query Does Not Refresh Automatically
  48. Determine Parse Position
  49. How to Sort Cells Without Sorting Linked Cells
  50. Displaying AutoFilter criteria

<< (Page 3)  Previous              Next  (Page 5) >>

 Excel User's Home
 ExcelUser Blog      
 Site Map              
 Contact              
 Excel for Business
 Excel Dashboards   
 Excel Solutions   
 Exploring Excel   
 BI for Excel    
 Business Tools   
 Excel Catalog   
 Affiliate Program   
 Excel Help Portal
 
   
     
   
     
 

ExcelUser, Inc.
http://www.ExcelUser.com

Copyright © 2004 - 2009 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.

 


What's your greatest Excel challenge?