1 00:00:13,310 --> 00:00:14,030 Hi, everyone. 2 00:00:15,190 --> 00:00:20,960 If you want to add developer ribbon tab to your interface, what would you do? 3 00:00:22,190 --> 00:00:31,700 Well, this is take us to learn a new feature and the new technique about customization, interface 4 00:00:31,700 --> 00:00:33,810 customization in Microsoft Excel. 5 00:00:34,580 --> 00:00:38,230 So we will learn today an important thing. 6 00:00:38,600 --> 00:00:42,050 It's about customize the ribbons. 7 00:00:43,160 --> 00:00:59,180 You can click on any ribbon group and select, customize the ribbon or you can use it more options and 8 00:00:59,180 --> 00:01:01,300 select customized Drebin. 9 00:01:01,940 --> 00:01:05,000 So this is all ribbons in Excel. 10 00:01:05,780 --> 00:01:12,830 In the previous lecture, we have learned to use quick access toolbar and we have learned to add or 11 00:01:12,830 --> 00:01:17,240 remove any command in quick access toolbar. 12 00:01:17,930 --> 00:01:25,760 And there are several commands and quick exit toolbar such as Save, Undo, Redo and Open. 13 00:01:27,510 --> 00:01:38,270 Now we want to answer the question, this question, how to add the ribbon so we will use customized 14 00:01:38,270 --> 00:01:38,600 ribbon. 15 00:01:39,290 --> 00:01:50,630 So customized ribbon have made taps and all types and tool taps from many taps. 16 00:01:51,290 --> 00:01:58,240 You can add or remove any ribbon tab by check or uncheck in this tab. 17 00:01:58,760 --> 00:02:09,640 For example, if you want to delete old old taps in the TAP toolbar, you can just check on them. 18 00:02:10,040 --> 00:02:19,910 So if you want to check insert page layout, formula data, if you view ons help home. 19 00:02:20,870 --> 00:02:28,430 And OK, so no taps here. 20 00:02:30,580 --> 00:02:43,900 Altered or disappeared, if you want to add this tab again, five more options, customized ribbon and 21 00:02:43,900 --> 00:02:45,220 check all these steps. 22 00:02:51,450 --> 00:03:03,030 Here is but the question is, how can I add developer tab to my tab ribbons, right. 23 00:03:03,030 --> 00:03:09,170 Click from here, customize it or find more options. 24 00:03:10,400 --> 00:03:14,560 Customized ribbon and check on developer, this devil worship. 25 00:03:15,450 --> 00:03:15,950 OK. 26 00:03:17,190 --> 00:03:26,120 Here is the tape and we will discuss this tape in detail in the advanced stage of this course. 27 00:03:27,150 --> 00:03:27,510 Well. 28 00:03:29,030 --> 00:03:31,400 What about customized ribbon? 29 00:03:31,430 --> 00:03:42,890 What about the other features and the other options and customizable so you can make a new step by adding 30 00:03:42,890 --> 00:03:45,120 Newtek and rename the step? 31 00:03:46,940 --> 00:03:49,360 I can't really make by smartphone. 32 00:03:51,430 --> 00:03:51,980 OK. 33 00:03:54,050 --> 00:03:57,050 And you can rhenium also Euterpe. 34 00:03:58,770 --> 00:03:59,730 By Smardon. 35 00:04:04,770 --> 00:04:16,080 So I have created a new tab called Smart, that and new Reben group called Smarter and I can add any 36 00:04:16,080 --> 00:04:17,700 comment I want to use. 37 00:04:17,820 --> 00:04:27,030 So if I want to add full color to this Raven Group, just add full color. 38 00:04:27,480 --> 00:04:36,240 I can add, for example, borders, and I want to add also save add. 39 00:04:36,690 --> 00:04:47,100 So I make a new step with a new ribbon group with a new three commonly used commanders based on my using 40 00:04:47,100 --> 00:04:47,940 Microsoft Excel. 41 00:04:47,940 --> 00:04:52,190 And these commands are full color borders safe. 42 00:04:52,890 --> 00:04:53,400 OK. 43 00:04:54,330 --> 00:05:05,070 So this is our new test, Smarter Tap, and this is our new reading group, Smarter, and this is the 44 00:05:05,070 --> 00:05:07,560 selected commanders here. 45 00:05:08,450 --> 00:05:17,480 We have selected from customized ribbon, and by this way, I can change o the face and the default 46 00:05:17,480 --> 00:05:23,700 interface of Microsoft Excel by adding and removes commands, steps, ribbons. 47 00:05:24,800 --> 00:05:27,260 This is customization, great customization. 48 00:05:27,410 --> 00:05:32,690 I can reformulate all this interface based on my use. 49 00:05:32,910 --> 00:05:35,090 And this is the power of ribbon customization. 50 00:05:37,720 --> 00:05:45,380 OK, this is our commanders and this is all commanders, this is commanders not in the ribbon. 51 00:05:46,180 --> 00:05:57,310 This is macro commanders and this is fight step and this is all taps and this is main taps and this 52 00:05:57,310 --> 00:06:02,590 tool taps and customized and group. 53 00:06:02,890 --> 00:06:04,220 So it's powerful. 54 00:06:04,600 --> 00:06:10,060 Moreover, what if I want to save the theme or this customization? 55 00:06:12,400 --> 00:06:14,880 Can I save them or report them to a file? 56 00:06:15,220 --> 00:06:23,080 And can I use the theme again to automatically report it to another Excel sheet? 57 00:06:23,110 --> 00:06:30,640 Of course, you can't save this seam by export all customizations. 58 00:06:31,660 --> 00:06:38,320 You will export all customization file to your desktop, for example, and to save. 59 00:06:43,550 --> 00:06:54,110 So this will have that customized ribbons based on your views, you can import this customization to 60 00:06:54,110 --> 00:06:59,060 any other Excel sheet, to any other personal computer. 61 00:06:59,720 --> 00:07:04,550 So just go to Excel, right? 62 00:07:04,550 --> 00:07:14,180 Click customize the ribbon and import this customization and both customization, file desktop and select 63 00:07:14,780 --> 00:07:23,340 and replace all existing existing ribbon and quick access toolbar customization for this program. 64 00:07:23,360 --> 00:07:24,020 Yes. 65 00:07:24,020 --> 00:07:31,130 If you do if you click yes, then you have imported this customization. 66 00:07:35,140 --> 00:07:46,380 This is about customizer, even this about how to reformulate and reinvent the exel interface and use 67 00:07:46,390 --> 00:07:51,050 the common commands based on your own usage. 68 00:07:51,490 --> 00:07:54,070 Thank you and see you in the next lecture.