|  

» My Bookmarked Tips

My Tips is a feature that allows you to bookmark your favorite tips on our website. Simply click on the icon when viewing a tip to bookmark it.

. You may later access the bookmarked tips by clicking on the My Tips tab.
. The tips will be bookmarked for all future visits to our website.


Delete Tip from MyTips Separating Positive and Negative numbers and add Running Balance column
Delete Tip from MyTips Removing Personal Information from a Workbook
Delete Tip from MyTips NUMBERVALUE function
Delete Tip from MyTips Calculating the Number of Weekday Hours between Two Dates
Delete Tip from MyTips Format table depending on number formats using VBA in Microsoft Excel
Delete Tip from MyTips Validating Number Entries
Delete Tip from MyTips Changing the Default Auto-Save File Location in Excel 2007
Delete Tip from MyTips Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match
Delete Tip from MyTips Changing the Default Style
Delete Tip from MyTips Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
Delete Tip from MyTips Hiding Errors in Cells Before Printing
Delete Tip from MyTips Avoiding Negative Values when Calculating the Number of Days between Two Dates
  To delete a tip, simply click on the trash icon of the tip you wish to remove




  1. Retrieving an Item from a List that Meets Multiple Criteria
  2. Simplifying Formulas by Reducing the Complexity of IF Functions
  3. Printing Cell Comments
  4. Writing Your First VBA Function in Excel
  5. Retrieving Values Using Range Names as References
  6. Creating a Timesheet
  7. The Best Shortcut Keys in Microsoft Excel
  8. Adding Time Values from Separate Hours and Minutes Columns
  9. Avoiding Errors When Counting Date Values That Meet Specified Criteria
  10. Using Loops in VBA in Microsoft Excel
  11. Adding the Page Setup Icon to the Excel Menu Bar
  12. Checking For Duplicate Values Within A Range
  13. Create an Amortization Schedule in Microsoft Excel
  14. Retrieving Unique Values From A List
  15. Quickly Printing a Page from the Workbook Using a Custom View
  16. Retrieving Every nth Value In a Range
  17. Formulas to calculate Loan payments in Microsoft Excel
  18. Ranking Salespeople According To Sales Figure
  19. Counting the Number of Cells Containing Text
  20. Calculating the Week Number Corresponding with a Specific Date

Excel 2007 Tutorials

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation