5 most useful Excel features you need to know

Microsoft Excel is the most important and useful level in both industrial and academic level. It is the most used tool by business analysts. It has lot of features, useful formulas and hundreds of interactive charts. But many of the user doesn’t know about all these features which are more powerful and make your work simpler. Some of you might haven’t noticed some useful Excel features like Slicers, Sparklines, Conditional formatting and other formulas which will add value to your work. Here we are going to show some powerful features which you must know.

5 most useful Excel features you need to know

1. Sparklines


Sparklines is the latest feature which is first introduced in the Excel 2010 version. These are used to represent the visualizations of the trends across the data in a row. It just occupies the space of one single cell and save space on worksheet. It is very simple to use and calculating the trend for row data and placing visualization in a single cell is really cool feature to use. To create the Sparklines, select the range of data and click on the insert button on the ribbon and select the type of Sparklines. Then enter the range of target where you want to show the sparklines.

2. Conditional Formatting


Conditional formatting is the another powerful feature of Excel, which is used to visually represent the data based on the conditions. It is used to create the heat maps which would be helpful to find interesting patterns by exploring data effectively. Here is how to create the heat map, select the data and navigate to the ribbon. Under the Home button, click on conditional formatting and then Color Scales. Now select the color scale and even set the color scale by editing the formatting rule.

3. Remove duplicates


You might think how this can be the important feature, but it is very important to get rid of the duplicate data. It is very efficient way to clean and organize the data and so it is very important to remove the duplicates. Remove duplicates feature was first introduced in Excel 2007 version. To remove the duplicates from the large chunks of data, select the data and navigate to the ribbon. Under the Data tab click on Remove duplicates option and you will get the data without duplicates.

4. Small and Large functions


MAX and MIN are the well known functions in Excel which will give maximum and minimum values from the selected data. But to find the 1st, 2nd, 3rd and nth largest or smallest value from the selected range of data, then use the LARGE and SMALL functions respectively.

5. Slicers


Slicers acts as the visual filters which allow you to visualize the subset of data as a connected chart or raw data. For instance let use consider, if you want to display trend of sales of different products, then you can create interactive sales trend chart using the Slicers feature. Slicers is first added to the Excel 2010 version.

To add the slicers to your charts, select the data range and click on insert > slicer and select the data range which you want to use as a filter.

Excel comes of in-built functions, features and third party add-ons also available which help you to successfully complete your daily tasks.

You may also like...