Excel Tips

1. Capitalizing Just a Surname
2. Excel Tip : Calculating the Last Day in a Week Number
3. Excel Tip : Displaying Negative Percentages in Red
4. Excel Tip : Jumping to Alphabetic Worksheets
5. Excel Tips - Data Entry Tips
6. Excel Tips - MS Excel for Accountants
7. Excel Tips : - Creating a CSV File
8. Excel Tips : - Random Numbers in a Range
9. Excel Tips : An Average that Excludes Zero Values
10. Excel Tips : Auto Filling with Weekdays
11. Excel Tips : Avoiding Rounding Errors in Formula Results
12. Excel Tips : Contextures -- Excel Keyboard Shortcuts
13. Excel Tips : Delete duplicate rows from a list in Excel
14. Excel Tips : Entering Dates in Excel
15. Excel Tips : Hash Marks Displayed Instead of Cell Contents
16. Excel Tips : Hiding Errors on Printouts
17. Excel Tips : Leap Years and Fiscal Periods
18. Excel Tips : Massive Printouts
19. Excel Tips : Quickly Entering Data - New !!
20. Excel Tips : Reversing Cell Contents
21. Excel Tips : Selecting an Entire Worksheet
22. Excel Tips : Sending Just a Worksheet via E-mail - New !!
23. Excel Tips :- Sort By Colour in Excel 2003
24. Excel Tips :- Displaying a Number as Years and Months
25. Excel Tips :- Inserting Video into Worksheets
26. Excel Tips :- Replacing Links with Values
27. Excel Tips :- Using VLOOKUP to Access Information to the Left
28. Excel tip : Getting Rid of Empty Rows after Importing
29. Shading a Cell Until Something is Entered
30. Useful Macros
31. Very Useful & Innovative Excel Tip : Using Your Own File Extensions
32. [Excel Tips] Replacing Links with Values