Thursday 30 April 2009

3G4GTraining - Excel macros for GoogleEarth

Title:
3G4GTraining - Excel macros for GoogleEarth


Video:


Description:Part of the tutorial package is this couple of macros, made for helping Telecom engineers when planning or optimizing the network.

Published:
30/Apr/2009

Wednesday 29 April 2009

Excel VBA Permutation Macro Code

Title:
Excel VBA Permutation Macro Code


Video:


Description:excelvisualbasics.com How ExcelVisualBasics.Com Is Different In our Excel tutorials, you will find videos that accompany the visual basic macro script. These brief videos will give you an idea of what the code on the page does visually. We feel the problem with most Excel websites is that they assume everyone knows Excel visual basic script. For the complete beginner, vb script looks like an alien language. That is why we aim to not only provide you with useful visual basic scripts, but to also show you what the script actually does and how to use it so you don't waste your time trying to figure it out.

Published:
30/Apr/2009

Tuesday 28 April 2009

video aula excel 2007 tabela e formulas. Aula 02

Title:
video aula excel 2007 tabela e formulas. Aula 02


Video:


Description:Acesse www.rogerinhofreitas.com.br e veja mais video-aulas na parte de Excel Para evitar conflito de informação o título deste vídeo foi alterado. Por Rogérinho Freitas

Published:
29/Apr/2009

video aula excel 2007 funcoes básicas. Aula 01

Title:
video aula excel 2007 funcoes básicas. Aula 01Video:


Description:Acesse www.rogerinhofreitas.com.br e veja mais video-aulas na parte de Excel Por Rogérinho Freitas

Published:
29/Apr/2009

Using Macros in Excel

Title:
Using Macros in Excel


Video:


Description:This video will teach you how to create macros in Microsoft Excel. Macros are recordings of your mouse movements and clicks that reproduce your work automatically. Recording a macro can help streamline Excel processes that are repetitive or tedious. Creating a macro is easy with Microsoft Office Excel 2007. Format a data sheet automatically or arrange data with one mouse click.

Published:
29/Apr/2009

Saturday 25 April 2009

Macro di Excel con VBA - Lezione 3

Title:
Macro di Excel con VBA - Lezione 3


Video:


Description:Macro di Excel con VBA - Lezione 3

Published:
25/Apr/2009

Wednesday 22 April 2009

VBA Lesson 11 - Populate an array with no duplicates - ExcelVbaSql.com 20+ hours of FREE training!

Title:
VBA Lesson 11 - Populate an array with no duplicates - ExcelVbaSql.com 20+ hours of FREE training!


Video:


Description:www.ExcelVBASql.com Populate an array with no duplicates.

Published:
23/Apr/2009

Basic WordPerfect Macro

Title:
Basic WordPerfect MacroVideo:


Description:How to easily undertsand and create your own time saving macros using WordPerfect.

Published:
23/Apr/2009

Monday 20 April 2009

Jitbit Macro Recorder Tutorial

Title:
Jitbit Macro Recorder Tutorial


Video:


Description:un tutorial para aprender a usar basicamente el Jitbit Macro Recorder

Published:
21/Apr/2009

Sunday 19 April 2009

Using The Office Button - Free Excel training

Title:
Using The Office Button - Free Excel training


Video:


Description:www.macresource.co.uk TUsing The Office Button - a Free Excel tutorial. by Macresource Computer Training, an independent computer training company offering tutor-led courses in London on Adobe Creative Suite Acrobat, Dreamweaver, Flash, Illustrator, InDesign and Photoshop; Microsoft Office: Access, Excel, Outlook, PowerPoint, Project, VBA, Visio and Word; as well as web design and development: ASP.Net, CSS, HTML, JavaScript, PHP/MySQL and XML. Visit our website for discounts and special offers on public training courses.

Published:
20/Apr/2009

Saturday 18 April 2009

VBA Lesson 5 - 1 Dimensional Dynamic Array - ExcelVBASql.com 25+ hours of FREE training!

Title:
VBA Lesson 5 - 1 Dimensional Dynamic Array - ExcelVBASql.com 25+ hours of FREE training!


Video:


Description:www.ExcelVBASql.com This video shows how to fill a 1 dimensional dynamic array (ie you don't know the size) and then return the values from the array.

Published:
18/Apr/2009

Friday 17 April 2009

Gráfica de Gantt / Excel 2007

Title:
Gráfica de Gantt / Excel 2007


Video:


Description:Esta es una demostración simple de la gráfica de Gantt (gráfica de tiempos y movimientos) realizada en Excel 2007.

Published:
18/Apr/2009

Thursday 16 April 2009

VIDEOEXCEL - TABLAS DINAMICAS EN EXCEL 2003 - http://clubinformaticatotal.blogspot.com

Title:
VIDEOEXCEL - TABLAS DINAMICAS EN EXCEL 2003 - http://clubinformaticatotal.blogspot.com


Video:


Description:Video explicación de como crear una tabla dinámica en excel 2003 clubinformaticatotal.com

Published:
17/Apr/2009

Tuesday 14 April 2009

MrExcel's Learn Excel #594 - Run Macro Button

Title:
MrExcel's Learn Excel #594 - Run Macro Button


Video:


Description:Youve created a simple macro and want to assign the macro to a button on a worksheet. In todays question, someone is trying to assign a macro to a button, but it is not working. She can assign the macro to a text box and it works, but not with a button. Episode 594 shows how to assign a macro to a text box, an AutoShape, or a button on the Forms toolbar. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Published:
14/Apr/2009

Monday 13 April 2009

Highline Excel Class 19: Advanced Filter Extract Data 9 Examples

Title:
Highline Excel Class 19: Advanced Filter Extract Data 9 Examples


Video:


Description:Learn about using Advanced Filter to extract data from an Excel List / Table / Database. See these 7 Advanced Filter examples: 1. Extract data with 1 criteria 2. See how Criteria and Extract areas get Named 3. Extract data with 2 or more AND criteria 4. Extract data with 2 or more OR criteria 5. Extract Unique Records 6. Extract data To Different Worksheet 7. Extract data To Different Workbook 8. Add column with True False Formula 9. Extract data with formula criteria This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Published:
14/Apr/2009

Sunday 12 April 2009

Excel VBA 2007 Setup

Title:
Excel VBA 2007 Setup


Video:


Description:How to setup Excel 2007 to use VBA Macros

Published:
12/Apr/2009

VBA Lesson 3 - Deleting blank rows - ExcelVBASql.com 25+ hours of FREE training!

Title:
VBA Lesson 3 - Deleting blank rows - ExcelVBASql.com 25+ hours of FREE training!


Video:


Description:www.ExcelVBASql.com This macro uses a loop to delete blank rows.

Published:
12/Apr/2009

VBA Lesson 1 - Intro to VBA Macros - ExcelVBASql.com 31+ hours of FREE Videos!

Title:
VBA Lesson 1 - Intro to VBA Macros - ExcelVBASql.com 31+ hours of FREE Videos!


Video:


Description:www.ExcelVBASql.com This video explains what a macro is, how to access macros, the VBA environment, subs, and debugging using step into and breakpoints.

Published:
12/Apr/2009

Friday 10 April 2009

Macros En Excel 2007 - Basico

Title:
Macros En Excel 2007 - Basico


Video:


Description:Como hacer macros sencillas en microsoft excel 2007. Apoyanos e ingresa a nuestro blog en solucionescompuclic.blogspot.com

Published:
11/Apr/2009

Tutorial de Macros

Title:
Tutorial de Macros


Video:


Description:En este video les daremos a conocer todo lo referente a microsoft access 2003, con ejemplos y muy bien explicado.

Published:
11/Apr/2009

Thursday 9 April 2009

Convertir número a letras en Excel

Title:
Convertir número a letras en Excel


Video:


Description:

Published:
10/Apr/2009

Wednesday 8 April 2009

Excel 2007 - Validation with Lists (Dropdowns / combo box)

Title:
Excel 2007 - Validation with Lists (Dropdowns / combo box)


Video:


Description:Easy way to add dropdown lists to an Excel file. Useful for validation. Also a good usability feature.

Published:
08/Apr/2009

Tuesday 7 April 2009

Word Tutorial Recording Macros Microsoft Training Lesson 22.1

Title:
Word Tutorial Recording Macros Microsoft Training Lesson 22.1


Video:


Description:Learn how to record a macro in Microsoft Word at www.teachUcomp.com. A clip from Mastering Word Made Easy v. 2007. www.teachucomp.com - the most comprehensive Word tutorial available. Visit us today!

Published:
08/Apr/2009

Monday 6 April 2009

Excel Statistics Tricks - Random Sampling without Replacement

Title:
Excel Statistics Tricks - Random Sampling without Replacement


Video:


Description:Let's say you have a sampling frame and you want to be able to capture one or many random samples without replacement from it. This tutorial will help you in doing this. Credits: Professor Tatum - Baruch College

Published:
06/Apr/2009

Sunday 5 April 2009

Highline Excel Class 13: Text functions & AMPERSAND

Title:
Highline Excel Class 13: Text functions and AMPERSANDVideo:


Description:See how to transform data into useful data using formulas and Text functions such as; TRIM, PROPER, SUBSTITUTE, REPLACE, FIND, and LEFT. See how to use the ampersand and the CONCATENATE function to join data. See how to speed up slow calculating spreadsheets with a concatenated column that joins three criteria and makes conditional (criteria) summing (adding) quicker. See how to: 1) create upper case for the first letter of each word, 2) extract only the last name, 3) extract only the first name, 4) get rid of extra spaces, 5) sum with 3 criteria using the ampersand and the CONCATENATION function. This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Published:
06/Apr/2009

Wednesday 1 April 2009

Hipervinculos en Excel

Title:
Hipervinculos en Excel


Video:


Description:Como poner hipervinculos en Excel.

Published:
01/Apr/2009