Wednesday 28 December 2011

Create User Form (Excel Mac 2011).mp4

Title:
Create User Form (Excel Mac 2011).mp4


Video:


Description:Create User Form (Excel Mac 2011).mp4

Published:
29/Dec/2011

Tuesday 27 December 2011

Create a UserForm (Excel 2010 Windows)

Title:
Create a UserForm (Excel 2010 Windows)


Video:


Description:Demonstrates how to create a user form and write code to make it show up.

Published:
28/Dec/2011

Monday 26 December 2011

Ejemplo macro consulta de venta de inventario

Title:
Ejemplo macro consulta de venta de inventario


Video:


Description:Video promocional de mi sitio: www.facebook.com Cualquier duda sobre este video estamos a la orden

Published:
27/Dec/2011

Saturday 24 December 2011

Microsoft Access Developer Tip - การใช้ฟังก์ชัน BahtText จาก Excel

Title:
Microsoft Access Developer Tip - การใช้ฟังก์ชัน BahtText จาก Excel


Video:


Description:เทคนิคการใช้ Function BahtText ใน Microsoft Excel มาใช้ใน Microsoft Access

Published:
24/Dec/2011

Friday 23 December 2011

Excel Planilha de Controle com Procv e Lista

Title:
Excel Planilha de Controle com Procv e Lista


Video:


Description:Como controlar, comparar e pesquisar itens, com o PROCV e uma LISTA de dados. O "procv" é uma das funções mais utilizadas por aqueles que gostam de realizar comparações entre planilhas, busca de dados e consolidação, já a "lista" é muito utilizada para aqueles que querem melhorar a "performance" de seus relatórios, buscando e interligando dados com um simples clique.

Published:
24/Dec/2011

Use the Offset Property in Excel VBA

Title:
Use the Offset Property in Excel VBA


Video:


Description:www.computergaga.com ‎Use the Offset property in Excel VBA. The Offset property is used to refer to cells in a worksheet and is extremly useful in loops to move around a worksheet. The Offset property applies to the Range object.

Published:
23/Dec/2011

Monday 19 December 2011

Excel Message with User Name

Title:
Excel Message with User Name


Video:


Description:www.contextures.com To get soneome's attention in Excel, you can show an Excel message box that includes their network user name. This video shows how to download and customize the sample Excel file, and create your own personalized messages. Visit the www.contextures.com web page, to download the sample file.

Published:
20/Dec/2011

Thursday 15 December 2011

How to group dates by month and quarter in Excel 2007 PivotTables (Excel 07-103)

Title:
How to group dates by month and quarter in Excel 2007 PivotTables (Excel 07-103)


Video:


Description:Demonstrates how to group dates in an Excel 2007 PivotTable into months, quarters, and both at the same time.

Published:
16/Dec/2011

Wednesday 14 December 2011

Excel VBA - Creating a Pivot Table using VBA

Title:
Excel VBA - Creating a Pivot Table using VBA


Video:


Description:Excel VBA - Creating Pivot Table using VBA

Published:
15/Dec/2011

Programación en Excel Facturas Avanzadas - Imprimir con Access

Title:
Programación en Excel Facturas Avanzadas - Imprimir con Access


Video:


Description:Como final de esta serie, se muestra cómo emitir muchas facturas de una vez empleando Access

Published:
15/Dec/2011

Tuesday 13 December 2011

Curso de Access 2010 73 Crear una consulta multitabla

Title:
Curso de Access 2010 73 Crear una consulta multitabla


Video:


Description:

Published:
14/Dec/2011

powermacros 0906

Title:
powermacros 0906


Video:


Description:

Published:
14/Dec/2011

powermacros 0901

Title:
powermacros 0901


Video:


Description:

Published:
14/Dec/2011

powermacros 0701

Title:
powermacros 0701


Video:


Description:

Published:
14/Dec/2011

Monday 12 December 2011

powermacros 0204

Title:
powermacros 0204


Video:


Description:

Published:
13/Dec/2011

Friday 9 December 2011

Dueling Excel - "Watch Box": Podcast #1488

Title:
Dueling Excel - "Watch Box": Podcast #1488Video:


Description:In today's Dueling Excel, Episode #1488, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen team up to defend Excel's honor, showing two different methods to create a Watch Box in Excel. Dueling Excel Podcast #92...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] and "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Published:
09/Dec/2011

Monday 5 December 2011

ALMACENES 2012 - COMPLEMENTO

Title:
ALMACENES 2012 - COMPLEMENTO


Video:


Description:LINK DE DESCARGA : www.megaupload.com AHORA SI QUIEREN MODIFICAR EL CODIGO U OTRA COSA ES ALGO SIMILAR QUE ESTA EN EL ARCHIVO DE WORD ...YA PUES NO ESPEREN QUE TODO LO HAGA YO , DONDE ESTA SUS INTELIGENCIAS , Y COMO DICE LOS ANCIANOS DE LO ALTO : SOLO LOS RECIEN NACIDOS COMEN TODO APLASTADITO , ( SOLO LOS BEBES COMEN PAPEADITO ) BUENA SUERTE ... NUEVO ENLACE DE DESCARGA EN MEDIAFIRE : www.mediafire.com AHORA NO ME DIGAN QUE NO FUNCIONA EL ENLACE , PENDEJO ...

Published:
05/Dec/2011

Saturday 3 December 2011

formulário de cadastro em excel vba com imagem

Title:
formulário de cadastro em excel vba com imagem


Video:


Description:Formulário desenvolvido em VBA com excel para inserção de dados planilha com imagem. Meu E-mail: rodolfo_s_rodrigues@hotmail.com Rodolfo

Published:
03/Dec/2011

Wednesday 30 November 2011

Estadística - Módulo 1 - Tutorial 6 - Excel

Title:
Estadística - Módulo 1 - Tutorial 6 - Excel


Video:


Description:

Published:
30/Nov/2011

Tuesday 29 November 2011

Creación de una Macro.flv

Title:
Creación de una Macro.flv


Video:


Description:Pasos para crear una macro

Published:
30/Nov/2011

Monday 28 November 2011

Episodio 44- ¿Dónde está mi macro?

Title:
Episodio 44- ¿Dónde está mi macro?


Video:


Description:Hoy en el Video del Día aprenderemos las diferentes rutas donde podemos guardar nuestras macros.

Published:
29/Nov/2011

Friday 25 November 2011

Microsoft Access 2010 Tutorial Part 10 of 12 - Customer Form

Title:
Microsoft Access 2010 Tutorial Part 10 of 12 - Customer Form


Video:


Description:Learn MORE Access at 599CD.com Forms are great for designing a nice, clean user interface for your database. They're especially perfect if other people need to work with your database because you can present to them only the data they need to see - and lock everything else. You will learn how to build forms to show a single record, multiple records (continuous forms), and a split form to show both. You'll learn about labels and text boxes, how to resize them, and how to save your form. We'll discuss editing data in your form, using record selectors to delete records, and how to use navigation buttons to move around. 10. Customer Form Why use forms? What are forms good for? Create a simple customer form Different ways to build forms Single Form Label and Text Box Form View Layout View Resizing Text Boxes Layout View uses Rows and Columns Save Form Delete Form Title and Logo Open in Form View Editing Data Using Navigation Buttons Pencil indicates Dirty record Record Selector Delete a Record Create a Multiple Items form Continuous Forms Create a Split Form

Published:
26/Nov/2011

Wednesday 23 November 2011

Link Yahoo Stock Page to Excel 2010 Spreadsheet

Title:
Link Yahoo Stock Page to Excel 2010 Spreadsheet


Video:


Description:Shows you how to link stock data from the Yahoo Finance site to your Excel 2010 worksheet.

Published:
24/Nov/2011

Tuesday 22 November 2011

Curso de Office 2010 - Aula 3 - Microsoft Access.avi

Title:
Curso de Office 2010 - Aula 3 - Microsoft Access.avi


Video:


Description:Curso de Access 2010, aprenda nesta 3º video aula como criar um formulario e trabalhar com as propriedades do access. Para adquirir o curso completo é so acessar a loja virtual www.classeacursos.com.br ou entrar em contato via e-mail:classeatreinamentos@yahoo.com.br

Published:
22/Nov/2011

Wednesday 16 November 2011

[SC 035] Microsoft Access 2010 - Création et mise en forme d'un état paramétré

Title:
[SC 035] Microsoft Access 2010 - Création et mise en forme d'un état paramétré


Video:


Description:Dans ce tuto sur Microsoft Access 2010 vous apprendrez à créer et mettre en forme un état paramétré donnant, selon le choix effectuer dans un menu, toutes les informations d'une table ou seulement certaines informations. Vous découvrirez également la macro "OuvrirEtat" permettant d'ouvrir un état (sérieux o_O ?) tout en réalisant un critère à l'ouverture (selon le contenu de la liste déroulante du menu sus-nommé ^^). ScreenCast par Marie Daupley and Julien Duquennoy

Published:
16/Nov/2011

Tuesday 15 November 2011

Excel VBA: Create an User Form Dropdown Menu

Title:
Excel VBA: Create an User Form Dropdown Menu


Video:


Description:Excel VBA: Create a User Form Dropdown Menu

Published:
16/Nov/2011

Monday 14 November 2011

02 crear macro de formato en Oo-Calc

Title:
02 crear macro de formato en Oo-Calc


Video:


Description:

Published:
15/Nov/2011

How to build historical database for backtesting with Yahoo market data, Matlab, and free MYSQL

Title:
How to build historical database for backtesting with Yahoo market data, Matlab, and free MYSQL


Video:


Description:How to build historical database for backtesting with Yahoo market data, Matlab, and free MYSQL. Apple AAPL is example Here is a little basic Matlab M file script I build to fetch the latest stock symbol data for AAPL With Yahoo fetch market data.

Published:
15/Nov/2011

Friday 11 November 2011

Atajos de teclado de Excel

Title:
Atajos de teclado de Excel


Video:


Description:exceltotal.com Los atajos de teclado de Excel son de mucha importancia porque te ayudarán a moverte rápida y facilmente entre los datos de una hoja.

Published:
11/Nov/2011

Tuesday 8 November 2011

Tableau de contingence (tableau à double entrées) sous Excel 2010 (ou Excel 2007)

Title:
Tableau de contingence (tableau à double entrées) sous Excel 2010 (ou Excel 2007)


Video:


Description:Comment faire un tableau de contingence (tableau à double entrées) sous Microsoft Office Excel 2010 (ou Excel 2007) à des fins d'analyses statistiques. Cégep régional de Lanaudière à Terrebonne Cours : 201-705-TB - Statistique Programme : Techniques de comptabilité et de gestion [410.B0]

Published:
08/Nov/2011

Learn Excel 2010 - "Embed a PDF in Excel": Podcast #1466

Title:
Learn Excel 2010 - "Embed a PDF in Excel": Podcast #1466


Video:


Description:Can you embed a PDF in a worksheet? Yes - Using the 'Insert Object' Menu Tab. Follow along with Bill, in Episode #1466, as he shows us how to embed a PDF in our Worksheet. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Published:
08/Nov/2011

Sunday 6 November 2011

Saturday 29 October 2011

Curso VBA Excel 2007 Forem Navarra. Ejercicio Producción. 2ª Parte. Video 01. David Asurmendi.

Title:
Curso VBA Excel 2007 Forem Navarra. Ejercicio Producción. 2ª Parte. Video 01. David Asurmendi.


Video:


Description:Seguimos con las sesiones dedicadas a la realización del ejercicio práctico, que desarrollamos en el curso presencial de VBA para Excel. Este curso se desarrolla en Forem Navarra. En la sesión anterior, la primera que dedicábamos a este ejercicio os presente el ejemplo y os mostré unas pinceladas de lo que hace el ejercicio una vez finalizado. Además empezamos a desarrollarlo y lo principal que resolvimos en esa sesión fue que al finalizar teníamos un procedimiento que me cargaba los países de los que teníamos datos de producción en un cuadro combinado. En esta sesión continuamos donde lo dejamos y nos vamos a centrar en conseguir que al seleccionar un país del cuadro combinado nos muestre en la hoja análisis los datos de ese país. Esta va ser la tarea que vamos a desarrollar en esta sesión. Para resolver este problema volveremos a utilizar la herramienta "Filtros Avanzados". Más información y el archivo del vídeo en el Blog: davidasurmendi.blogspot.com

Published:
29/Oct/2011

Thursday 27 October 2011

Publishing to Wonderware Information Server using Excel (AF Workbook)

Title:
Publishing to Wonderware Information Server using Excel (AF Workbook)


Video:


Description:This video will show you how to use ActiveFactory Workbook inside of MS Excel and publish a report to the Wonderware Information Server.

Published:
28/Oct/2011

Sunday 23 October 2011

CUADRO COMBINADO FORMULARIO ACCESS 2007

Title:
CUADRO COMBINADO FORMULARIO ACCESS 2007


Video:


Description:CUADRO COMBINADO FORMULARIO ACCESS 2007

Published:
23/Oct/2011

Thursday 20 October 2011

excel using custom routines 1

Title:
excel using custom routines 1


Video:


Description:using custom routines in excel vba.

Published:
20/Oct/2011

Monday 17 October 2011

How to convert PDF to DOC, TIFF, JPEG, XLS, etc.

Title:
How to convert PDF to DOC, TIFF, JPEG, XLS, etc.


Video:


Description:How to convert PDF files? Total PDF Converter is the right solution for both advanced users and beginners. Watch a short video tutorial to learn how to convert PDF files.

Published:
17/Oct/2011

Sunday 16 October 2011

Power Debt Plan Tutorial2

Title:
Power Debt Plan Tutorial2


Video:


Description:bit.ly Video tutorial 2 how to consolidate multiple debt accounts into a single debt account. This spreadsheet is $9 at my website. Video tutorial 1 is at bit.ly Video tutorial 2 is at bit.ly Video tutorial 3 is at bit.ly Video tutorial 4 is at bit.ly Video tutorial 5 is at bit.ly Video tutorial 6 is at bit.ly Video tutorial 7 is at bit.ly Video toturial 8 is at bit.ly Video tutorial 9 is at bit.ly Software is at bit.ly

Published:
17/Oct/2011

Saturday 15 October 2011

Curso VBA Excel 2007 Forem Navarra. Ejercicio Producción. 1ª Parte. Video 01. David Asurmendi.

Title:
Curso VBA Excel 2007 Forem Navarra. Ejercicio Producción. 1ª Parte. Video 01. David Asurmendi.


Video:


Description:Como ya sabéis doy cursos presenciales para Forem Navarra y uno de los que imparto es el de programación en Excel 2007. Durante el curso hago dos tipos de sesiones. Por un lado sesiones como las que ya he publicado en el Blog, en las que explico conceptos generales. Y también realizamos sesiones en las que voy desarrollando un ejercicio en el que practicamos todo lo visto en el otro tipo de sesiones y conceptos nuevos que se explican con este ejercicio. Esta es la primera sesión dedicada a la creación de ese ejercicio. A parte de servir a mis alumnos para repasar lo que hacemos en clase, también os servirá al resto para aprender nuevos conceptos y ver ejemplos prácticos de lo que llevamos explicado en el Blog. En el curso uso la versión 2007 de Excel, hasta el próximo año creo que no se va a realizar la migración a la siguiente versión. Los vídeos los voy a realizar con la versión 2007 para que sean 100% lo que hacemos en clase. Si queréis realizar el ejercicio con la versión 2010 creo que no vais a tener ningún problema. Antes de publicar los vídeos comprobaré que todo funciona sin problemas y si hay que hacer alguna modificación os avisaré. Es un ejercicio muy completo y creo que os va resultar realmente útil a la hora de resolver problemas reales que tengáis en vuestro trabajo. Para que os hagáis una idea se van a tratar temas como la importación de datos desde una base de datos de Access, la conexión de Excel con documentos de Word, creación de formularios y muchos ...

Published:
15/Oct/2011

Friday 14 October 2011

Tutorial Excel 2

Title:
Tutorial Excel 2


Video:


Description:

Published:
15/Oct/2011

Tuesday 11 October 2011

Excel 2007 Tutorial 11 Printing in Excel

Title:
Excel 2007 Tutorial 11 Printing in Excel


Video:


Description:

Published:
11/Oct/2011

Sunday 9 October 2011

Excel 2003: inmovilizar paneles

Title:
Excel 2003: inmovilizar paneles


Video:


Description:Cómo inmovilizar filas columnas y/o filas en excel

Published:
09/Oct/2011

Saturday 8 October 2011

Simulate Stock Prices in Excel: Bootstrap

Title:
Simulate Stock Prices in Excel: Bootstrap


Video:


Description:In this video I am showing you how to generate random stock prices in Microsoft Excel by using the Bootstrapping approach.

Published:
09/Oct/2011

Thursday 6 October 2011

tutorial excel grafica

Title:
tutorial excel grafica


Video:


Description:tutorial.

Published:
06/Oct/2011

Wednesday 5 October 2011

Scorecard - Six Sigma Excel template

Title:
Scorecard - Six Sigma Excel template


Video:


Description:Excel template for organizing and archiving Six Sigma data. Systems2win

Published:
06/Oct/2011

smart office picsel insert and delete rows excel

Title:
smart office picsel insert and delete rows excel


Video:


Description:Don't have enough rows or columns in your sheet or you've got too many? Tap a cell to select it then tap 'insert'. It couldn't be any simpler.

Published:
05/Oct/2011

Tuesday 4 October 2011

How to create check-box in Excel

Title:
How to create check-box in Excel


Video:


Description:

Published:
04/Oct/2011

Friday 30 September 2011

Word 2010 Expert, MOS Study Questions

Title:
Word 2010 Expert, MOS Study Questions


Video:


Description:This video covers some possible questions/tasks you might find on the Word 2010 Expert exam. Enjoy

Published:
01/Oct/2011

Monday 26 September 2011

Excel 2003 Tutorial Running Macros Microsoft Training Lesson 33.2

Title:
Excel 2003 Tutorial Running Macros Microsoft Training Lesson 33.2


Video:


Description:Learn how to run and delete recorded macros in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. Get the complete tutoria...

Published:
26/Sep/2011

Excel 2003 Tutorial Deleting Macros Microsoft Training Lesson 33.3

Title:
Excel 2003 Tutorial Deleting Macros Microsoft Training Lesson 33.3


Video:


Description:Learn how to run and delete recorded macros in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. Get the complete tutoria...

Published:
26/Sep/2011

Excel 2003 Tutorial Recording Macros Microsoft Training Lesson 33.1

Title:
Excel 2003 Tutorial Recording Macros Microsoft Training Lesson 33.1


Video:


Description:Learn how to run and delete recorded macros in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. Get the complete tutoria...

Published:
26/Sep/2011