Excel Formula IF and Nested IF

This is a tutorial about excel function IF and nested IF. 'IF' is one of the very commonly used important formula which can be used for simple calculation to very complex calculation. 'IF' formula can be used within another 'IF', which is called nested 'IF'. Also it can be used with other excel functions like AND, OR, MAX, MIN etc.

Check the video tutorial for more details about 'IF' formula 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.

Windows 7 Aero Shake & Aero Snap

This video is about how to use Aero Shake and Aero Snap in Windows 7. Aero Shake is a Windows 7 feature to minimize open windows quickly to the task bar. The windows button and “D” on key board is used to minimize all open windows to the task bar where as Aero Shake is useful to minimize all windows except the one user wants to focus having a clean view to the window.  On the other than Aero Snap is useful to compare contents in 2 windows side by side easily. Using this feature, one window can be fixed nicely at the right half of the display and another one at the left half of the display for visual comparison. 

This tutorial will be helpful for someone who is new to Windows 7. These features can help you to save time while working with Windows 7. Check the video tutorial to find out details about Aero Shake and Aero Snap. 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 AVERAGE MAX MIN COUNT

In this tutorial we will see how take average of a set of numbers, find out maximum number out of a set of numbers, find out minimum number out of a set of a numbers and count numbers. We can do these using some basic excel formula which are AVERAGE, MAX, MIN and COUNT.

Check the video tutorial for more details about these formula. 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 Aero Peek

This video is about how to use Aero Peek in Windows 7. Aero Peek is a Windows 7 feature designed to improve your experience with interface when there are multiple windows open. It can save your time if you know how to use it. Aero Peek helps you to get to a specific open window or running application quickly by providing better visibility to what you have open and running.

Check the video tutorial to find out details about Aero Peek in Windows 7 which includes Show Desktop, Quick View from task bar and 3D view of all windows. 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 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.