Microsoft Excel VLOOKUP Tutorial for Beginners – Office Excel 2003, 2007, 2010
This video is a brief tutorial on how to use the (sometimes complex) =vlookup() function in Microsoft Excel. I use Excel 2007 in this video, but it works in 2003, 2007, and 2010. The tutorial is designed for beginners that… Continue reading
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see these functions:… Continue reading
Import Excel Data Into MS Access
This is the first in a series of video lessons where I demonstrate how you can share data between Excel and Access. In this lesson I show you how to Import, Append and Link Excel data to Access tables. You… Continue reading
Excel 2010 Tutorial: Creating a Basic Worksheet
Webucator is rolling out our instructor-led online Excel 2010 courses and this tutorial was created as part of the course development process. The Introduction to Excel 2010 class outline is under development and will soon be available at www.webucator.com