Do a Two Way Lookup in Excel - Match() Index() Functions

Title:
Do a Two Way Lookup in Excel - Match() Index() Functions


Video:


Description:www.TeachMsOffice.com How to do a two way lookup in excel. This tutorial teaches you how to lookup a value in a table based on two separate parameters. It is similar to the Vlookup and Hlookup but this allows you to make a more versatile lookup function. This tutorial expects you to have at least a general understanding of the Match() and Index() functions. To get the spreadsheet used here and for more information including free macros, forums, and keyboard shortcuts, go to www.TeachMsOffice.com

Published:
31/Aug/2008

Excel (Aula 25) - Macros

Title:
Excel (Aula 25) - Macros


Video:


Description:CURSO DE EXCEL Professor: Tio Ilmo tioilmo@yahoo.com.br video 25: Macros, gravar macros, executar macros, exibir barra ferramentas, botão macro, wordart, botão macro. www.videoaulasgratis.com EVOLUÇÃO BRASIL!

Published:
30/Aug/2008

Combine/Consolidate Data Dynamically Between Seperate Excel files

Title:
Combine/Consolidate Data Dynamically Between Seperate Excel files


Video:


Description:www.TeachMsOffice.com How to consolidate data from multiple worksheets into one worksheet. This tutorial teaches you how to use the consolidate command in excel and shows you how to add sales data for parts from two different stores. This also teaches you how to consolidate the data so that it is dynamically linked and so that when any spreadsheet is updated, the consolidated worksheet will also be updated. Additionally, you can consolidate data from open or closed workbooks and also from different worksheets within the same workbook. To follow along with this tutorial and to get more free tutorials, free macros, and visit the forums, check out the website www.TeachMsOffice.com

Published:
28/Aug/2008

How to Graph/Chart Hidden Data in Excel

Title:
How to Graph/Chart Hidden Data in Excel


Video:


Description:www.TeachMsOffice.com This tutorial will teach you how to graph data that has been hidden in excel. Normally, when you hide a row or column within excel, any data located there which is plotted on a chart will disappear. Here I show you how to avoid or fix that problem. For more excel tutorials, keyboard shortcuts, macro code and other related help, go to www.TeachExcel.com

Published:
24/Aug/2008

HLOOKUP() in Excel - how to use it and edit it. Walkthrough explanation.

Title:
HLOOKUP() in Excel - how to use it and edit it. Walkthrough explanation.


Video:


Description:www.TeachMsOffice.com How to use the HLOOKUP() function in Excel. Explains how it works and teaches you how to use it. Also compares it to the VLOOKUP() function and explanes the difference. To follow along with this worksheet and to get more excel tutorials, keyboard shortcuts, and macros, go to www.TeachMsOffice.com

Published:
24/Aug/2008

Creating a simple macro in Word 2007

Title:
Creating a simple macro in Word 2007


Video:


Description:Creating a macro to orientate the page to landscape. Software used: BSR Screen Recorder 4 Microsoft Office Word 2007 Windows Movie Maker

Published:
21/Aug/2008

Print multiple Worksheets and Workbooks in Excel

Title:
Print multiple Worksheets and Workbooks in Excel


Video:


Description:www.TeachExcel.com How to print multiple worksheets and workbooks in excel. Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website www.TeachExcel.com

Published:
21/Aug/2008