How to use Excel

How to use Excel


  Excel is a computer program that allows you to organize data much more quickly compared to doing it by hand done by hand. It also allows people to organize files, accounts and create accurate representation of models. 



Starting off with Excel

There are some terminology that you should know before we can start.

Please learn what the phrases so that this process becomes more natural


Assuming that you know the terminology from above we will now get started. As an example lets say I have a home work assignment with the equations x+2, 3x+2, and x^2 +2x+3 from 1 to 20. Even if your a math expert it takes long to calculate each and everyone of this equations. Excel makes this process much quicker.

The steps to complete the equations x+2, 3x+2, and x^2 +2x+3 from 1 to 20.
  1. Click on cell A:1 and type in x so that column is the x-values.

  2. Click on cell A:2 and type in 1 then click in cell A:3 and type 2.
  3. Then click and hold on cells A:2 and 3, make sure that while clicking the arrow turns in to a white plus not as a dark cross (try hold the arrow in the middle of the cells so it turns into a plus).
  4. If you noticed the cells A:2 and 3 are highlighted, so all you do is go to the lower right of the green box and the arrow will turn into a dark cross.
  5. Now that it is the dark cross you click and hold and drag it to cell A:21 and once you let go the program finds the pattern in the highlighted region and continues the pattern to the dragged region of the sheet.
  6. Now that we have all our x inputs we can now move on to plugging in the equations, start by clicking on cell B:1. 
  7. B:1 will show the equation x+2 but will not contain the equation it self it is only for people to see what is the equation is because if you plug in the equation they will not see what the equation is and in the cell they will only see #VALUE! . All you have to do is type in x+2 into cell B:1.
  8. Cell B:2 will contain the equation and you complete this by typing in =A1+2. Typing in A1 can be done one of two ways first typing in A1 or by clicking on Cell A:1 either way is fine. 
  9. Now just like in step 5 you click and drag the dark cross down column B to cell B:21 and Excel does the hard work of calculating the equations for you.
  10. Now you can do the same to the other equations but be careful of your formatting or you may get the wrong answers. Putting an = sign in the cell tells Excel you want to start an equation.
  11. Now type in 3x+2 in to cell C:1 and type in =3*A1+2 in cell C:2. If you do not put an * in the equation than you will be given an Error. 
  12. Repeat the process of clicking and dragging the equation down the C column.
  13. Now the last equation is a little tricky, again type the equation  x^2 +2x+3 in cell D:1 and in cell D:2 type in =(A2)^2+2*(A2)+3. Make sure that you put in the parenthesis or it will not work.
  14. Now the last step is clicking and dragging the equation down the D column.
Now that you have finished you can start doing some of the optional choices like create a graph.

to preform this all you need to do is go to the Insert Tab and then in the Chart group you can click any chart you like and all you have to do is select the first column as the x-axis and the rest of your equations as the outputs and Excel does all the graphing and graphing adjustments for you. Now you can work be the hard worker that you are.

Comments

  1. HAJMarch 12, 2018 at 1:30 PM

    Isaac,

    I'm pretty sure that the steps you have given to input that particular equation are sound. I'm not sure because I didn't try it, but the syntax seems clear enough.

    The issue is that you didn't really provide enough framework for why that equation works, why you'd want to do it, or what the equation does (besides provide a particular answer to a homework question, perhaps).

    Were there some shorter lessons leading up to your magnum opus, including using tables for organization or doing more simple equations, it would have been easier to understand the functionality of Excel.

    There are a couple of grammar errors, and I'm not sure that the graph is as clear as it could be (but it's pretty good). And while more could have been done to give us a broader understanding of Excel, I'm sure that following your steps will provide the reader with some powerful insights about Excel, allowing them to branch out from your tutorial.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Install Windows on your Mac

Image
Have you ever looked at your Mac, and wondered what it would be like if you can install Windows without having to buy a PC computer instead? Many people would want Windows for the games you can download without having to pay, and also for those who are into coding, it is much easier in Windows, than in Mac. Many are always arguing about which is better, Windows or Mac, but why not have both! Things you'll need:  Mac model 2012 or later  USB drive (sometimes USB is not needed depending on model)  Be sure to back up your data, just in case! Step 1: Check Your Storage! Click the Apple menu , and then click About this Mac .  Click on Storage. Make sure you have at least 32GB of free space on your hard drive! Step 2: Download the Windows 10 ISO file Windows ISO file download Go to the link and click on  Select Edition , click on Windows 10  and press  Confirm . After that Select a Language  and then press Confirm  again. You will then ch
Read more

How To Install LED Light Bulbs for Your Car

Image
To Install or Change your Headlight for the car is pretty simple. Just Plug and Play! NOTE: You should know which type of bulb fits your car. It is important to use the correct type of bulb and wattage when replacing a headlight that is burned out. You should take your own responsibility to find out your bulb type. IDENTIFY YOUR BULB TYPE!   Only apply to plug-and-play style.   Here is a source that can help you find the bulb meant for your vehicle. https://www.bulbs.com/Automotive_Lighting/results.aspx Reference:  http://stores.ebay.com/dt-autotech/Home.html_?rt=nc&_sid=1035629323&_sticky=1&_sop=1&_sc=1 Things You Need: Vehicle Headlight Bulbs Owner's Manual Alcohol Wipes (optional) Cross Screwdriver (optional) Straight Screwdriver (optional) Reference: https://www.theretrofitsource.com/blog/headlight-tech-hid-bulbs/ Step 1. Knowing which bulb you are installing/changing.  Check the Owner's Manual, find out what
Read more

How to Procrastinate

Image
...News Flash... There is no guide on how-to procrastinate. Waiting till the last minute will only bring you disappointment. Time is the only thing you can never get back; appreciate it. S/o to everyone who gets the concept. You're the real MVP!!!
Read more