New Posts
Home / Computer 4 Beginners / Microsoft Excel 2016 Workbook Basics.

Microsoft Excel 2016 Workbook Basics.

Microsoft Excel 2016 Workbook Basics

In this lesson, you will learn about Microsoft Excel 2016 Workbook Basics and how to enter data into the worksheet. Where I have discussed following topics:

  • Creating a new workbook.
  • Using Save As.
  • Close workbook.
  • Open workbook.
  • Exploring data entry and editing techniques.
  • Entering data with AutoFill.
  • Working with dates and times.
  • Using Undo and Redo.
  • Adding comments.

Workbook-Basics

Creating new workbooks.

File.

New.

Click on Blank Workbook ( a blank workbook will be created.)

(ctrl+N).

 Creating new workbooks

Using Save As.

File.

Save as.

This command is used to give the name to the workbook.

(F12).

Using Save As

save as of excel

 save as this pc

OneDrive: Files will be save on (OneDrive by Microsoft) it needs Internet Connection and Microsoft Account).

save ondrive

This PC:  The Currently PC you are using, file will be saved on it.

 save as this pc

Add a Place: I will explore the internet.

Browse: A saving dialogue box will be shown. Where you can save your file according to your location.

 save as this pc

Updating data or save work into workbook.

File.

Save (ctrl+s).

Updating data or save work into workbook

Close the workbook.

File.

Close.

(ctrl+w).

Open the workbook.

File.

Open.

(ctrl+o).

Open

Recent: Recently working files will be displayed.

 open recent

OneDrive: OneDrive files will be displayed.

 open ondrive

This PC: Your current PC files will be shown.

this pc

When you will click on Browse: Location of your PC and OneDrive will be displayed.

Computer.

Browse.

 open location

give the location of the file.

select file.

open.

How to Enter Data into the worksheet.

Exploring data entry and editing techniques.

Adding comments

To edit in the text cell.

First Way.

double click on the cell.

Second Way.

F2.

Third Way.

Create changes into formula bar.

Two typing patterns are used in Microsoft Excel for typing.

The 1-text pattern goes to right side.

Text pattern goes to right side.

The 2-numbers pattern goes to the left side.

Numbers pattern goes to left side.

Entering data with AutoFill.

  1. Type any month.
  2. keep Mouse’s cursor on the down right-hand side. as shown in below image.
  3. auto filling
  4. dragging it at down. like below image.
  5. auto filling
  6. The result will be shown like below image.
  7. result

Note: This Technique can be used with numbers, Month, Days also.

 

 Entering data with AutoFill

Entering data with AutoFill rows

Entering data with AutoFill days

Entering data with AutoFill date in number

Working with date and time.

For Date: Ctrl+;

For Time: Ctrl+;

Using Undo and Redo.

Using Undo and Redo

redoctrl+y

undo options

redo options

 

 

 

Adding comments.

Click on the cell where you want to give.

insert.

comment.

Adding comments

Adding comments 2

 show all comments

 comments options

 

 

 

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …