1 00:00:13,120 --> 00:00:21,820 Hi, everyone, and this picture, we are going to explore, Microsoft Excel, the objectives of this 2 00:00:21,820 --> 00:00:29,500 lecture are exploring Start-Up Screen Excel interface and learn how to customize Ribbon's. 3 00:00:30,720 --> 00:00:40,560 When you open Microsoft Excel, you will find title bar, quick access toolbar and file type REBIN Command 4 00:00:40,860 --> 00:00:49,800 group name box formula, bar code on bar and your account name. 5 00:00:51,540 --> 00:00:57,010 Let's get started about this interface and know it in some details. 6 00:00:58,020 --> 00:01:04,690 So let's open Microsoft Excel and analyze each component of this interface. 7 00:01:05,430 --> 00:01:14,200 First thing is title bar title bar is showing the name of workbook. 8 00:01:15,480 --> 00:01:21,690 So this workbook is called Book three and this is its name. 9 00:01:22,530 --> 00:01:29,730 After that quick access toolbar is Bar contains some features and commands of Microsoft Excel, such 10 00:01:29,730 --> 00:01:38,880 as New Open Save Email, Quick print, Andu Greedo sending sort ascending or descending. 11 00:01:39,150 --> 00:01:46,920 And you can choose any command you want to add to this quick access toolbar. 12 00:01:47,550 --> 00:01:54,120 This is all commanders of Microsoft Excel and you can select all commands by clicking here. 13 00:01:54,120 --> 00:01:57,600 And this is all commanders of Microsoft Excel. 14 00:01:58,260 --> 00:02:09,540 And you can add this icon to this bar by adding or checking or on checking a specific command. 15 00:02:09,570 --> 00:02:17,160 So if you want to remove check from this quick X toolbar, just uncheck save. 16 00:02:18,270 --> 00:02:21,400 So it's deleted. 17 00:02:22,050 --> 00:02:26,300 So if you want to remove all commands and check all commands. 18 00:02:27,390 --> 00:02:33,320 So this is quick access toolbar has no command. 19 00:02:34,710 --> 00:02:51,360 So if you want to add, um, specific commands such as save or undo and redo and open so you can open 20 00:02:51,360 --> 00:03:03,600 it, you can open by file open or you can use click access toolbar icon from here to open and use open 21 00:03:03,600 --> 00:03:05,140 of work book. 22 00:03:07,260 --> 00:03:09,600 So this is quick access toolbar. 23 00:03:10,140 --> 00:03:20,750 You can show below the ribbon here and you can click and the show above the ribbon here. 24 00:03:23,370 --> 00:03:28,770 Also there is a file type ribbon. 25 00:03:29,220 --> 00:03:34,710 Microsoft Excel is designed by using several Cribbins. 26 00:03:35,070 --> 00:03:48,240 So there is file type ribbon and home type ribbon and insert ribbon and page layout, ribbon type and 27 00:03:48,240 --> 00:03:52,140 all these steps called Ribbentrop. 28 00:03:54,270 --> 00:03:57,060 Each Ribbentrop consists of. 29 00:03:58,530 --> 00:04:07,170 Rebin Group, so Clipboard is a rebel group formed as a rebel group alignment is a rebel group and each 30 00:04:07,170 --> 00:04:11,430 rebel group consists of a group of commands. 31 00:04:12,300 --> 00:04:24,210 So alignment consists of top align command and middle aligned command and lower or bottom command. 32 00:04:25,530 --> 00:04:34,260 So this is a structure of commanding in the Microsoft Excel, Ribbentrop, then Raven Group, then command. 33 00:04:35,910 --> 00:04:45,360 After that, there is name books, this is name books, netbooks chose the name of self, you stand 34 00:04:45,370 --> 00:04:45,530 this. 35 00:04:47,100 --> 00:04:55,860 So if you start on a one, you will find the name books yone if you stand this on C5. 36 00:04:56,790 --> 00:05:01,850 The name books will chose see five Antawn. 37 00:05:03,180 --> 00:05:10,740 And this is formal, but we will you we will know it in detail in the formula lecture. 38 00:05:12,830 --> 00:05:22,850 Also, there is no this is all Colomba Microsoft Excel sheet consists of a group of columns and a group 39 00:05:22,850 --> 00:05:31,300 of rows and these columns and these rows devolving max of Excel cells. 40 00:05:31,430 --> 00:05:38,180 So each cell is just intersection between a column and the row. 41 00:05:39,260 --> 00:05:40,640 So this is. 42 00:05:42,510 --> 00:05:45,780 Go to war and this is rollbar. 43 00:05:48,060 --> 00:05:59,910 So summarizing all this interface, we have discussed title bar, quick access toolbar, file type ribbon, 44 00:06:00,090 --> 00:06:05,340 ribbon taps, ribbon group commands. 45 00:06:08,110 --> 00:06:16,660 Inside each rebel group named Box Formula Mulbah, Colomba rollbar, your account, by the way, I want 46 00:06:16,660 --> 00:06:25,270 to sign up with my account, so I will use my email to sign up. 47 00:06:29,840 --> 00:06:31,910 Haitham Salemi. 48 00:06:36,360 --> 00:06:40,440 At G mail dot com. 49 00:06:46,000 --> 00:06:46,750 My password. 50 00:06:55,510 --> 00:06:56,570 Oh, yeah, that's it. 51 00:06:57,260 --> 00:07:03,650 So I have signed up by my account and this is my account here by Hisam almost. 52 00:07:06,090 --> 00:07:14,400 So this is the first slide about exploring Excel and about Excel interface. 53 00:07:14,880 --> 00:07:17,790 Let's get started and continue about Excel interface. 54 00:07:19,800 --> 00:07:31,410 This is rollbar and this is the first sheet, the sheet and each Excel book consists of one or more 55 00:07:31,440 --> 00:07:39,060 about this Excel sheet, and this is a sheet area consisting of some of cells. 56 00:07:39,060 --> 00:07:46,100 And each cell is an intersection between column and row. 57 00:07:47,700 --> 00:07:48,630 And this is cell. 58 00:07:50,980 --> 00:07:55,810 And this is scrollbar, you can scroll up down or vertical. 59 00:07:56,820 --> 00:07:59,970 And horizontal, and you can scroll to lift. 60 00:08:01,170 --> 00:08:06,810 And this is Zoome control, you can zoom the sheet, minimize or maximize. 61 00:08:08,300 --> 00:08:09,920 And this is a view patterns. 62 00:08:14,950 --> 00:08:25,980 Zoom, slider, you can maximize and minimize the Excel sheet by increasing or decreasing the setting. 63 00:08:26,800 --> 00:08:33,640 And there is a medical advice here to your eye health and more clearly reading. 64 00:08:34,150 --> 00:08:43,880 You should increase zoom by 10 percent for reading and for your eye health. 65 00:08:44,350 --> 00:08:47,530 So how to do that? 66 00:08:48,670 --> 00:08:49,660 Just open Excel. 67 00:08:50,140 --> 00:08:51,610 You can lead the slide now. 68 00:08:52,840 --> 00:09:02,410 And this is the scroll horizontally and the scroll to Right and left and this is Zoom Slider. 69 00:09:03,340 --> 00:09:13,510 You just select slider and you can increase by 10 percent by select, customize and write one hundred 70 00:09:14,440 --> 00:09:25,120 and ten percent and OK, so all the interface column name and the Colomba and Rabbah are increased by 71 00:09:25,120 --> 00:09:25,800 10 percent. 72 00:09:25,810 --> 00:09:34,990 And this is more convenient to your eye and your reading and your your application in Microsoft Excel 73 00:09:35,590 --> 00:09:36,340 view patterns. 74 00:09:39,070 --> 00:09:48,710 There are three layouts of your buttons normally out to you, page, layout, view and page view, normal 75 00:09:48,740 --> 00:09:49,370 layout view. 76 00:09:49,390 --> 00:09:55,500 This is a normal layout you use when you open Microsoft Excel page layout view. 77 00:09:55,660 --> 00:10:07,570 You can use it in the printing Microsoft Excel sheet and we will explain this views in detail and print, 78 00:10:08,680 --> 00:10:11,000 lecture and page view. 79 00:10:11,370 --> 00:10:22,750 You can use it also in printing work, but we have explained Reben and this is Ribbentrop, and each 80 00:10:22,750 --> 00:10:34,930 ribbon type consists of ribbon group such as alignment, phone number, etc. and each ribbon group consists 81 00:10:34,930 --> 00:10:42,430 of some commands and each ribbon group has a dialog launcher. 82 00:10:43,870 --> 00:10:54,670 And this launcher, such as alignment, if you click on this corner or Dierig launcher, you will find 83 00:10:54,670 --> 00:11:00,010 a description about this rebel group. 84 00:11:00,610 --> 00:11:02,050 So alignment setting. 85 00:11:03,230 --> 00:11:14,300 Click here, you can eliminate you can use all this option to justify and to adjust alignment in the 86 00:11:14,300 --> 00:11:16,130 cell and alignment of the text. 87 00:11:17,310 --> 00:11:17,700 OK. 88 00:11:19,400 --> 00:11:20,240 Exurban. 89 00:11:25,500 --> 00:11:37,050 So exurban are fine home, sir, throw out formulas, data review, view, help developer, this is 90 00:11:37,050 --> 00:11:40,500 our Excel Raybans in Microsoft Excel. 91 00:11:43,000 --> 00:11:53,530 And this customizer, when we have discussed this football, you can hide, show or remove these ribbons 92 00:11:53,890 --> 00:11:57,430 by this icon to appear. 93 00:12:02,580 --> 00:12:06,960 Control, you can use it, you can hide and excel by control, if one. 94 00:12:09,830 --> 00:12:20,450 You can also add to quick access toolbar any of this ribbon group so you can hear. 95 00:12:22,470 --> 00:12:34,140 Hide all this ribbon and you can't show taps only and you can't show Tab and the commands and you can't 96 00:12:34,150 --> 00:12:39,840 hide commands and you can't fix it commands again. 97 00:12:39,840 --> 00:12:43,440 Open the driven again by using control of one. 98 00:12:45,980 --> 00:12:57,440 And this is all news, and this is one option to change the view of Microsoft Excel workbook, also 99 00:12:58,190 --> 00:13:08,450 you can add charges to Quick Access Toolbar, right click and add to Quick Access Toolbar. 100 00:13:08,750 --> 00:13:18,980 So Chartist, I couldn't have added here and you can use it by click, by left click. 101 00:13:18,990 --> 00:13:31,790 You can use all commanders of the Chartist Rebin here and you can delete this chart by right click and 102 00:13:31,790 --> 00:13:34,130 select remove from quick access toolbar. 103 00:13:35,510 --> 00:13:37,250 So you removed it. 104 00:13:39,930 --> 00:13:44,310 In the latest picture, we are going to discuss customize the ribbons. 105 00:13:48,520 --> 00:13:54,670 We will discuss the terrible thank you and to you in the next lecture.