Fill out the submission form at the end of the videos.
Directions for Class:
- Watch Class Video
- Download Excel data
- Create a video showing you using Vlookup and Hlookup & MATCH and INDEX functions
- The class video has the exact homework requirements
CLASS VIDEO
This excel homework is about vlookup, hlookup, MATCH and INDEX Excel Functions. This is another way to quickly get data from a data set.
See the Youtube videos below for help.
VLOOKUP FUNCTION VIDEO
MATCH & INDEX FUNCTIONS VIDEO
Although the V-lookup was a bit more simple to operate to me than the H-lookup, I can really see how the V-lookup and H-lookup functions can be helpful when dealing with an excel spreadsheet. these functions can save you a great deal of time when dealing with a ton of data within a spreadsheet. It makes it a lot easier to pinpoint a certain cell on the spreadsheet or a certain data point without having to check every single point one by one.
ReplyDelete