Pages

Thursday, August 2, 2012

Excel - How to find cells having Conditional Formatting

In my last excel tutorial we have seen how to use Conditional Formatting feature with some examples. Now in this one we are going to talk about how to find worksheets/ cells that are already having Conditional Formatting. For various reason, we may want to know if an excel worksheet or a range of cells having already defined Conditional Formatting. We may want to apply some basic formatting, want to add new Conditional Formatting or modify existing Conditional Formatting.

One option is to use ‘Find & Select’ option another is to use ‘Manage Rule’ option from Conditional Formatting drop down. Check out the video tutorial for details of these two options.


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.