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.

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.

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.

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.

Hide your Secret Folders or Files in Windows

This tutorial is about how to hide your secret folders or files in Windows. This could be useful if you want to show your computer to someone or someone is using your computer temporarily and you do not want to share your secret folders or files. There are freeware available in the market to do this using different technique. If you do not like to install any of those as some of those freeware may not be safe; there are 2 easy ways you can do it by yourself in Windows:

1. Use hidden folder and hide hidden folders
2. Hide folder name and use blank icon

Check the video tutorial for details of these 2 options. If you know about any other way to do this, please use the comment section and share with everyone.

Excel - Alignment, Merge Unmerge & Wrap Text

This tutorial is to cover different commands available in the Alignment section under home tab of Microsoft Excel. Vertical alignment options top, center, bottom and horizontal alignment options left, center, rights are shown with example. Also use of wrap text, orientation, margin or indentation of data inside cell is covered. Another important thing that is covered in this tutorial in details is merge and unmerge cells. Difference between “Merge & Center”, “Merge Across” and “Merge Cells” is explained clearly with easy example.  

Also at the end there is a “Tip Of The Session” showing how to quickly generate sequential numbers in Microsoft Excel. 

So check this video tutorial for details of Alignment, Merge Unmerge & Wrap Text 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.

Excel Basics - Format Cells - Font and Borders

This is another Microsoft Excel basic tutorial. In this tutorial we can learn about formatting cells using fonts and cell borders. Also at the end of the tutorial there is a useful excel tip.

Formatting cells in Microsoft Excel is very important in order to show data in meaningful way and to provide better presentation. This tutorial will give us idea about how to work with fonts and borders. It shows one of the cool features of Microsoft Excel 2007 and 2010 where we can preview data before applying a font. It also includes how to work with customized cell borders, border colors and border styles along with all predefined borders.

Some hot keys:

Bold : CTRL + B

Italic : CTRL + I

Underline : CTRL + U

So check this video tutorial for the details of font and borders for formatting a cell. If you have any question/ comment/ suggestion; please use the comment section to reach me.

Excel Basics - Cut Copy Paste Special Format Painter

If you are following my tutorials then by now you have an idea about Microsoft Excel interface and templates. Now I am going to start with a series of tutorial to cover basic functions in Microsoft Excel.

In this video I am talking about clipboard section under home tab on the ribbon which has functions like cut, copy, paste, paste special and format painter. I am sure that you already know about cut, copy and paste as this is a very common function of any kind of standard editor. In Microsoft Excel there some additional property of these functions. These additional properties could be useful and can save your time if you know how to use them.   

So check this video tutorial for the details of cut, copy, paste, paste special and format painter. If you have any question/ comment/ suggestion; please use the comment section.

Excel - How to create Templates in Excel 2010

In my last tutorial I talked about “how to use templates” in Microsoft Excel. Also I explained what is a template and why should we use templates. To recollect I would like to mention again that - templates in Microsoft Excel can be used to eliminate efforts for repetitive work and we should use templates to increase productivity of our excel work.

In this tutorial I am going to show how to create an excel template. Once we have an excel work book ready to use as template, we have to save it as type “Excel Template (*.xltx)” or “Excel Macro-Enabled Template (*.xltm)”. “Excel Macro-Enabled Template” is for a template having macros defined in it and for simple templates the option “Excel Template” can be used.

Check the video tutorial for details about how to create a Template in Microsoft Excel. Use template, save time, be productive.

How to use Templates in Excel 2010

Templates in Microsoft Excel can be used to eliminate repetitive work. Even if you use a template for one time only, it can save some of your time which you would have been spent on formatting tables, font, color, page set up for printing etc. So using templates you could be much more productive. Let’s take an example: every month you need to take dump of your sales details and then you generate report of sales by product and by customer and then you take print of these reports. If you use a template which is preformatted for this job then only thing you have to do is take dump of sales details and put into the template. It will automatically generate all your report. Also the report is then ready for print also.

So check the video tutorial below for details about how to use a template in Microsoft Excel. Use template, save time, be productive.

Microsoft Excel 2010 - Introduction to the Interface

Microsoft Excel 2007 and 2010 interface are almost same. So if anyone used 2007 version will have no issue in finding different commands or actions in Microsoft Excel 2010. The interface has completely changed since the 2003 version. The new interface is much more improved by categorizing similar command/ actions into a single tab. So the tabular format of the ribbon is much easier to browse through. Also pictorial representation of each commands/ actions creates better visual impact to the users.

There are many more improvements in interface, performance, capability, security etc in 2010 version of Microsoft Excel. Please check the video tutorial below for an introduction to Microsoft Excel 2010 interface. This will be helpful for people who only worked with 2003 or earlier versions and not familiar with 2007 or 2010 version. Beginners anyway will get a good overview of the Microsoft Excel 2010 interface from this video.

What is Microsoft Excel and Use of Microsoft Excel

What is Microsoft Excel and Use of Microsoft Excel

• A powerful tool for data analysis
• Track data
• Build models for data analysis
• Formula based calculation of data
• Pivot data generation
• Professional chart presentation

Use of Microsoft Excel

It can be used for any kind of data tracking, calculations and analysis for personal, small scale to large scale business, organization etc.

Examples: Use of Microsoft Excel - Check the video tutorial

• Personal Monthly Budget
• Sales Report
• Loan Amortization
• Time Cards
• Charts
• Checklist
• Flowchart
• Test Plan
• Status Reporting
• And many more

Here is the video tutorial

This video is to provide an idea about Microsoft Excel to beginners. This will help people to understand capabilities of Microsoft Excel. The different way Microsoft Excel can be used is demonstrated with multiple examples.