Unlock all 123 lessons of Medical Data Analytics & VisualizationFull course ₹40,000 · paid
Excel Interface, Data Entry and Auto Fill Basics
A free lesson from Skill-Lync's Medical Data Analytics & Visualization course, on Grow by Skill-Lync · Last updated 16 Nov 2026 · Session: “Data Analysis and Visualization Using Microsoft Excel”
What will you learn in this free Medical Data Analytics & Visualization lesson?
The instructor shows three ways to launch Excel, how to check the installed version, and the parts of the interface. Examples include entering and editing data, setting column width and row height, and using auto fill on numbers, weekdays and month names with a small student marks table.
- Launching Excel and checking its version
- Tabs, ribbons, formula bar and status bar
- Entering and editing cell data with F2
- Auto fill for numbers, days and months
What comes after lesson 1?
The next free lesson is lesson 2, “Relative, Absolute and Mixed Cell References in Excel” (29 min). Later in Skill-Lync's Medical Data Analytics & Visualization course (paid): lesson 4, Excel Formatting Techniques; lesson 5, Customizing the Quick Access Toolbar in Microsoft Excel; lesson 6, Data Analysis and Visualization using Microsoft Excel. The full course has 123 lessons (54 h 21 min of video); see the course overview or its price and syllabus.
Lesson transcript
Machine transcript of the lesson audio (lightly cleaned). Technical terms may contain errors; the video is the reference.
Hello, everyone. Welcome to course Data Analysis and Visualization using Microsoft Excel, that is MS Excel. We are into week one and in this week, what we are going to learn, we are learning here course introduction and the fundamentals that belongs to this subject, that is Microsoft Excel. So we will explore our learning to understand the concepts involved with Microsoft Excel in order to experience and in order to practices with the data analysis and the visualization that is highly demand in the market nowadays. So what are the table of contents for this week?
First, we are going to cover the introduction to the course, how we can launch Microsoft Excel and how we can check the version that is already installed in our system. And then we will learn about the introduction to the interface, the basic interface of this tool, Microsoft Excel. After that, we will learn how we can enter and edit data into Excel. We will learn about relative and absolute cell references and then some common shortcuts. Formatting, we will learn how we can do the data formatting, whether we are changing the color, whether we are making it bold, italic, we will learn everything.
After that, how we can customize the quick access tool bar. And then the most important thing, how we can get the help, the self-help from this wonderful tool, Microsoft Excel. Our learning objectives, by the end of this session, you will be able to launch Microsoft Excel and check the current version of Excel. How you can enter and edit the data, you will learn in this week. You will be able to use common shortcuts that are available with Microsoft Excel. And then how we can format the data, customizing the quick access toolbar and using Excel self-help.
So, let's start. Introduction to the course. So, in this course, we have total 24 learning hours. So, that we are going to cover in total 12 weeks. So, in each week, we will have two hours for learning. And you need to do your assignments and projects as well. So, that you can actually cross-check your knowledge. So, you will be getting total 12 assignments for each for one week. So, if you are completing this first week, after that, you need to do your assignments. Once you submit the assignments, only then you will go to week 2 content.
And in this course, we are also doing two projects. One is minor project and another is major project. So, you need to do the first project, the minor project, after completing week 1 to week 6. And the second project, you will be doing after completing total 12 weeks. And you have the active support from the skilling for this wonderful course. This was the introduction to the course. So, now, let's talk about Microsoft Excel. How we can launch this Excel and how we can check the which versions Excel is available with us.
So, launching the Excel, the first option is we can write in the Windows search bar as Excel. Just see this screenshot here. So, this is the screenshot that is available. We are writing in the Windows search bar for the Excel. And once I do that, I will get the option like this. So, this is for this best matches with the Excel application. I will click on this application and I can launch Microsoft Excel with this search bar. The another option is to go to command, run command.
And you can open the command from Earth with window plus R key also. And once you have this run window with it, you just write Excel over there and click on OK. And you can launch Microsoft Excel in that system. We have option 3 also. And that is directly open the workbook. If you have the shortcut or if you have a location where Excel is launched or already or it is the shortcut is available. In that case, you can directly click on that and open the workbook.
So, let's try that. We already talked about three options. So, what I will do, I will go with the first one first. So, this is writing it in the Windows search bar. So, just see there, I have clicked the Windows option and now in the search bar here, I am writing Excel. So, once this Excel thing is done, writing Excel, I can see this application over the Excel app. I will click on that and see, we can actually open the Excel. Good evening. So, we will explore it, how to open a book and everything.
For this purpose, I am just closing it for now and come again. The second option, let's try that also. What I need to do, I need to press the key window, window and then R. So, window R is done and I have this window with me. Type the name of a program, folder, document or return this resource and Windows will open it for you. So, I will write here Excel and I will click on OK. So, again I have Microsoft Excel with me. So, I have launched it.
The third option, again you can try it in your system, with your location, wherever you have the shortcut. Just click on that shortcut and open the workbook. Ultimately, the result will be the same. So, this is your choice, which option you want to try. You want to try it with the Windows search bar, you want to try it with the Windows command or you can just directly launch the workbook or the Excel with the shortcut that is available with the installation. So, in my case, I will find this one as the easiest one.
Next, checking the version. So, how we can check the version, which actual version is installed with me in this MySystem. So, the way you just need to go to the file, we will see it also. But now just understand the path. Go to file and click on account and then you can have the product information. So, product information, what we can have in 2003, we can have version 2007 as well, 2010 as well, 2013, 2016, 2019. Or we can have the latest one, Microsoft 365 with us.
So, if I try this thing, like if I talk about MySystem and MySystem, this Microsoft 365 is installed. So, if I do the same option here, in that case, going to file, going to account, and then going to product information, I'll get the output like this. And here I can have the information. Just see their product information, Microsoft, and the subscription of the product, this 365, and everything is written here. So, I'll do it in my system also. So, I'll just launch it with the Windows option.
How we did that? We just wrote it in the search bar of the Windows. And we got this suggestion for the Excel app. So, what I'm doing, I'm just clicking it home for now. And I'll take the blank workbook also. So, what we did, we just got the new blank workbook. So, for now, we have learned how we can launch the Microsoft Excel and how we can check the version. Now, once you have the tool with you, so, let's start with this wonderful tool, this Microsoft Excel to do the magic with the data analysis and visualization.
So, this kind of interface I'll get once I open my Excel. So, what is this? What is that interface? So, I have output with me. So, just see the first thing. We will start from a topper one. This ribbon is known as quick access toolbar. So, whatever is available, that is, you can easily access, quickly access, that is available on this quick access toolbar. You can also customize this tab also. So, whatever you want to keep it here, you want to have the print option, you want to have the copy option, you want to have the save option.
Whatever you want to click, you are allowed to customize it. We will learn it in this session only, how we can customize that quick access toolbar also. So, this is this first thing in our interface is known as quick access toolbar. Then, we'll try what we have in the second tab. The second part. So, you can say that you have divided your interface into three parts. This first part is known as quick access toolbar, where we have all the options available that is easily or quickly available on your Excel tool.
So, you don't need to find it, whatever is quickly available. So, in some cases, like we have some options, like you need to copy it more frequently or you need to auto-sum more frequently. In that case, you can keep that particular tool on quick access toolbar and you can easily approach it. In the second part, we are talking about, this is known as tabs and dribble. So, just see it here carefully. The file, the home, insert, page layout, formulas, data, review, view, the smart view, help, power pivot.
This everything is known as tabs. This is known as tab and when we have this line here and this particular one is known as ribbon. Ribbon, so just see there what is written down. So this is font ribbon, this is alignment ribbon, this is number ribbon, this is styles ribbon and cells ribbon and so on. We will see in actual interface as well. We are just talking here with the screenshot available and then come to the third part. This part is known as formula bar and name box.
So whatever formula we are applying on our data, we can actually see it here. Whatever data you have, you can actually see in this formula bar and then name box. Next part is this A, B, C, D and so on. This is known as column name. Of course, you can have your column name as well, but by default Excel has divided the sheet, the workbook into row into columns and this row is numbered 1, 2, 3 onwards and this column names are ordered with alphabetic from A to Z and then it start with double A to double Z and similarly so on.
So this is number of rows, column name. I have already told. Next come to the downside of this interface, the bottom one and this bottom one is this part is known as worksheet and the status bar with which worksheet you are working like if you're working with the Excel so you can have the same document with the multiple worksheets. So it is not necessary that these worksheets are related to each other or not, but normally if we talk about the logically in that case, if we are saving for data for one organization, one particular organization.
So for different departments, we can have data and the different worksheets. So let's revise this again, but this time we will do with the Excel, our systems Excel. So I'm launching it again in the same manner, version check and the launching Excel we already learned. I'll go to the blank workbook first. So just see this. So we were talking about this interface. Till now what we have learned, we have learned what the particular part is known as or called in interface. So this top one, this top part, this green one, you can say, this is known as quick access toolbar and I already mentioned that you are allowed to customize this.
So we have some options here. You just hold the mouse and you can see the tooltip here. The symbol is for the save. So save option is available. Auto save and to on or off it is up to me. You can make it for one particular file as well and you can make it your default choice as well. So each document you can turn on for the auto save. Then we have here copy. We have here deletion for the sheets and we have some mouse mode also.
And the spelling check is also available. So this is access, quick access toolbar. So easily available or frequently used items or frequently used tools are normally kept in this quick access toolbar. Then we talked about this part from file to this clipboard thing. So this is known as tabs and ribbon. So file, I'll go back. Home, insert, page layout, formulas, data, review, view, help. This everything is tabs. And what are ribbons? Ribbons are this clipboard, this complete set is one particular ribbon. This font is one particular ribbon.
Alignment is particular ribbon. Similarly, number here. I'll zoom my screen so that you can see it. But okay, let's try that. Then we have styles here, cells here and editing as well. Similarly, if I'll go to one another tab, in that case, I have different ribbons here. Like for whom, I have different ribbons. For insert, I have different ribbons. So if we talk about the tab insert, we have ribbons for the tables, illustrations, add-ins, charts, tours, sparklines, filters, and this links, comments. And if I go to page layout, in that case, we have themes, page setup, scale to fit, sheet options, arrange.
If I go to formula tab, I have function library here, define names here, formula auditing, calculation. If I go to data tab, in that case, I have get and transform data, queries and connections, sort and filter, data tools, forecast, outline. If I go to review, then we have roofing, accessibility, insights, language, comments, notes, protect, and this link one. View, I have sheet view, workbook views, show, zoom, window, macros. And similarly, for the help, we have two ribbons. This is help and community. So for different tabs, I have different ribbons.
So these all tabs and ribbons are actually having all the functionalities that is available with this wonderful tool that is Microsoft Excel. So once you complete this course, you will be mastered in using all the functionalities, whether it is available with different ribbon or different tab. So for now, I just want to have a quick look on this interface so that you should be aware where we can have this particular functionality. So this was tabs and ribbons. Next, this part is known as formula bar, NIVAN formula bar.
So whatever I am writing here, I can see that how we can enter and edit the data, we will learn in a few minutes. And this is number of columns. So this A, B, C, D, I'll scroll my screen. Let me zoom it again. So you can have a clear view here. So this is this A, B, C, D, E. I'll go to my right part, right side of the sheet. So you can just have a look. After Z, I have double A, then A, B, A, C, A, D.
This is the combination and I'll go, go again and you can see it and N number of columns here. Of course, it is not N number of columns. We have a fixed limit here. I'll tell you that also. For now, you can have a good amount or good area to enter your data. Similarly, if I will go to the rows, as we have Microsoft Excel in the form of the rows and columns. So this 1, 2, 3 is known as columns. So this is not necessary that you can't have your column name.
You can have it. But by default, this Microsoft Excel is providing you space to enter your data in the form of rows and columns. This A to A onwards is known as the columns. Name of the columns, default column names. And this is, this 1, 2, 3 is known as the row number. So if I talk about, I need to enter something here. So what I am doing, I am entering in C column and 6th row. So this is about the interface. And if I go down here, so here I am having the information about the worksheet number, workbook number.
So which worksheet I am talking about, how I am adding sheet. We will learn that also. So this is status bar and sheet worksheet bar. I'll minimize this with this minimize option. I am minimizing my tool and coming back. So we have learned about the interface. What we have learned about? We have learned about the quick access toolbar. We have learned about the tabs and ribbon. We have already seen the formula bar and the name boxes. Column names as well. Number of rows and the worksheet and status bar.
Let's come to the next topic that is entering and editing data. So we talked about like we can do data analysis and visualization with Microsoft Excel. But before that, we need to learn how actually we can write or enter our data in this tool. So how we can do that? So there are a number of ways to do that. First, you need to click on the cell. Cell. So what is cell? I'll just go back to Microsoft Excel again. So this area is known as cell.
A, B, you just see this cursor is moving, this green cursor. So this is known as the cell. This particular area is known as cell. So what we are saying, we are saying you need to click on the cell. Okay, we need to click on the cell and type in the formula bar. Formula bar is this one. And here you can write ways to edit the data. So once you have the data, then you can edit the data. If you are writing something here, so this is entering the data.
What I did, I just opened my tool, this Microsoft Excel. I clicked on the cell. Once I click this, I'll have this line with me. So once I have this line, I'll write my content. And once I have the content, if I want to make any changes, this is known as the editing the data. So how we can edit the data? Delete and type. Okay, so I entered something by mistake. So what I need to do, I need to delete it. And enter. The data. Okay. The another way is double click on the cell, add it in the formula bar and then we have one option, this press F2 also. So let's try this. I'll start it from idly. I'll go with the idly row 1 and the column 1. So I'm writing here. I'll click here. So I'll write, this is mine, my first time, my first type of data.
So I wrote this thing in this Excel. That is mine, my first type of data. So for example, I want to make some changes. So I'll click that. I'll go to the formula bar. You just see it here. I'll go to the formula bar. For example, I'm adding here data and data. So you can see the complete sentence in this formula bar. Do we have in the cell also? Let's try that. I'll come out of the cell. Yes, we have it. There is no problem in that. So my first type of data and data. So this I can enter. I'll try it again. My first set of data I'm writing here.
If I want to delete this, what I'll do, I'll go to the cell and put the delete button. The another way I'm doing control Z. That is the shortcut for the undo. I have done the undo here. I'm just reversing my last change and I'm getting this again. The one option is to delete this. Just go to the cell and click on the delete button. The another way is to select the particular thing or maybe I want to delete this only first thing. So I'll click this first and click on the delete button. So this how we can actually edit the data, how we can enter the data, how we can delete the data or we can edit the data.
So we can rewrite it also. When you are doing this and want to make some editing here. So you need to click on the cell first to get this editing allowed to yourself. Or otherwise what you can do. You can from arrow from keyboard. You can go to the particular cell and press F2. Once I'm pressing the F2. So I don't need to click on the cell. I can have the access or the data and then I can make the changes or what will happen if you're not doing that.
Suppose I want to make some editing or I want to add something in the cell. This my setup and what I'm doing I'm just going to that cell but I'm not clicking anything. I'm not clicking and even I'm not pressing the F2 also and if I'm writing something this will overwrite the previous content. If I want the overwritten thing. So that is okay what I'll do. I'll go to this cell and I'll write whatever I want to write. If you want to make the changes then you need to click on that particular cell.
Go there and make the changes or another way is to click on the F2 button function in F2 according to your system requirement and then do the editing. So we have learned about how we can enter the data in Excel and how we can actually edit the data. So this was all doing the dummy data entering. What I'll do I'll take some original set of data. I'm writing here maybe serial number here. Let's write the name of student. Name of student. So what I'm doing I'm just going to this particular cell and then I'm writing whatever I want to write in this.
Data set. Now you just see that this name of student is crossing this content is crossing the width of this column. Go to the column that particular column and get this kind of a symbol and click on that. So once you're clicking that automatically this column width will be set according to the size of the content. I'll do the control Z again. The another way what you can actually stretch the width here or you can right click here and you can give the column width again.
So the three options available to set the column width. The first option to do it automatically let it decide how much width it is required with the maximum size of the content that is written in that particular column. Click on that or the second option stretch it and the third option right click and click on the column width and give it a column width. So this is 8 written here. Let's do it 16. I'll click on that. So I got the column C as with the width of 16. I want to make it shorter.
I can do it like this option. So this is allowed. We have three ways to actually give the column width. So similarly we can do with the row also I can make it much bigger. The height thing I can make it smaller also by clicking that and then the right click option you have the row height with you. I can set the row height for now it is 14.4. I can make it 16 as well or whatever is the requirement and accordingly it can make the changes.
So we have just learned about how we can increase or decrease the row height or the column height. So we have learned here row height and the column height. Serial number name of student. Then I'll enter some marks. Let's enter marks for physics. Then for mathematics and maybe your favorite subject. I'll put here chemistry and let's have total here. This is the data entry. Now very good thing available with the Excel is that at every step Excel is actually helping us. How it is helping us? I'll write here 1, 2. I have total 10 students.
So how you're doing the data entry? You'll write everything 1, 2, 3, 4, 5, 6 and we have 10 till 10. So this is the one way. Now you just think you have records for 1 lakh students. So are you going to write everything? If you're not aware about the Excel, you need to write everything. If you're doing it in any other tool like any word processing tool, yes you need to write into it. But when we are dealing with Excel, Excel is actually helping us with the data.
So what you can do it, you can just write two numbers here. So 1 and 2 so that Excel can actually learn what I want. What kind of data you want to enter in this particular column. So once you have entered that, I'll select this one. So these two cells are selected like this. So once the selection is done, I'll hover my mouse to the borders, this border area of this cell. This plus symbol will be converted like this symbol. Just see it again. This was a symbol coming before.
I'll take my mouse to the corners or the border area of the cell, the selected cell. I'll get this kind of plus sign. Once I've got this kind of cell, what I'll do, I'll hold my mouse here and stretch it to the down. So you can see a tooltip here. So automatically, it has got the numbers. You have not entered anything. What you have done? You have entered the first number. You have entered the second number. And once you entered that, I'll just select the cell, the both cells.
And once both the cells are selected, I'll hover my mouse to the border area of those two cell selection. I'll get this kind of a plus sign and I'll stretch it to the down area. That's not necessary. You can do it in a column manner also. You can have it in this manner also. So I'll do this. This way, I can have multiple numbers. For now, I just want to have maybe a record for five students. So I'll delete the rest of the numbers. Can we have any other format also?
I can do it with the alphabets also or not? Let's try that. So for now, I'm writing A and B here and doing the same thing. So I selected this A and B and this plus is converted to this plus and I'm stretching it down. So same kind of pattern is repeated here. A, B, A, B, A, B. So if I'll do again, so it will the same kind of pattern will be stretched, the copied with the Microsoft Excel. Another way, if I'm having, maybe I want to have the numbers like, you can assume here 20, 40, 60, 80 and 100.
So now you just see we have the difference of what is the pattern for these numbers. So this is an example situation. It can can't be happened with a real life data. You can't have marks for a student in this kind of, you know, difference. For example, we have this kind of a data set 20, 40, 60, 80, 100. Can we do it same with the Excel again? So we have the difference 20 for each numbers. So I'll delete these three numbers. I'm clicking on the delete button after selecting it.
And now I'll try the same method with this 20, 40 also. I'm stretching it down. Oh, and the great thing is, like we got the numbers 20, 40, 60, 80, 100. Okay. Now just think about you have these kind of a patterns, you can identify the patterns, you will give your first, second or even in some cases you can give the third, fourth number also and Excel will decide that format and accordingly Excel can have the multiple set of the data, whether it is in the thousands or it's in the hundreds of data, this Excel can help you out.
So you just think that you're so much work is already done by Microsoft Excel. So that is why there are, this is the only very simple example. That is why this Microsoft Excel is preferred when you're doing the data analysis or even for the data record purpose. So I'll write, I'll write something else here, 30, 60, same method. I entered the data. Another thing I'll try here, maybe 40 and then let's 40 again. So we have three here. So I'll copy this. In that case I am getting same 40 here. So it got the pattern and accordingly it provided the data.
Another thing, let's try with the weekdays, Sunday, Monday. So I'll write complete for now. Sunday, Monday and same method I'm applying. Yes, we got that also. Sunday, Monday, Tuesday, Wednesday, Thursday and Microsoft Excel is actually right. This Excel is aware. This Excel is aware about the number of this days name as well. Similarly, I can have it the complete seven days also. So I'll just do it for maybe more stretching. You just see this more stretching Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, Monday, Tuesday, Wednesday again. So the repetition is so going on.
Can I do this with this? Can I do this with S-U-N and M-O-N also? Let's try that. So I'll do the stretching again. Oh, great. So this Microsoft Excel, Excel is so smart to do this also. Sunday, Monday, Tuesday, this short form is allowed here. Wednesday, Thursday, Friday, Saturday, Sunday, Monday, Tuesday. Can we do it with the month name also? So let's try that also. So I'm writing here January, February. I'm again doing the selection part and going down and you will amaze to see this result also.
January, February, March, April, May, June, July, August, September, October, November and we can have December as well. Let's try it with the short form Jan, Feb and do the stretching part here. Oh, great. So we got the short forms as well. So we'll keep the student's name as January, February, February. Yes, we can have these names also. Don't worry about that. So I'll keep my student's name as January, February, March, April, May. I'll delete the rest of the thing. So till now, what we have learned that this Microsoft Excel tool actually helps us with the data entering as well.
So this F2 thing we learned how we can enter the data, how we can edit the data by clicking on the cell on that particular cell, writing in the formula bar and doing the clicking on the F2 key and then entering the data, deleting the data, overwriting the data. And then we learned about this entering or getting the help from Microsoft Excel to enter the data. So we can have that particular number here. We can have this table thing also here. For example, I am not aware about the table for the 13th table.
So I can have the 13th table directly from Microsoft Excel as well. 13 ones are 13, 13 twos are 26, 13 threes are 39. Similarly, I can have it for the other numbers as well. So Excel actually calculated everything according to the pattern that is detected by Microsoft Excel. In fact, this thing is also available with the number of this name of the month and the name of the weekdays as well. We can have it in the full form also and for the short form also.
And similarly for string, it can do the pattern matching. Pattern matching in the sense if I'm writing here ABC and then again I'm writing here AA, BB, CC. So if I'm trying this, so how it is doing, it is copying ABC to the first cell and this again, this again. So pattern will be first, second, first, second, first, second that will be repeated. So whatever pattern is understood by Microsoft Excel accordingly, it will generate the data set. So for now we have this data with us, serial number, name of student, physics, mathematics, chemistry and total.
So this is just one very simple example. So you can have your number of a good number of rows data with you, whether you want to enter on your own or you can have help from the Microsoft Excel functionality. So this is all about entering the data in Microsoft Excel. I'll come back to my screen. So this we learned here. Next topic is relative and absolute cell references. Before going to that, I just want to have a quick revision, whatever we have till now. I'll go back to my tool.
So we have learned about how we can actually launch Microsoft Excel. What we can do, we can go to this Windows bar, search bar and write Excel here. Another option is writing in the window button, window plus R and run. You can write Excel and launch the Excel. And then the third option is just looking for the shortcut for the Microsoft Excel tool and then clicking on that. Second, we checked about the version also. So how we checked, we went to file option, file and then account.
And then we can check the which version is available with us. Then we learned about the quick access tool and then tabs and rebounds, formula bar, column names, row names and this worksheet name and status bar. Then we learned about how we can edit the data, how we can enter the data, delete the data, how formatting or the data pattern can be detected by Microsoft Excel. And it can actually help you to enter the data.