Let's learn IT

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...

Hello everyone, and welcome back to another tutorial where this time we're going to create a  unique target chart using Microsoft Excel.  If you've followed the previous posts you will get the idea on what we will try to do and shouldn't have any difficulties whatsoever.    1.  First step, fill in the cells with the information given bellow. Once we're finished with this tutorial you can create the table based on your needs and preferences.    2. Step two, by now you probably noticed the headers consisting the Agents, Units sold, Target and Didn't meet target by.  What you will do now is under the Didn't meet target by cell type the formula =MAX(D7-C7,0) in order to avoid the IF function we've added MAX instead, where we set 0 as our number limit so we don't have net results like -12, -25, -36 etc.     3. Step three, we've added another header Target overachieved where we will type the formula...

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 ...

This data entry form is very similar to the previous post (Student data entry) except this time we're going to create this data entry form to work related tasks. If you don't know how to enable the data entry form in Excel visit the previous  post:  https://letslearnitnow.blogspot.com/2019/12/how-to-create-simple-student-data-entry.html     1.  In the meantime, write down the categories as seen on the picture below and insert as a table. Now we're going to integrate a couple of math formulas on some of the cells. So under the  Total Salary cell write down the formula =F2+G2      2.  Step two, we're going to type the formula for the tax deduction. What you need to do is just under the  Tax Deduction  cell write down  =H2*18%  , that is going to calculate us the 18% tax of the total salary.       3. Step three, under the  Net Salary  cell write down the formula...

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...

In this tutorial I'm going to show you a step by step guide on how to create a mortgage calculator in Excel. Creating this mortgage calculator doesn't require any demanding skills, as long as you remember the formulas It's quite easy to create one.    1. Step one, under A1 write down "mortgage calculator" and continue writing down the cells as in the picture below:            A4: House Price                                    A12: Breakdown of Payments      A5: Down Payment                               A13: Payment Period      A6: Amount Borrowed                           A14: Principal Paid       A8: Monthly Payment       ...

In this tutorial I'm going to show you how to use the IF function (logical test) with the True or False value. Also, how to use symbols in excel.     1. For us to use the IF function and Tick symbols, firstly we have to create a basic student data sheet where you can type the necessary information such as: Student name, subject, score, status etc. The first step for you to do is write down a simple student sheet with the as seen on the picture below.      2. Step two, on the Student column select the cells from A2 to A10 , right click > format cells click on the merge cells box, then set the orientation to 90 degrees and click OK.    3. Once you've merged the cells, write down the name of your student and make sure to align your content and text to center and middle as seen on the picture below. Also, make sure you change your font size to your liking as well.       4. Next step,...