1.2 lesson 2 Components of a worksheet, cell, active cell, range, Name box, formula bar, row Heading

In this video you will learn (lesson 2) Components of a worksheet, cell, active cell, range, Name box, formula bar, row Heading, Column Headings, Moving around the spreadsheet, Entering data , Performing calculations, rename sheet
in this video you will learn. How to open saved file in Microsoft Excel? Then what is excel? What is cell? What is range? What is the difference between formula and function? How to resize spreadsheet? How to resize page? How to resize a spreadsheet by using mouse wheel? How to resize by using mouse cursor? How to create weekly expense? How to identify column headings? What is column heading? What is row heading? How to understand better self? What is cell address? How to remember cell names? Easy way to understand self. How to calculate? What is basic calculation of Excel? What is most useless function? What is difference between formula and function? How to drag and auto fill? Please watch full video and don't forget to like, share and subscribe.
#timestamps
0:30 2 ways to open saved file in Microsoft excel
1:00 How to zoom in or zoom out worksheet
1:38 How to Change sheet1 to your any name (Rename Worksheet).
1:51 How to take 2nd or multiple sheet
2:00 Introduction to a cell
2:16 Define Cell Name easily
3:40 What is Active Cell
4:15 What is Cell Pointer
4:30 What is Range in excel
4:59 How to move from one cell to another cell
5:38 Difference Between Tab and Shift+Tab, Enter and Shift+Enter
6:25 How to Select Multiple cells
6:50 How to Merge Cells
7:00 What is Merge
7:30 Create Monthly expense in excel
7:40 How to write first letter of the word capital without CapsLock
8:30 Weekly Expenses Table
8:54 Excel Similar word suggestion
10:18 2 ways, How to Adjust text inside cells
11:11 Total Formula in weekly expenses
11:40 How to modify, edit formula
13:37 What is difference between formula and function
13:48 What is operators
14:18 use of Sum (function)
15:38 How to check applied formula
16:04 Conclusion
Lesson 1.1 https://youtu.be/6iIwmEm0yXo
#youtube
#viral
#excel
#excelforbeginners
@mahally_graphics
@Mahally_Tech
Channel link: https://www.youtube.com/channel/UCgXuawgOD22jgAqWCqT4kvQ

Видео 1.2 lesson 2 Components of a worksheet, cell, active cell, range, Name box, formula bar, row Heading канала Mahally Graphics