Excel Formula SUBTRACT DIVIDE MULTIPLY

In my last excel tutorial we talked about how to add numbers in excel; now in this tutorial we will see how subtract, divide and multiply in excel. These basic excel formulas are very simple but as usual they takes part in complex formulas. So it is important to know how these basic formulas works in excel.

At high level these are topics covered in this tutorial:

• Direct formula where operands are directly typed in the formula
• Formula by reference, reference of cells are used with the formula to indicate operands
• Subtraction
• Division
• Multiplication
• How order of operation is used in excel

Check the video tutorial for more details about above topics. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion.

Windows 7 Recent Items (How to delete history of recent documents)

Recent Items are different files/ documents available from a quick list of the Start Menu. This is useful to locate a recently browsed file easily and we can avoid browsing the file through folder structure.

Different topics that are covered in this tutorial are:

1. What is Recent Items?
2. Where is the Recent Items option located?
3. How to use Recent Item option?
4. Hide/ unhide the Recent Item option.
5. How to delete history of recent items in windows 7

Check this video tutorial for more details of Recent Items. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion.

Excel Formula SUM (How to add in Excel)

In this tutorial it is described how to add numbers in Excel. An excel formula SUM is used to add numbers. Also there are two other ways are shown for addition in Microsoft Excel. At the end I have shown a common issue while adding numbers and the resolution for the same with a good example.

Check the video tutorial for more details of Excel basic formula SUM(). If you have any question I will be happy to assist you. Please use the comment section to share your question, comment and suggestion.

Temporary file folder in Windows 7 (disk cleanup/ delete temp files)

If you are running out of disk space, your computer is running slow or responding late; first thing you may want to check is disk space used by different temporary folders. Sometime temporary folders grows up too much and takes multiple GB of size. So it is better to clean up temporary folders periodically. You can do this manually by your own or using different utilities.

This tutorial will help you to understand what these temporary file folders are and how to clean them manually. Different topics that are covered in this tutorial are:

1. What is temporary file folder?
2. Why to delete Temporary files?
3. Is it safe to delete Temporary Files?
4. Different Temporary folders in Windows 7
5. Location of Windows Temporary folder
6. Location of Application Data Temporary folder
7. Location of Internet Temporary folder
8. How to delete temporary files
9. Other Options - utilities to delete temporary files like Disk Cleanup, CCleaner etc 

Check this video tutorial for more details of temporary file folder in Windows 7. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion.

 

Excel - Number Format

This tutorial is to talk about Number Format in Microsoft Excel. Different number format discussed about are General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific and Text.

In this video, the difference between Currency and Accounting formatting is explained with a good example. Also there is a tip about how to convert numbers in text format for arithmetic calculations.

Check this video tutorial for details of Number Format in excel. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion.