Friday 29 May 2009

video tutorial excel cuarta parte referencias absolutas

Title:
video tutorial excel cuarta parte referencias absolutas


Video:


Description:videosexplicativos.blogspot.com video tutorial excel cuarta parte referencias absolutas español

Published:
30/May/2009

video tutorial excel tercera parte funciones simples referencias relativas

Title:
video tutorial excel tercera parte funciones simples referencias relativas


Video:


Description:videosexplicativos.blogspot.com video tutorial de excel funciones simples y referencias relativas en castellano

Published:
30/May/2009

Wednesday 27 May 2009

ExcelExperts.com - Excel Tutorial - Insert Alternate Blank Lines

Title:
ExcelExperts.com - Excel Tutorial - Insert Alternate Blank Lines


Video:


Description:ExcelExperts.com brings you training video on: Excel Tutorial - Insert Alternate Blank Lines

Published:
27/May/2009

Monday 25 May 2009

Buscar Objetivo

Title:
Buscar Objetivo


Video:


Description:Instrucciones para crear una Macro que ejecute la busqueda de objetivos (3 dentro de la macro).

Published:
26/May/2009

Thursday 21 May 2009

How to Create a Pivot Table in Excel 2007 For Dummies

Title:
How to Create a Pivot Table in Excel 2007 For Dummies


Video:


Description:You can quickly and efficiently analyze data and trends in Excel 2007 by creating a pivot table. With all the power and flexibility that Excel's pivot tables offer, they are fairly easy to create, as this how-to video reveals.

Published:
21/May/2009

Wednesday 20 May 2009

Using VBA to Access Document Content in the 2007 Office System

Title:
Using VBA to Access Document Content in the 2007 Office System


Video:


Description:Accomplish more with Microsoft Visual Basic for Applications (VBA) when you write macros that can access content without first selecting that content. This article looks at common VBA constructs for working with content in Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, and Microsoft Office Word 2007.

Published:
21/May/2009

Tuesday 19 May 2009

Exploding Dates Macro - 1017 - Learn Excel from MrExcel

Title:
Exploding Dates Macro - 1017 - Learn Excel from MrExcel


Video:


Description:Shawn sends in today's question. The spreadsheet has billing data to audit. For each record, there is a location, a start date, and an end date. Shawn wants to find any records where the same date and location is double-billed. A quick two-loop macro solves this problem.Episode 1017 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Published:
19/May/2009

Monday 18 May 2009

am4510 - Einfache Makros erstellen

Title:
am4510 - Einfache Makros erstellenVideo:


Description:Auf wer-weiss-was.net kann man den vollständigen Excel-Kurs mit einer Gastanmeldung kostenlos besuchen. Hier sehen Sie Schritt für Schritt, wie ein einfaches Makro erstellt wird und man es in die Symbolleiste für den Schnellzugriff einbaut.

Published:
18/May/2009

Gathering Entries - 464 - Learn Excel from MrExcel Podcast

Title:
Gathering Entries - 464 - Learn Excel from MrExcel Podcast


Video:


Description:In offices throughout the US, people are starting to turn in their NCAA bracket sheets to the office commissioner. Whether you are asking accountants to fill out an NCAA bracket or sales reps to fill out a sales forecast, it makes sense to collect the data in an Excel workbook. In Episode 464, we take a look at a macro that can be used to gather entries from the individual worksheets and combine them into a master worksheet.

Published:
18/May/2009

Saturday 16 May 2009

Cómo hacer un menú desplegables en Open Office Calc

Title:
Cómo hacer un menú desplegables en Open Office Calc


Video:


Description:

Published:
16/May/2009

Friday 15 May 2009

BINGO EN EXCEL CON MACROS VBA

Title:
BINGO EN EXCEL CON MACROS VBA


Video:


Description:Excelente juego del Bingo elaborado en excel utilizando VBA , macros y programacion en general

Published:
16/May/2009

Thursday 14 May 2009

Planilla en excel automatizada

Title:
Planilla en excel automatizada


Video:


Description:Automatizacion de una planilla de costos automatizada con macros en excel. Automatizacion de excel

Published:
15/May/2009

aprenda a elaborar y usar Formularios con Excel

Title:
aprenda a elaborar y usar Formularios con Excel


Video:


Description:diferentes formas de emplear un formulario, construyendolo con una macro, con visual basic o los propios recursos de Excel, más fácil no puede ser

Published:
14/May/2009

Consuming Web Services In Excel 2007

Title:
Consuming Web Services In Excel 2007


Video:


Description:Learn how to consume a web service from an Excel 2007 workbook managed code extension. Previous versions of Microsoft Office applications were able to access Web services using the Microsoft Office Web Services Toolkit. However, the Web Services Toolkit is not a Microsoft supported product. Microsoft Visual Studio 2008 Tools for Office provides support for creating Office 2007 application managed code extensions that allow developers access to the full power of the .NET framework, including the ability to easily make calls to Web services.

Published:
14/May/2009

Merge and Center in Excel 2007

Title:
Merge and Center in Excel 2007


Video:


Description:See a higher quality video on TechTutor.TV! The merge and center command is a time-saving command that will merge cells together and cell the cell contents within those merged cells. In this tutorial, you will learn how to use merge and center in Excel 2007. See higher quality tutorials all for FREE at www.techtutor.tv

Published:
14/May/2009

Hacer Factura En Excel Parte 1 - ExpertoEnExcel.com

Title:
Hacer Factura En Excel Parte 1 - ExpertoEnExcel.comVideo:


Description:¿Vives en España? Gánate una Kindle ebook Gratis. Clic Aquí: bit.ly Aprende a hacer una factura en Excel paso a paso. ¿Deseas Dominar Excel? Inscríbete en nuestro Curso Básico Gratis. Ingresa: expertoenexcel.com

Published:
14/May/2009

Excel Export Worksheet Data to Notepad, Wordpad or Any Text File

Title:
Excel Export Worksheet Data to Notepad, Wordpad or Any Text File


Video:


Description:www.ExcelVisualBasics.com - Tutorial on how to export worksheet data in your Excel worksheet to a file on your hard drive like a notepad file, a text file, a wordpad file, or even other file types. You can export an Excel workbook in this fashion. ExcelVisualBasics shows you visually what vb code actually does BEFORE you waste your time trying to tweak it.

Published:
14/May/2009

Wednesday 13 May 2009

Automatizar carta de compromiso

Title:
Automatizar carta de compromiso


Video:


Description:Automatiza documentos de word, excel, acces, etc. Con tan solo haciendo clicks usted puede llenar un documento utilizando pare ello FORMULARIOS hechos en VBA . Usando MACROS EN WORD, MACROS EN EXCEL usted puede automatizar documentos laboriosos y extensos. Tecnologia MASTERSOFT de Marco Agreda Matias

Published:
13/May/2009

Tuesday 12 May 2009

Mail Merge in Microsoft Office Word 2007

Title:
Mail Merge in Microsoft Office Word 2007


Video:


Description:This tutorial will cover creating a Mail Merge in Microsoft Office Word 2007. Mail merges pull information from spreadsheet programs like Microsoft Excel and database programs like Microsoft Access and place that information where you need it in your documents. The Instructional Media Center (IMC) at Mitchell Memorial Library produces tutorials and conducts workshops on desktop publishing and graphic design software such as the Microsoft Office 2007 Suite and the Adobe Creative Suite. For more information, visit us at library.msstate.edu

Published:
12/May/2009

Monday 11 May 2009

Formularios en Word 2007

Title:
Formularios en Word 2007


Video:


Description:Se muestra cómo elaborar un cuestionario en word. Cómo asignarle protección para compartirlo y que las personas que nos interesan puedan rellenarlo.

Published:
12/May/2009

Tuesday 5 May 2009

Curso Microsoft Access 2003 creacion de formularios

Title:
Curso Microsoft Access 2003 creacion de formularios


Video:


Description:esta es la segunda parte del tutorial rapido de access 2003, en este video podemos ver como se crea un formulario, digamos que el formulario es la interface grafica para hacer mas amigable nuestra base datos, o bien para mostrarsela al cliente final de una forma elegante y agradable.

Published:
06/May/2009

Monday 4 May 2009

Macros Excel

Title:
Macros Excel


Video:


Description:Creación de una Macro en Excel utilizando el editor de Visual Basic.

Published:
04/May/2009

Sunday 3 May 2009

Using The Quick Access Toolbar - Free Excel training

Title:
Using The Quick Access Toolbar - Free Excel training


Video:


Description:www.macresource.co.uk Using The Quick Access Toolbar - a Free Excel tutorial. by Macresource Computer Training, an independent computer training company offering tutor-led courses in London on Adobe Creative Suite Acrobat, Dreamweaver, Flash, Illustrator, InDesign and Photoshop; Microsoft Office: Access, Excel, Outlook, PowerPoint, Project, VBA, Visio and Word; as well as web design and development: ASP.Net, CSS, HTML, JavaScript, PHP/MySQL and XML. Visit our website for discounts and special offers on public training courses.

Published:
03/May/2009

How to concatenate the contents of multiple cells in Excel 2007

Title:
How to concatenate the contents of multiple cells in Excel 2007


Video:


Description:www.helpvids.com is a free high quality video clip streaming site. Providing free video clips tutorials to help people learn how to use software such as Microsoft Office, Windows Vista, Windows XP, Word, Excel, PowerPoint, Adobe, NetObjects Fusion, Pinnacle Studio. In this video you will learn how to Combine data using the ampersand Combine data using the Concatenate function. Visit out website at www.helpvids.com for more videos!

Published:
03/May/2009

Friday 1 May 2009

Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0

Title:
Excel Magic Trick 314: Convert TRUE and FALSE to 1 and 0


Video:


Description:See 4 methods for converting TRUE and FALSE to 1 and 0 (zero) using double negative, multiply by one, add zero, and divide by one: --TRUE, TRUE*1, TRUE+0, TRUE/1. See the SUMPRODUCT function and learn about the Order Of Precedents that Excel follows when evaluating formulas.

Published:
02/May/2009