MS Excel Tutorial | Clarified.com

How To Add Graphic In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Use Macros In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Use Templates In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Use Themes In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Use Styles In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Perform Data Validation In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Use Ranges In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Perform Data Sorting In Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Perform Data Filtering In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

How To Use The Built-In Functions In MS Excel 2010

11 Feb, 2016 admin Mastering MS Office, MS Excel 0

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 …

People Are Reading

Tagged: MS Excel Tutorial

Trending

Apple