1 / 13

Excel Skills

With Victor Soskin. Excel Skills. Relative vs Absolute Address. Relative Address= Changes when you drag. Tracks its position Absolute Address=Always points to the same cell Give your work to Sara=Absolute (independent of where you are)

cedric-adams
Download Presentation

Excel Skills

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. With Victor Soskin Excel Skills

  2. Relative vs Absolute Address Relative Address= Changes when you drag. Tracks its position Absolute Address=Always points to the same cell Give your work to Sara=Absolute (independent of where you are) Give your work to the person on your left=Relative (dependent of where you are)

  3. VLookup • What is it used for? • Look up the value in B2 in the table to the right. • Find the name of the teacher and the room . • If you cannot find the correct section do not guess

  4. VLookup

  5. Vlookup- Range=True Range lookup=TRUE means Looks down the list until it finds correct range. Numbers must be in order Does not round

  6. HLookup

  7. If Statement • If you work hard then you will get sweets otherwise you will get coal.

  8. If Statement

  9. If Statement- Logical Test • C2>5 • C2<5 • C2=5 • C2<>5 • C2>=5 • C2>D2 value in C2 bigger than the value in D2 • C2<“F” value in C2 alphabetically before letter F • C2=“F” • AND(C2>”E”, C2<“F”) begins with E • OR(C2=“shj”, C2=“ajm”)

  10. If Statement- Value if true • Can be a number (5) • Can be letters (“pass”) • Can be a formula (D2+E2)

  11. If Statement Worked Example

  12. Conditional Formatting • Lets you highlight cells which have special values • Example1: Failing students • Example 2: English higher than Business

  13. Play a little • Games

More Related