Excel Spreadsheet Applications and Tips



Time saving practices in Excel for beginners   Applications and Tips (Excel)

Working with MS Excel is very easy and fun for those familiar with available options and functions. But for the others it is a  hard job. 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 the field. Many people in the beginning used to have this experience using Excel that the same job that was finished 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. Many people even do not care for implementing new learnt techniques in work. 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 aim to 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 when 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 - So many people 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.


  How to calculate interest rate in Excel for a one time deposit?
How to copy or drag down a condition in Conditional formatting?
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  18 April 2017

Copyright 2012  Nitha