Monday 31 May 2010

01 - Importando Dados com o Excel 2007

Title:
01 - Importando Dados com o Excel 2007


Video:


Description:

Published:
01/Jun/2010

CursosOfimatica.eu: tutorial minigraficos excel 2010

Title:
CursosOfimatica.eu: tutorial minigraficos excel 2010


Video:


Description:Una de las novedades más interesantes de la versión de Excel 2010 es la posibilidad de generar gráficon integrados en Celdas, conocidos como minigráficos. En este tutorial te enseñamos a hacerlos. www.cursosofimatica.eu

Published:
31/May/2010

Sunday 30 May 2010

Hide Specific Excel Sheets With a Macro Shortcut

Title:
Hide Specific Excel Sheets With a Macro Shortcut


Video:


Description:blog.contextures.com Use a macro to show or hide the Admin sheets in your Excel workbook, so users don't accidentally change the data.

Published:
31/May/2010

VBA Excel 2007 Video 01

Title:
VBA Excel 2007 Video 01


Video:


Description:Video tutorial de VBA aplicado a Excel 2007. Donde se explica de una manera secilla el uso de las funciones Date, Time, Now y Weekday.

Published:
30/May/2010

Problemas con macros versión 1.1 Certificados de estudios incompletos ESB

Title:
Problemas con macros versión 1.1 Certificados de estudios incompletos ESB


Video:


Description:Herramienta en excel para confeccionar certificados de estudios incompletos de la Educación Secundaria Básica de la Prov. de Buenos Aires.

Published:
30/May/2010

Cursos Excel Office 2007 | VídeoAulas Interatívas_ Curso Passo a Passo! Frete Grátis!!!

Title:
Cursos Excel Office 2007 | VídeoAulas Interatívas_ Curso Passo a Passo! Frete Grátis!!!


Video:


Description:www.cursoexcel.xpg.com.br Veja o que você irá aprender no Modulo Introdução do "Curso Excel 2007" Recapitulando o Excel 1_ A interface do Excel. 2_ Exibindo Barras de Ferramentas Ocultas. 3_ Formatação. 4_ Vínculo. 5_ Funções Simples e aninhadas. Banco de Dados: 6_ Conceito de Banco de Dados. 7_ Puxando dados de um arquivo de texto (txt). 8_ Contagem de entradas, Verificação de idades e aniversariantes do Mês. 9 _ Incerindo dados no Excel por meio de ferramenta Formulário. 10_ Classificação de Registros. Controle de Estoque: 11_ Controle de quantidade em Estoque. 12_ Atualizar fórmula para incluir novos dados. 13_ Controle de saída. 14_ AutoFiltro. 15_ Gráfico Dinâmico. Formulário de Fatura: 16_ Layout Formatado e explicação dos campos. 17_ Incerindo Fórmulas de procura de Dados. 18_ Criando e configurando caixas de combinação. 19_ Calculando os valores. 20_ Configurando a impressão da Nota de fatura. SUPER PROMOÇÃO! "VOCÊ GANHA O OFFICE 2007 INTERPRISE Português" APROVEITE! www.cursoexcel.xpg.com.br Contatos glaudeslm@gmail.com

Published:
30/May/2010

Friday 28 May 2010

Soccer Dashboard for Excel 2010 Challenge

Title:
Soccer Dashboard for Excel 2010 Challenge


Video:


Description:In brief, "FlickHeader" is a dashboard for accessing monitoring FIFA and non-FIFA league play stats, news, and videos. Built in chat mechanism as well. Leveraging new Excel 2010 Sparklines and conditional formatting options. Also making use of embedded MS Web Browsers, Shockwave Flash Objects, ActiveX controls, Form controls, Web Queries, Macros and a User Defined Function. Links to and data drawn from Footytube.com, YouTube, Google docs and FIFA World Cup site. (tactics adopted from "Excel Basics to Blackbelt" Cambridge University Press 2008)

Published:
29/May/2010

Problema interes compuesto calculo del capital

Title:
Problema interes compuesto calculo del capital


Video:


Description:Se muestra como calcular el capital en un problema que involucra interés compuesto

Published:
28/May/2010

Wednesday 26 May 2010

tutorial vba: Ms Excel 2007 insertar varios registros en MySQL

Title:
tutorial vba: Ms Excel 2007 insertar varios registros en MySQL


Video:


Description:Utilizar Ms Excel 2007 con ADO para conectarse a un servidor MySQL y agregar varios registros tomados de una hoja de cálculo de un libro de Ms Excel.

Published:
27/May/2010

Crear una macros en Excel 2003

Title:
Crear una macros en Excel 2003


Video:


Description:Explicación de como crear una macro en Microsoft Office Excel 2003

Published:
27/May/2010

Tuesday 25 May 2010

Prototipo Generando cotizaciones con excel word muy potente cotizar jfksoft.com

Title:
Prototipo Generando cotizaciones con excel word muy potente cotizar jfksoft.com


Video:


Description:www.jfksoft.com Este es una ejemplo de como crear cotizaciones usando microsoft Excel y Word usando macros y combinación. Esto simplifica y potencializa el uso de estas dos herramientas de trabajo. Se trabaja con excel y word para usar macros y comibinar documentos. Parecería que es para usuarios con niveles avanzados de esta herramienta. Sin embargo solo usa una cuantas macros sencillas para llevar a cabo esta tarea. esta combinación es MUY POTENTE, por las capacidades de personalización. mas información en www.jfksoft.com

Published:
25/May/2010

Monday 24 May 2010

How to use VBA in Excel | lynda.com tutorial

Title:
How to use VBA in Excel | lynda.com tutorial


Video:


Description:This Excel tutorial explores the Visual Basic for Applications (VBA) programming environment. Watch more at http://www.lynda.com/Office-2007-tutorials/excel-...

Published:
24/May/2010

Running macros from a keystroke shortcut: Excel 2007: Macros in Depth from lynda.com

Title:
Running macros from a keystroke shortcut: Excel 2007: Macros in Depth from lynda.com


Video:


Description:Watch the entire course at www.lynda.com In Excel 2007: Macros for Automation, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that cant be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario.

Published:
24/May/2010

Short examples of the recording method: Excel 2007: Macros in Depth from lynda.com

Title:
Short examples of the recording method: Excel 2007: Macros in Depth from lynda.com


Video:


Description:Watch the entire course at www.lynda.com In Excel 2007: Macros for Automation, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that cant be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario.

Published:
24/May/2010

Definition and examples: Excel 2007: Macros in Depth from lynda.com

Title:
Definition and examples: Excel 2007: Macros in Depth from lynda.com


Video:


Description:Watch the entire course at www.lynda.com In Excel 2007: Macros for Automation, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that cant be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario.

Published:
24/May/2010

Excel Macros Tutorial Knowledgecity.com

Title:
Excel Macros Tutorial Knowledgecity.com


Video:


Description:This Microsoft 2007 Excel tutorial in using Macros is presented by www.knowledgecity.com. We have all types of training tutorial courses in computer software and business courses. If your are looking to advance your career or just need help with Microsoft, Adobe, or any other software product then visit our website today.

Published:
24/May/2010

Sunday 23 May 2010

tutorial vba: Ms Excel y MySQL realizando consultas genéricas

Title:
tutorial vba: Ms Excel y MySQL realizando consultas genéricas


Video:


Description:Muestra una mejora en el código anterior de realización de consultas usando VBA, en el cual se mejora el código para que se muestren todos los campos de cualequier consulta, para ello se usa un ciclo for que recorre todos los campos de cada registro tomando sus valores

Published:
24/May/2010

tutorial vba: Ms Excel y mySQL realizando consultas

Title:
tutorial vba: Ms Excel y mySQL realizando consultas


Video:


Description:Se muestra como programar en VBA un método que se conecta a una base de datos de MySQL por ODBC y se ejecuta una consulta SQL. Posteriormente se coloca cada registro en una fila de una hoja de cálculo.

Published:
24/May/2010

Excel Tutorial #1 - Shading Alternate Rows

Title:
Excel Tutorial #1 - Shading Alternate Rows


Video:


Description:Excel Tutorial - Shading Alternate Rows

Published:
24/May/2010

Currency Converter Form Part 1

Title:
Currency Converter Form Part 1


Video:


Description:Part 1 of a Excel VBA program to do currency conversions. Highlights the use of the Data tool to grab data from a URL.

Published:
24/May/2010

Saturday 22 May 2010

Macros en Excel

Title:
Macros en Excel


Video:


Description:Un pequeño tutorial para hacer macros en Excel

Published:
22/May/2010

Friday 21 May 2010

Borrar celda de Excel desde Visual Basic.mp4

Title:
Borrar celda de Excel desde Visual Basic.mp4


Video:


Description:Este video tutorial pertenece al sitio web www.serviprofer.com.ve y en el mismo se explica cómo borrar una celda de Excel desde una aplicación en Visual Basic 6.0. Se utiliza el operador MOD para borrar sólo los datos (nombre y edad) de las personas cuya edad sea un número par. Aquí también aprenderás los pasos correctos para establecer conexión o acceder a un libro de Excel desde Visual Basic 6.0 abrir el libro, trabajar con el libro y finalmente cerrarlo. Si quieres obtener el código fuente de este trabajo, visita mi sitio web, ¡regístrate y descárgalo gratis!

Published:
21/May/2010

Wednesday 19 May 2010

How To Make A VBA Procedure

Title:
How To Make A VBA Procedure


Video:


Description:Get Your FREE! Excel VBA Training Guide at yourexcelvbatraining.com Need a tutorial on creating a VBA procedure? This video gives you how a little tutorial to creating a VBA procedure. Shows Public and Private procedure differences and how to call the procedure (macro) from a button on an Excel worksheet.

Published:
19/May/2010

lynda.com: Excel 2007: Macros in Depth

Title:
lynda.com: Excel 2007: Macros in Depth


Video:


Description:Watch the entire course at www.lynda.com In Excel 2007: Macros for Automation, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that cant be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario.

Published:
19/May/2010

Monday 17 May 2010

Tutorial Excel - Uso da função PROCV

Title:
Tutorial Excel - Uso da função PROCV


Video:


Description:Tutorial que ensina como utilizar a função PROCV para preencher tabelas.

Published:
18/May/2010

Presentacion del curso INTRODUCCION A EXCEL CON MACROS

Title:
Presentacion del curso INTRODUCCION A EXCEL CON MACROS


Video:


Description:En este video te detallo el contenido del curso INTRODUCCION A EXCEL CON MACROS

Published:
18/May/2010

4.9 Use Script and Syntax Files for Statistical Analyses: PASW (SPSS) Statistics v.17 video

Title:
4.9 Use Script and Syntax Files for Statistical Analyses: PASW (SPSS) Statistics v.17 video


Video:


Description:Use a script or syntax file to automate a series of statistical analyses performed on a file with dynamic data containing static variables. Scripts are captured and edited in the PASW Statistics Syntax Editor window.

Published:
18/May/2010

Friday 14 May 2010

Exploring Layout view: Access 2010 New Features from lynda.com

Title:
Exploring Layout view: Access 2010 New Features from lynda.com


Video:


Description:Watch the entire course at www.lynda.com In Access 2010 New Features, author Alicia Katz Pollock explains each new and enhanced feature in Microsoft Access 2010. This course covers the Backstage view that replaces the File menu in Office 2010, shortcuts for building tables, new layout tools and navigation controls, the macro designer featuring IntelliSense, as well as exporting to and collaborating in SharePoint.

Published:
15/May/2010

How to Merge Multiple Excel Workbooks to a Master Budget

Title:
How to Merge Multiple Excel Workbooks to a Master BudgetVideo:


Description:Do you collaborate with other Excel users who use the same workbook? For example, are you responsible for just one part of a budget that must be combined into a Master Budget? If so, you want to watch this short Excel Video Lesson to learn the steps to follow to successfully Share Changes that you and your colleagues make to an Excel 2007 workbook. I invite you to visit my website - www.thecompanyrocks.com - to view all of my video lessons. Danny Rocks

Published:
15/May/2010

Determinar ubicacion de la ultima celda con valor en una columna.mp4

Title:
Determinar ubicacion de la ultima celda con valor en una columna.mp4


Video:


Description:Este video tutorial pertenece al sitio Web www.serviprofer.com.ve y en el mismo se explica cómo determinar la ubicación de la última celda con valor en una columna, utilizando VBA para programar un botón de dentro de la hoja. Si quieres obtener el código fuente de este trabajo, visita mi sitio web, ¡regístrate y descárgalo gratis!

Published:
14/May/2010

tutorial VBA: Generar un userform ( formulario ) en Ms Excel 2007

Title:
tutorial VBA: Generar un userform ( formulario ) en Ms Excel 2007


Video:


Description:Indica como generar un userform ( formulario ) en Ms Excel 2007 en el editor de VBA. Tutorial vba, usando Ms Excel 2007 insertar botón www.youtube.com VBA: tomar valores de hoja de Excel www.youtube.com

Published:
14/May/2010

Thursday 13 May 2010

Excel Avançado 2007 Parte 1.2 - Funções SE, E e Formatação Condicional www.professorramos.com

Title:
Excel Avançado 2007 Parte 1.2 - Funções SE, E e Formatação Condicional www.professorramos.com


Video:


Description:Excel Avançado 2007 Parte 2 - Funções SE, E e Formatação Condicional Vídeo Aula de Excel 2007 Avançado ( Tutorial Passo a Passo com Exercícios práticos e Simples) Leandro Ramos Curso Completo em www.professorramos.com

Published:
14/May/2010

Wednesday 12 May 2010

Pareto Analysis Using Microsoft Excel 2007

Title:
Pareto Analysis Using Microsoft Excel 2007


Video:


Description:A Pareto diagram has to have a certain look and scale. Here's how to create a proper Pareto diagrm with Excel 2007.

Published:
13/May/2010

Tuesday 11 May 2010

Record a simple macro

Title:
Record a simple macro


Video:


Description:This video teaches how to record a simple macro

Published:
12/May/2010

Monday 10 May 2010

Recibo Inteligente, Excel 2007

Title:
Recibo Inteligente, Excel 2007Video:


Description:Recibo inteligente, com numeração automática e extenso, também, automático, formulário de lançamento e impressão, base de dados para armazenamento dos recibos emitidos, etc... Custo? Menos do que você imagina. Veja no site www.luciorezena.com.br e aproveite para visitar outras soluções e video-aulas tanto de Access quanto de Excel que temos ali, feitos na medida certa pra quem quer aprender, usar, e ao mesmo tempo, economizar. Um forte abraço. LucioRezena.

Published:
11/May/2010

Friday 7 May 2010

Excel 2007 - Create Basic Inventory System using Form and Formula

Title:
Excel 2007 - Create Basic Inventory System using Form and FormulaVideo:


Description:How to create a basic inventory system using Form and Formula

Published:
08/May/2010

Creating Your Own Functions in Excel with VBA

Title:
Creating Your Own Functions in Excel with VBA


Video:


Description:This is a description of how to create user-defined functions in Excel using Visual Basic for Applications (VBA), the built-in macro language. It comes from a course I teach as part of an online Masters degree program in engineering (mepp.engr.wisc.edu Higher res versions of this video can be found at blanchard.ep.wisc.edu. You can download the workbook from the same location.

Published:
07/May/2010

Excel 2007 - Calculate Internal Rate of Return.

Title:
Excel 2007 - Calculate Internal Rate of Return.


Video:


Description:Demonstrate =IRR Formula using Excel 2007

Published:
07/May/2010

Thursday 6 May 2010

PRACTICA DE EXCEL - CECYTEM TECAMAC - OPERAR UNA PC

Title:
PRACTICA DE EXCEL - CECYTEM TECAMAC - OPERAR UNA PC


Video:


Description:PRACTICA DE EXCEL 202 Y 205 CECYTEM TECAMAC PEQUEÑA PRACTICA

Published:
06/May/2010

VBA & OpenOffice.org

Title:
VBA and OpenOffice.org


Video:


Description:Visual Basic for Applications (VBA) is the programming language of Microsoft Office. VBA was used until now mainly to automate Excel macros or Access routines. And today, this language is used with OpenOffice.org version 3 of Sun! Besides the fact that OpenOffice.org is free, it also allows to use VBA on various platforms other than Windows! Credits : Microsoft Office www.microsoft.com OpenOffice.org www.openoffice.org

Published:
06/May/2010

Wednesday 5 May 2010

Using AutoHotKey For Windows Macro Recording

Title:
Using AutoHotKey For Windows Macro Recording


Video:


Description:www.pcmech.com - Using AutoHotKey For Windows Macro Recording

Published:
06/May/2010

6-2 Proteger y distribuir la hoja (Tutorial Excel 2007)

Title:
6-2 Proteger y distribuir la hoja (Tutorial Excel 2007)


Video:


Description:6-2 Proteger y distribuir la hoja (Tutorial Excel 2007)

Published:
06/May/2010

Excel 2010 VBA - Basic Loop Tutorial

Title:
Excel 2010 VBA - Basic Loop Tutorial


Video:


Description:Video tutorial on how to do the basic loop in Excel Visual Basic Window.

Published:
06/May/2010

5-Crear Informes y Diagramas (Tutorial Excel 2007)

Title:
5-Crear Informes y Diagramas (Tutorial Excel 2007)


Video:


Description:5-Crear Informes y Diagramas (Tutorial Excel 2007)

Published:
06/May/2010

3-2 Dar estilo y usar imágenes (Tutorial Excel 2007)

Title:
3-2 Dar estilo y usar imágenes (Tutorial Excel 2007)


Video:


Description:3-2 Dar estilo y usar imágenes (Tutorial Excel 2007)

Published:
06/May/2010

Excel 2003 vba: Formulario para copiar y pegar celdas entre hojas - Video 1/3

Title:
Excel 2003 vba: Formulario para copiar y pegar celdas entre hojas - Video 1/3


Video:


Description:En este ejercicio se crea un formulario en el que mediante botones de opción se señala la hoja de origen, se le da la fila y columna donde debe buscar la celda a copiar de esa hoja de origen y despues se hace lo mismo con el destino, es decir, mediante option se señala la hoja de destino y se le da la fila y columna de destino donde debe copiarse la celda seleccionada anteriormente. Por ejemplo: Vete a la hoja 3, busca la celda(3,6) y copiala en la hoja 1 en la celda de destino (10,5).

Published:
06/May/2010

2-3 Buscar y Reemplazar (Tutorial Excel 2007)

Title:
2-3 Buscar y Reemplazar (Tutorial Excel 2007)


Video:


Description:2-3 Buscar y Reemplazar (Tutorial Excel 2007)

Published:
06/May/2010

Monday 3 May 2010

PRACTICA DE EXCEL -- CECYTEM TECAMAC -- 202 Y 205

Title:
PRACTICA DE EXCEL -- CECYTEM TECAMAC -- 202 Y 205


Video:


Description:Practica de Excel sobre encuesta de antivirus, utilizando validacion, graficos, funciones y un macro

Published:
04/May/2010

SUM Function - Example 1 - in Excel 2007

Title:
SUM Function - Example 1 - in Excel 2007


Video:


Description:www.MacroMountain.com This brief tutorial shows how to use the SUM Function in Microsoft Excel 2007, including ranges, non-adjacent ranges, and mixtures of text and numerical cells.

Published:
03/May/2010

Saturday 1 May 2010

Insertar hoja de excel desde VB6.mp4

Title:
Insertar hoja de excel desde VB6.mp4


Video:


Description:Este video tutorial pertenece al sitio Web www.serviprofer.com.ve y en el mismo se explica cómo insertar una nueva hoja dentro de un libro de Excel usando la programación con Visual Basic 6.0. Aquí también aprenderás los pasos correctos para establecer conexión o acceder a un libro de Excel desde Visual Basic 6.0 abrir el libro, trabajar con el libro y finalmente cerrarlo. Si quieres obtener el código fuente de este trabajo, visita mi sitio web, ¡regístrate y descárgalo gratis!

Published:
02/May/2010