Thursday 30 October 2008

Tutorial - Excel 2007: Filtros, macros y formularios

Title:
Tutorial - Excel 2007: Filtros, macros y formularios


Video:


Description:Videotutorial que muestra cómo combinar y usar correctamente filtros, macros y formularios.

Published:
30/Oct/2008

Tuesday 28 October 2008

Excel MT #143: VBA: Avoid Data Validation 1 Rule Limit

Title:
Excel MT #143: VBA: Avoid Data Validation 1 Rule Limit


Video:


Description:See how to work around Data Validations one rule limit by getting VBA code to prevent duplicates. See how to ask questions at the Mr Excel Discussion Board and get answers.

Published:
29/Oct/2008

Excel MT142 p2: Array Formula for Counting Dates

Title:
Excel MT142 p2: Array Formula for Counting Dates


Video:


Description:See how to create a complex array formula that counts weekends between two dates with the SUM IF WEEKDAY ROW and INDIRECT functions in one formula See how to create an array formula that counts with date and other criteria Also see: From a beginning and ending date, see how to create a list of dates (serial numbers) in memory using the ROW and INDIRECT functions. Also see this video for another example of this date trick: Excel Magic Trick # 165: MACRO to Extract Birthdays.

Published:
28/Oct/2008

Excel Magic Trick #139: HYPERLINK function & Drop Down List

Title:
Excel Magic Trick #139: HYPERLINK function and Drop Down ListVideo:


Description:See how to use Data Validation List Drop-down and the hyperlink function to create a list of hyper links. See how to link to a web site or a cell on a different worksheet.

Published:
28/Oct/2008

Tutorial - Excel 2007: Referencias en 3D

Title:
Tutorial - Excel 2007: Referencias en 3D


Video:


Description:Videotutorial que explica paso a paso como realizar referencias 3D en Excel 2007.

Published:
28/Oct/2008

Saturday 25 October 2008

How To Use Microsoft Excel : Formatting Cells in Microsoft Excel

Title:
How To Use Microsoft Excel : Formatting Cells in Microsoft ExcelVideo:


Description:How to format cells in Microsoft Excel; learn more about spreadsheet software in this free instructional video. Expert: Gary Zier Bio: Gary Zier, originally from Florida, is a systems administrator with 10 years of computer networking experience and an expertise in conditional access security systems. Filmmaker: Gary Zier

Published:
25/Oct/2008

Friday 24 October 2008

Excel - Auto MS Access Upload

Title:
Excel - Auto MS Access Upload


Video:


Description:Demo shows how to connect to Access programmatically and insert data directly to Access using ADO and SQL from Excel. Uses two textboxes and a command button.

Published:
24/Oct/2008

Thursday 23 October 2008

Curso Multimídia Access XP - Editora Terra

Title:
Curso Multimídia Access XP - Editora Terra


Video:


Description:Conheça e aprenda os principais recursos do Access XP, um software que tem a finalidade de auxiliar o usuário no desenvolvimento e na manipulação de arquivos de bancos de dados. Neste curso, você irá aprender, de maneira didática, como gerar um arquivo de banco de dados, trabalhar com tabelas, criar consultas, definir e criar formulários e relatórios e vários outros recursos que o Access XP disponibiliza. São 86 lições apresentadas em mais de 2 horas e meia de vídeo. O curso apresenta uma interface intuitiva, agradável e auto - explicativa. As lições são apresentadas, passo a passo, em vídeo e organizadas em capítulos e tópicos, facilitando o acompanhamento ea navegação.

Published:
23/Oct/2008

Tuesday 21 October 2008

Adding picture in Excel 2007 -Wingslive.com

Title:
Adding picture in Excel 2007 -Wingslive.com


Video:


Description:This tutorial depicts about how to add a picture in excel 2007. For more video's : www.wingslive.com

Published:
21/Oct/2008

Monday 20 October 2008

How to Protect Excel 2007 Spreadsheet

Title:
How to Protect Excel 2007 Spreadsheet


Video:


Description:Protect your Excel 2007 Spreadsheet with a password. More video tutorials are available at www.selectsyss.com

Published:
20/Oct/2008

Friday 17 October 2008

Excel Magic Trick #129: More than 7 Nested IF functions

Title:
Excel Magic Trick #129: More than 7 Nested IF functions


Video:


Description:See what to do if you must have more than 7 nested IF functions: 1) Use the Ampersand, Use different cells, buy Excel 2007, use VLOOKUP, or Use a Boolean formula.

Published:
18/Oct/2008

Excel Magic Trick #126: Macro: Advanced Filter Extract Text

Title:
Excel Magic Trick #126: Macro: Advanced Filter Extract Text


Video:


Description:See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for advanced filter before creating a Macro and then adding the Macro to a Form Command button.

Published:
18/Oct/2008

Excel Magic Trick #124: Box Plot or Box & Whisker

Title:
Excel Magic Trick #124: Box Plot or Box and Whisker


Video:


Description:See how to create a Box Plot or Box and Whisker Statistics chart using a Stacked Bar Chart and a Open-High-Low-Close Stock Chart. See how to use the QUARTILE function. See how to link Chart Labels to cells.

Published:
18/Oct/2008

Sunday 5 October 2008

302208 - Creating a simple database using Microsoft Excel

Title:
302208 - Creating a simple database using Microsoft Excel


Video:


Description:302208 - Creating a simple database using Microsoft Excel... free video to demonstrate the quality of our online Microsoft Excel training course (video tutorial)

Published:
05/Oct/2008

Thursday 2 October 2008

macro excel convertir minusculas a mayusculas modificado

Title:
macro excel convertir minusculas a mayusculas modificado


Video:


Description:Macro elaborada en EXCEL que convierte texto introducida en minusculas a mayusculas y viceversa

Published:
03/Oct/2008