Learn Microsoft Excel Basic to Advance | Myanmar Language Ep.1
33.4 هزار بار بازدید -
4 سال پیش
-
Myanmar language to learn Microsoft
Myanmar language to learn Microsoft Excel from Basic to Advance
HOW TO NAVIGATE TO MICROSOFT EXCEL FROM THE COMPUTER?
Welcome to WLH Education Channel. Let start with Microsoft Excel. Method 1, on the windows taskbar menus,
• Click on the “Start” button
• Scroll down the list and you will see you have installed Microsoft Excel.
• Then Click on the Excel App.
Method 2
• On the window taskbar
• Navigate to the search button beside the “Start” button
• Type “Excel” or “Microsoft Excel”
Then you will see Excel has displayed the recent screen in backstage view. This screen or the first user interface is called the Backstage View.
INFORMATION ABOUT THE BACKSTAGE VIEW OR FIRST USER INTERFACE OF EXCEL APPLICATION
• Click on “Open” from which you can open your recent documents or saved documents.
• Click on “New” you can open a new workbook from here and also you can also open different varieties of FREE templates from here.
• Click on the “Backward Arrow” button on the top left of the backstage screen or the first screen of the excel, which brings you to the visual display of the Excel screen. This is also called a “Spreadsheet”. The first time you get to the excel spreadsheet is seen as “Sheet1” which you can see at the bottom left of the screen.
WHAT IS SPREADSHEET? WHERE ARE THEY USED? WHAT ARE BENEFITS OR ADVANTAGES?
For now, let go into detail about the Spreadsheet. Inside or an Excel spreadsheet, text, number, and values are added or put or entered in rectangular cells or tables. Many business and companies benefit from Spreadsheets as they have vast advantages on them such as budgeting, management, and other sectors as well and it also helps prepare REPORTS such as a financial report. We can also draw charts, graphs such as line charts, bar charts, stack charts, pie charts, etc. in spreadsheets. To sum up, a spreadsheet contains rows and columns where we users can enter or put or create or insert text, numbers, and values.
EXCEL TABS, GROUPS, AND COMMANDS
The top area of the Excel where tabs like “Files, Home, Insert, Page Layout…” exist is called “Ribbons”. Ribbons show different types of tabs, each tab has its own group of commands, functions, and abilities. In the “Home” tab, there you will see many tabs. For example, in the font group, this group has
• Font color command, it also has
• Font fill color command,
• Similarly, other commands such as functions of bold, italic, underline, etc.
• You can increase or decrease the size of the font with the command shaped like “A with upward arrow” for increase font and “A with downward arrow” for decrease font.
Therefore, you can see that every tab has many groups.
WHAT IS FORMULA BAR AND WHERE IS FORMULA BAR?
The bar with or beside the symbol “fx” is called the formula bar. Formula bars show the formula, text, numbers, and values which are entered into the active cells in the spreadsheet. Type something in the active cell will also show that thing in the formula bar.
WHAT OR WHERE IS REFERENCE BOX OR NAME BOX IN EXCEL?
The box approximately above column A is the “Name box” which shows the reference of the active cell. The Name box will show the cell you selected.
DON’T WANT TO SEE RIBBON (TABS TOP OF THE EXCEL) ANY MORE? TO DISAPPEAR RIBBON?
You can collapse the ribbon by clicking the “Upward Arrow” symbol on the rightmost hand of the ribbon.
WANT TO DISPLAY OR HOW TO MAKE RIBBONS APPEAR AGAIN?
You can click the symbol like “Upward arrow in a box” which is located left side of the “Minimize” button of the excel app.
QUICK ACCESS TOOLBAR
There are many commands in the quick access toolbar such as “Save, Undo, Redo” and others such as “Automatically Save, Quick Print, Email, Open” etc. if you want to add the “Quick Print” button on the top left of the Excel app, click on Quick Access toolbar then click on “Quick Print”. If you want to add spelling, click spelling. If you want more commands, click “More commands” from QAT, which brings you to the “Excel Options” dialogue box in which there are many more commands. You can scroll down the list and let say find the “Sum” button then click the “Add” button, then click OK. Then you can see the “Sum” button is added to QAT. You can enter a simple number anywhere. Then click the “Sum” button that appears from the QAT which provides you the direct answer.
AS BENEFITS
QAT speeds up your work and you can save time.
Follow Us on Facebook:
Facebook: WaiLinHtetUSYD
WLH Education Channel
@wlheducation9109
အစီအစဉ် - ၁။ Microsoft Word Basic to Advance Course
https://www.youtube.com/playlist?list...
အစီအစဉ် - ၂။ Microsoft Excel Basic to Advance Course
https://www.youtube.com/playlist?list...
အစီအစဉ် - ၃။ R-Programming for Data Science Course
https://www.youtube.com/playlist?list...
HOW TO NAVIGATE TO MICROSOFT EXCEL FROM THE COMPUTER?
Welcome to WLH Education Channel. Let start with Microsoft Excel. Method 1, on the windows taskbar menus,
• Click on the “Start” button
• Scroll down the list and you will see you have installed Microsoft Excel.
• Then Click on the Excel App.
Method 2
• On the window taskbar
• Navigate to the search button beside the “Start” button
• Type “Excel” or “Microsoft Excel”
Then you will see Excel has displayed the recent screen in backstage view. This screen or the first user interface is called the Backstage View.
INFORMATION ABOUT THE BACKSTAGE VIEW OR FIRST USER INTERFACE OF EXCEL APPLICATION
• Click on “Open” from which you can open your recent documents or saved documents.
• Click on “New” you can open a new workbook from here and also you can also open different varieties of FREE templates from here.
• Click on the “Backward Arrow” button on the top left of the backstage screen or the first screen of the excel, which brings you to the visual display of the Excel screen. This is also called a “Spreadsheet”. The first time you get to the excel spreadsheet is seen as “Sheet1” which you can see at the bottom left of the screen.
WHAT IS SPREADSHEET? WHERE ARE THEY USED? WHAT ARE BENEFITS OR ADVANTAGES?
For now, let go into detail about the Spreadsheet. Inside or an Excel spreadsheet, text, number, and values are added or put or entered in rectangular cells or tables. Many business and companies benefit from Spreadsheets as they have vast advantages on them such as budgeting, management, and other sectors as well and it also helps prepare REPORTS such as a financial report. We can also draw charts, graphs such as line charts, bar charts, stack charts, pie charts, etc. in spreadsheets. To sum up, a spreadsheet contains rows and columns where we users can enter or put or create or insert text, numbers, and values.
EXCEL TABS, GROUPS, AND COMMANDS
The top area of the Excel where tabs like “Files, Home, Insert, Page Layout…” exist is called “Ribbons”. Ribbons show different types of tabs, each tab has its own group of commands, functions, and abilities. In the “Home” tab, there you will see many tabs. For example, in the font group, this group has
• Font color command, it also has
• Font fill color command,
• Similarly, other commands such as functions of bold, italic, underline, etc.
• You can increase or decrease the size of the font with the command shaped like “A with upward arrow” for increase font and “A with downward arrow” for decrease font.
Therefore, you can see that every tab has many groups.
WHAT IS FORMULA BAR AND WHERE IS FORMULA BAR?
The bar with or beside the symbol “fx” is called the formula bar. Formula bars show the formula, text, numbers, and values which are entered into the active cells in the spreadsheet. Type something in the active cell will also show that thing in the formula bar.
WHAT OR WHERE IS REFERENCE BOX OR NAME BOX IN EXCEL?
The box approximately above column A is the “Name box” which shows the reference of the active cell. The Name box will show the cell you selected.
DON’T WANT TO SEE RIBBON (TABS TOP OF THE EXCEL) ANY MORE? TO DISAPPEAR RIBBON?
You can collapse the ribbon by clicking the “Upward Arrow” symbol on the rightmost hand of the ribbon.
WANT TO DISPLAY OR HOW TO MAKE RIBBONS APPEAR AGAIN?
You can click the symbol like “Upward arrow in a box” which is located left side of the “Minimize” button of the excel app.
QUICK ACCESS TOOLBAR
There are many commands in the quick access toolbar such as “Save, Undo, Redo” and others such as “Automatically Save, Quick Print, Email, Open” etc. if you want to add the “Quick Print” button on the top left of the Excel app, click on Quick Access toolbar then click on “Quick Print”. If you want to add spelling, click spelling. If you want more commands, click “More commands” from QAT, which brings you to the “Excel Options” dialogue box in which there are many more commands. You can scroll down the list and let say find the “Sum” button then click the “Add” button, then click OK. Then you can see the “Sum” button is added to QAT. You can enter a simple number anywhere. Then click the “Sum” button that appears from the QAT which provides you the direct answer.
AS BENEFITS
QAT speeds up your work and you can save time.
Follow Us on Facebook:
Facebook: WaiLinHtetUSYD
WLH Education Channel
@wlheducation9109
အစီအစဉ် - ၁။ Microsoft Word Basic to Advance Course
https://www.youtube.com/playlist?list...
အစီအစဉ် - ၂။ Microsoft Excel Basic to Advance Course
https://www.youtube.com/playlist?list...
အစီအစဉ် - ၃။ R-Programming for Data Science Course
https://www.youtube.com/playlist?list...
4 سال پیش
در تاریخ 1399/02/23 منتشر شده
است.
33,436
بـار بازدید شده