Wednesday 26 November 2008

Como hacer un Histograma en Excel Usando Tablas Dinámicas

Title:
Como hacer un Histograma en Excel Usando Tablas Dinámicas


Video:


Description:El tutorial muestra como hacer un Historgrama en Excel de Microsoft utilizando Tablas Dinámicas (Pivot Tables)

Published:
27/Nov/2008

Saturday 22 November 2008

Add VBA Code to ArcMap

Title:
Add VBA Code to ArcMap


Video:


Description:Learn how to add VBA code to the ArcMap interface.

Published:
23/Nov/2008

Excel 2007/2010 : Mise en forme conditionnelle

Title:
Excel 2007/2010 : Mise en forme conditionnelle


Video:


Description:Cette vidéo décrit comment utiliser la mise en forme conditionnelle avec Microsoft Excel 2007. Cette optionest aussi disponible dans les versions précédentes d'Excel. lecompagnon.info

Published:
22/Nov/2008

Thursday 20 November 2008

filtros autofiltros Excel 2007

Title:
filtros autofiltros Excel 2007


Video:


Description:

Published:
21/Nov/2008

Monday 17 November 2008

Visual Basic for Mac!

Title:
Visual Basic for Mac!


Video:


Description:This video shows you a hidden tool in Mac Word which allows you to open up a userform similiar to visual basic (a Microsoft application which isn't available for macs)...its called macros... enjoy

Published:
18/Nov/2008

Microsoft Excel, SQL & Internet Tips : How to Use a Do-While Loop in Excel VBA

Title:
Microsoft Excel, SQL and Internet Tips : How to Use a Do-While Loop in Excel VBAVideo:


Description:When using Excel's VBA, or visual basic editor, create a code that runs when a worksheet is activated and use a do-while loop that has an end condition. Use a do-while loop in Excel VBA withtips from a software developer in this free video on using Microsoft Excel. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Published:
17/Nov/2008

Sunday 16 November 2008

Calc. How to create macro and set hot keys

Title:
Calc. How to create macro and set hot keys


Video:


Description:Tutorial Calc. How to create macro and set hot keys

Published:
17/Nov/2008

Thursday 6 November 2008

Filter Excel Data to a Different Sheet

Title:
Filter Excel Data to a Different Sheet


Video:


Description:www.contextures.com How can you send Excel data to a different sheet, without a macro, and no copying and pasting? Use an advanced filter -- and you can see how, in this video. With an Excel Advanced Filter, you can filter the data in place, or you can filter it to a different location. In this Excel video tutorial, you'll see the steps for setting up the advanced filter so the results are moved to a different worksheet, and the key steps for making this technique work.

Published:
06/Nov/2008

Wednesday 5 November 2008

i-teach-u Excel Buttons and Combo Box

Title:
i-teach-u Excel Buttons and Combo Box


Video:


Description:i-teach-u Excel Buttons and ComboBox Buttons and Combo Box. I have named the 4 worksheets, Title, Dashboard, Questions and Results. You are asked to write your name and college details on the Title sheet, then write in your questions on the Question sheet. On the results sheet you should create a table so that you can fill in the details of your results, (when you get them from your Questionnaires). On the Dashboard I have created one combo Drop Down Menu so that you can select your students and the see details of their choices on the Dashboard sheet. Dedicated to the late John Hooton, Great Tutor at the University of Westminster, who gave me a love of Excel.

Published:
06/Nov/2008

Tuesday 4 November 2008

i-teach-u Excel Button Macros

Title:
i-teach-u Excel Button Macros


Video:


Description:i-teach-u Excel Button Macros I tried to show the simplest way possible to create a button to turn pages or perform simple macro tasks on an excel sheet. Dedicated to the late John Hooton, Great Tutor at the University of Westminster, who gave me a love of Excel.

Published:
05/Nov/2008