Author Archives: XZoLMLRU2Pg

How to Evaluate Formula in Excel

Microsoft Excel is a detailed software that can be used as a multiple analysis tool. It gives simple options that can help you manage and manipulate data to derive desired or actual results. It is important to understand the workings of this software to be able to use it effectively. Working with formulas in Excel is quite easy and very helpful. Huge amounts of data can be worked with using these formulas. To learn how to evaluate formulas in Excel, follow this step by step tutorial.


read more »

How to Use Trace in Excel

Microsoft Excel is a detailed software that can be used as a multiple analysis tool. It gives simple options that can help you manage and manipulate data to derive desired or actual results. It is important to understand the workings of this software to be able to use it effectively. There are many more options in Excel with respect to using formulas. One of the most useful tools are the ability to trace in Excel where all your calculations are coming from or going to. Trace dependents in Excel or precedents so that you always know how values are come to. To learn how to apply such techniques, follow this step by step tutorial.


read more »

How to Create Multiple Custom Worksheet Views in Excel

Microsoft Excel is a detailed software that can be used as a multiple analysis tool. It gives simple options that can help you manage and manipulate data to derive desired or actual results. It is important to understand the workings of this software to be able to use it effectively. You can create Custom View in Excel so that you don’t have to set your view each time you want to review a certain part of the Worksheet. It is very simple to create Views in Excel and you can have multiple views to suffice for each type. Follow this step by step to learn how to create multiple custom Worksheet views in Excel.


read more »

How to Create Templates in Excel

Excel provides templates which are worksheets which are already made for basic and common uses. The have been pre designed and you can make some changes and modify them. The templates are automatically installed in Excel 2010 and if you want some other templates you can easily download them from the Microsoft Office Website. It saves a lot of time when you work with a template, all the things which are common and used by most of the people are already there so instead of making a worksheet from scratch you can simple use the template. There are lots of other websites which provides you with a lot of different templates so you can search the internet for them as well or create template in Excel.
Follow this Step by Step tutorial to learn how to create and use original templates in Excel.


read more »

How to Add Numbers in Excel

Excel allows you to do various kinds of calculations. There are various formulas and functions that you can use for calculations. In order to add the number you can use the “SUM” function. In this tutorial we will not use the add formula in Excel, instead we will add the numbers manually and excel will recognize the pattern and do the calculations for rest of the cells itself.


read more »

How to Change and Add an Excel Worksheet

Microsoft Excel is a detailed software that can be used as a multiple analysis tool. It gives simple options that can help you manage and manipulate data to derive desired or actual results. It is important to understand the workings of this software to be able to use it effectively. You can change your Excel Worksheet and add in Excel sheets. To learn how to change and add in an Excel Worksheet, follow this step by step tutorial.


read more »

How to maintain Excel Compatibility

Microsoft Excel is a commercial spreadsheet application through which we can calculate, use graphing tools, add pivot tables and do a lot more. Over time, new versions of Microsoft Excel have come which have added some new features in the newer versions and these features are sometimes not supported by the older versions. If you want to open your new version file in another computer which does not have the newer version of Microsoft Excel then you will have to save it in the older format so that you can work around the Excel Compatibility Mode.
Follow this step by step tutorial to learn how to maintain Excel compatibility.


read more »

How to Delete every other Row in Excel

In this video tutorial we will show you how to delete every other row in excel.
Open the excel document you want to edit. In blank column besides original data, enter 1,0,1,0,1,0,1,0…1,0.


read more »

How to Delete Duplicates in Excel

In this video tutorial we will show you how to delete duplicates in excel.
Open the excel document you want to edit. Select the part of the text where you want to find duplicates. Go to “Data” tab, click on “Remove Duplicates” button.


read more »

How to Delete Blank rows in Excel

In this video tutorial we will show you how to delete blank rows in excel.
Open the excel document you want to edit. Select the part of the text where the blank rows are and you want to delete. Now click “Find & Select”, in popup menu choose “Go To Special…”.


read more »