In MS Excel, user can insert various kind of graphic objects like Text Box, Shapes gallery, WordArt and SmartArt, which is available in the Insert Tab. Insert Shape Go to the Insert Tab, followed …
Macros help in automating few tasks in the MS Excel. Go to the View Tab, followed by Macro dropdown in order to record tasks that have to be performed routinely. Once done, you won’t …
MS Excel 2010 offers wide variety of templates to give a new refreshing look to the worksheet. In order to view the Excel templates, go to the File followed by New. Here you will …
If you wish to create professional looking documents, make use of the document themes. Go to the Page Layout Tab, followed by Themes Dropdown. This will display a live preview when you move the …
MS Excel offers Named styles that are extremely easier to apply on a set of the predefined formatting options for a cell or range. In MS Excel, a Style can consist of settings that …
Data validation features allows users to set up certain rules which dictates want can be entered in the cells. Validation Criteria In order to perform data validations, follow these steps. Select the range or …
A cell happens to be a single element in the worksheet that has the ability to hold value, text and formula. A cell is usually identified by its address composed of both the column …
MS Excel offers easier and simpler ways to sort data as per ones preference. MS Excel smartly rearranges the row based on the content of the particular through data sorting. If you wish to …
MS Excel offers the feature of data filtering wherein worksheet display only those rows which meets the certain conditions set by the user. The other ‘rows’ which doesn’t satisfy the condition simply remains hidden …
MS Excel comes loaded with a variety of built-in functions that can be easily used in the formulas. In order to see all the functions by category, select the Formulas Tab followed by the …