Learn Online Top- 5 Advanced Excel Features and Functions In 2020
Microsoft Office Excel is one of the most important tools to perform the calculation, analysis, and visualization of data and information. There are a total of 1048576 rows, and columns range from A to XFD and there are a total of 16384 columns. Now, let’s take a closer look at some of the best Microsoft Excel features or functions you can use to become more efficient.
1. Vlookup()
This function helps to search a value in a table. It returns a corresponding value. In other words, it searches for the given value and returns a matching value from another column. To know more about it, let’s look at the following syntax and its example. Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
2.Pie Chart
Now On the Insert tab, in the Charts group, click the Pie symbol and then click Pie. After clicking, the following image will show the result. Learn Online Advance Excel from Top Institute
3.Mixed or Combination Type Charts
• Now, On the Insert tab, in the Charts group, click the Combo symbol and after that click on create custom combo chart. • Now, the insert chart dialog box will appear. Now, for the rainy days series, select the clustered column as the chart type. After that for the profit series, select line chart type. • • Now, plot the profit series on the secondary axis. • Then click to Ok button.
4. Data Validation
• • • •
Data validation is one of the most powerful excel capabilities. It makes sure that users enter particular values into a cell. In the following example, we have restricted users to enter a whole number between 0 and 10. Now, to create Data Validation Rule, Select cell C7 and now on the Data tab, in the Data Tools group, click Data Validation. Now, On the Settings tab, in the allow list, click the Whole number and after that in the data list, click between. Now enter the minimum and maximum values. Now, after this click on Input Message and set the input message. After finishing this click on the Error Alert tab and set the error message to display if a user enters other than whole numbers or some other text. The following two figures show you the result.
5. IFERROR Function
IFERROR is a simple way to manage errors without using more complex nested IF statements. Syntax =IFERROR (value, value_if_error) Now if we use iferror function then if a cell contains an error, an empty string (“”) is displayed. Benefits of Online Advanced Excel Certification and It’s Career Scope
Follow Us
Twitter: https://twitter.com/cetpainfo Facebook: https://www.facebook.com/cetpainfo/ Instagram: https://www.instagram.com/cetpa_infotech/ Youtube: https://www.youtube.com/user/CetpaInfotech Linkedin: https://www.linkedin.com/company/cetpainfotech/ CETPA INFOTECH PVT LTD Phone Number: 91-9212172602 Address: - D-58, Red FM Road, Sector 2, D Block, Sector 2, Noida, Uttar Pradesh 201301 Email: - QUERY@CETPAINFOTECH.COM Website: - www.cetpainfotech.com
Thank You