Let's learn IT

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 follow through our last exercise where we tweak some things and finish it off with a chart.     1 Step one, select the columns from A to T (or to any column you feel it's far enough), Right Click > Column width and set it to 17.      2.  Step two, fill in the cells with the order you see in the picture down bellow.    3.  Step three, under  Conditional Formatting format the new rule and under Value > Maximum make sure you select the cell right beside Goal.  You probably know by now how you're supposed to format your new rule. If you're new to this tutorial then please visit our last exercise:  https://letslearnitnow.blogspot.com/2020/04/how-to-create-actual-cell-vs-target.html    4. After you've successfully created the new rule, please do edit and format the table so it will have that clean l...

Hello again guys and welcome to another tutorial where this time  I'm going to guide you on how to create a very simple  drop down function in Excel. In this beginners tutorial we are going to use a simple stock guide for some of the products and once we're finished with this tutorial you can go ahead and create a drop down function based on your needs.     1. The first thing you should do is create your product list and fill the cells under that category. Now that you have done that go on another cell and create a table containing the list that you wish to be shown under the drop down function.  After you've done all the steps, head over to Data > Data Validation where a window will appear under the Data Validation category.     2.  Next, under Allow select List  for the validation criteria to be in function. Now, under source select the table icon as seen on the picture below.   ...

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

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