This bundle of two separate videos covers the fundamentals of Dates and Times, and also LOOKUP and HLOOKUP functions in Microsoft Excel used in the UIL Computer Applications contest.
Excel Dates & Times Video - In this 20-minute video lesson, we focus on the dates and times in Microsoft Excel. You'll learn: how dates and times work, different common date and time number formats, whole numbers versus decimals/fractions in dates and times when formatted as general numbers, Common Formulas (TODAY, DAY, MONTH, YEAR, DATE, TIME, WEEKDAY, etc), Basic calculations involving dates and times, etc. To illustrate these things, we'll go through some examples in Microsoft Excel. Note that starting point worksheets are attached as are the ending point worksheets (in the attached Excel workbook) to allow you to work off of the starting document and compare your results to the ending document.
Excel LOOKUP & HLOOKUP Video - In this 16-minute video lesson, we will focus our attention on the VLOOKUP and HLOOKUP formulas in Excel, which allow you to compare lists or pull in data from distinct but related flat data sets. In this tutorial, you'll learn how to use VLOOKUP and HLOOKUP formulas in Excel to compare lists or pull in data from multiple flat data files, the parts to the formulas and how they work, things to look out for when using the formulas, shortcuts and tips to use when using the formulas. To illustrate these concepts, we'll go through some examples in Microsoft Excel. Note that a starting point worksheet is attached as is the ending point worksheets (in the attached Excel workbook) to allow you to work off the starting document and compare your results to the ending document.
- Downloadable files are included with each video
- Videos are sold as an online subscription, good until June 1st (end of the academic year).
- Once your credit card, PayPal, or purchase order is processed/verified, we will create an account for you manually and email you login credentials. If you already have an account, please login here.
- TIP: Once your videos are viewed once, they move to the “Completed” tab. Please be sure to let your students know to look in the “Completed” tab in case someone else on your team has already viewed your videos.
ABOUT OUR UIL COMPUTER APPLICATIONS VIDEOS
Save time teaching and give your students a real chance to learn some of the concepts of the Texas UIL Computer Applications Contest with video from building a basic pivot table in Excel, to mastering complex update queries, to learning all the ‘ins and outs’ of dates and times, and much more! Each lesson incorporates the latest screencasting technology with the expertise of Huntley Tarrant. Videos are presented in a step-by-step, tutorial format so that students can follow along on their own computer, stopping and starting the video as needed to keep up.