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

 

Home > Excel Help Portal > Using Excel Formulas

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

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. Increment a Hour/Minute String
  2. Extract Info from Text File
  3. Limitations of the Break Links Command
  4. Sum the largest values in a range
  5. Changing #N/A to "Your Response" text
  6. Compare List and Insert if Not Found
  7. OverPunch Code
  8. Count Occurences in String
  9. Changing grades (in numeric format) to Letter Grades
  10. Adding every other cell in a column
  11. Thai Bhat currency
  12. Perform math operations without formulas
  13. Multiple Page Numbers
  14. Perform two-way table lookups
  15. How to calculate the nth Root of a Number in Excel 2000
  16. Removing text-string characters
  17. Add today's entries to the next empty row on a master sheet
  18. Unlink a chart series from its data range
  19. CountIf or Sumif with two conditions
  20. Finding an average between two data sets
  21. Keeping a running total in an adjacent column
  22. Determine Years, Months, & Days between 2 Dates
  23. Automatically add a character in a cell
  24. Color Unlocked Cells
  25. Trap Those Errors
  26. Custom Dialogs
  27. Change cell values using Paste Special
  28. Returning specific data on examining a range
  29. Hiding a range depending upon user selectons
  30. Button Editor Addin
  31. Excel Code Examples
  32. Trapping VBA Errors {Part 2}
  33. Learn How to Add Running Totals to a Worksheet
  34. Returning Zero instead of #N/A
  35. Using Ubound
  36. Referencing a sheet indirectly
  37. Add a percentage to all cells in a range
  38. Counting distinct entries in a range
  39. Trapping Errors
  40. Change Case to Mixed
  41. Increment a Counter everytime a Userform is opened
  42. Add a Single Quote
  43. Broken lines
  44. Write Contents of Multi Choice Box
  45. Excel -- Named Ranges
  46. Move the Minus Sign to Front
  47. Convert Text to Numbers
  48. Four Methods of Adding Totals to a List
  49. Add Data to Next Row
  50. Data Validation

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

 Home              
 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 - 2008 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?