Monday 29 November 2010

Add or Subtract Years from a Date in Excel

Title:
Add or Subtract Years from a Date in Excel


Video:


Description:Go to www.Teachmsoffice.com to view all of this tutorial. This Excel date and time tutorial shows you how to add or subtract years from a date in Excel. Adding or subtracting years from a date in Excel is a little tricky and requires the use of a number of different functions, but this tutorial goes step by step to show you how to add or subtract years from dates in Excel. This tutorial also covers some date formatting tips.

Published:
30/Nov/2010

Add Multiple Sheets to a Workbook at Once Using VBA

Title:
Add Multiple Sheets to a Workbook at Once Using VBA


Video:


Description:Go to www.Teachmsoffice.com to view all of this tutorial. This Excel VBA macro tutorial shows you how to add multiple worksheets, sheets, tabs, etc. to a workbook using a macro. This method does not use a loop and so is very easy to use and understand. As well, you will learn how to insert the new sheets before or after other sheets within the workbook.

Published:
30/Nov/2010

Add Elements to a Dynamic Array Variable in VBA Using a Loop

Title:
Add Elements to a Dynamic Array Variable in VBA Using a Loop


Video:


Description:Go to www.Teachmsoffice.com to view all of this tutorial. This Excel VBA macro tutorial shows you how to quickly add elements to a dynamic array using a loop. The loop used for this example is a For Next Loop. This tutorial covers how to use variables instead of hard coded values to resize a dynamic array and then to add a new element to the array.

Published:
30/Nov/2010

Add Elements to a Dynamic Array Variable in VBA

Title:
Add Elements to a Dynamic Array Variable in VBA


Video:


Description:Go to www.Teachmsoffice.com to view all of this tutorial. This Excel VBA macro tutorial shows you how to add elements to a dynamic array variable in VBA. This tutorial will also cover how to prevent previous elements in the array from being erased when you add a new element to the array. This is especially important when you need to increase the size of the array in order to add an extra element or multiple new elements to the array, which is also covered in this tutorial.

Published:
30/Nov/2010

Add Bold Italics Underline and Strikethrough to Cells using VBA

Title:
Add Bold Italics Underline and Strikethrough to Cells using VBA


Video:


Description:Go to www.Teachmsoffice.com to view all of this tutorial. This Excel VBA macro tutorial shows you how to add formatting to cells in a worksheet in Excel, specifically, you'll learn how to add bold, italics, single underline, double underline, accounting underline, and strikethrough to the contents of cells.

Published:
30/Nov/2010

Add an Entry on a New Line with a UserForm in Excel

Title:
Add an Entry on a New Line with a UserForm in Excel


Video:


Description:Go to www.Teachmsoffice.com to view all of this tutorial. This Excel VBA UserForm tutorial shows you how to add data from an Excel UserForm onto the next blank row or line in a worksheet. This allows you to use Excel as a sort of database for information. This tutorial covers how to setup the UserForm, how to add VBA code to the UserForm, and what VBA code to use to ensure that data from the form will always be input into the next blank row within the desired worksheet. This tutorial covers the VBA code needed for this functionality step-by-step. There is also a thorough review of how to change the VBA code in this tutorial to fit your own UserForm so that you won't have to start from scratch. This tutorial provides a comprehensive explanation of how to add data from a UserForm to the next blank row within a worksheet in Excel.

Published:
30/Nov/2010

Sunday 28 November 2010

Macro Scheduler for Non-Technical Beginners

Title:
Macro Scheduler for Non-Technical Beginners


Video:


Description:Watch in 720p or 1080p for best clarity. The amazing and versatile automation tool lets you program without knowing a programming language. For those who may be intimidated at first glance, here's tutorial on getting started writing scripts. It's a little easier, though I make no claim that it's better, than the tutorials at www.mjtnet.com

Published:
29/Nov/2010

Word y Excel 2010: Insertar imágenes desde escáner

Title:
Word y Excel 2010: Insertar imágenes desde escáner


Video:


Description:Insertar imágenes desde escáner o cámara en Word 2010 mediante una macro y colocar un botón que ejecute dicha macro en la barra de acceso rápido. En Excel 2010 insertar una macro o módulo con la instrucción: Sub Imagen() On Error Resume Next Application.CommandBars.FindControl(ID:=1764).Execute End Sub Artículo en el blog (con el código de la macro): palelmvp.wordpress.com Blog: palelmvp.wordpress.com Facebook: www.facebook.com

Published:
29/Nov/2010

Saturday 27 November 2010

Alida Macros

Title:
Alida Macros


Video:


Description:Sistema Integral para el comerciante, el pequeño empresario y el profesional independiente, basado en las operaciones de toda actividad comercial y operacional, desarrollado en una Macro de Microsoft Excel 2007, integrando en un mismo archivo el ejecutable y la base de datos. Mas que un sistema, tiene como valor agregado el aprender un método para visualizar y definir las operaciones de su día a día en todas las actividades comerciales, logrando obtener los resultados en términos de logros, compromisos, financiamientos, estadísticas, lo que le permitirá obtener la imagen de cual ha sido su rendimiento, y así desarrollar su visión de nuevas metas y estrategias ha alcanzar.

Published:
27/Nov/2010

Thursday 25 November 2010

Excel 2007 Advanced Filter Runs Very Slowly

Title:
Excel 2007 Advanced Filter Runs Very Slowly


Video:


Description:www.contextures.com An Excel Advanced Filter is a speedy way to extract data from a table, or filter a list by several criteria. However, you might run into a problem in Excel 2007, when an advanced filter runs very slowly. It almost looks like Excel is copying and pasting each row of data separately, and you can imagine how long that would take! In a file where this problem occurs, this Excel video tutorial shows how to solve the problem, by removing worksheet comments. Fortunately, this problem appears to be fixed in Excel 2010.

Published:
26/Nov/2010

Excel 2010 - Makroerstellung Teil 1

Title:
Excel 2010 - Makroerstellung Teil 1


Video:


Description:Makros werden in einfachen Fällen eingesetzt, um immer wiederkehrende, gleichartige Abläufe in einer Excel-Arbeitsmappe zu automatisieren. Im Video wird ein Makro produziert, welches die automatische Einstellung von optimaler Spalten- und Seitenbreite vornimmt. Die herunter ladbare Excel-Arbeitsmappe mit dem Makro zum Fallbeispiel enthält Produkte bzw. Dienstleistungen welche vom Auftraggeber dieses Videos bereitgestellt wurden: wer-weiss-was.net Dieses Video und die zugehörige Arbeitsmappe sind nicht nur für Excel-Nutzer gedacht, welche sich mit der Makroerstellung beschäftigen möchten. Das Video ist auch Anschauungsmaterial für die Öffentlichkeitsarbeit und das Branding von Unternehmen im Zusammenhang mit Bildungs- und Weiterbildungsangeboten. In jedem YouTube-Video kann ein Vorspann gezeigt werden in dem zahlende Förderer genannt werden. Ein passendes Wasserzeichen wird während des ganzen Videos gezeigt und zusätzlich können bei derartigen Trainingsvideos auch die Daten des Auftraggebers verwendet werden, damit sich die Nutzer die Produkte und Dienstleistungen einprägen. Wenn die Daten zu Produkten in Handlungen einbezogen werden, ist die spätere Erinnerung nachhaltiger als bei herkömmlicher Werbung. Ausführliche Informationen steht bei: eduthek.com

Published:
25/Nov/2010

Wednesday 24 November 2010

Curso de Dreamweaver CS5. 21.1. Cear un juego de registros.

Title:
Curso de Dreamweaver CS5. 21.1. Cear un juego de registros.


Video:


Description:Curso de Adobe Dreamweaver CS5. 21.1. Cear un juego de registros.

Published:
24/Nov/2010

Tuesday 23 November 2010

Excel macro

Title:
Excel macro


Video:


Description:Excel macro.

Published:
24/Nov/2010

Monday 22 November 2010

Simplexcel - BuscarV - Seleccionar datos a mostrar en una busqueda

Title:
Simplexcel - BuscarV - Seleccionar datos a mostrar en una busqueda


Video:


Description:Tutorial para realizar una búsqueda según criterio y mostrar los datos que se requieran

Published:
22/Nov/2010

Excel: Excel Macro: create an auto-run macro

Title:
Excel: Excel Macro: create an auto-run macro


Video:


Description:1. an auto-run marcro will run when workbook is open 2. simple auto-run macro: sending a message to screen 3. then call any form or sub program to run.

Published:
22/Nov/2010

VBA & Macros 2010 - Chart Location: Podcast #1291

Title:
VBA and Macros 2010 - Chart Location: Podcast #1291


Video:


Description:In Episode #1291, Bill looks at manipulating Charts with Excel VBA. Its easy to control the exact location of your Chart by designating its placement on your worksheet. ...a podcast from Ch.11 -"VBA And Macros: Microsoft Excel 2010", from Bill Jelen.

Published:
22/Nov/2010

Sunday 21 November 2010

Tutorial Excel - Juego de Logica - Funcion SI - Aleatorio - Macros

Title:
Tutorial Excel - Juego de Logica - Funcion SI - Aleatorio - Macros


Video:


Description:Juego de logica utilizando la funcion si, aleatorio.entre y una macro. Descarga el Archivo: www.asesorjuanmanuel.com sitio: www.asesorjuanmanuel.com facebook www.facebook.com twitter: www.twitter.com www.facebook.com Dale me gusta, +1 , compártelo... el conocimiento es de todos. únete a mi red de amigos, contactame por facebook!

Published:
22/Nov/2010

Como hacer Macros (en excel)

Title:
Como hacer Macros (en excel)


Video:


Description:El primer tutorial que he hecho (perdon si esta mal explicado) y tambien aprendi a usar el camtasia studio (es la primera vez que lo uso) bueno gracias por ver el video

Published:
22/Nov/2010

Tutorial selbstsortierende Excel Tabellen

Title:
Tutorial selbstsortierende Excel Tabellen


Video:


Description:Tutorial zum Erstellen von selbstsortierenden Tabellen in Excel. Verwendet werden nur Excel Befehle und keine Makros. siehe: spreadsheets.google.com

Published:
22/Nov/2010

VBA - Visual Basic for Applications The Video Tutorials - OTO2_BCK

Title:
VBA - Visual Basic for Applications The Video Tutorials - OTO2_BCK


Video:


Description:www.thevideotutorials.com The presentation of the basic edition of the VBA - Visual Basic for Applications Video Course. Many people have been told that to automate Microsoft Office Applications (eg Excel, Word and Access) is very difficult! They lied to them! Just give me a few hours and you will fully dominate Visual Basic for Applications even if you do not know anything about software and programming and you will create your powerful tool to automate your work and let your machine working while you take a coffee! For a long time everyone in a company or in any office or department was working frustrated creating his/her own Excel reports, complex Word documents or elaborate Access databases spending a lot of precious time learning the Microsoft Office Applications and trying to find the best way to be independent from busy IT departments, which always promise to come to them as soon as possible and maybe they never appear. They spent a lot of their time trying to understand complex user manuals or online tutorials. But they did not know that they can automate their work if they can make another tool doing this for them. They do not know that there is a tool, Visual Basic for Applications, that can easily help them to do their work for them. But they think it is hard to understand Visual Basic, because the word itself remind them the name of a programming language. In my experience I saw many colleagues that at the beginning spent their time to prepare documents rather ...

Published:
21/Nov/2010

Saturday 20 November 2010

Problems With Excel Copy and Paste Multiple Selections

Title:
Problems With Excel Copy and Paste Multiple Selections


Video:


Description:www.contextures.com In Excel, you can run into problems when you copy multiple ranges and try to paste them to a new location. If you select ranges that aren't the same size, and try to copy them, you'll see an error "That command cannot be used on multiple selections" Another problem is that values are pasted, instead of formulas, when you paste multiple ranges. See the steps for copying and pasting multiple selections in this short Excel video tutorial.

Published:
21/Nov/2010

Friday 19 November 2010

Excel Plantilla para control de Pagos Nomina, Proveedores y Otros

Title:
Excel Plantilla para control de Pagos Nomina, Proveedores y Otros


Video:


Description:QuieroTrabajarEnCasa.info Espero con mis aportes contribuir para que todas las personas amantes de las herramientas de Office optimicen sus concimientos. Te interesan los negocios por Internet?, te invito a que visites AHORA MISMO mi sitio web y descargues un Reporte gratis. http

Published:
20/Nov/2010

Thursday 18 November 2010

Tutorial pagina.flv

Title:
Tutorial pagina.flv


Video:


Description:Macros, filtros avanzados e informe en excel

Published:
19/Nov/2010

Set Up Criteria Headings for Excel Advanced Filter

Title:
Set Up Criteria Headings for Excel Advanced Filter


Video:


Description:www.contextures.com Use an Excel Advanced Filter to copy data from an Excel table to a new location. Set up an advanced filter criteria range, with headings that exactly match one or more of the headings in the original table. Then, enter one or more criteria in the row below the criteria range headings. However, if you're using a formula in the criteria row, either clear the criteria range heading, or use a heading that is different than any heading in the original table. See the steps in this short Excel video tutorial.

Published:
19/Nov/2010

Monday 15 November 2010

Peculiaridades da Função BdExtrair - Excel

Title:
Peculiaridades da Função BdExtrair - Excel


Video:


Description:Veja neste vídeo algumas considerações importantes para uso da Função BDEXTRAIR no Excel. Para compra de Matérias Completas acesse o Site WWW.LUCIOREZENA.COM.BR

Published:
16/Nov/2010

SkillCaddy.com - Creating Excel Macros

Title:
SkillCaddy.com - Creating Excel Macros


Video:


Description:How to create and use Excel Macros, part of the Microsoft Office suite, tons of other free software training videos at SkillCaddy.com

Published:
15/Nov/2010

Saturday 13 November 2010

Loop Down Rows and Move rows to another sheet in Excel using VBA- Download Files at ExcelVBASql.com!

Title:
Loop Down Rows and Move rows to another sheet in Excel using VBA- Download Files at ExcelVBASql.com!


Video:


Description:Visit ExcelVBASql.com to download the working macro.

Published:
14/Nov/2010

macro de lista desplegable.wmv

Title:
macro de lista desplegable.wmv


Video:


Description:Accionar una macro a partir de una lista desplegable

Published:
13/Nov/2010

Friday 12 November 2010

INTE 4402 Macros in Microsoft Excel 2007

Title:
INTE 4402 Macros in Microsoft Excel 2007


Video:


Description:this is a tutorial in how to create and use macros in Microsoft Excel 2007 to sort first name and auto fit columns

Published:
13/Nov/2010

Downloading Stock Quotes from Yahoo directly to Excel

Title:
Downloading Stock Quotes from Yahoo directly to Excel


Video:


Description:The post on the blog has the code to be pasted into excel to make the macro

Published:
12/Nov/2010

Excel Macros -014- Multiple Files

Title:
Excel Macros -014- Multiple Files


Video:


Description:Lesson Summary: Multiple Files. This video shows you how to open, save and close files using macros. It uses the file dialog command and shows you how to change other open workbooks. Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
12/Nov/2010

Excel Macros -013- More Visual Basic Forms

Title:
Excel Macros -013- More Visual Basic Forms


Video:


Description:Lesson Summary: VBA Forms 2. This video teaches you how to create more advanced forms in Visual Basic. It covers row sources, checkboxes, option buttons, combo-boxes, and tab indices. Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
12/Nov/2010

Excel Macros -012- An Introduction to VBA Forms

Title:
Excel Macros -012- An Introduction to VBA Forms


Video:


Description:Lesson Summary: VBA Forms 1. This video teaches you how to create a form in Visual Basic and use it to enhance the user interface. This may stop a user having to input data directly into your spreadsheet. Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
12/Nov/2010

Excel Macros -011- Protecting Macros and Spreadsheets

Title:
Excel Macros -011- Protecting Macros and Spreadsheets


Video:


Description:Lesson Summary: Protecting Macros and Spreadsheets. This video teaches you how to prevent users from breaking your macros, be it in Excel or in Visual Basic. Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
12/Nov/2010

Thursday 11 November 2010

MerusCase Tutorial: How to enable macros in MS Word 2007 for QuickSave

Title:
MerusCase Tutorial: How to enable macros in MS Word 2007 for QuickSave


Video:


Description:Enable Word to accept macro-embedded documents 1. In Word click the Microsoft Office Button, then click Word Options. 2. Click Trust Center andgt; Trust Center Settings andgt; Macro Settings. 3. Click the radio button Enable all macros. 4. Click OK, twice.

Published:
12/Nov/2010

Access Tabla Cliente y Factura Relacion Cuadro combinado AINTE

Title:
Access Tabla Cliente y Factura Relacion Cuadro combinado AINTE


Video:


Description:Access Tabla Cliente y Factura Relacion Cuadro combinado AINTE

Published:
11/Nov/2010

Wednesday 10 November 2010

excel tutorial

Title:
excel tutorial


Video:


Description:

Published:
11/Nov/2010

Excel Macros -010- VBA Text Functions

Title:
Excel Macros -010- VBA Text Functions


Video:


Description:Lesson Summary: VBA Text Functions. This video teaches you how to analyze and manipulate text strings using Visual Basic. Includes Left, Right, InStr, Mid, Trim and UCase functions Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
10/Nov/2010

Excel Macros -009- Excel Formulas with VBA

Title:
Excel Macros -009- Excel Formulas with VBA


Video:


Description:Lesson Summary: Macros and Formulas. It is often desirable to let Visual Basic handle certain functions whilst standard Excel formulas perform calculations. This macros shows you how to combine the two techniques. Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
10/Nov/2010

Excel Macros -008- Recording Macros

Title:
Excel Macros -008- Recording Macros


Video:


Description:Lesson Summary: Recording Macros. This video shows you how to record new macros to learn new code. It demonstrates how to interpret recorded code, so you can adapt it for your own purposes Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
10/Nov/2010

Excel Macros -007- Accessible Coding

Title:
Excel Macros -007- Accessible Coding


Video:


Description:Lesson Summary: Accessible Coding. This video shows you how to comment out code and define variables using the Dim command. This will help others add to and understand your code. It illustrates the points using a Worksheet Change macro Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
10/Nov/2010

Tuesday 9 November 2010

Excel Macros -006- Analyzing Macros and Identifying Errors

Title:
Excel Macros -006- Analyzing Macros and Identifying Errors


Video:


Description:Lesson Summary: Identifying Errors. This video shows you find errors by stepping through macros and using break points. It also provides an introduction to error handling Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
09/Nov/2010

Excel Macros -005- Using Ranges, Rows and Columns

Title:
Excel Macros -005- Using Ranges, Rows and Columns


Video:


Description:Lesson Summary: Definitions. This video shows you how to define sheets, ranges, rows and columns using Excel Visual Basic. It also covers advanced ELSEIF statements Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
09/Nov/2010

Excel 2010 - Função ORDEM

Title:
Excel 2010 - Função ORDEM


Video:


Description:Mais tutoriais em: tutorial-excel.net www.vascomarques.net Insira a função ORDEM, na coluna classificação, para classificar os ciclistas por ordem ascendente Ordene agora a tebela, ascendentemente, em função da coluna da classificação. Usar função CONTAR.VAL para contar o número de ciclistas Inserir gráfico de colunas com nome e tempos dos ciclistas. Os nomes dos ciclistas devem de ficar por baixo da coluna, o tempo no topo da coluna. Retire o fundo e as linhas da gráfico.

Published:
09/Nov/2010

Monday 8 November 2010

What's New: Visual Basic Macros

Title:
What's New: Visual Basic Macros


Video:


Description:Office for Mac 2011: An overview of using Visual Basic to record, edit, and play a macro.

Published:
09/Nov/2010

Excel Macros -004- Loops and Conditions

Title:
Excel Macros -004- Loops and Conditions


Video:


Description:Lesson Summary: Loops and Conditions. This macro shows you how to repeat calculations and manipulations using loops. It also provides an introduction to the IF statement. Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
08/Nov/2010

Excel Macros -003- Different Types of Macro

Title:
Excel Macros -003- Different Types of Macro


Video:


Description:Lesson Summary: Different Types of Macro. This module teaches you how to start Visual Basic macros automatically using buttons or events, such as worksheet changes Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
08/Nov/2010

Excel Macros -002- Basic Macro Maths

Title:
Excel Macros -002- Basic Macro Maths


Video:


Description:Lesson Summary: Basic Macro Maths. This module teaches you how to replace complicated Excel formulas with more meaningful Visual Basic code Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
08/Nov/2010

Dueling Excel - Approximate Multi-Lookup: #1283

Title:
Dueling Excel - Approximate Multi-Lookup: #1283


Video:


Description:In today's Dueling Excel Podcast [Episode #1283] Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen look at a data set and then attempt to find all of the records that contain the word "Car". Using Excel VBA [Macro] and Formula methods, Mike and Bill produce the desired results - see how they do it in Episode #1283!

Published:
08/Nov/2010

Excel Macros -001- An Introduction to Macros

Title:
Excel Macros -001- An Introduction to Macros


Video:


Description:Lesson Summary: An introduction to macros. This module teaches you how to access the Visual Basic Editor and write a simple sub routine Visit www.excel4business.com for additional information on this video. The "Excel Macros" series of training videos has been created by Excel4Business' expert consultants.

Published:
08/Nov/2010