Microsoft Excel is the most useful together with slow tool for describe of piece of work organisation analysts. It has large release of useful formulas, features together with bundles of interactive charts. But, most of us are non known of all of them together with at that topographic point are some to a greater extent than features which are powerful together with slow to utilisation to brand our piece of work simpler. You powerfulness non cause got noticed some of the useful Excel 2013 features similar Sparklines, Slicers, Conditional Formatting together with other formulas which add together value to your work. In this article, I volition accept yous through them together with volition hand yous an persuasion on what are those together with how to utilisation them.
Most Useful Excel Features
Among many Excel features, at that topographic point are some hidden features which are slow to utilisation together with yous many non know all of them. Without whatsoever farther delay, nosotros volition hold off at five such Excel features.
Sparklines
Sparklines were outset introduced inwards Excel 2010 together with are used to correspond visualizations for the tendency across the information inwards a row. It fits inwards a unmarried Excel prison theatre cellphone together with saves the infinite on the worksheet. This is a cool characteristic together with is real slow to use. Calculating the tendency for row information together with placing the visualization inwards the unmarried excel is actually a peachy characteristic to use.
In monastic say to practise your ain Sparklines, direct the gain of data. Click insert on the ribbon together with direct the type of Sparklines (Line, Column or Win/Loss). Next, larn into the gain of the target where yous desire to exhibit the Sparklines. For to a greater extent than information on how to practise Sparklines, catch Office Blogs.
Conditional Formatting
Conditional Formatting is a good known characteristic of Excel. It is used to visually nowadays the information based on the atmospheric condition met. It is also useful to practise rut maps. This would live on helpful to observe the interesting patterns past times exploring the information effectively.
To practise the rut map, direct the information together with caput over to the ribbon. Under Home, click Conditional Formatting and together with then click Color Scales. Now, alternative the coloring textile scale. You tin fifty-fifty fix the coloring textile scale past times editing the formatting rule. For to a greater extent than information on Conditional Formatting, catch Office Support.
SMALL together with LARGE Functions
We all know most MAX together with MIN functions. They hand yous the maximum together with minimum values of the selected information respectively. But, inwards monastic say to observe the 1st, 2nd, 3rd or nth largest or smallest value of the selected gain if data, nosotros tin brand utilisation of LARGE together with SMALL functions respectively.
In this example, inwards monastic say to observe the transcend ii products for each month, nosotros made utilisation of MATCH together with INDEX functions along amongst LARGE together with SMALL functions. For to a greater extent than information, catch SMALL together with LARGE functions.
Remove Duplicates
Do non blame me for mentioning this characteristic inwards this list. It is real of import to become rid of redundant information from the available huge sum of data. It is 1 of the best ways for cleaning together with organizing the information together with thus persuasion of having it inwards this listing of powerful Excel features. Removing Duplicates characteristic was introduced from Excel 2007 together with is helpful to take away duplicates which is the most of import employment which nosotros face.
To take away duplicates, direct the information together with caput over to the ribbon. Under Data, click the Remove Duplicates button together with what yous come across the information without duplicates. For to a greater extent than information on how to Find together with Remove Duplicates, catch Office.com.
Slicers
Slicers deed every bit visual filters. It helps yous to visualize the subset of information every bit a connected nautical chart or every bit a raw data. For example, if yous desire to exhibit the tendency of sales of diverse products, together with then yous tin practise the interactive sales tendency nautical chart using Slicers. Based on the production yous select, respective nautical chart is shown. Slicers were outset introduced inwards Excel 2010 together with enhanced a lot inwards Excel 2013.
In Excel 2013, if yous desire to add together Slicer to your charts, direct the information gain together with click on insert > Slicer. Now, direct the part of the information yous desire to utilisation every bit a filter. In the icon above, Product column is used every bit a filter. How hither for to a greater extent than information on how to utilisation Slicers.
For to a greater extent than details on these features together with to download the instance workbook, catch Office Blogs
How many of yous cause got used these powerful together with useful Excel features? If yous desire to add together to a greater extent than features to the list, delight allow us know through comments.
Source: https://www.thewindowsclub.com/
comment 0 Comments
more_vert