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
Press Win key From Keyboard and Type Excel and hit the Enter Key
Press Win+R to open Run command Dialog Box then Type “Excel” and press Enter key.
MS-Excel 2013 / 2016 / 2019 Interface
Ms-Excel 2013 / 2016 / 2019 Screen Components
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
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
The Quick Access Toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Redo commands.
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 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
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
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
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
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 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
Click on Back button to back to normal view
Backstage view Options
|1||Return to Excel||You can use the arrow to close Backstage view and return to Excel.|
|2||Info||The Info pane will appear whenever you access Backstage view. It contains information about the current workbook.|
|3||New||From here, you can create a new blank workbook or choose from a large selection of templates.|
|4||Open||From here, you can open recent workbooks, as well as workbooks saved to your OneDrive or on your computer.|
|5||Save and Save As||Use Save and Save As to save your workbook to your computer or to your OneDrive.|
|6||From the Print pane, you can change the print settings and print your workbook. You can also see a preview of your workbook.|
|7||Share||From here, you can invite people to view and collaborate on your workbook. You can also share your workbook by emailing it as an attachment.|
|8||Export||You can choose to export your workbook in another format, such as PDF/XPS or Excel 1997-2003.|
|9||Close||Click here to close the current workbook.|
|10||Account||From the Account pane, you can access your Microsoft account information, modify your theme and background, and sign out of your account.|
|11||Options||Here, you can change various Excel options, settings, and language preferences.|
Some Fact about Excel
MS Excel File known as Workbook and extension is (.xlsx) . A workbook is collection of worksheets.
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