Microsoft Excel Tutorial

Microsoft Excel Tutorial 2013 2016 2019

Microsoft Excel Tutorial 2013 2016 2019

What is Microsoft Excel or Excel?

Microsoft Excel is an electronic spreadsheet. You can use Excel to organize your data into rows and columns and to perform mathematical calculations. An Excel spreadsheet can contain workbooks and worksheets

What is a Spreadsheet ?

A spreadsheet is an electronic document that stores various types of data. There are vertical columns and horizontal rows. A cell is where the column and row intersect. A cell can contain data and can be used in the calculation of data within the spreadsheet.

How to Open MS-Excel 2013 , Excel 2016 or Excel 2019 or Excel

How to Open Excel with Start Menu
How to Open Excel with Start Menu

Press Win key From Keyboard and Type Excel and hit the Enter Key

Or

How to Open Excel with Run Command
How to Open Excel with Run Command

Press Win+R to open Run command Dialog Box then Type “Excel” and press Enter key.

MS-Excel 2013 / 2016 / 2019 Interface

microsoft Excel Interface

Ms-Excel 2013 / 2016 / 2019 Screen Components

Excel Screen Components

Showing and hiding the Ribbon

Showing and hiding the Ribbon

If you find that the Ribbon takes up too much screen space, you can hide it. To do this, click the Ribbon Display Options arrow in the
upper-right corner of the Ribbon, then select the desiredoption from the
drop-down menu.

Auto-hide Ribbon: Auto-hide displays your workbook in full-screen mode and completely hides the Ribbon from view. To show the Ribbon, click the Expand Ribbon command at the top of the screen.


Show Tabs: This option hides all command groups when they’re not in use, but tabs will remain visible. To show the Ribbon, simply click a tab.

Show Tabs and Commands: This option maximizes the Ribbon. All of the tabs and commands will be visible. This option is selected by default when you open Excel for the first time.

The Quick Access Toolbar

Quick Access Toolbar location
Quick Access Toolbar Menu

The Quick Access Toolbar lets you access common commands no matter which tab is selected. By default, it includes the SaveUndo, and Redo commands.

The Tell Me bar

The Tell Me bar

The Tell me bar allows you to search for commands, which is especially helpful if you don’t remember where to find a specific command.

The Ribbon

The Ribbon

The Ribbon contains all of the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands.

The Command Groups

The Command Groups

Each group contains a series of different commands. Simply click any command to apply it. Some groups also have an arrow in the bottom-right corner, which you can click to see even more commands.

The Worksheet views bar

The Worksheet views bar

Normal view is the default view for all worksheets in Excel.

Page Layout view displays how your worksheets will appear when printed. You can also add headers and footers in this view.

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

The Zoom bar

The Zoom bar

Click and drag the slider to use the zoom control. The number to the right of the slider bar reflects the zoom percentage.

The Status Bar

the status bar

Status Bar locate at the bottom of Workbook window. Sum, Average, count are display auto after selecting cells . You can also find the CAPS Lock status and Number Lock status here.

Backstage view

backstage view

Backstage view gives you various options for saving, opening a file, printing, and sharing your Workbook. To access Backstage view, click the File tab on the Ribbon.

Backstage view after click on File tab

Backstage view after click on File tab

Click on Back button to back to normal view

Backstage view Options

1Return to ExcelYou can use the arrow to close Backstage view and return to Excel.
2InfoThe Info pane will appear whenever you access Backstage view. It contains information about the current workbook.
3NewFrom here, you can create a new blank workbook or choose from a large selection of templates.
4OpenFrom here, you can open recent workbooks, as well as workbooks saved to your OneDrive or on your computer.
5Save and Save AsUse Save and Save As to save your workbook to your computer or to your OneDrive.
6PrintFrom the Print pane, you can change the print settings and print your workbook. You can also see a preview of your workbook.
7ShareFrom here, you can invite people to view and collaborate on your workbook. You can also share your workbook by emailing it as an attachment.
8ExportYou can choose to export your workbook in another format, such as PDF/XPS or Excel 1997-2003.
9CloseClick here to close the current workbook.
10AccountFrom the Account pane, you can access your Microsoft account information, modify your theme and background, and sign out of your account.
11OptionsHere, you can change various Excel options, settings, and language preferences.

Worksheet Overall

Worksheet Overall

Some Fact about Excel

Work Book:-

MS Excel File known as Workbook and extension is (.xlsx) . A workbook is collection of worksheets.

Worksheet :-

A Worksheet consists Columns and Rows and the intersection of Column and Row is know as cell. So a worksheet is group of cells.

Total Number of Column in a worksheet :- 16,384 & Last header is (XFD)

Total Number of Row in a Worksheet :- 10,48,576

Total Number of Cell in a worksheet :-16384 x 1048576 = 17,17,98,69,184 cells

Total Number of sheet in a workbook :- Unlimited

Default Number of worksheets when a workbook load :- 1 worksheet

Pages: 1 2 3 4

Leave a Reply

Your email address will not be published. Required fields are marked *