MS EXCEL 2016 TUTORIAL (INTRODUCTION)

HELLO EVERYONE!

So now when we understand the word 2016, I am going to introduce you to the MS EXCEL 2016. I will be updating about this topic everyday.

So let's Start!

Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.

If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface.

WORKING ENVIROMENT:

The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in Excel. The Backstage view gives you various options for saving, opening a file, printing, and sharing your document.

EXCEL RIBBON:

Excel 2016 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel.

Each tab is having one or Group;

Some groups have a Arrow So we can click for more options;

Different Tabs Have Different Commands:

SHOW OR HIDE RIBBON:

You Can add Commands to The QUICK ACCESS TOOLBAR-

1. Choose the Command you want to add from the Drop Down box.

2. Your command will be added to the Quick Access Toolbar.

THE EXCEL 'TELL ME' FEATURE:

The Tell Me Feature of EXCEL 2016 works like search box to help you find the commands or tools you want to you use.

Type Your words you want to search from excel sheet.

The search result will show you accordingly.

WORKING VIEW OF EXCEL SHEET:

Excel 2016 has a variety of viewing options that change how your workbook is displayed. These views can be useful for various tasks, especially if you're planning to print the spreadsheet. To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view, or Page Break view.

Normal View is the Default View for EXCEL WORKSHEET.

The Page Layout View displays how your worksheets will appear when after printing.

You can add Header and Footer accordingly to your worksheets.

Page Break view allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.

Backstage view gives you various options for saving, opening a file, printing, and sharing your workbooks.

To See The Backstage View

1. click the file Tab, Backstage will appear

So, This is the Introduction part for the MS EXCEL 2016

I Will be Updating Everyday!

Stay Updated!