Mr Watson s Introduction to Spreadsheets .


89 views
Uploaded on:
Description
Mr Watson’s Introduction to Spreadsheets. The ‘ Quick ’ and ‘ Easy ’ guide to using Microsoft Excel. By the end of the lesson, I want you to be able to say….
Transcripts
Slide 1

Mr Watson\'s Introduction to Spreadsheets The " Quick " and " Easy " manual for utilizing Microsoft Excel

Slide 2

By the end of the lesson, I need you to have the capacity to say… "I recognize what a spreadsheet is, I can enter straightforward information into a spreadsheet, and I can utilize basic formulae to perform computations. With help I can make basic diagrams"

Slide 3

Starting toward the Beginning What is a Spreadsheet? A spreadsheet is an intense apparatus for arranging data. What are they for? They are utilized to complete loads of estimations rapidly and to store a lot of data for a scope of purposes. What would they be able to do? When you know how to do it – they can do any maths that you could require!

Slide 4

So, how would they work then? Lines (Side to Side) [Numbered] Columns (Up and Down) [Letters] Cell (Every one on these containers is a cell) Every cell has a name to help you locate the right one. Its name begins with the section letter and after that the column number. Along these lines, this phone is called what? F22

Slide 5

Using formulae Login and open Microsoft Excel Entering information in spreadsheets is truly simple! You simply tap on the cell and sort it in. We should accomplish something more troublesome then! How about we utilize a few formulae (that implies entireties!) In Numeracy, when we compose a number sentence we compose the "=" sign just before the reply, in a spreadsheet we compose it in the first place, before the total. So when you need a spreadsheet to work out an entirety: PUT THE = FIRST! On the off chance that you don\'t it won\'t work.

Slide 6

Using formulae There is one all the more thing that you have to think About utilizing a spreadsheets to perform estimations. The images for the operations are not all the same. So to compute 3x4 You would enter =3*4 And the spreadsheet would demonstrate "12". (That is the reply!)

Slide 7

Task one Open another page in Microsoft Excel. Enter this information as appeared in the right cells. We are going to make up some Multiplication tables. Tap on cell B2. Enter the number 7 Highlight the section from B2 to B13 On the Menu bar. Select: Edit – Fill – Down. The entire segment will load with 7\'s. Tap on cell C2. We are going to enter the count. What do we have to enter first?

Slide 8

Task one =a2*b2 This is on account of these are the cells with the numbers we need to duplicate. Note need happens when you enter the equation. Presently utilize similar strategy that you used to FILL section B with 7\'s to rehash the recipe in segment C. Will you recollect how?

Slide 9

Task one If you have done it right, which you will have done! Your spreadsheet ought to resemble this. Undertaking Two: In another spreadsheet, would you be able to make the 8x table utilizing the procedures we have adapted in this way.

Slide 10

Task Three PE Kit You get a letter from your educator. It lets you know what PE you requirement for the new term. You require: 2 T-shirts, 2 sets of shorts, 2 sets of socks, a couple of mentors for outside and a couple of plimsolls for inside Open another report and enter this data into the right cells.

Slide 11

Task Three With the data appeared above you can figure the cost of you new PE Kit for yourself. Fill in cells D2, D3, D4, D5 and D6. Presently select cell D7 and tap on this image on the toolbar . Squeeze RETURN and the section add up to shows up Use increase to fill segment E and F, and use to add up to up the segments.

Slide 12

Task four Creating Graphs You can utilize spreadsheets to make diagrams of your information. Obviously you will require a few information to make charts of! Open another spreadsheet and set up the segments and lines as appeared here. Presently you have to discover what number of young men and what number of young ladies are in every year assemble. Discover and enter the information. In segment D utilize an equation to include the sums. Tap on B10 Then tap on the toolbar.

Slide 13

Task four Creating Graphs This apparatus permits you to include section aggregates. Tap on B3, hold down the move key and tap on B8. The section aggregate ought to show up in B10. Utilize this strategy to finish whatever is left of this spreadsheet. Presently you are prepared to make a chart! It is simple – yet observe precisely!!

Slide 14

Task four Select the information you are going to diagram. Presently you are prepared to make a diagram! Discover this symbol and snap it. Select the segment diagram and snap NEXT. Tap the "Arrangement" tab. Change every arrangement, Series 1 – Boys, Series 2 – Girls, and Series 3 – Total. Click NEXT and give your diagram a title and mark the X and Y pivot. Click NEXT, place outline in new sheet, then snap FINISH. Presently you can print your diagram. It\'s that basic!!

Slide 15

Congratulations! Did you oversee it? Obviously you did! Could you say it then? "I recognize what a spreadsheet is, I can enter basic information into a spreadsheet, and I can utilize basic formulae to perform estimations. With help I can make straightforward diagrams."

Recommended
View more...