Table of Contents
Introduction
In this lesson, we will tell you the basics of Microsoft Excel 2016. If you are new to this course then you must first read our Lesson # 1 Introduction to Microsoft Excel, so that you can understand Microsoft Excel well. So, let’s go now to know the basics of Microsoft Excel.
In this section, we introduce one by one following Microsoft Excel Basics.
- Tabs
- Ribbon
- Worksheet
- Workbook
- Templates
- Format Cells
- Find and Select
- Import
- Export
- Data Validation
- Protect
- Share
- Shortcut Keys
Tabs
The tabs are on the top of the following Figure i.e. File, Home, Insert, Page Layout, Formulas, Data, Review, and View.
These tabs are consisting of the many commands in MS Excel. Each tab has a group of commands. See below the Data tab has some groups, like Get External Data, Get & Transform, and Connects, etc.
Ribbon
The ribbon shows with the File, Home, Insert, Page Layout, Formulas, Data, Review, and View tabs. Each tab contains the most commands on a ribbon.
How to use Ribbon?
Suppose, we use it to wrap text in the sheet. Write some words in some rows in the sheet then it wraps the text.
Follow these steps:
- Select rows with range C1:C3,
- On the Home tab, click Wrap Text
Result show:
How to Collapse the Ribbon?
You get more space with using collapse the ribbon. Right-click anywhere on the ribbon, and click on Collapse the Ribbon, the ribbon is hidden.
Result Show:
How to Show the Ribbon?
Worksheet
The worksheet depends on limited memory and system resources. A worksheet is consists of rows and columns. We quickly work on the worksheet. You can also work on multiple worksheets at the same time by grouping worksheets together. Now we learn worksheet specifications and features.
Worksheet Specifications
| Sr # | Features | Limits |
|---|---|---|
| 1 | Total Rows | 1048576 |
| 2 | Total Columns | 16384 |
| 3 | Row Hieght | 409 Points |
| 4 | Column Width | 255 Characters |
| 5 | Total Characters in a Cell | 32767 |
| 6 | Total Characters in a Header | 255 |
| 7 | Total Characters in a Footer | 255 |
| 8 | Page Breaks (Horizontal & Vertical) | 1026 |
| 9 | Sheets in a Workbook | default is 1 sheet Excel 2016, old version has default 3 sheets, |
| 10 | Total Hyperlinks in a Worksheet | 65530 |
| 11 | Zoom Range | 10 to 400 % |
| 12 | File Name Length | 218 Characters |
Workbook
The workbook depends on the collection of worksheets. The workbook is the file of Microsoft Excel file. There are we create a workbook in MS Excel.
Create a Workbook in MS Excel
Whenever we work within MS Excel, whether it is a data entry chart, table, etc. An MS Excel file is called a workbook. Now we show you how to create a new workbook.
- Open MS Excel
- Select Blank Workbook
- Then you enter data or any as per your requirement, then save it.
Templates
A Template is a pre-designed spreadsheet that you can use to create a new spreadsheet using the same format data and predefined formulas. There are many templates in MS Excel 2016. In this section, we tell you how to create a workbook with the template. And other many templates are available on MS Office Official website templates.office.com
Using Templates in MS Excel 2016
There are many templates in MS Excel 2016. In this section, we tell you how to use a template.
- Open MS Excel
- Type Home Inventory in the search bar on the top
- Select Home Inventory template
- Home Inventory Template window opened
- Click Create button
- Template downloading and will be opened
