Top10 Most important Tips for Microsoft Excel

Microsoft excel is most important application for everyone. This application have many useful features, but most of the people don’t aware some important features. In this guide explain about top 10 most important features in excel. Please note this guide prepared based on Microsoft excel 2013. May be other version user interface slightly different.

1. How to use excel Format Painter?

Format Painter is one of the most important feature in excel spreadsheet. You can easy way to format multiple column based on your desired column by doing following steps:
 

 

1. Select proper formatted column and cells, click the Format Painter link in top menu bar
2. Now your mouse cursor will be changed plus and painter icon, than select columns and cells which you need apply format.
3. After selected the columns and cells, format will be applied based on existing formatted columns.

2. How to add excel Table Style?

You can rapidly add table’s styles using format as Table features by doing following steps:

1. Select entire table which you need to add styles
2. Click the Format as Table link in top bar
3. Predefined table styles will be appear, you can select as you wish
4. Now selected table style will be changed as format table template
5. You can also create your own template style by click on New PivotTable Style link

3. How to Freeze excel Column and Row?

You can lock excel sheet first column or first row

1. Go to View Tab in tab menu bar
2. Click Freeze Panes link, here if you select Freeze first columns link your excel sheet first column will be locked.
3. If you would like to lock first row, than you select Freeze Top Row link
4. You can unlock by click on Unfreeze Panes link

4. How to create Excel Chart?

You can create excel chart based on excel data’s

1. Select the excel data which you would like to create a chart
2. Go to Insert Tab and move to charts area
3. Here you can select any type of chart such as line chart, pie chart, bar chart
4. After select the chart your data will be shows with chart
5. If you modified the data in the table chart value will be automatically changed

5. How to add Excel workbook Tab color?

You can add the excel workbook tab color for easy identified the pages

1. Right click in the Tab which you would like to add
2. Go to Tab Color now color palate will be displayed you can choose any one of color or you can choose your own color by click on More Colors link
3. If you would like to remove the tab color just click No color

6. How to Add Duplicate value in Excel Column and Rows?

You can duplicate the value multiple column or row

1. Select cell which you would like to duplicate the value
2. Click the cells bottom corner and Drag it which you need add the column or rows
3. Now duplicate value will be added all column or rows which selected

7. How to create PivotTable in Excel?

Pivot table is used for easy way to calculate excel tables.

1. Select the Excel Tables which would like to add pivot tables
2. Go to Insert Tab and click Pivot Table link
3. Now create Pivot Table window will be appear
4. Selected tables will be displayed in Table/Range field, if you would like to modify you change here.
5. Select new worksheet option and click OK button
6. Now new worksheet added in your excel workbook
7. Go to new work sheet and click on Pivot table chart
8. Pivot Table Fields window will be displayed in sidebar
9. You can modify anything here as you needs

8. How to remove Duplicate Value in Excel?

You can easily remove the duplicate value in excel table rows

1. Select the Table which you need to remove duplicate content
2. Go Data Tab and click on Remove Duplicates in Data Tools area
3. In Remove duplicates window select only which row you need to remove duplicate values and click OK
4. Duplicates value will be removed and alert message will be populated with how many duplicate values removed in the selected row.

9. How to add Subtotal in Excel Table?

Subtotal is important for sales tables, in excel you can add subtotal by doing following steps:

1. Select the excel table which need to add sub total
2. Go to Data Tab and click on subtotal in Outline area
3. In Subtotal window select which column you need to calculate and click OK
4. Now subtotal will be added in the tables as per your settings

10. How to Share Excel Workbook?

Basically in same time more than one people can’t open the same excel workbook. Some times more than one people need to work same excel sheet, in this situation we can share the workbook to others

1. Go to Review Tab and Click Share Workbook link
2. Share Workbook window populated
3. Select “All changes by more than one user at the same time” options
4. Now your workbook will be shared to other, they can also edit the documents and changes will be merged.