|  

» 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 Summing the Last N Values in a Column
Delete Tip from MyTips Prevent Unauthorized Opening of Workbook
Delete Tip from MyTips Changing the Number Formatting in Excel 2007
Delete Tip from MyTips Format table depending on number formats using VBA in Microsoft Excel
Delete Tip from MyTips Deleting a Name when the Reference containing an Error or an Orphan Name in Excel 2007
Delete Tip from MyTips Adding a Picture to a Header/Footer
Delete Tip from MyTips Calculating the Difference Between Hours
Delete Tip from MyTips Finding the maximum value of all those meeting a certain criteria.
Delete Tip from MyTips Auto-complete data
Delete Tip from MyTips SHEETS function
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout
Delete Tip from MyTips Create Conditional Formula
  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. Using Loops in VBA in Microsoft Excel
  10. Avoiding Errors When Counting Date Values That Meet Specified Criteria
  11. Adding the Page Setup Icon to the Excel Menu Bar
  12. Checking For Duplicate Values Within A Range
  13. Quickly Printing a Page from the Workbook Using a Custom View
  14. Retrieving Unique Values From A List
  15. Create an Amortization Schedule in Microsoft Excel
  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