Pages

Sunday, July 8, 2012

Excel Conditional Formating - Easy Examples

This is a tutorial about excel Conditional Formatting. We will talk about what is Conditional Formatting, when to use it and then we will see some simple examples. Microsoft Excel is great tool which can handle tons of data but where you have so many data it is difficult to find some specific data quickly. Conditional Formatting is a very useful feature of excel which can help you in such cases by making your specific data stand out visually for easy and quick identification.

Check the video tutorial for more details about Conditional Formatting in excel. If you have any question I will be happy to assist you. Please use the comment section below to share your question, comment and suggestion.


Tuesday, June 5, 2012

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.


Monday, May 21, 2012

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.


Tuesday, May 1, 2012

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.

Wednesday, April 25, 2012

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.