MS OFFICE 2016

MS EXCEL TUTORIAL(CREATING & EDITING WORKBOOKS):

Excel files are called workbooks. Whenever you start a new project in Excel, you'll need to create a new workbook. There are several ways to start working with a workbook in Excel. You can choose to create a new workbook—either with a blank workbook or a predesigned template—or open an existing workbook.

NEW BLANK WORKBOOK:

1. Select the File Tab

    

       2. Select NEW then click Blank Workbook.

 

           3. A Blank New Workbook Will appear.

OPEN AN EXISTING WORKBOOK:

In addition to creating new workbooks, you'll often need to open a workbook that was previously saved.

1. Navigate to the Backstage View

       2. In addition to creating new workbooks, you'll often need to open a workbook that was   previously saved.

    3. In addition to creating new workbooks, you'll often need to open a workbook that was previously saved.

PIN WORKBOOK:

If you frequently work with the same workbook, you can pin it to Backstage view for faster access.

1. Navigate to Backstage view, then click Open. Your recently edited workbooks will appear.

      2.Hover the mouse over the workbook you want to pin. A pushpin icon will appear next to the        workbook. Click the pushpin icon.

       3. Select A Templet To Review it.

       4. A preview of the template will appear, along with additional information on how the templet

          can be used.

       5.Click Create to use the selected template.

       6. A new workbook will appear with the selected template.

COMPATIBILITY VIEW:

Sometimes you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these types of workbooks, they will appear in Compatibility Mode.

Compatibility Mode disables certain features, so you'll only be able to access commands found in the program that was used to create the workbook. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.

Sometimes you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these types of workbooks, they will appear in Compatibility Mode.
Compatibility Mode disables certain features, so you'll only be able to access commands found in the program that was used to create the workbook. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.


CONVERT A WORKBOOK:

If you want access to all of the Excel 2016 features, you can convert the workbook to the 2016 file format.

1. Click the File Tab to Open the Backstage View.
2. Locate and Select Convert Command.
3. The Save As Dialog Box will appear. Select the location where you want to save the workbook, enter a file name for the presentation, and click Save.
4. The workbook will be converted to the newest file type.

So, That's it For Now !

I will be Updating!

Stay Updated!