Assalamu Alaikum Warahmatullahi Wabarakatuh. How are you all? Hope everyone is well. We will start the Excel lecture from today. So basically we'll look at two parts of Excel. One is basic and the other is advanced. So, in the basic part, we will have 10 lectures, InshaAllah. And in the advanced part, we will watch 11 lectures. So first of all, we will learn about Excel, what Excel is and what it is used for. Excel for Today Lecture Number One. So Excel is basically a Microsoft Office program. Microsoft Office includes Excel. Then there's Word, there's PowerPoint. So Excel basically works with databases. Work is done on database management. If we give different examples, then it is creating a result sheet, creating a balance sheet , then creating different types of documents. So in such cases we mainly use Excel. Okay. So what are we going to learn in lecture number one today? We'll take a look at the outline of this lecture number one. First, what is Microsoft Excel and how to use it? What is Microsoft Excel and what is it used for or why do we use it? Overview of Microsoft Excel and Understanding Interface We will learn about the interface of Microsoft Excel, that is, the interface that comes when we open Excel. Then, we will look at the structure of the worksheet in which we will create data or insert data. Data entry method: How to enter data, that is, how to insert and push data here. In this article, we will see how we can go back and forth using the redo and read and end buttons. I will look into these things. Inserting Column Row. How can we insert columns and rows? Moving using Format Painter and Style. We will see how we can copy a style and paste it to another location using the Format Painter. Moving Rows and Columns. We will look at moving a column or a row from one place to another, or moving a cell from one place to another. Autofit column width and row height. Let's see how we can autofit row heights and column widths. And then there are the last basic keyboard shortcuts. Where we will see things like going back with Control Z, copying with Control C, or pasting with Control V, and so on. So first is the interface idea. The interface idea is that we learned about Excel, what exactly is Microsoft Excel and what is it actually used for? As I said at the beginning, we use Microsoft Excel for database management. From generating results to creating a balance sheet or a company's financial statement, we can create various documents using Excel. Well, we will gradually clear up these issues going forward. So first, we'll look at the idea of ​​the interface, which is actually what interface comes up when I open Microsoft Excel. So if I minimize it a little and if I double-click on Microsoft Excel from here, you might see an interface like this at the beginning. If you install Excel in a brand new state, what's actually here? I'm currently using my Microsoft Excel. If I click on Account here, you can see Microsoft Office LTSC Professional Plus 2024. This is the 2024 interface. So for those of you who are using the 2021 interface, these options might look a little different. These are almost similar. Just some updates have been made to 2024. Moreover, 21 and 24 are almost similar. So, for those of you who are using 21, there is no problem. Everything is almost the same. So after opening here, we can see that we are home. So what's here at Home? See the blank workbook here. We can create a new workbook with this blank workbook. Welcome to Excel. These are tutorials on various topics, such as formula tutorials, power query tutorials, and pivot table tutorials. So what will happen through these is that they will give you a tar. I mean, you can watch a tutorial, what else. Okay? Well, if we click on More Templates here, you can see what different templates are available here. It's like a photo calendar. Then there is the personal monthly budget. Well, here is the monthly budget. There is an academic calendar. Then if we look a little further down, there is the Sales Invoice Tracker. Then there is the loan calculator. What are these actually? These are each a prebuilt template. This means you can use different templates from here for your relevant work. If you use that template, it will look like this: Click here. Then when I click Create here, it will give me a to- do list template. You can do these tasks here, where you list your daily tasks in the form of a to-do list. For example, if I click on Create here, you'll see that it's open after a while. See what you can do here? You can list here. Here you can check what you have to do on your to-do list today. Okay? There is a button with a check mark here. This means that when you type one and click outside, it will be checked. Okay? So it's being checked. So what is this to-do list? By default, there is a template there that you can use. You can customize it. You can change the color. From here, I can use any other color if I want. What other color can I use? Okay? So that means you can use these templates from here for your relevant work if you want. Okay, then the Open button is where you can view the files that you will be working with in Microsoft Excel. You can open it. As you can see, I'm shown several files here. These files are files that I created and opened using Microsoft Excel. Which is why I need to open these files again from here. But you won't be able to see them when you install Excel fresh. Because you were n't working with any files at that time. But when you are slowly working on a file or saving a new file, you can open those files from your computer's file manager by opening it. Well, what you can do through the share option is you can share this sheet of yours online. Info: From here you can see a lot of information. Protect Workbook You can protect workbooks. So there's a lot more information here. You can save the file by clicking Save. You can save this file under a different name through Save. You can print the file by clicking Print. Like I can print this. Files can be exported through Export. What can we do with the clause ? I can close it and exit by clicking Don't Save. Okay? So this is pretty much the overall primary interface. There are options here. By clicking on Options, you will see several options. We use this option for some advanced tasks here. So, we will look at them gradually. Okay. So now our first task is if I close this a little bit and then open Excel again, you can see that we can take a new file from this blank workbook, this blank workbook. Okay? So now we're going to see that this interface is an idea of ​​this interface. I mean, what happens when you click on Blank Workbook from File ? You will come to an interface like this. So now we will get to know a little about what is in this interface. So first of all, what you see on the far left, at the very top, is called the Quick Access Toolbar. What is the Quick Access Toolbar basically? It's basically like if I zoom in on this place a little bit. So here we can see that on this Quick Access Toolbar, I have this, this is a save button. That means if you want to save a file, what can you do ? Clicking the save button here will save it. Well, I think I wrote something here. I wrote something here again. Look at this button, this button is the undo button. The Undo button means the same thing we do with Control Z. Going to the bank. As soon as I clicked on it, I saw that my text was gone. If you click again, this text is also gone. That is, I went to the bank. We can click this button to come back to the front from the back. Clicking again will open another one. Okay? That means the point is that we can put these buttons here for quick use. And after you click here, you can open several more options from here. For example, here I want to create a new button called New. Through which I can create a new file. So if I click on the checkmark next to New, you can see that I have a New button created here, right? So what happens when you click this button ? You are new to me, so I was able to create another Excel file. So, in this way, you can create a new file using the New button. So, if you want, you can turn off this Quick Access Toolbar from here. So you can put the tools you need the most on the Quick Access Toolbar. Well, then this is the search bar from where we can search for various tools. Okay? For example, you can see from here that we can search for the fridge span, header, and footer. These three, the ones on the left, the ones on the right, these are called window controllers. Which is roughly speaking, you can see these three buttons in all the different programs that we have on our computers. What is done through this ? is minimized. I opened it again. That means I didn't cut it out, I just minimized it. I was able to open it again from here. This just makes it smaller. You can make it smaller or larger from here if you want. You can make it smaller or larger than below. Okay? Okay. And what is done through this clause? The file can be closed. Okay? This is the window controller. This file is then the home insert. Each of these is called a tab. And under each tab, you can see many small tools, as shown below. These are all called ribbons. Which means ribbon in Bengali. So there are many groups in this ribbon. For example, what is in Home? Clipboard. This clipboard is a group. Then there's the font group. You can see many small tools under each group of that font group. This is the alignment group. This part is the alignment group. Alignment is visible within alignment. Number groups, styles, sales, editing, addons. So these are each a group, and within each group there are several small tools. Similarly, there are many groups and tools in Insert. Draw, page layout. So what else are there? Okay. Then you will see an option at the bottom called Display Ribbon Display Options. What is done with the ribbon display option? This is the ribbon that we can collapse. See, if I click here, what I can do from here is hide the Quick Access Toolbar. What happens if we click on Show Tab Only, which is the Always Show Ribbon ? The ribbon will always be on show. If I click here and bring up Show Tabs Only, if I click on it, only the tabs will open. I click on the tab, the tab opens. I click inside again, the tab goes away. I turn on the tab again, it opens. So from here, through this option, if you click on the Always Show Ribbon, what will happen is that it will always show, meaning you will always be able to see it. Okay, this is called the name box. In this name box, we can see the names of each cell here. This is called a formula bar. If we have written any formulas in the formula bar, we can see those formulas here. Well, then if you go to the left side from here, or to the right side, you can see many. Each of these is called a column. Column A, Column B, Column C, Column D are each a column. Okay. And each of these is called a row or serie. That is, one saree, two sarees, three sarees. Each of these is a saree. And these are the cells that you can see. Okay ? These are individual cells. Well, then what you see below is each a sheet and you can open a new sheet using the plus button. If I click on the plus sign, I see that a new sheet has been created called Sheet R, and you can change the name of the sheet by double-clicking on it. Like I wrote in News Sheet One. So I changed the name like this. Okay? You can open multiple sheets from here if you want. So these are every single sheet. Well, then this is the school bar. This means that if you have too many of these sheets, you can move them left and right. Okay? Similarly, by clicking on this three-dot icon, you can open the latest sheet from here. Again, if you click here, you can open the first sheet. This is Skolbar. This means you can scroll left and right. And you can scroll up and down using what you see on this side. What you see below is the status bar. The status bar where you can see the status. This is the view button. You can see these in different views. And this is the zoom slider. Through which you can zoom in and out. That means you can zoom in and out on them. Another shortcut technique for zooming in and out is to hold down the control key and move the mouse wheel up and down, but it will zoom in and out. I hope you understand. So that was the basic idea of ​​the interface. Now we will look at data entry. Well, when you work with any data in Excel, the first thing you need to do is enter the data. That means we will push the data here. So to make this entry, we can enter data in different ways. As you can see, what we're going to do now is we're going to enter some numbers here. So it is said here that integer number means whole number. So if we want to write whole numbers. Like I wrote here, one. Okay. And here we clicked on this cell and gave it a two. I clicked on this cell and gave it a three. What you can do if you want to move left and right, that is, to move from one cell to another, is that you have four arrow buttons on your keyboard: down arrow, top arrow, left arrow, right arrow. With these arrow buttons, you can move from one place to another place to another cell. Okay, like this, I entered four, five, six, seven, and so on, and I entered these data. But look, if you try to enter like this, it will take a lot longer than if you try to enter one by one. So what we have to do here is that we will do the work through Excel. So if you have to go through so much trouble entering data in Excel, what's the point of using Excel? Excel will make our work easier. Isn't that right ? So what we're going to do here is, what we're going to do to make it very easy is, we're going to select these two. So how do you make the selection? As you can see, I'll give you a little detail about the selection. Let's come to the interface idea. Selection means that you can select a single cell. If you want, the left mouse button means the button on the left side. If you hold it down and drag it from the left side to the right side, you can select several at once. If you drag down while holding it down, you can select downwards. You can select left, you can select top, you can select right , you can select bottom. You can select by all means. So you see, I want to be able to select one like this if I select one. If you select two, you can select three, three, four, five, like this. Similarly, if I want you to select multiple cells. You can select multiple items by dragging them this way. You can select an entire column if you want. In this way, click on D in this column. A column is selected. Click on it. This column is selected. If you want to select two columns, hold down the left mouse button and drag. The more you drag, the more will be selected. You can select a row in the same way. You can select multiple rows by holding down the mouse. And also if you want me to select this column in this row. Then select column C. So how do you do it? You can select column C, column E, column F, column G, column M, column J, and so on by holding down Control. Similarly, you can select rows and columns at the same time by holding down Control. For example, row number six, row number 10, row number 13. That means we can select columns and rows at the same time. Okay? Again, we can deselect the parts we are selecting by holding down the Control key. This way. So what are these parts ? Going out of selection. Not being selected. So what does this mean? The selection will be as much a part of the auction as you make it. That is, if you give a color, the part you select will be colored. See, as much as I'm selecting the part, since I'm selecting along the column , I'm selecting along the row, so the entire part has become the selected color. And since I'm deselecting these places, there's no color here. Okay? We come back with a little control Z. This is how you can select. What you can do is select this part from the middle, hold down the left mouse button, and select several D's. You can deselect one by one. You can add some extras if you want. I added something here. I added something here. From here, I deselect it by holding down Control and clicking on it. This way you can make the selection as you wish. I hope you understand. So what we're going to do here is to automatically bring in these numbers or integer numbers, we're going to select these two like this. After selecting, do you see which selection button is actually there? This is the plus icon in the middle, white in color. This is selection. And this option that comes up means that the color of the icon has changed, this is the move icon. This means you can move these cells from here to somewhere else. And after selecting it, you will find an icon in this corner, a black plus icon with a given color. What will happen through this? What happens if you hold down the left mouse button from here and drag it downwards? You see that the automatic number has been generated and the numbers from one to eleven have been generated. Now what if we tell you how to find the odd number? Odd numbers mean odd numbers. So whatever we do for the number one, we'll give it one. Then I'll give you two here. Sorry, we will write three here. Then what happens if I select these two and drag it? So what will happen is that all the odd numbers are coming one by one. Similarly, for even numbers or zone numbers, you select two, then four and then one. If you drag these two from here, what will happen? The zone numbers will come. Repeated numbers, for example, I wrote one. I want each of these numbers to be repeated. How will this happen? If I drag it like this, leaving one, then the number will be repeated again and again. Well, besides this, we can also find out the day. Like, you know, Saturday, Sunday, Monday. So if we use the short form of SAT here, SAT means Saturday, and if we drag it from here, you can see Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, starting with Saturday again. That means it will give you a series like this. Similarly, if you want the full form of Saturday, you would write it as S A T U R D A Y. So what will happen is that when you drag it from here, the full form will show Saturday, Sunday, Monday, Tuesday, and so on. Well, similarly, if you want to find out the month, what happens if you give JN? The short form for the month of January is J A N. So if you drag it like this, every short form will come out. January, February, March. And what if you want the full form? I will write the whole thing in January. J N U A R Y January. So whatever happens in January, February, March, April, May, it will all come together. Okay? Well, we'll see more later. That is, let's say I click on this side. Okay, I've colored this part of ours here in just a few parts. But what can you do with them if you want? You can increase it from here. So we can pull this part from here, January and February, and increase the amount even more. These will be repeated continuously. Okay? So I'll go back a little bit with Control Z. Well, what can you do next ? For example, suppose you wrote ABC C one with a hyphen and added one. But now you don't need to pull with ABC. If you write ABC one and drag it, it will give you the number ABC one two three four five like this. Well, we have seen repeated numbers in the case of numbers. But we can repeat in the case of text. As Dhaka wrote. Okay? If I drag it like this after writing the cover, the cover will be repeated over and over again. So if I write Dhaka here, well, the background color that is coming there is basically because of the formatting here already, the color is coming. If we want to repeat the Dhaka from here, see that it will be repeated. Okay, it will work like this. Okay, let's delete the new sheet a little. To delete a sheet, we will right- click here, then click on Delete from here, then the sheet will be deleted. Okay, so we saw the data entry. Then we will see the read. The read is what I said at the beginning that when we go back or forward, we can undo the read. For example, if I write some data here that is 45, then I write it is or we can do a task here I write Dhaka DH A K A then I write it is Khulna case U L A N sorry case U L A N okay Khulna then it is Barisal then we can write Chittagong here okay or you can write Rajshahi here or write Sylhet this is what we did here we wrote the names of several departments now I want to go back I give control Z I went back I gave another one another back another back another back again if you want to go forward you give control Y you can go forward like this. But one thing is, like Dhan, I came back two times with Control Z. Now if you type something else here, like if we type Rajshahi here, it will go back with Control Z. But those big selections you're writing about won't come again. Because they are already deleting them. Okay? So the thing is, it will go to the last place you typed, but if you redo it, it will go there. I hope you understand. Okay, next we'll look at inserting columns and rows. How can we insert column rows ? You can see that we are given a data set here. What is there? Okay, where we bold this part a little. So where we have serial numbers, the names of some people, their income, their profit and their expenses, how much money they are earning, how much profit means how much money has been earned, how much money has been spent, how much has been spent, what have I got to do here, for example, you have been told that after the name, add me a designation before the income, meaning to add the designations of these people, then what will you do, then I need a column between my name and income, so how do we get the column? What we're going to do to get the column is right-click on this eye. This means that a new column will be added before the one you right-click on. What happens if you right-click and click Insert from here? A column has been inserted here. And one thing you will notice is that the size in this column is not the same as this size. So where did this size come from? This size is according to the size of this H, but it is done. As you can see, if you want to understand a little more clearly, if I enlarge the H column and right-click on Income and insert, you can see that another column like my H column is given to me. Okay? So now you can give the design designation very nicely here. You can write. Well, similarly if you want to insert a row, like I want to insert a row above 11. So, right-click on 11 and click Insert, and a row is created. Okay? Okay, let's go back a little now. Now the point is, if you select two columns, right-click and click Insert, two rows will appear. If you right-click on three rows and columns and insert, three columns will be created. Similarly, if you select a few rows and insert four rows, it will give you four rows. They will give you as many as you select. Well, there are some shortcut methods for inserting these columns and rows. For example, what happens if I click on this I column, hold down Control, and click on the plus sign? A column has been created. I give you a plus again. You will see that the more pluses you give, the more columns will be created. And if you want to exclude these columns, use control minus. Give control minus. This one is gone. Similarly, you can add rows using Control Plus. This is how you click on the row. You can also use Control Minus to move the rows up. Okay? Okay. However, in some cases, giving Control Plus will not work or giving Control Minus will not work. In their case, you will use Control Shift plus. There is a button above this control, the Shift button. So when you hold down Control Shift once and click on the plus, it might be an insert in your case. So if Control Plus doesn't work, you can use Control Shift Plus to do it, God willing. Then it will work. Okay? Okay, next we'll look at the moving column row. How can we move a column row from one place to another? Well, let me tell you another thing here, that is, we can move the cells if we want. Like, what are these? Each one is a cell, right? For example, if I show from below that Comilla is a district here. I want to move it. So what should I do? Look at this little icon here, it's the move icon. If I zoom in a little, I can see the arrow icons around it. Look what it's like here and after arriving here, the move icon appears around the border. So from here I hold down the left mouse button and if I drag it. Let's drag what needs to be done here and bring it here. It will return wherever you bring it and leave it. And one thing to note is that it will get the size of the cell you bring it to. You can move it and bring it here again. Now if you select multiple cells at once, like I want, there's no problem selecting all of these cells. Select and bring them all out. Again, you can add them all here. Okay? Now the question is, how do you move a column? To move a column, you need to do something like I want to move this column in the F column district to another place. Guess who brought it here, so what will you do with it? So what you need to do is select this column of F. This is the move icon that is coming under the F. From here, you just have to hold down the left mouse button. So, I'll hold it from here and let it go. So what happens? Who came up from here? But notice one thing: if I go back a little bit, you think you're in a position like this. What does it mean? What number is this for me ? Row number four. I mean, the top three rows have gone in, right? So I scrolled up again with the mouse. I went back inside for a bit. Row number four. If you select it in such a situation, you will not find the move icon here. Okay? I can't find the move icon. Why aren't you getting it? Because we are currently in column number four. To get the So Move icon, you must go to the very top. The number one rota must be open. Now you click on column F and then you see that you get the move icon and you can move it. Similarly, we have this column here. Isn't that right? So if I want to move the number 10, I can move the number 10 very easily from here. But if you move this scroll bar inward a little. Now look at my B column, it's open. This column has gone inside. Now if you go to look for the move icon here at number 10, you won't find it. When will you get it? When your first column is open. Now you can move column number eight up from here. Okay? Well, we can move, but we can do both at the same time. For example, select these two. Then move it from here. Two will come out. Similarly, you can move multiple rows. Just like we can move multiple cells. This is what happened. Okay. Okay. Another thing we'll look at is what I want to copy. So how do you make the copy? To copy the father's name, all you need to do is select this column and move it from here. But to copy, you have to hold down Control. Let me zoom in a little. Here it is the move icon. Hold down the control and a small plus button will appear, right? Here I hold down the control plus button. When I hold down the control, the plus button appears. So what we will do is after the move column appears here, we hold down the control and hold down the left mouse button and drag it from here. So what happened is that another column like this father name column is being copied. Similarly, if you want to copy multiple columns, select multiple columns, then the move icon will appear here. Hold down the control and hold down the left mouse button. Then it will be copied in the same way. But you can't do that from here, we hold down the control and drag it. Copied. Similarly, what can you do if you want? You can copy multiple rows. Sorry, I want to copy the cells like Tahmid Aziz. One is to move it like this. Another is to hold down the control and drag it like this. So what happened? Copied. Again, you gave me another copy from here , took out another copy, took out another copy. This way, you can extract copies from there one by one. You can take out multiple copies from here if you want. And look here, but the size was much larger. What the hell is going on here? Our size here has become smaller. Why? Because this size was like this before. So what is happening to me here ? But the flowers are not showing. If we want, we can automatically fit the column size. How to do it? For example, what happens if we double-click here? He will take up as much space as he needs. Similarly, if we go to L and double-click here, it will also be taken. They took this one too, didn't they? This way we can take up as much space as we need. Again, what you can do if you want is if I go back to control J a little bit. You can enlarge these three separately or you can select all three at once. Then any of the icons will appear. This icon. If you double-click on this icon after it appears, you will see that all three of them together will take up as much space as they need. Well, now another thing is if you want to increase the column size, how do you do it? There's a small icon on this side. Look, this is our select icon. Through which we can select columns. And when an icon like this appears here, you'll see more icons on both sides. That means we can make it bigger or smaller on both sides. If I pull it and make it bigger, it will grow bigger. Again, make it smaller and smaller. I made it shorter. And if you double-click it, it will automatically take up as much space as it needs. Okay? Similarly, if you select three columns together and enlarge them, all three will enlarge to the same size. Look, I made it smaller and it's growing back to the same size. Okay? As you can see here, only three columns are selected. Now you want the rest of the columns to be the same as what you do to this column. If I make the K column this big, the rest will be that big. Again, if you want the L column to be this small, then the rest will be in the same proportion, but larger or smaller. This happens once you select it. Similarly, but what can we do with these icons here ? I can raise Ro. I can make Ro smaller again. If you double-click again, it will automatically take up as much space as needed. I hope you understand. The last thing we'll look at is keyboard shortcuts. This basically means I will give you the sheets for your class, God willing. So you should look at that sheet and practice. The keyboard shortcuts are basic keyboard shortcuts, meaning the shortcuts we use in Excel. I have already talked to you about several shortcuts. For example, what can we do with Control Z ? I can go back and forward with Control Y. Redo Undo. Then in the case of selection, well, another thing we missed is that if you want to select all of them at once, all of the cells, columns, rows, what do you do? There is a button here, a triangle icon. Just click on this triangle icon, then all of them will be selected at once. The shortcut to select this is Control A. If you press Control A, all of them will be selected at once. If you press Control A, all of them will be selected. The white cell that you see is also selected. Okay? We were in a state of clicking. The cell you click on will appear in white color. Okay? This way we can select the whole thing. This was the overall everything of today's number one lecture. What you need to do is practice this first lecture very well from beginning to end. You need to practice a little more. Why practice? The reason is that these basic one or two classes in Excel are the foundation. The stronger you can make this foundation , the easier the journey ahead will be for you. This means that future learning will become easier. For this reason, you will first need to practice these one, two, three, four, five lectures very well. You need to practice a little more. Okay ? So, today's lecture will end here, InshaAllah. We will start lecture number two tomorrow. So until then, everyone stay well and healthy. Assalamu Alaikum Warahmatullahi Wabarakatuh.