excel

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 759: Array Formula To Sort List & Remove Duplicates – Dynamic Named Range

Download file: people.highline.edu See how to create a Sorted Unique List Of Words With Formula using INDEX, MATCH, COUNTIF functions and Comparative Operators. Learn about using the INDEX function and Defined Names to create a dynamic range so that the… 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

Get the book now