Excel Spreadsheet Applications and Tips

Home

 

 

Time saving tips in Excel for beginners

   

Working with MS Excel is very easy and fun for those familiar with the tools and functions, but it is a hard job for others. Knowing the applications and tips in Excel can have a cascading effect on the time saving at work. Likewise not knowing them means you are losing productivity in spite of valuable experience and knowledge in your field. Several people in the beginning used to have this experience using Excel that the same job that was completed after spending an hour or two were able to be completed in a matter of minutes after implementing some new techniques. By learning new tips you can combine various  applications which again helps to reduce the time spending at work. Several people even do not care for implementing the new learnt techniques in their work place. Instead it should be made a practice that a new technique is learnt and implemented every day. Through this website we are offering some good practices and also a number of tips and tricks which can help improve your efficiency at work place.

We also provide useful articles on all commonly used office applications and general subjects in addition to MS Excel.

  How to combine multiple cells without losing data?
  How to truncate fractions and convert decimals to whole numbers?
  How to change the width of multiple columns?
  How to change the height of multiple rows?
  Solving equations using Excel.
  How to filter data in MS Excel?
  Sum does not appear in status bar.
  Filter function does not work properly in MS Excel.
  Editing links to other work sheets.
  How to solve if excel do not filter blank cells?
  How to delete all spaces in a selection?
  How to copy and paste only non blank cells in Excel?
Some good practices while using MS Excel
  Ctrl + Shift + Down not working properly in MS Excel
1. Do not unnecessarily merge cells to create space. Use drag function instead.
  Ctrl + Down arrow not working properly in MS Excel
2. Try to reduce size of files so that working becomes easy.
  How to correct #NA error in vlookup function - MS Excel?

3. To search within a file - Several users do not know that there is an option to search the work book instead of just the work sheet. Try to search within the workbook instead of going to each work sheet and searching.

More

  How to calculate interest rate in Excel for a one time deposit?
How to copy or drag down a condition in Conditional formatting?
More
     
     
Other articles

How to embed pictures in email?

How to import emails from sent items folder in webmail to MS Outlook?

How to search exact string within a file in Windows 7?

How to show all subfolder contents through search function in Windows 7?

How to access mobile internet in PC/Laptop?

What are the differences between Primavera and MS Project?

What is difference between snow and cloud?

What is TOR Steel?

How to stop music player autostart in Android devices when phone connects to car's bluetooth device?

Why mobile internet is not working in my android phone?

Safe driving tips

What are the differences between ASTM, AASHTO, ACI and ANSI?

Last updated on  05 May 2017

Copyright 2012  Nitha