“Features Of MS Excel”

There are many features of MS Excel. Of which we will tell it about Feature today, which is very important for you.

This feature and you would like to use your everyday tasks.

Let’s start


1: Auto Fill

“AutoFill, that are gonna make this process a lot simpler and faster Feature.”


2:  Pasting:

“Pasting some data from one cell and pasting it into another cell is one of the most common activities in Excel”


3: Zooming

“zooming is best feature of ms excel  Through this we can easily see the tables.”


4:Pivot Tables

Use a large spreadsheets to store, count, collectively or average data and display them in their new table.

“A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.”


5:Watermark:

Microsoft Excel doesn’t come with a built-in watermark button. But you can use an image, like a logo, to create a watermarkIf You Create a Watermark follow the instruction

  1. Select Insert > Header & Footer.
  2. Tap on the header and select Picture.
  3. Insert your image. In the header, you’ll see & Picture

 


6:Illustrations:

This feature shows you type of image that may be compromised for your worksheets. You can use your own images

Or even free image use from the microsoft image library Apart from this, different types of shapes are also available


7:Filters

Explore data in a table quickly. Filtering effectively hides data that is not of interest.

Use the AutoFilter feature to find, show, or hide values—in one or more columns of data. You can filter based on choices you make from a list, or search to find the data that you seek. When you filter data, entire rows will be hidden if the values in one or more columns don’t meet the filtering criteria.

8:3D Map

Microsoft 3D Maps for Excel is a three-dimensional (3D) data visualization tool that lets you look at information in new ways. 3D Maps lets you discover insights you might not see in traditional two-dimensional (2D) tables and charts.


9:Charts:

chart can be helpful for displaying different types of information or a range of values that varies greatly.

Excel Provide 10 different types charts “The following is below”

  1. Recommended Charts
  2. Column Or Bar Charts
  3. Hierarchy Charts
  4. Waterfall Or Radar Charts
  5.  Line Or Aria Charts
  6. Statistics Charts
  7. Combo Charts
  8. Pie Charts
  9. Scatter or Bubble Charts
  10. Pivot Charts

10: Spark lines:

“A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data”


Different types of Free themes:

I Like This feature Personally because very Beautiful themes Provide free Ms Excel  and ”

You can also upload your choice. Or can make”


 

11:Conditional Formatting:

“Conditional Formatting brings out the patterns of the universe, as captured by your spreadsheet”


12:Adding Multiple Rows & Column  :

If you want to add more than one, select as many rows or columns as you’d like to add and then “Right Click and  Click Insert and add Column & Rows” Very Easy.


13:Drop down validation:

Can you make your work books interactive, so that users can control the inputs? Using form control


14:Absolute References:

Indispensable! The dollar in front of the letter fixes the column, the dollar sign in front of number fixes the row F4 toggles through the four possible combinations.


15:Lookup  Formulas:

 

“Lookup formulas help you locate any information in your workbooks based on input criteria.”


16:VBA

“VBA stands for Visual Basic for Applications, is a special language that Excel speaks.”


 17:Math :

“Using basic math functions to manipulate those numbers is one of the features that makes Excel so powerful.”


18:Formula

“A Excel formula is an expression which calculates the value of a cell.”