How to create a simple student data entry in Excel

By


Here's a very easy and simple student data entry tutorial that I'm going to show you how to do it in very easy steps. Once you get around this tutorial you can create one for yourself using different categories, depends how it suits your best needs. So, let's get started!


   1. First step, write down the categories as seen on the picture below, select all the cells > insert table > My table has headers > OK.




   2. Step two, once you've created the table go to File > Options.





   3. Step three, once you click options, a window under the name excel options is going to appear where we have to enable the data entry form command.

   - Click the Quick Access Toolbar and under Choose commands form select Commands not in ribbon. 

   - Scroll down until you find Form, click the ADD>> button until the Form is shown on the right window and click OK. 





   4. Step four, after you've clicked OK this data entry window is going to appear where you have to input all the necessary information. You can also open this data entry window manually as shown on the top left picture below right above the red arrow. From now on it's simply plain forward, you write down the empty fields and when you're finished, you click New. 






   5. Step five, once you click New, the information will be shown under the table that you've created and to add more items in this case student information you just click New again.

   - You'll notice that there is a criteria button on the data entry window. In order to use the criteria you simply write down the criteria on the fields you wish to search for and the information will be provided to you depending on the criteria you set.

 And that's how you create a very simple student data entry.





   6. Once you have fully established your student data entry you can also add a design element where you can make your table to look visually much more better. To do that, select the fields where it shows the subject marks and go to Conditional Formatting > Highlighted Cells Rules and select either Greater Then, Less Then, Between or Equal to.   





   7. In my example as you can see on the picture below, I've selected Greater Then > 4.5 > Green Fill with Dark Green Text. 




   8. This is how the table looks like after using the Conditional Formatting > Highlighted Cells Rules. The table is also interactive, what that means is that every time you change or add marks to your student list the colors on the cell will change as well depending on how you've formatted the cells. 




Here's also a video on how to create this particular tutorial.




Comments

Post a Comment

Popular posts from this blog

How to create a barcode using Excel

By
Image
Hello everyone and welcome to another tutorial where we are using Excel to create or generate a barcode using very simple few steps. Before starting with this tutorial make sure you have downloaded a barcode font where we're going to use it in the next steps. Finding a barcode font is very easy, just google the font and you'll be able to download various barcode fonts.     1. First step, enlarge the A and B column so that the barcode would fit in. By doing so, in the A column select the number format as Text.     2. Next, under the A column, we have the serial number ID that will generate the barcode (you can also use letters instead of texts).    - Use the formula to generate the barcode: ="*"& A2 &"*"     3. After you've entered the barcode formula drag and drop so it can automatically generate the barcode for the rest of your serial number ID.     4. At this stage, select all the gen...
Read more

How to create a simple database in Excel

By
Image
In this step by step guide, I'm going to show you how to create a quick and simple database using Microsoft Excel. Even if you've just started using Excel for the very first time this tutorial doesn't require any intermediate skills, all you have to do is follow the logic behind the steps that will create this database function. For this database we're going to use the DSUM, DAVARAGE, DMAX and DMIN functions.      1. Step one, have an idea on what your database will consist of, in my example I have used a simple smartphone database. So, from cells A6 to F6  write down the categories on what your database will consist of and whats you did that make sure you highlight the categories with Bold and fill the cells below with the required information. As you can see from the example below I have filled the necessary information to each category.   - Once you're finished with the first step, note that as seen in the example below in the highlighted cells...
Read more

How to create an actual cell vs target graph in Excel

By
Image
Hello everyone and welcome to another tutorial where this time we're going to see how you can make a very quick and simple actual cell vs target graph in Microsoft Excel in just a few easy steps.      1.   First step, fill in the cells as seen on the picture bellow and write down the benchmark of units sold on the target or goal cell. Now that we have the benchmark of 100 units sold as our primary goal, head over to the actual cell and write down a random or in your case the actual number of units sold. Once you've done that on the graph cell type =D5  as seen on the picture where we will use the formula to show the graph in the next step.     2. Step two, once you click enter you will notice on the graph bar the progress is 50 units of the 100 target units sold. To add the graph go to Conditional formatting > New rule     3. When the New Formatting Rule window opens head over to Format Style and set it ...
Read more