Some Useful Excel Tips :-)

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
Replies (7)

Nice collection

Thanks

really awesome post

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

nothing new !!!

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

 

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

 

thanks praveen jee..

 

:-)

TNQ

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details