How to Use VLOOKUP

In this video, we use the amazingly powerful VLOOKUP function to make it easier to keep track of the calories we consume.

New Video: Dieting with Excel, Part 4

Well, it took a while, but I finally finished the fourth and final part of my video series on Dieting with Excel. In this video, we use the amazingly powerful VLOOKUP function to make it easier to keep track of the calories we consume.

And as always, If you want to see the other videos in this series as well as several other videos and resources by Rich Malloy and Tech Help Today, be sure to click that same link: https://sit.cxf.mybluehost.me/videos/

To follow along, click https://sit.cxf.mybluehost.me/videos/ and click the link for the Excel workbook designed for this video.

Here’s a summary of the various parts in the Dieting Series:

Part 1: Dieting with a simple table
Part 2: Dieting with Excel Tables
Part 3: Dieting with Pivot Tables
Part 4: Dieting with the VLOOKUP function

Advanced Excel Class

An Excel spreadsheet on a laptop.Microsoft has equipped the latest versions of Excel with some amazing “Power” features. In this hands-on Advanced Excel 2016 course taught by Rich Malloy at Norwalk Community College, students will learn how to use the most important of these industrial-strength tools: specifically, Power Query (also known as Get & Transform), Power Pivot, and Power View.

The course includes a review of Excel’s database features such as pivot tables, the VLOOKUP function, and the INDEX/MATCH combination. Students will also learn how to use Excel’s new formatted tables and slicers and how to take advantage of macros and the Visual Basic for Applications programming language.

The logo for Excel 2016 from MicrosoftThe six-session course will be held on Wednesday evenings from 6 pm to 9 pm. The first session is scheduled to start on April 10. Tuition is just $349. Go to www.norwalk.edu to sign up (use CRN number 5210), or visit the campus (directions).

Advanced Excel Class

An Excel spreadsheet on a laptop.Microsoft has equipped the latest versions of Excel with some amazing “Power” features. In this hands-on Advanced Excel 2016 course taught by Rich Malloy at Norwalk Community College, students will learn how to use the most important of these industrial-strength tools: specifically, Power Query (also known as Get & Transform), Power Pivot, and Power View.

The course includes a review of Excel’s database features such as pivot tables, the VLOOKUP function, and the INDEX/MATCH combination. Students will also learn how to use Excel’s new formatted tables and slicers and how to take advantage of macros and the Visual Basic for Applications programming language.

The logo for Excel 2016 from MicrosoftThe four-session course will be held on Wednesday evenings from 6 pm to 9 pm. The first session is scheduled to start on Monday, October 29. Tuition is just $249. Go to www.norwalk.edu to sign up (use CRN number 6809), or visit the campus (directions).

1-Hour Website Course: Sept. 26

WordPress logoThe next session of my 1-Hour Website mini-course will be on Wednesday evening, September 26. WordPress.com is the fastest and least expensive way to get a professional looking website up and running. No programming language is involved. Join thousands of photographers, bloggers and  small businesses creating new WordPress sites each day. In this hands-on course, you will learn how to get a site up quickly, how to refine it with the right design, how to add new content quickly, and how to format pictures for the best impact. Continue reading “1-Hour Website Course: Sept. 26”

1-Hour Website Course: Feb. 28

The next session of my 1-Hour Website mini-course will start on Wednesday, Feb. 28.
WordPress Transp logo_500x500WordPress.com is the fastest and least expensive way to get a professional looking website up and running. No programming language is involved. Join thousands of photographers, bloggers and  small businesses creating new WordPress sites each day. In this hands-on course, you will learn how to get a site up quickly, how to refine it with the right design, how to add new content quickly, and how to format pictures for the best impact. Continue reading “1-Hour Website Course: Feb. 28”

1-Hour Website Course: Oct. 12

The next session of my 1-Hour Website mini-course will start on Thursday, Oct. 12.
WordPress Transp logo_500x500WordPress.com is the fastest and least expensive way to get a professional looking website up and running. No programming language is involved. Join thousands of photographers, bloggers and  small businesses creating new WordPress sites each day. In this hands-on course, you will learn how to get a site up quickly, how to refine it with the right design, how to add new content quickly, and how to format pictures for the best impact. Continue reading “1-Hour Website Course: Oct. 12”