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.
Creating new workbooks.
Click on Blank Workbook ( a blank workbook will be created.)
Using Save As.
This command is used to give the name to the workbook.
OneDrive: Files will be save on (OneDrive by Microsoft) it needs Internet Connection and Microsoft Account).
This PC: The Currently PC you are using, file will be saved on it.
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.
Updating data or save work into workbook.
Close the workbook.
Open the workbook.
Recent: Recently working files will be displayed.
OneDrive: OneDrive files will be displayed.
This PC: Your current PC files will be shown.
When you will click on Browse: Location of your PC and OneDrive will be displayed.
give the location of the file.
How to Enter Data into the worksheet.
Exploring data entry and editing techniques.
To edit in the text cell.
double click on the cell.
Create changes into formula bar.
Two typing patterns are used in Microsoft Excel for typing.
The 1-text pattern goes to right side.
The 2-numbers pattern goes to the left side.
Entering data with AutoFill.
- Type any month.
- keep Mouse’s cursor on the down right-hand side. as shown in below image.
- dragging it at down. like below image.
- The result will be shown like below image.
Note: This Technique can be used with numbers, Month, Days also.
Working with date and time.
For Date: Ctrl+;
For Time: Ctrl+;
Using Undo and Redo.
Click on the cell where you want to give.