Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

»Recommended Microsoft Excel Tips

  1. Extracting Characters from Text Without Using Formulas

  2. Rounding Numbers to Thousands with Hundreds as a Decimal

  3. Vlookup Formula – Organizing the Data Table

  4. Joining text using formula in Microsoft Excel

  5. Rounding Numerical Substrings

  6. Opening a template file automatically upon starting Microsoft Excel

  7. Selecting a Column(s) or Row(s) Using Keyboard Shortcuts

  8. Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003

  9. Adding a Custom Keyboard Shortcut

  10. Applying Colors to Maximum/Minimum Values in a List

  11. Moving the Chart to a Different Place in the Sheet in Microsoft Excel

  12. Disregarding blank cells when performing calculations on a range.

  13. Totaling Time Values

  14. Add a cell, Row or a column in Microsoft Excel

  15. Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.

  16. Avoiding Problems when Numeric Values are used as Text

  17. Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell

  18. Adding the full path of the saved file to headers and footers in Microsoft Excel 2002 xp

  19. Create and Add a Function for Reversed Text Characters in Microsoft Excel

  20. Adding the Camera icon to the toolbar in Microsoft Excel

  21. Copying the Subtotals Summary

  22. Combining Text from Different Cells

  23. Calculating the Average for Numbers Meeting Specified Criteria

  24. Reversing The Order Of Values In A List

  25. Ranking Numbers in a Dynamic List

  26. Displaying the serial number behind Date format in Microsoft Excel

  27. Rounding Numbers to Millions with Thousands as a Decimal

  28. Separating a Number Into Digits

  29. Moving Between Precedent and Dependent Cells

  30. Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel

 

Sponsors:

Convert PDF Files to Excel


Recommended Books:


Related MS EXCEL TIPS:








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