Excel Basics

Lesson # 2 Microsoft Excel Basics

  • Post category:MS Excel

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
  • Print
  • 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.

MS Excel Tabs

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. 

Excel 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.

Some Word for Wrap Text

Follow these steps:

  1. Select rows with range C1:C3, 
  2. On the Home tab, click Wrap Text 
Range Rows

Result show:

Wrap Text Result

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. 

Collapse Ribbon

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. 
MS Excel New Workbook

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 

MS Excel Templates

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
Using Templates
  • Select Home Inventory template
  • Home Inventory Template window opened
Home Inventory Template
  • Click Create button
  • Template downloading and will be opened
Home Inventory Template

Leave a Reply