Some Useful Excel Tips :-)

Excel 2254 views 7 replies
User Avatar

MBA (Finance) B.Com.(P)
3443 Points Joined March 2007

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
4 Reply Share Follow
On 26 May 2010 at 17:39 Report
Replies (7)
User Avatar

Nagari Sultanpur U.P.Delhi
15155 Points Joined March 2007

Nice collection

Reply
On 26 May 2010 at 17:45
User Avatar

CHARTERED ACCOUNTANT
16295 Points Joined January 2010

Thanks

Reply
On 26 May 2010 at 18:52
User Avatar

Finalist
35929 Points Joined September 2009

really awesome post

Reply
On 26 May 2010 at 20:44
User Avatar

Finalist
35929 Points Joined September 2009

your contribution is added:

 

Community Resources

 

Resource Title Where it is

Some Useful Excel Tips :-)

 Forum
USEFUL LINKS PART 2 Forum
All May 2010 Exam Q papers at one Place Forum
CFA all Notes Collection Forum
Knowledge Resource(Various Law Primers) Forum
List of Useful Websites. Forum
IMPORTANT WEBSITES TO DOWNLOAD NOTES Forum
how to prepare audit in less time? Forum
EXECUTIVE PROGRAMME CS STUDENT KIND ATTN PLEASE Forum
PGBP NOTES HELPFUL FOR ALL Forum
Reply
On 26 May 2010 at 20:47
User Avatar

Tax Consultant
1596 Points Joined February 2009

nothing new !!!

Reply
On 27 May 2010 at 07:50
User Avatar

Still Learning
163 Points Joined January 2010

akash bhai.... aap bahut gyani ho... shayad...

 

i think this is awsome post.... i like all of them..... really really helpful....

 

thanks praveen jee..

 

:-)

Reply
On 27 May 2010 at 15:25
User Avatar

CMA*CA*CMDM*ast FUND MANAGER*LEGAL ADVIS
14938 Points Joined January 2009

TNQ

Reply
On 15 July 2010 at 22:58


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading