what i m learning n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
What I’m Learning PowerPoint Presentation
Download Presentation
What I’m Learning

Loading in 2 Seconds...

play fullscreen
1 / 17

What I’m Learning - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

What I’m Learning. Today we are learning how to: Add simple formula Replicate formula efficiently (Level 4) Insert Autosum (Level 5) Performing Goal seek (Level 5-with help, independently level 5+) Make a data validation list to allow users to select from a range of data. (Level 5+)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

What I’m Learning


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
    Presentation Transcript
    1. What I’m Learning Today we are learning how to: • Add simple formula Replicate formula efficiently (Level 4) • Insert Autosum (Level 5) • Performing Goal seek (Level 5-with help, independently level 5+) • Make a data validation list to allow users to select from a range of data. (Level 5+) • Insert VLOOKUP’s (Level 6-) • Add conditional formatting (Level 5)

    2. Scenario • You have been hired by • To use your spreadsheet skills to calculate their weekly income and expenditure and to let them know if they have made a profit or a loss.

    3. What I’m looking for • You save the Spreadsheet in your D Drive From vispvle.com • Open up this PowerPoint • Must Create simple formula and replicate (4) • Must Insert Autosum (4+) • Should Perform Goal Seek (5 independently 5+) • Should Independently create an Data Validation List (5) • Should insert VLOOKUP(5+) • Could use 3D Referencing (5) • Could add conditional formatting (5) • Could Independently insert VLOOKUP(6-) • Could understand all formulas and functions and carry them out independently (6-)

    4. Expenditure Check your formula

    5. Data Validation Box 2 1 3 5 8 6 7 Click on data Data Validation  change allow to list  Click on source button  Highlight Source  Click Source Button  Click OK

    6. Click on cell you want to perform vlookup click on fx VLOOKUP 1 2

    7. Formulas

    8. If Statement

    9. Conditional Formatting

    10. Self Reflection • Log off • 3 minutes to fill out the self reflection form • How do you feel about each task

    11. What I can do • I can create an IF Statement with some guidance • I can independently create an IF Statements and I understand why they are used • I can confidently and correctly perform 3D referencing • I can create Data Validation list box • I can confidently add VLOOKUPS and will be able to use them in the future

    12. What is this?? • This functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table. • Answer- VLOOKUP

    13. What is this?? • A 'conditional statement' often used within a spreadsheet which checks to see if a statement is true or false and then does one of two things depending on the result. • Answer- IF STATEMENT

    14. What is this?? • formula will add up a range of numbers for you. The 'range' can be a single column of numbers or even a grid of numbers spread along rows and columns. • Answer- AUTOSUM

    15. What is this?? • This function will 'tweak' the other cell and examine the effect on the cell's value. If it is now closer to the target, then a little bit more is added and so on, until the target is reached • Answer- Goal Seek

    16. Starter Part 2

    17. Questions • The logical test in an IF statement is used to test if a cell meets the given criteria • IF statements are used to see if something works • Data Validation lists are used to create a drop down list of a limited set of values • VLOOKUP is a