Friday 14 December 2007

Introduction to Writing Excel Macros (VBA)

Title:
Introduction to Writing Excel Macros (VBA)


Video:


Description:This video introduces the creation of macros in Excel using VBA. The intro is oriented towards engineers and is part of a course I teach in an online Masters program. The program is described at mepp.engr.wisc.edu and high res versions of this and other videos is available at http There is also a demonstration video on the same topic at the same site.

Published:
15/Dec/2007

Sunday 25 November 2007

Tutorial - Truco: Excel / OpenOffice

Title:
Tutorial - Truco: Excel / OpenOffice


Video:


Description:Pequeño tutorial/truco para excel y open office donde usando la función "repetir" se obtiene una barra indicando el valor de una celda asociada.

Published:
26/Nov/2007

Wednesday 31 October 2007

Video tutorial Calculadora en visual basic

Title:
Video tutorial Calculadora en visual basic


Video:


Description:Un básico video tutorial de como hace runa calculadora en vb. Para descargar visual studio 6.0: www.megaupload.com

Published:
01/Nov/2007

Tuesday 30 October 2007

Gruss Betting Assistant VBA

Title:
Gruss Betting Assistant VBA


Video:


Description:www.betting-school.com A video showing how to program macros in VBA for the Gruss Betting Assistant, learn how to automate your betting. The Betting School Insiders Club is dedicated to helping you win with your betting.

Published:
30/Oct/2007

Wednesday 24 October 2007

Filtros avanzados en Excel 2007

Title:
Filtros avanzados en Excel 2007


Video:


Description:Se describe cómo extraer registros de tablas grandes usando filtros avanzados

Published:
24/Oct/2007

Tablas dinámicas en Excel 2007

Title:
Tablas dinámicas en Excel 2007Video:


Description:Se describe cómo construir tablas dinámicas resumiendo hasta tres campos

Published:
24/Oct/2007

Monday 3 September 2007

Sincronizar Planilha OO

Title:
Sincronizar Planilha OOVideo:


Description:Vídeo para auxílio em sincronização de planilhas no BrOffice

Published:
04/Sep/2007

Sunday 2 September 2007

Macros para produtividade

Title:
Macros para produtividade


Video:


Description:Um video demonstrando como trabalhar de forma mais produtiva usando macros. Se você não sabe o que é macro (ou record). Mostrarei como se tornar apto desta funcionalidade disponibilizada por muitos programas pode ajudar o programador no seu dia-a-dia. Neste video-tutorial, demonstrarei no programa EditPlus, que eu estou mais acostumado, mas outros programas também possuem esta propriedade/ferramenta, como o PSpad.

Published:
03/Sep/2007

Monday 13 August 2007

Excel - Planilha Dinâmica

Title:
Excel - Planilha Dinâmica


Video:


Description:Como descobrir em uma base de dados desorganizada, dados importantes para tomada de decisão.

Published:
14/Aug/2007

Microsoft Excel #02: Create a Seating Chart

Title:
Microsoft Excel #02: Create a Seating ChartVideo:


Description:Creating charts and diagrams may not be the first thing you think of when you use Excel, but I use it all the time. In this example I use Excel to create a seating chart for my computer lab.

Published:
13/Aug/2007

Sunday 12 August 2007

Visual Basic Simple Animation

Title:
Visual Basic Simple AnimationVideo:


Description:Animation in visual basic with timers watch and have fun !

Published:
12/Aug/2007

Tuesday 7 August 2007

Macro excel vba calculo automatico MRP

Title:
Macro excel vba calculo automatico MRP


Video:


Description:macro vba en Excel para el cálculo automático del MRP, explosión de la lista de materiales y necesidades de compra, excelente macro para realizar la gestión y planificación de la empresa.Puedes descargarlo en www.webandmacros.com

Published:
08/Aug/2007

Excel Tutorial - Create a Dynamic ComboBox Filter

Title:
Excel Tutorial - Create a Dynamic ComboBox Filter


Video:


Description:Small little tutorial on how to create those ever difficult dynamic comboboxes. Sorry for the quality. It takes like 5 minutes to make and im at work so I don't have complete attention to it.

Published:
08/Aug/2007

Sunday 5 August 2007

Excel - Using a combobox Tutorial- Cell Link

Title:
Excel - Using a combobox Tutorial- Cell Link


Video:


Description:Just bored at work, threw a little tutorial on how to create a combobox and have it linked to a cell.

Published:
06/Aug/2007

Friday 27 July 2007

Radio Buttons

Title:
Radio ButtonsVideo:


Description:www.hawkeducation.com Excel Radio Buttons

Published:
28/Jul/2007

Thursday 12 July 2007

Recording Macros - Excel 2003

Title:
Recording Macros - Excel 2003


Video:


Description:How to record a macro in Excel 2003. How to add a button to worksheet to run macro.

Published:
12/Jul/2007

Tuesday 19 June 2007

Wall St. Training: 19.0 Advanced Excel for Data Analysis

Title:
Wall St. Training: 19.0 Advanced Excel for Data Analysis


Video:


Description:This course focuses on how to effectively and efficiently utilize Microsoft Excel for data analysis. A financial analyst will not only use Excel to build financial models, but also to crunch a large data dump. Learn how to minimize as much manual labor as possible, thereby saving time and performing more detailed analysis quickly. Apply commonly-used formulas in new and different ways; uncover often over-looked Excel formulas; streamline number crunching and analysis via functions and tools including pivot tables, sumif, sum+if, transpose, working with arrays, vlook-up, subtotals, and regression analysis; enhance your spreadsheets with drop-down boxes, data validation techniques, automation of alternate row shading; take Excel to the next level with an introduction to building and automating simple macros and more! ***YOUTUBE VISITORS ONLY*** 10% off any online course, use Discount code: youtube www.wstselfstudy.com

Published:
20/Jun/2007

Thursday 14 June 2007

Making a Gantt Chart in Excel 2007

Title:
Making a Gantt Chart in Excel 2007Video:


Description:Using Excel 2007 to create a Gantt chart--a popular project management tool

Published:
15/Jun/2007

Sunday 10 June 2007

Excel 2007 Demo - Create charts

Title:
Excel 2007 Demo - Create charts


Video:


Description:See more Excel 2007 demos at office.microsoft.com In Office Excel 2007, you just select data in your worksheet, choose a chart type that best suits your purpose, and click. Want to try a different chart type? Just click again and select a new chart type from a huge range of possibilities. Then work with the new Chart Tools to customize the design, layout, and formatting of your chart. You can see how various options would look just by pointing at them.

Published:
11/Jun/2007

Tuesday 15 May 2007

Excel Gantt Macro vba - Planificación de Proyectos

Title:
Excel Gantt Macro vba - Planificación de Proyectos


Video:


Description:macro vba Excel Gantt creación del diagrama o gráfico de gantt para cualquier tipo de proyecto, creación automática del informe de avance o retraso del proyecto y de las actividades que lo engloba.Puedes descargarlo en www.webandmacros.com

Published:
16/May/2007

Saturday 12 May 2007

Example macro vba in excel - automatic report.

Title:
Example macro vba in excel - automatic report.


Video:


Description:Example of Excel macro, consists of the automatization of a report, once executed the macro the excel sheet creates a specific format, elimination of repetitive tasks, increase effectiveness and efficiency in your work.You can download in www.webandmacros.net

Published:
12/May/2007

Ejemplo Macro Excel Vba - Automatizar Informes

Title:
Ejemplo Macro Excel Vba - Automatizar Informes


Video:


Description:Ejemplo funcionamiento de macro Excel vba, consiste en la automatización de un informe, una vez ejecutada la macro la hoja excel crea un formato específico, eliminación de tareas repetitivas, aumento de eficacia y eficiencia en el trabajo.Puedes descargarlo en www.webandmacros.com

Published:
12/May/2007

Friday 11 May 2007

Hack Excel VBA Password

Title:
Hack Excel VBA Password


Video:


Description:This video will help you overcome Excels' security features. Check back often for additional information. This video is a using one of the many available password recovery tools (and a shareware screen recorder) both of which cost money to use without restrictions. Please see my other videos for completely free methods of recovering Excel Passwords or click on the appropriate link at the beginning of the video.

Published:
12/May/2007

Monday 19 March 2007

Excel assign a macro

Title:
Excel assign a macro


Video:


Description:Steps to assign a macro in excel from www.streamboat.com

Published:
19/Mar/2007

Friday 23 February 2007

Excel Spread Sheet Basics - Using a Formula

Title:
Excel Spread Sheet Basics - Using a Formula


Video:


Description:CHECK BELOW!!!! How to set up a very basic spread sheet. If you're really new to Excel, you might want to check out my REALLY BASIC video before this one, it has some valuable concepts that will help. www.youtube.com

Published:
24/Feb/2007