The QUE blog checks in for some mid-week Excel-lence:
“For day three of VLOOKUP Week, this two-part video podcast featuring Bill Jelen demonstrates the VLOOKUP Formulas in Excel. Bill Jelen, author of Excel 2010 In Depth offers a beginning and advanced look at VLOOKUP in these two videos. In video 1, matching data from two lists:! …Click here to continue on to the Videos presented at Que Publishing Blog.
From Emily Warn at Microsoft Excel Blog:
“In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. You most likely know the core set of formulas that come with Excel and have heard that VLOOKUP is an easy way to look up a value in an Excel workbook, speeding up getting work done. But that’s about it.”… Click here to continue at Blogs.Office.Com
Neil has prepared a video for VLOOKUP WEEK 2012 entitled “Fun With VLOOKUP”!
“In this episode, Neil shows how the MATCH function and a little Data Validation can make the VLOOKUP function more user-friendly.”
You may find Neil Malek at TV.KnackTraining.Com
VLookup in Plain Thai! Yes, Thai! MS Excel MVP Somkiat Foongkiat has sent in a contribution for our Thai Excel-lers!
“แม้การใช้คำสั่ง Data > Sort และ Data > Filter สามารถช่วยค้นหาข้อมูลที่ต้องการมาแสดงได้ง่าย ถ้าใช้คำสั่ง Sort ย่อมส่งผลทำให้ลำดับรายการของข้อมูลเดิมเปลี่ยนไป ต่างจากการสั่ง Filter ซึ่ง” คลิกที่นี่เพื่ออ่าน
Somkiat Foongkiat may be found at ExcelExpertTraining.com
Oscar Evia, of Universoexcel.com presents his first VLOOKUPWEEK [BUSCARV] Video entry this week. In Spanish, Oscar is Trouble-shooting VLOOKUP errors and offering solutions to correct them.
Episodio 127- BUSCARV (VLOOKUP Week)
“Hoy en el Video del Día y en honor de VLOOKUP week, usaremos su equivalente en español que es BUSCARV y veremos los pasos para usar esta función.”
In the spirit of “VLOOKUP WEEK 2012″ [march 25th - March 31st, 2012], Bill centers on VLookup again today. In theory, I sent my workbook to my manager. I have received the workbook back from my manager and now I need compare the data [the original data with the new data] to find out what was deleted, what was added and what was changed. Today Bill shows us how to work with VLOOKUP to find the answers to our questions.
From QUE Publishing:
“It is day #2 of VLOOKUP Week and who better to give the lay of the VLOOKUP land than Paul McFedries, author of “Formulas and Functions for Excel 2010“. In the following post, he breaks it down nice and neat like…” Click Here To Read More…
The Second Video for “VLOOKUP WEEK 2012″ from Mike “ExcelisFun” Girvin: “LOOKUP function Beginner to Advanced” covering 23 examples!!
Download the workbook for this example video at: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn about LOOKUP function:
1. Approximate Match only ( 00:40 min) 2. Table taller or equal to width, does vertical lookup ( 2:18 min) 3. Table wider than tall, does horizontal lookup ( 3:48 min) and 20 more examples contained on this video! To see the full menu of the video, visit Mike’s YouTube Site Here