Features of MS Excel

Microsoft Excel Features

Almost all the professionals use this spreadsheet tool, and MS Excel is the universal language that speaks in almost all the offices. As a starter or intermediate level user, you need to know some of the important features of MS Excel. In this article, we will show you “Features of MS Excel.”

Features of MS Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Features of MS Excel (wallstreetmojo.com)

Top 9 Main Features of Microsoft Excel with Examples

Now we shall discuss the 9 different features of Microsoft Excel with examples which are as follows:

You can download this Features of MS Excel Template here – Features of MS Excel Template

#1 – You Can Insert a New Worksheets at Will

You might have seen 1 o 3 default worksheets when you open the new workbook (number of worksheets may vary depending on the settings).

You can insert a new worksheet in excel and delete the same at any point in time. To insert any new worksheet, you simply need to press the “PLUS” icon key, which is available at the bottom.

Features of MS Excel Example 0

Click on this button to insert a new worksheet.

You can also insert a new worksheet by simply pressing the shortcut key Shift + F11.

#2 – Time Saving Shortcut Keys

All the time you spend on excel can be reduced drastically by masterful excel shortcut keys. Apart from universal “Ctrl + C, Ctrl + X, and Ctrl + V,” we can use many other abundant shortcut keys in excel.

Shortcut key for Copy:

Copy Example 0.5

Shortcut key for Cut:

Features of MS Excel Example 0.6

Shortcut key for Paste:

Paste Example 0.7

You can refer to our article on “Excel Shortcut Keys” to learn some of the important shortcut keys.

#3 – Get Quick Sum of Numbers

If you have serial numbers or any numerical data, then you can quickly get the sum of these numbers with simple shortcut keys.

Assume you have numbers in 10 cells and just imagine how long it is going to take you to get the total of these numbers.

Features of MS Excel Example 0.1

I can say less than a second!!!!

Yes, you hear it right less than a second.

Simply select the cell where you need to get the total of these numbers and press the shortcut key ALT + = to get the auto sum.

Features of MS Excel Example 0.3
 Example 0.2

We get the following result.

Features of MS Excel Example 0.4

#4 – Filtering Data

Filtering the excel data is one of the important features of Microsoft Excel. We can filter any data available under the filter section.

We can use more advanced techniques under filtering the data. To insert a short filter, you can press the shortcut key Ctrl + Shift + L or Alt + D + F + F.

Shortcut key to Insert the Filter:

Features of MS Excel Example 0.8

or

Example 0.9

For example,

Features of MS Excel Example 0.10

#5 – Paste Special Feature

I love to paste special because it gives more edge to increase workplace productivity. For example, look at the below data.

Example 1

In A5 cell, we have a formula which is taking the range of cells from A1 to 4. So A5 cell is dependent on the above cells; if we copy and paste this cell to other cells, we get this formula only not value.

So we can use the paste special technique to paste as only values. So, copy the cell A5 and place a cursor on the cell where you need to paste.

Features of MS Excel Example 1.1

I have copied the cell A5 and placed the cursor on the C5 cell.

Now press shortcut key ALT + E + S open paste special dialogue box.

Features of MS Excel Example 1.2
Example 1.3

We have plenty of options under paste special features here. In this example, we paste only the value, so select the Values” option “to paste as the only value.

Features of MS Excel Example 1.4

So this will paste only the value from A5 cell to C5 cell.

Example 1.5

Like this under paste special, we can all other techniques like “formulas, formats” etc.

#6 – Insert Random Numbers

Excel has plenty of formulas and functions in its arsenal. If you want to insert random numbers with an excel worksheet, then you can use a built-in function called “RANDBETWEENRANDBETWEENRANDBETWEEN excel formula determine random numbers between two extreme variables (bottom and top numbers). The user needs to fill in the bottom and top numbers in the syntax =RANDBETWEEN (bottom, top) to acquire the random integer.read more.”

Features of MS Excel Example 2

For the first argument, supply the least number that you want to insert.

Example 2.1

For the last argument, enter the highest number that you want to insert.

Features of MS Excel Example 2.2

So now RANDBETWEEN function inserts numbers from 100 to 1000.

 Example 2.3

#7 – Insert Random Fraction Numbers

As we have seen above, we can insert random numbers; now, we will see how we can insert random fraction numbers.

To insert random fraction numbers, which are greater than 0 and less than 1, use the RAND function.

Features of MS Excel Example 3

RAND function doesn’t have any parameters, so just close the bracket and insert the function.

Example 3.1

Note:

Both RAND and RANDBETWEEN are volatile functions and keeps varying whenever we make any changes in the workbook.

#8 – Goal Seek Analysis Tool

Goal Seek analysis tool is an extremely useful tool to find out what needs to be done to achieve the desired goal. For example, Mr. A wants to get an overall average score of 90 from 6 subjects. Mr. A already attended 5 exams, and below are his anticipated scores.

Features of MS Excel Example 4.0

Now Mr. A left with only one examination, and he wants to know how much he needs to score in the final examination to get the overall average of 90.

First, apply the AVERAGE function for the first five exams.

Example 4.1.0

We get the following result.

Features of MS Excel Example 4.2.0

Now go to the DATA tab and click on the What-If AnalysisWhat-If AnalysisWhat-If Analysis in Excel is a tool for creating various models, scenarios, and data tables. It enables one to examine how a change in values influences the outcomes in the sheet. The three components of What-If analysis are Scenario Manager, Goal Seek in Excel, and Data Table in Excel.read more tool to open the “Goal Seek” tool.

Example 4.3

In the Goal Seek window, we can see three options.

Features of MS Excel Example 4.4

Select Goal Seek.then we get the following options Set Cell, To Value, By Changing Cell.

 Example 4.5

For Set Cell, the average function applies to the cell, i.e., B8 cell.

In order to Value, the cell enters the value as 90.

By Changing Cell gives the cell reference to B7 cell.

Features of MS Excel Example 4.6

Now click on Ok, Goal Seek analysis tool will help Mr. A to know how much needs to score in the final examination to get the overall average of 90.

 Example 4.7

Ok, Mr. A has to score 99 from his final examination to get the overall average of 90.

#9 – Insert Serial Numbers

If you want to insert serial numbers that are incremented by 1, then we can do this by simply fill the series option. Enter the value 1 in any of the cells.

Features of MS Excel Example 5

Now using Excel FILL Handle drag till the cell where you want to insert serial numbers.

 Example 5.1

Now click on the “Auto-Fill” option and choose “Fill Series” to get the serial numbers incremented by 1.

Features of MS Excel Example 5.2

We get the following result.

 Example 5.3

Things to Remember about Features of MS Excel

  • These are some of the basic and cool features of excel.
  • We have so many uses that other features will also cover incoming topics.
  • Use shortcut keys to skillfully use excellent spreadsheet tool.
  • First, learn basic formulas to get start with functions.

Recommended Articles

This has been a guide to the features of MS excel. Here we discuss the top 9 features of Microsoft Excel that include Time Saving Shortcut Keys, Get Quick Sum of Numbers, Filtering Data, Paste Special Feature, etc.along with examples, and a downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>