This is the first of four videos in a series that covers the nuts and bolts of IF statements, nested IF statements, and the conditional formulas in Microsoft Excel; this series is also available for sale (at a discount relative to a la carte purchase of the included videos).  In this 10-minute video lesson, we focus on the IF formula and construction of IF statements in Excel.  In this video, you'll learn how the IF formula works, how to think of the IF formula as a sentence in order to help with constructing accurate IF statements, how to diagram an IF statement graphically, which will help you to conceptualize and understand how nested IF statements work, which we'll cover in latter videos, what the parts are to an IF statement and how to think about these types of formulae and statements, etc. To illustrate these things, 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) in order to allow you to work off of the starting document and compare your results to the ending document.

Check out the beginning of this video with the preview pasted in at the bottom of this description area - hit the 100% button in the video player to view the preview in a larger screen.  To purchase immediate access to this video using a credit card or PayPal account, click through to the product page on our separate video-on-demand store.  If you'd like  to purchase immediate access to the broader series of videos that includes this individual video in its coverage of IF statements, nested IF statements, COUNTIF and SUMIF, click through to the series product page on our video store.  If your purchase is not time-sensitive or requires a PO, see directions below.  

An email address is required as a condition of purchase.  This email address will be configured as your login email address for your video product account on our store.

Save time teaching and give your students a real chance to learn some of the concepts of the UIL Computer Applications Contest with video from building a basic table Access to mastering complex update queries to learning all the ins and outs of Excel pivot tables, 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. 

Please read the following before you add videos to your shopping cart:
- Videos are sold as a one-year online subscription.
- Videos may be ordered two ways as follows:

1. PURCHASE ORDER (one to two business days) - If using a purchase order, add this item to your cart from the current product page via "add to cart" and choose your video selection(s) in the drop-down menu.  When your order is processed and verified through the Hexco Academic ordering department, we will manually set up and activate account access to your videos and send you a confirmation and login information by email by the end of the next business day.
2. CREDIT CARD/PAYPAL (instant access) - For instant access to videos, and if you are NOT paying with a purchase order, you may view and purchase videos directly from the Hexco Video Store page on our website.  If you choose this option, your credit card invoice will show Mindbites (video hosting company). If you choose to purchase directly from our video page instead of this current page, you will be asked to pay right away; any other UIL purchases (i.e., books, CDs, etc.) must be made from the regular Hexco shopping area.  

Note: Once your credit card, PayPal, or purchase order is processed/verified, we will create an account for you manually and email you login credentials and instructions for getting you logged in to our video store to access your video purchases.