“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.
1: Auto Fill
“AutoFill, that are gonna make this process a lot simpler and faster Feature.”
“Pasting some data from one cell and pasting it into another cell is one of the most common activities in Excel”
“zooming is best feature of ms excel Through this we can easily see the 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.”
- Select Insert > Header & Footer.
- Tap on the header and select Picture.
- Insert your image. In the header, you’ll see & Picture
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
Explore data in a table quickly. Filtering effectively hides data that is not of interest.
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”
- Recommended Charts
- Column Or Bar Charts
- Hierarchy Charts
- Waterfall Or Radar Charts
- Line Or Aria Charts
- Statistics Charts
- Combo Charts
- Pie Charts
- Scatter or Bubble Charts
- 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”
“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
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.
“Lookup formulas help you locate any information in your workbooks based on input criteria.”
“VBA stands for Visual Basic for Applications, is a special language that Excel speaks.”
“Using basic math functions to manipulate those numbers is one of the features that makes Excel so powerful.”
“A Excel formula is an expression which calculates the value of a cell.”