Friday 29 April 2011

Matriz transpuesta en Excel

Title:
Matriz transpuesta en Excel


Video:


Description:Operación muy usada en el cálculo matricial.

Published:
29/Apr/2011

Microsoft Excel Tutorial

Title:
Microsoft Excel Tutorial


Video:


Description:Tutorial on formatting an Excel worksheet.

Published:
29/Apr/2011

Excel VBA tutorial 14 Intro to Do While loops and Guess my number game

Title:
Excel VBA tutorial 14 Intro to Do While loops and Guess my number game


Video:


Description:Introduction to DO WHILE loops and creating a Guess my number game. Please subscribe to my channel to see all my tutorials!!

Published:
29/Apr/2011

Tutorial Macro y Filtro Ivor Baeza.wmv

Title:
Tutorial Macro y Filtro Ivor Baeza.wmv


Video:


Description:Se demuestra la utilización de filtro y un macro sencillo utilizándolo en una planilla para realizar seguimiento a solicitudes de compra. Permite filtrar algunos campos y el macro permite mostrar solo las solicitudes pendientes

Published:
29/Apr/2011

Hvordan beskytte bestemte celler i Excel

Title:
Hvordan beskytte bestemte celler i Excel


Video:


Description:Dette er en brukerveiledning for å beskytte bestemte celler i Excel.

Published:
29/Apr/2011

Thursday 28 April 2011

052 สร้างคำสั่ง Macro ใน Excel ง่ายนิดเดียว.avi

Title:
052 สร้างคำสั่ง Macro ใน Excel ง่ายนิดเดียว.avi


Video:


Description:อธิบายการใช้งาน EPS16YEAR ไฟล์เก็บข้อมูล งบดุลบริษัท และ ราคาหุ้น ในตลาดหลักทรัพย์ ผมแจก EPS16YEAR ให้เพื่อนๆเอาไปศึกษาดูข้อมูลหุ้นในตลาดหลักทรัพย์ โดยแจ้งความประสงค์มาได้ที่ kanchit_pai@hotmail.com

Published:
28/Apr/2011

excel tutorial 3

Title:
excel tutorial 3


Video:


Description:

Published:
28/Apr/2011

Wednesday 27 April 2011

Data Validation Multiple Selection Setup

Title:
Data Validation Multiple Selection Setup


Video:


Description:blog.contextures.com Use Excel data validation to create drop down lists on a worksheet. With Excel VBA programming, you can allow users to select multiple items from a data validation drop down list. This video shows how to set up the data validation lists, and copy the Excel VBA code from the sample workbook. Make a small adjustment to the VBA code, if necessary, so it works correctly in your workbook.

Published:
28/Apr/2011

Crear botones nuevo, guardar y borrar en formulario access

Title:
Crear botones nuevo, guardar y borrar en formulario access


Video:


Description:Tutorial de access. Sigue mis tutoriales desde sites.google.com

Published:
27/Apr/2011

Tuesday 26 April 2011

Dynamic Pivot Table Report Filters - Excel Tutorial

Title:
Dynamic Pivot Table Report Filters - Excel Tutorial


Video:


Description:http://chandoo.org/wp/2011/04/27/update-report-filter-macro/ Learn how to dynamically update Pivot Table Report Filters using simple macro code. In this exam...

Published:
27/Apr/2011

PROCESO PARA ACTIVAR MACROS EN EXCEL

Title:
PROCESO PARA ACTIVAR MACROS EN EXCEL


Video:


Description:PROCESO PARA ACTIVAR MACROS EN EXCEL

Published:
27/Apr/2011

TUTORIAL SOFTWARE INVENTARIOS Y KARDEX

Title:
TUTORIAL SOFTWARE INVENTARIOS Y KARDEXVideo:


Description:tutorial recorrido general por software de control de inventarios o kardex

Published:
26/Apr/2011

Makros deaktivieren - TUTORIAL

Title:
Makros deaktivieren - TUTORIAL


Video:


Description:Verhindern Sie, dass Makros ungefragt ausgeführt werden Makros dienen regulär dazu, beispielsweise in Office-Anwendungen, Arbeitsabläufe zu automatisieren. Findige Virenprogrammierer haben jedoch rasch erkannt, dass diese Sprache sich auch sehr gut dazu eignet, Viren zu programmieren. Die meisten Makroviren haben dann das Ziel, die Standardvorlage (in Word: „normal.dot") zu infizieren, da diese bei jedem Programmstart automatisch geladen wird und der Virus so automatisch mit aktiv wird. Das Schlimme daran: Es werden dann alle neu erstellten Dokumente mit diesem Virus infiziert und er erreicht die höchst mögliche Verbreitung. Schützen Sie deshalb Ihr System vor heimtückischen Makroviren. Wie einfach das in Office 2007 geht, zeigt Ihnen dieses Video. Der ganze Artikel unter: www.computerwissen.deInteressant für Sie wird sicherlich auch unser Internetauftritt www.computerwissen.de sein. Schauen Sie sich auch unsere anderen Videos an, die helfen, ein Problem zu lösen und andere Tips und Tricks rund um den PC bieten. Diese Videos bieten viele Hilfestellungen und persönlichen Support zu IT-Themen - zB Microsoft Office - besonders Outlook, Excel, Word 2003, 2007, 2010 und hilfreiche Office Downloads - aber auch OpenOffice und Photoshop bzw. Gimp. Darüber hinaus alles zu Windows - von Windows XP über Windows Vista bis Windows 7 (alle Win 7 Versionen). Weitere Themen sind Hardware (spezielle Gamer-Hardware, Windows 7 Hardware, Hardware-Tuning etc.), Grafik, Treiber und das Lösen ...

Published:
26/Apr/2011

Tutorial de Excel - Nombres Aleatorios (Macro Sorteo - Ciclo for.. next)

Title:
Tutorial de Excel - Nombres Aleatorios (Macro Sorteo - Ciclo for.. next)


Video:


Description:Descarga el archivo aqui: www.asesorjuanmanuel.com Macro para seleccionar un nombre aleatoriamente utilizando un ciclo for next sitio: www.asesorjuanmanuel.com facebook www.facebook.com twitter: www.twitter.com fan page: www.facebook.com Dale me gusta, +1 , compártelo... el conocimiento es de todos. únete a mi red de amigos, contactame por facebook!

Published:
26/Apr/2011

Monday 25 April 2011

TUTORIAL NOMINA 1

Title:
TUTORIAL NOMINA 1


Video:


Description:tutorial en video para software gestion de nomina tomas 302

Published:
26/Apr/2011

lynda.com tutorial | Excel 2010: Pivot Tables in Depth—Creating a PivotChart

Title:
lynda.com tutorial | Excel 2010: Pivot Tables in Depth—Creating a PivotChart


Video:


Description:Watch the entire course at www.lynda.com In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot.

Published:
25/Apr/2011

lynda.com tutorial | Excel 2010: Pivot Tables in Depth—Search Filters in Pivot Tables

Title:
lynda.com tutorial | Excel 2010: Pivot Tables in Depth—Search Filters in Pivot Tables


Video:


Description:Watch the entire course at www.lynda.com In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot.

Published:
25/Apr/2011

lynda.com tutorial | Excel 2010: Pivot Tables in Depth—Summarizing more than one data field

Title:
lynda.com tutorial | Excel 2010: Pivot Tables in Depth—Summarizing more than one data field


Video:


Description:Watch the entire course at www.lynda.com In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot.

Published:
25/Apr/2011

lynda.com tutorial | Excel 2010: Pivot Tables in Depth—Pivoting a PivotTable

Title:
lynda.com tutorial | Excel 2010: Pivot Tables in Depth—Pivoting a PivotTable


Video:


Description:Watch the entire course at www.lynda.com In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot.

Published:
25/Apr/2011

Excel VBA Immediate Window

Title:
Excel VBA Immediate Window


Video:


Description:Discusses the role of the Immediate Window of VBA Integrated Development environment (VB IDE). Discusses one way to think about the Immediate Window as being a complementary tool to the macro recorder. Move information about the Excel, VBA and Access software training I provide can be found here: uk-software-training.com . A higher resolution version of the film can be viewed or downloaded from www.dorchestersoftware.co.uk Excel VBA

Published:
25/Apr/2011

Fórmulas en Excel 2010: Referencias Relativas. Vídeo 01. davidasurmendi.blogspot.com

Title:
Fórmulas en Excel 2010: Referencias Relativas. Vídeo 01. davidasurmendi.blogspot.com


Video:


Description:En este vídeo explico como utilizar las Referencias Relativas para poder copiar una fórmula a otras celdas diferentes y de esa manera aprovecharla para ahorrar tiempo y trabajo. Como cuento en el vídeo las fórmulas son la herramienta más potente con la que contamos en Excel. Muy al contrario de lo que la gente piensa, las fórmulas se pueden utilizar en todas la herramientas que Excel pone a nuestra disposición, por ejemplo en el Formato Condicional o en la Validación de Datos, entre otras posibilidades. Utilizando fórmulas junto con estas herramientas conseguiré hacer cosas realmente avanzadas y potentes, que ni siquiera podemos imaginarnos que se pueden hacer con Excel. Por eso estas sesiones que voy a dedicar a las fórmulas son muy importantes. En la primera vamos a tocar el primer tipo de Referencia a Celdas que podemos usar: Las referencias Relativas. Yo distingo entre tres tipos de Referencias: Relativas, Mixtas y Absolutas. Empezamos por las más fáciles en las sesiones posteriores comentaremos el resto. Pero todas son importantísimas y debéis conocer como funciona para utilizar toda la potencia de las fórmulas de Excel.

Published:
25/Apr/2011

Excel VBA tutorial 11 IF Statments Continued and Hiding a Range of Cells

Title:
Excel VBA tutorial 11 IF Statments Continued and Hiding a Range of Cells


Video:


Description:If Statments Continued and showing an ausome little trick using If Statments and the hide Cells property. Please check out my other Videos by clicking on my channel and subscribe to future tutorials!

Published:
25/Apr/2011

Sunday 24 April 2011

Excel VBA tutorial 10 IF Statment OR operator and ELSEIF

Title:
Excel VBA tutorial 10 IF Statment OR operator and ELSEIF


Video:


Description:Learning how to use the OR operator to create a Insurance Premium Calculator. Please click on my channel to see all my tutorials and to subscribe to future tutorials.

Published:
25/Apr/2011

Excel VBA tutorial 8 IF Statment continued and assigning macros to a button

Title:
Excel VBA tutorial 8 IF Statment continued and assigning macros to a button


Video:


Description:This Tutorial Follows on from the last tutorial and explains the not equal to operator for not equal too. It also explains how to assign a macro to a button. Please Click on my Channel to see all my tutorials and subscribe to future tutorials!

Published:
25/Apr/2011

Excel VBA tutorial 7 Intro to IF statements - Password protected Macro

Title:
Excel VBA tutorial 7 Intro to IF statements - Password protected Macro


Video:


Description:Introducing IF Statements and creating a Password Protected Macro Also Introduces using an input box. Please go to my channel and check out all my videos and...

Published:
24/Apr/2011

Excel VBA tutorial 4 Using Integer Variables to perform calculations

Title:
Excel VBA tutorial 4 Using Integer Variables to perform calculations


Video:


Description:An introduction to variables and how to use them in calculations. Also introduces the "With" keyword

Published:
24/Apr/2011

Excel VBA tutorial 3 Using the Cells Property to Copy Cells

Title:
Excel VBA tutorial 3 Using the Cells Property to Copy Cells


Video:


Description:Introduction to the cell property and copying the value of cells. Please watch the rest of my tutorials and subscribe to my channel

Published:
24/Apr/2011

Excel VBA tutorial 2 Using the Range Property to Select Cells

Title:
Excel VBA tutorial 2 Using the Range Property to Select Cells


Video:


Description:Welcome Everyone to the Second Tutorial. This tutorial introduces the range property and how to select cells using Visual Basic. Please see my other tutorials and subscribe to my channel

Published:
24/Apr/2011

Excel VBA Tutorial 1 Creating your first Macro - Hello World!

Title:
Excel VBA Tutorial 1 Creating your first Macro - Hello World!


Video:


Description:Please check out all my tutorials here!!!!!!! www.youtube.com Excel VBA tutorial 1 Creating your first Macro - Hello World! Welcome Everyone to the first in a series of Visual Basic in Excel tutorials. Please Subscribe to my channel and check out my other videos.

Published:
24/Apr/2011

Saturday 23 April 2011

Tutorial Trabajo Formulario Excel - Taller de Software - Parte 1

Title:
Tutorial Trabajo Formulario Excel - Taller de Software - Parte 1


Video:


Description:-Creacion del UserForm -Insertar Etiqueta, Cuadro de Texto y Macro Cualquier duda o cunsulta escribanme al Facebook oa mi correo luisfigueroa@movistar.cl

Published:
24/Apr/2011

Friday 22 April 2011

How To Record An Excel Macro - Video Tutorial

Title:
How To Record An Excel Macro - Video Tutorial


Video:


Description:SpreadSheetSuperStar.com - Do you want to record your first Excel Macro? Confused about Excel VBA? Watch this Excel macro tutorial to get started - I show you how to record your first macro and what is possible with Excel. Want More Information - Check out the extended video here: spreadsheetsuperstar.com

Published:
23/Apr/2011

Thursday 21 April 2011

How to make barcode in CorelDRAW x3 simple HD.wmv

Title:
How to make barcode in CorelDRAW x3 simple HD.wmv


Video:


Description:Choase HD to watch in the best quality

Published:
21/Apr/2011

How To Modify Macros In Excel

Title:
How To Modify Macros In Excel


Video:


Description:Have you ever wanted to get good at microsoft excel. Well look no further than this advice video on How To Modify Macros In Excel. Follow Videojug's professional experts as they direct you through this guide.

Published:
21/Apr/2011

Wednesday 20 April 2011

Cómo crear CONSULTAS con Excel 2010 - SIN MACROS

Title:
Cómo crear CONSULTAS con Excel 2010 - SIN MACROS


Video:


Description:Si usted encuentra limitaciones utilizando BUSCARV o CONSULTAV, este seminario le llevará mucho más allá de la Certificación al mostrarle cómo crear Consultas rápidamente y sin necesidad de utilizar Macros. Participe en nuestros exclusivos Seminarios ONLINE. Mayores informes: pms.seminarios@gmail.com informes@thepms.info www.thepms.info 988336400 7214216

Published:
20/Apr/2011

Programa para Rifas, sorteos, tómbolas o concursos - Fruit Machine

Title:
Programa para Rifas, sorteos, tómbolas o concursos - Fruit Machine


Video:


Description:Acceso directo al programa: www.asesorjuanmanuel.com

Published:
20/Apr/2011

Tuesday 19 April 2011

Excel VBA MsgBox - Video Tutorial

Title:
Excel VBA MsgBox - Video Tutorial


Video:


Description:SpreadSheetSuperStar.com - Want to show a Excel VBA Msgbox from inside your spreadsheet? In this video I go over the elements of an Excel VBA Msgbox and show you how to write the VBA code to show the msgbox whenever you want. For more information about VBA Msgbox-es please visit: www.spreadsheetsuperstar.com

Published:
20/Apr/2011

001 การตั้ง Excel Option อนุญาตให้ใช้ Macro.avi

Title:
001 การตั้ง Excel Option อนุญาตให้ใช้ Macro.avi


Video:


Description:อธิบายการใช้งาน EPS16YEAR ไฟล์เก็บข้อมูล งบดุล และ ราคาหุ้น บริษัทในตลาดหลักทรัพย์ ผมแจก EPS16YEAR ให้เพื่อนๆเอาไปศึกษาดูข้อมูลหุ้นในตลาดหลักทรัพย์ โดยแจ้งความประสงค์มาได้ที่ kanchit_pai@hotmail.com

Published:
20/Apr/2011

como escribir en pinyin con tonos

Title:
como escribir en pinyin con tonos


Video:


Description:Tutorial sobre como instalar el macro para escribir chino en pinyin con tonos en word. El archivo esta en www.pinyinjoe.com

Published:
20/Apr/2011

Llenar cheques usando formato excel express plantilla creada en excel

Title:
Llenar cheques usando formato excel express plantilla creada en excel


Video:


Description:Descarga gratis en goo.gl ahi puede encontrar un ejemplo listo

Published:
19/Apr/2011

Find duplicates in Excel: search in 1 list or compare 2 tables with Duplicate Remover

Title:
Find duplicates in Excel: search in 1 list or compare 2 tables with Duplicate Remover


Video:


Description:The video shows how to quickly find and remove duplicates in 1 Excel list and in 2 different worksheets. You can watch the original full-size video here: www.ablebits.com This video shows how the Duplicate Remover for Excel add-in can help you quickly find all duplicates in an Excel list or in two tables by comparing one or a few columns. Once the duplicates are found, you can delete, select, color and copy them, or move the values to another location, eg a new workbook or a new / existing worksheet. Find more about Duplicate Remover for Microsoft Excel here: www.ablebits.com

Published:
19/Apr/2011

Sunday 17 April 2011

Visor de Fotos en Excel

Title:
Visor de Fotos en Excel


Video:


Description:Este es un ejemplo de un Visor de Fotos hecho en Excel mediante macros. Al personalizarlo puede ser útil para algún directorio telefónico, registro de estudiantes, etc.

Published:
18/Apr/2011

Macro_1.mp4

Title:
Macro_1.mp4


Video:


Description:Print macro in Excel

Published:
18/Apr/2011

VWG Learning Services: Record a simple Macro in Excel 2007

Title:
VWG Learning Services: Record a simple Macro in Excel 2007


Video:


Description:Always wondered what the hell a 'Macro' is? Well here's your chance to find out!

Published:
18/Apr/2011

duplicar hojas.avi

Title:
duplicar hojas.avi


Video:


Description:Resultado de la ejecución de una macro en Excel que genera unos duplicados de hojas. www.excelforo.blogspot.com

Published:
17/Apr/2011

Saturday 16 April 2011

How to make an XY graph in MS excel 2007

Title:
How to make an XY graph in MS excel 2007


Video:


Description:This tutorial is about how to make an XY graph in Microsoft Excel 2007. I have explained some feature to edit this type of graph too in this video. I hope it would be helpful for you.

Published:
16/Apr/2011

Friday 15 April 2011

Excel 2010 - Create a Stacked Chart

Title:
Excel 2010 - Create a Stacked Chart


Video:


Description:How to create a Stacked Chart using Excel Currently studying for my CPA and hopefully I will be done in May, 2011. If you need assistance regarding MS Excel, feel free to contact me at jiejenn@gmail.com You can download the video files at www.easy-share.com Video Files

Published:
16/Apr/2011

Microsoft Excel en mode projet / VBA: Planning par phases lié à une bibliothèque de formes.

Title:
Microsoft Excel en mode projet / VBA: Planning par phases lié à une bibliothèque de formes.


Video:


Description:Bien avant le lancement d'un projet, et avant d'engager des moyens importants, il est souvent pertinent d'obtenir une pré-analyse des caractéristiques du futur projet. Cette cartographie du périmètre du projet permet d'en éprouver les points faibles, d'améliorations et forts pour obtenir les futures pistes stratégiques du project management. Ces caractéristiques valident aussi si le projet est plutôt viable ou non: Le fameux "Go / No go" du projet. Les formes disponibles dans les logiciels Microsoft Office permettent de façon manuelle de réaliser cet audit. Pour tester en temps réel divers scénarios, une macro VBA liée avec une base de données (BDD) optimise le temps d'audit. Pour personnaliser à loisir son planning prévisionnel par phases, l'utilisateur à une bibliothèque de formes disponible. www.eveillenvol.com Avertissement: La vocation de cette vidéo est de présenter notre savoir-faire et non d'être une forme de didacticiel ou de tutoriel.

Published:
16/Apr/2011

Michael Lerner Sam Botta Atlas Shrugged April 15 Movie Release Oscars

Title:
Michael Lerner Sam Botta Atlas Shrugged April 15 Movie Release OscarsVideo:


Description:ATLAS SHRUGGED Michael Lerner Ayn Rand Scott Brick Audible Amazon The Bachelor when there's genuinely romantic, genuinely sweet (and did we mention genuine?) televised proposals like this? Sam Botta IMDB search Tonya Roberts Charlies Angels, of two years, accountant Jesse Sloan, popped the...

Published:
15/Apr/2011

modeFRONTIER - CATIA direct node

Title:
modeFRONTIER - CATIA direct node


Video:


Description:CATIA (Computer Aided Three Dimensional Interactive Application) is a multi-platform suite created for CAE, CAD and CAM users. The direct integration with modeFRONTIER provides automatic introspection tools and geometric modification functionalities. In this way CATIA users can manage all the technical parameters and use Macro functions in a single optimization environment.

Published:
15/Apr/2011

Thursday 14 April 2011

Excel 2010 Tutorial The Personal Macro Workbook Microsoft Training Lesson 29.3

Title:
Excel 2010 Tutorial The Personal Macro Workbook Microsoft Training Lesson 29.3


Video:


Description:Learn about the personal macro workbook in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2010. Get the complete tutorial FREE at www.teachucomp.com - the most comprehensive Excel tutorial available. Visit us today!

Published:
14/Apr/2011

Excel 2010 Tutorial Running and Deleting Recorded Macros Microsoft Training Lesson 29.2

Title:
Excel 2010 Tutorial Running and Deleting Recorded Macros Microsoft Training Lesson 29.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. 2010. Get the complete tutoria...

Published:
14/Apr/2011

Excel 2010 Tutorial Recording Macros Microsoft Training Lesson 29.1

Title:
Excel 2010 Tutorial Recording Macros Microsoft Training Lesson 29.1


Video:


Description:Learn about recording macros in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2010. Get the complete tutorial FREE at www.teachucomp.com - the most comprehensive Excel tutorial available. Visit us today!

Published:
14/Apr/2011