Top 10 MS Excel Basic Features

Top 10 MS Excel Basic Features Everyone Should Know – Abstract Review

MS Excel is one of the famous and most used software all around the world. The Windows Operating system users are almost using MS Excel. MS Excel came in the MS Office package. There is a number of versions released available of MS Office. The version of MS Office is MS Office 2003, MS Office 2007, MS Office 2010, MS Office 2013, MS Office 2016, MS Office 2019, MS Office 2020, and MS Office 365.


The top 10 best basic to advance features of MS excel are;

Top 10 MS Excel best Features

  1. Create New File
  2. Open File
  3. Save & Save As
  4. Filter
  5. Create New Sheet
  6. Auto Sum Formula
  7. Font Styling & Alignment
  8. Set all rows height
  9. Write formulas
  10. Print & Print Options

These are some very basic and most important top 10 MS Excel features. Read all of the features in detail you will be get benefit from the article. If you are a new/beginner or expert you will still get some new things in the article so stay tuned. As every student, employee, faculty member or sales boy/ girl needs to know the basics.

Before starting the brief description of features let me show you how to start MS Excel 2013 program if the MS Excel shortcut icon is not present. Go to the Start menu write MS Excel and you will see the MS Excel icon with the version you had installed. Here is a brief description of the top 10 basic features of MS Excel listed below.

1. Create New File

Creating a new file in MS Excel is simple. You need to click on the File menu, then click on new File, after that you can select either the template of the start file or can choose the blank document to start work on.

The shortcut key to open a new file is Ctrl + N

2. Open File

The file in Microsoft Excel can be opened in multiple ways firstly, after opening Microsoft excel. Click on the File menu that can be found at the top left of the menu. You will see the option open, click on that, and after that, you need to select the file to open via giving the path to it. It is the second feature out of the top 10 basic features of MS Excel.

Second Method: You can go to the file location then double click the file it will open the file in MS Excel.

Third Method: You can drag and drop the file in MS excel that will also open up the file in MS Excel.

The Shortcut Key to open the File is: Ctrl + O

3. Save & Save As

Save: Once you wrote something in the file most probably you need to save that file to use the same file with the same data in the future. Method 1 to save file is you need to click on the File menu you will see the Save option, click on that and it will ask for saving file destination, press okay to save the file.

The Shortcut Key is: Ctrl + S

Save As: In MS Excel the Save as is needed because someone wants to save the same with little changes with a different version name. That will allow saving as an option. Click on the File menu and click on the save as menu. It will again ask for the file name and destination. After providing detail click okay to save.

The Shortcut Key is: Ctrl + Shift + S

4. Filter

One of the most important and interesting features in MS Excel is the filter. It is used to sort the column values, filter out some rows with some specific format, and more. The filter is applicable on the header row. You can find it in

Home tab -> Sort & Filter -> Filter

You need to select the row and apply the filter feature.

5. Auto Sum Formula

Auto Sum Formula is one of the most used features for formulas. It includes the Sum, Average, Count, Minimum, Maximum, and many more functions formulas already build.

You can access the auto sum from the home tab

   Home -> Auto Sum -> Sum

You need to select the number of cells, on which you want to sum the values or average. You can read about the MS Word top 10 features.


This post is for beginners of Microsoft Excel/ MS Excel. Therefore, the top 10 MS Excel basic features are very helpful to those who are new to Microsoft Office. Here we described the top 10 basic/ necessary features for starters. If you have any query please comment, we will reach you as soon as possible for guidance.

Leave a Comment