What are the Main Features of ms Excel


what are the main features of ms excel

As a business owner, you know that using MS Excel is essential for managing your finances and managing your data. In this article, we will take a look at the main features of MS Excel 2016, so that you can better understand what this powerful spreadsheet can do for you.

What is an Excel Workbook?

The Excel workbook is a document that contains all of the data and information that you need to work on a project. You can save your work in an Excel workbook, so that you can access it later without having to open the file again. You can also share your workbook with other people, so that they can help you with your project.

The Main Features of an Excel Workbook

An Excel workbook is a versatile tool that can be used for a variety of tasks. Here are some of the main features of an Excel workbook:

-You can store data in columns and rows.
-You can create tables and charts to display your data.
-You can format your data using font, color, and borders.
-You can password protect your workbook.

How to Save a Workbook

There are a few main features of Excel that you may want to keep in mind when saving a workbook:

1. You can save a copy of your workbook as a PDF or XLS file.
2. You can password protect your workbook so that only you can access it.
3. You can share your workbook with others by sending them an email or attaching it to an email.
4. You can track changes to your workbook by marking it as read-only and then viewing the changes history.

How to Print a Workbook

If you print your workbook in Microsoft Excel, you can choose to print either the entire workbook or just the sheets you are working on. To print a workbook:
1.Open the workbook you want to print.
2.Click the File tab and then click Print.
3.Select which pages you want to print and then click OK.
4.If you want to include headers and footers on your printout, select them from the Page Setup dialog box that appears and then click OK.

You can also save a copy of your workbook as a PDF file by clicking File > Save As > PDF. In this case, only the pages that have content will be printed, not any headers or footers that you may have selected in the Page Setup dialog box.

How to Open a Workbook in Excel

If you want to open a workbook you already have open in Excel, there are a few different ways you can go about it. The easiest way is to just click on the workbook’s icon on your desktop. If the workbook is open in another application, like Office 2013, you can open it in Excel by clicking the “Open” button on the File tab and selecting “Excel.”

If the workbook isn’t open in any of these ways, you can try one of the following methods:

1. Click on the “File” menu and select “Open.” This will open the file in your default application.

2. Double-click on the file’s name. This will open the file in Excel if it’s not already open.

3. Click on the “Workbooks” tab and select the workbook from the list that appears.

4. Use keyboard shortcuts to open a workbook quickly: F5 (for Microsoft Excel 2013) or Ctrl+O (for Microsoft Excel 2010) will open a workbook in its default location, while Alt+F11 (for Microsoft Excel 2007) or Ctrl+O (for Microsoft Excel 2003

How to Use Functions in an Excel Workbook

If you’re like most people, you use Excel for a variety of tasks—from calculating taxes to planning budgets to tracking progress on projects. But what if you need to do something a little more specific than what Excel can offer? That’s where functions come in handy. In this article, we’ll explain what functions are and how to use them in your Excel workbook.

Functions are special commands that Excel can run automatically whenever you enter particular values into certain cells. For example, you can use the SUM function to calculate the total value of all the cells in a workbook row by row. Or, you could use the VLOOKUP function to lookup a value from a specific cell and return its corresponding value from the first column in the worksheet that contains that cell’s value.

There are dozens of different functions available in Excel, and each one comes with its own set of instructions (or “recipe”) for how it should be used. So don’t be surprised if you’ve never seen or used a function before—just keep reading and gradually start incorporating them into your workflows!

How to Create Tables in an Excel Workbook

In this article, we will be discussing the different features of Microsoft Excel and how to use them to create tables. When working with tables in Excel, it is important to keep in mind that there are a few main features that you should be aware of.

First and foremost, tables in Excel can be used for organizing data. Whether you are working with basic data or more sophisticated information, table formatting can help make your work easier. Additionally, tables in Excel can be used to perform calculations on the data within them. For example, you can use formulas to calculate averages or percentages based on data within a table.

Finally, tables in Excel can be exported as PDF files or CSV (common spreadsheet) files. This allows you to easily share your work with other people and collaborators.

How to Format Cells in an Excel Workbook

If you need to format cells in an Excel workbook, there are a few main features to keep in mind. The easiest way to format a cell is to use the predefined formats that Excel provides. For example, you can set a cell to be a number or a date. You can also use custom formats, which allow you to format cells in a more specific way. For example, you can make a cell bold or underline it.

You can also format text in a cell by using the available formatting options. You can change the font, size, and color of the text. You can also add borders around the text and add highlights. Finally, you can add images to your cells by using the Insert Picture command.

How to Use AutoCorrect in an Excel Workbook

Microsoft Excel offers a number of features that can help you save time and effort when working in the spreadsheet application. One such feature is AutoCorrect, which can automatically correct common typographical errors as you type. This article will explain how AutoCorrect works and what kinds of errors it can correct.


As a business owner, you are likely using Microsoft Excel on a daily basis. Whether you are creating spreadsheets to track expenses or compiling data for presentations, understanding the basics of this software can save you time and help ensure accuracy in your work. In this article, we will take a look at some of the main features of Microsoft Excel so that you can start using it more effectively.