Thursday 30 September 2010

Construct A Box Plot on Microsoft Excel 2007

Title:
Construct A Box Plot on Microsoft Excel 2007


Video:


Description:NOTE: THIS METHOD ONLY WORKS WITH DATA THAT IS ALL POSITIVE. For data that is all negative or is mixed, there is a slightly different way. If you need to know how to do that, message me or comment and I will make a video. This is a video I made to help teach people how to construct a box plot (box and whisker) in Microsoft Excel 2007. I hope to add step-by-step instructions to the description of the video soon. A similar and more complex video on how to do this can be found here: www.youtube.com I hope that you find this useful. If you have any questions, send me a message or post a comment and I will get right back to you. I can show you how do do this in OpenOffice Calc as well. If you find this video helpful, please 'like' it. Thanks and good luck! :)

Published:
01/Oct/2010

CONTROL DE ALMACEN Y VALUACION DE EXISTENCIAS EN EXCEL

Title:
CONTROL DE ALMACEN Y VALUACION DE EXISTENCIAS EN EXCELVideo:


Description:Para mayor información www.excelnegocios.com Con este Aplicativo podras facilmente controlar tus existencias, teniendo información actualizada y creando reportes para el mejor analisis; puedes tambien valuar estas existencias usando el metodo promedio. Un aplicativo muy facil y practico de usar. SU PRECIO: S/ 100.00 POR LANZAMIENTO PUEDES CONTACTARME A: excelparacontadores@hotmail.com Celular: 970982933 Rpm: #265789 Atte: Gustavo A. Sebastiani Cépeda ****

Published:
30/Sep/2010

Wednesday 29 September 2010

Access 2003: Adding Buttons to a Form

Title:
Access 2003: Adding Buttons to a Form


Video:


Description:Adding buttons to an Access form can make your work easier and faster, it will also save others who use your database from wondering where a command it. By having the button on the form and correctly labelled they'll know what it does. This will save you getting asked loads of questions. The buttons are easy to add in this video tutorial Gary Schwartz from www.jargonfreehelp.com will show you how.

Published:
29/Sep/2010

Tuesday 28 September 2010

Excel 2010 - A Simple Macro - MacroMountain.com

Title:
Excel 2010 - A Simple Macro - MacroMountain.com


Video:


Description:www.MacroMountain.com This brief tutorial shows how to create a simple macro. The macro displays a message box. Also, this video shows how to assign a macro to an button.

Published:
29/Sep/2010

Excel 2010 - Overview of Visual Basic Editor - MacroMountain.com

Title:
Excel 2010 - Overview of Visual Basic Editor - MacroMountain.com


Video:


Description:www.MacroMountain.com Overview How to Open the VB Editor VB Editor Overview Project Window Properties Window Code Window Insert a User Form Insert a Module Insert Class Modules Module Types Explained How to Open the VB Editor Click the Developer Tab Click the Visual Basic button Project Explorer Window Show the Project Explorer Window Click View Then, Project Explorer Shortcut Ctrl + R The Project Explorer Window shows all of the open workbooks and the components in them, such as: worksheets, user forms, modules, and class modules. Properties Window Show the Properties Window Click View Then, Properties Window Shortcut: F4 The Properties Window will change as different components are selected. For example, select one of the worksheets and the first property will be the name of that worksheet. Code Window Show the Code Window Double-click on one of the objects in the Project Window For example, double-clicking on a worksheet will bring up the code, if any, that is on that worksheet. Insert a User Form Insert a User Form Click Insert Then, click UserForm The new UserForm will be inserted at the bottom of the Project Window. The Code Window will show the UserForm. That is where Form Controls would be inserted, such as: text boxes, radial buttons, check boxes, etc. Insert a Module Insert a Module Click Insert Then, click Module The new Module will be inserted at the bottom of the Project Window The Code Window will be blank and ready for input Insert Class Modules Insert ...

Published:
29/Sep/2010

Monday 27 September 2010

How to Create an Excel Box and Whisker Chart (Excel Box Plot)

Title:
How to Create an Excel Box and Whisker Chart (Excel Box Plot)Video:


Description:blog.contextures.com A box and whisker chart can give you a snapshot of each series in your data. What are the highest and lowest numbers? What was the median number? What was the range of numbers on either side of the median? In this example, I create a box and whisker chart from airport security checkpoint wait time data. It shows which checkpoint has the longest wait times, and which is fastest. To make the job of creating a box plot faster, you can use the box and whisker chart utility. Click the link to my blog article, and read the details about Jon Peltier's box plot utility.

Published:
28/Sep/2010

Sunday 26 September 2010

Excel 2010 Avanzado: 8.2 Actualizar Información con Mapas

Title:
Excel 2010 Avanzado: 8.2 Actualizar Información con Mapas


Video:


Description:tutolandia.com Mejore suDestreza en Excel. VIDEO CURSO EXCEL BASICO Para principiantes que quieren aprender rápidamente el manejo adecuado de Excel VIDEO CURSO EXCEL INTERMEDIO: Le permitirá la cración, administración y protección óptima de bases de datos y aplicaciones personalizadas para implementar en su trabajo, hogar o estudio. VIDEO CURSO EXCEL AVANZADO: le permitirá crear análisis avanzados de dátos, especialmente útil para aquellas personas que toman decisiones en empresas basadas en tendencias históricas y proyecciones económicas. También le permitirá sobresalir con presentaciones sorprendentes y un ahorro en más del 50% en sus tareas cotiadianas en Excel. Actualicese ya a la version de Excel 2010 y sáquele provecho a las nuevas y potentes mejoras de este software tutolandia.com

Published:
27/Sep/2010

Ler arquivo texto com Excel Macro

Title:
Ler arquivo texto com Excel Macro


Video:


Description:Este tutorial do site guiadoexcel.com.br demonstra como gravar uma macro para abrir arquivos texto em colunas de forma automática utilizando macro.

Published:
27/Sep/2010

Excel 2003: VLOOKUP Function

Title:
Excel 2003: VLOOKUP Function


Video:


Description:There is an updated video with missing bit added at www.youtube.com In this video Gary Schwartz from www.jargonfreehelp.com shows you how to use the VLOOKUP function, this useful function allows you to look up values in a table and return a value. For example, you might have a list of marks from an exam using a VLOOKUP you can get it to return a grade or show as a pass or fail. It can also be used to look up text such as a list of goods and return the price of the goods. They are only a couple of ways in which this function can be used.

Published:
26/Sep/2010

Saturday 25 September 2010

Software Video Tutorials - Excel Word Access PowerPoint

Title:
Software Video Tutorials - Excel Word Access PowerPoint


Video:


Description:Gary Schwartz from www.jargonfreehelp.com has created many video tutorials on subjects including Excel, Word, Access, PowerPoint, websites, iPhones and many more. Gary brings the same advice he does when he is training which includes training people for the ECDL tests. If you want to know about creating table in Word or using functions in Excel including getting started with functions, VLOOKUP, IF and other features such as charts, scenarios, macros and goal seek then you'll want to see these videos.

Published:
25/Sep/2010

Friday 24 September 2010

Excel 2010 Basico: 8.3 Encabezado y Pie de Pagina

Title:
Excel 2010 Basico: 8.3 Encabezado y Pie de Pagina


Video:


Description:tutolandia.com Mejore su Destreza en Excel. VIDEO CURSO EXCEL BASICO Para principiantes que quieren aprender rápidamente el manejo adecuado de Excel VIDEO CURSO EXCEL INTERMEDIO: Le permitirá la cración, administración y protección óptima de bases de datos y aplicaciones personalizadas para implementar en su trabajo, hogar o estudio. VIDEO CURSO EXCEL AVANZADO: le permitirá crear análisis avanzados de dátos, especialmente útil para aquellas personas que toman decisiones en empresas basadas en tendencias históricas y proyecciones económicas. También le permitirá sobresalir con presentaciones sorprendentes y un ahorro en más del 50% en sus tareas cotiadianas en Excel. Actualicese ya a la version de Excel 2010 y sáquele provecho a las nuevas y potentes mejoras de este software tutolandia.com

Published:
25/Sep/2010

Thursday 23 September 2010

Why Using Excel Vlookup is Important

Title:
Why Using Excel Vlookup is Important


Video:


Description:Download the free Vlookup tutorial here: www.vlookuptutorial.com. Fun Excel Vlookup Tutorial shows you what this function is and why you must use it. Understand intuitively how to use all the terms/arguments: lookup_value, table_array, col_index_num, range_lookup and get introduced to multiple lookup functions

Published:
24/Sep/2010

Comenzando a realizar macros - Ejemplo excel - Tutorial

Title:
Comenzando a realizar macros - Ejemplo excel - Tutorial


Video:


Description:Este video describe una sencilla macro, que realiza una animación con la función coseno.

Published:
24/Sep/2010

Bloomberg Brief Tutorial 1.MOV

Title:
Bloomberg Brief Tutorial 1.MOV


Video:


Description:Brief tutorial of how to use Bloomberg for the individual project's of the Asset Management Practicum- Part 1

Published:
23/Sep/2010

Wednesday 22 September 2010

Les tableaux croisés dynamiques

Title:
Les tableaux croisés dynamiques


Video:


Description:Découvrez la création d'un tableau croisé dynamique sous Excel 2007 Retrouvez plus d'astuces sur www.excel-plus.fr

Published:
23/Sep/2010

JMP 9 Excel Add-In Basics

Title:
JMP 9 Excel Add-In Basics


Video:


Description:See the JMP 9 Excel Add-In in action. This tool provides a menu add-in for Excel that lets you quickly export data to JMP 9, as well as using Excel data with JMP's Profiler tool, which lets you do sensitivity analysis and simulations.

Published:
23/Sep/2010

Monday 20 September 2010

Tutorial Excel - Macro que Copia, Ordena y guarda informacion

Title:
Tutorial Excel - Macro que Copia, Ordena y guarda informacion


Video:


Description:Materiales aquí: www.asesorjuanmanuel.com Aqui un tutorial de como crear una macro que copie, Ordene y guarde informacion de una hoja de excel a otra. Muy util para crear un un mini sistema de altas o bajas para inventario u otras cosas. Únete a mi red: www.facebook.com Sígueme en: www.twitter.com Sitio Oficial: www.asesorjuanmanuel.com (Solo si estas SUSCRITO) Archivo para trabajar www.asesorjuanmanuel.com si estas suscrito y deseas el archivo envia un email a: asesorjuanmanuel@hotmail.com para recibir el archivo...

Published:
21/Sep/2010

Sunday 19 September 2010

3. Basic Macros

Title:
3. Basic Macros


Video:


Description:Hi guys, this is the first of the actual VBA tutorails I'm doing. This one just shows you how to use the Macro recorder and view the VBA code that it produces. In the next lesson I'll show you how to write some VBA code of your own.

Published:
20/Sep/2010

Saturday 18 September 2010

numerar numeracion de facturas cotizaciones remisiones consecutivos en excel autonumeración

Title:
numerar numeracion de facturas cotizaciones remisiones consecutivos en excel autonumeración


Video:


Description:Obtenga una membresia Premiun de todas las plantilla en www.jfksoft.com aqui se muestra el funcionamiento de un consecutivo o autonumeracion usando microsoft excel, trabaja con 2 macros una para crear el consecutivo inicial y otra para ir incrementando cada vez que se requiera. www.jfksoft.com

Published:
19/Sep/2010

Thursday 16 September 2010

IMACROS tutorial (pokemon vortex)

Title:
IMACROS tutorial (pokemon vortex)


Video:


Description:IMACROS tutorial (on pokemon vortex)

Published:
17/Sep/2010

Visual Basic Tutorial - #7 - If, Elseif, Then, Endif, Rnd, Statements

Title:
Visual Basic Tutorial - #7 - If, Elseif, Then, Endif, Rnd, Statements


Video:


Description:In this tutorial we'll be covering the If, Then, Endif, Rnd statements. We're making a small game and I'll be giving you a small assignment to practise your skills with. Here's the code used: Dim Eyes As Integer Private Sub cmdResult_Click() Dim Guess As Integer Dim GuessS As String GuessS = txtGuess.Text Guess = CInt(GuessS) If Eyes = Guess Then txtResult.Text = "Correct, you win!!" Else txtResult.Text = "Wrong, you lose, noob!" End If End Sub Private Sub cmdThrow_Click() Eyes = Int((6 * Rnd) + 1) End Sub

Published:
17/Sep/2010

lynda.com Tutorial | Word 2010: Mail Merge in Depth—Inserting address blocks and merge fields

Title:
lynda.com Tutorial | Word 2010: Mail Merge in Depth—Inserting address blocks and merge fields


Video:


Description:Watch the entire course at www.lynda.com In Word 2010: Mail Merge in Depth, author Gini Courter demonstrates how to take advantage of Word's Mail Merge feature to save a tremendous amount of time creating customized documents. The course offers tutorials on creating letters, emails, envelopes, and labels. It also shows how to use Mail Merge with Outlook and Excel, creating data sources, inserting fields, using IF and other rules for customized merges, and troubleshooting Mail Merge issues.

Published:
16/Sep/2010

Tuesday 14 September 2010

Excel 2010 - Macros and VBA - The Developer Ribbon - by MacroMountain.com

Title:
Excel 2010 - Macros and VBA - The Developer Ribbon - by MacroMountain.com


Video:


Description:www.MacroMountain.com Excel 2010 - Macros and VBA - The Developer Ribbon In order to work with Macro and VBA in Excel you will need to use the Developer Ribbon. This section provides and overview of the ribbon, including where to find it. Overview -How to Show/Hide the Developer Ribbon ---The Code Group ---Visual Basic Editor ---Macros ---Record Macro ---Use Relative References -Controls Group ---Insert Controls ---Properties ---View Code How to Show or Hide the Developer Ribbon in Microsoft Excel: 1. Open and Excel Workbook 2. Click on the File tab 3. Click Options - The Excel Option menu will appear 4. Click Customize Ribbon 5. Check the box next to Developer 6. Click OK - The Developer tab will now be visible

Published:
15/Sep/2010

tutorial ordenar aleatoriamente

Title:
tutorial ordenar aleatoriamente


Video:


Description:como ordenar datos de excel de manera aleatoria

Published:
15/Sep/2010

Excel in Depth - Macro Recording: Podcast #1244

Title:
Excel in Depth - Macro Recording: Podcast #1244


Video:


Description:Using the Microsoft Excel Macro Recorder. In Episode #1244, Bill shows you an example of how to record an Excel Macro using Relative References. ...This is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen aka MrExcel.

Published:
14/Sep/2010

Monday 13 September 2010

Capitulo 2(parte 2 de 2). Continuando con las macros.mp4

Title:
Capitulo 2(parte 2 de 2). Continuando con las macros.mp4


Video:


Description:Se trata de las primeras nociones de sintaxis para escribir el código fuente de macros en excel.

Published:
14/Sep/2010

Sunday 12 September 2010

Truco de Macros (Actualizar Datos por Hora)

Title:
Truco de Macros (Actualizar Datos por Hora)Video:


Description:Al igual que los videos anteriores, este video en n lenguaje coloquial se explica como se maneja las macros y un truco para su uso.

Published:
13/Sep/2010

2. Basic Features

Title:
2. Basic Features


Video:


Description:Hey guys, this is the second and last in my basic tutorials for the moment, again it's not really intended for anyone who is totally new to excel and looking for a detailed expiation of how to use the features in Excel (might do something like that another time) this video is just a quick primer for anyone who wants to watch the videos I'm going to be doing on VBA and RibbonX.

Published:
13/Sep/2010

Saturday 11 September 2010

função inverter texto

Title:
função inverter texto


Video:


Description:Neste tutorial aprenderá a fazer uma função definida pelo utilizador que lhe permitirá inverter os caracteres de uma palavra ou frase utilizando o excel

Published:
12/Sep/2010

microsoft excel - tutorial - inverter texto

Title:
microsoft excel - tutorial - inverter texto


Video:


Description:Neste tutorial aprenderá a fazer uma função definida pelo utilizador que lhe permitirá inverter os caracteres de uma palavra ou frase utilizando o excel

Published:
12/Sep/2010

MS Excel Tutorial Urdu Part 18 By Irfan Wazir Ali

Title:
MS Excel Tutorial Urdu Part 18 By Irfan Wazir Ali


Video:


Description:Skype: irfan.wazir.ali

Published:
12/Sep/2010

Free Speech Recognition Tutorial 1 - Setting Up Windows Speech Recognition W7 Vista WSR

Title:
Free Speech Recognition Tutorial 1 - Setting Up Windows Speech Recognition W7 Vista WSR


Video:


Description:www.schoolfreeware.com Windows Vista and Windows 7 come with built-in speech recognition and dictation software. The software is called Windows Speech Recognition (WSR). The tutorials use Windows 7, but users with Windows Vista should be able to follow along without complication. Notes For Setting Up The Computer For Speech Recognition. To make sure that the speech recognition works properly Make sure that the room is free of background noise. Do not shout at the computer when speaking commands Use a USB microphone. Microphones that plug into the microphone port of the sound card or are bluetooth do not have the quality that an USB microphone has. This tutorial series uses the Blue Snowball. Before using WSR, setup the microphone: Control Panel, Ease of Access, Speech Recognition Options. Then, use Take Speech Tutorial. After the tutorial is done, click Train Your Computer To Better Understand You. It can take some time to learn WSR and for the computer to learn your voice, so stick with it. This tutorial series uses Windows Speech Recognition and covers: Setting up the software Mouse Controls Computer Controls Dictation to Word, PowerPoint and Excel Use for dyslexia and speech therapy Installing and creating macros

Published:
11/Sep/2010

Thursday 9 September 2010

Add Navigation Macro button on Excel Worksheet

Title:
Add Navigation Macro button on Excel Worksheet


Video:


Description:www.contextures.com After you record a macro in Excel, you can add a button to the worksheet, to make it easy to run the macro. In this Excel video tutorial, there are two macros in the workbook: one macro moves the user to the next worksheet, and the other macro moves the user to the previous worksheet. See the steps for adding the buttons, and aligning the buttons, then copy the buttons to other worksheets.

Published:
10/Sep/2010

Curso de Excel 2010. 18. Crear una macro.

Title:
Curso de Excel 2010. 18. Crear una macro.


Video:


Description:Curso de Microsoft Excel 2010. 18. Crear una macro.

Published:
10/Sep/2010

Curso de Excel 2010. 17. Tablas dinámicas.

Title:
Curso de Excel 2010. 17. Tablas dinámicas.


Video:


Description:Curso de Microsoft Excel 2010. 17. Tablas dinámicas.

Published:
10/Sep/2010

Curso de Excel 2010. 16.2. Formularios para introducir datos.

Title:
Curso de Excel 2010. 16.2. Formularios para introducir datos.


Video:


Description:Curso de Microsoft Excel 2010. 16.2. Formularios para introducir datos.

Published:
10/Sep/2010

Curso de Excel 2010. 12.1. Crear un gráfico con el asistente.

Title:
Curso de Excel 2010. 12.1. Crear un gráfico con el asistente.


Video:


Description:Curso de Microsoft Excel 2010. 12.1. Crear un gráfico con el asistente.

Published:
10/Sep/2010

Wednesday 8 September 2010

Excel Suma Resta Multiplicacion Division Sumatoria Columna Fila Hoja

Title:
Excel Suma Resta Multiplicacion Division Sumatoria Columna Fila HojaVideo:


Description:QuieroTrabajarEnCasa.info Operaciones matemáticas básicas Suma, Resta, Multiplicación, División y Sumatoria, que es una Hoja o Libro Excel, que es una Columna, que es una Fila, que es una Celda, que es una hoja y como cambiar nombre a las hojas. Además sumatoria por columnas y sumatoria por filas. Espero les guste y por favor suscríbanse, hagan sus aportes y comentarios POSITIVOS y si lo desean, pueden solicitar otros videos tutoriales del tema que les interese, bien sea de Office, de Camtasia Studio, de Diseño Web, de cómo trabajar desde casa, como llenar formularios, etc. Mejor dicho estoy en capacidad de responder casi cualquier tema. Suscribanse en www.quierotrabajarencasa.info

Published:
09/Sep/2010

Tuesday 7 September 2010

Asignar un botón a una macro en Excel 2007

Title:
Asignar un botón a una macro en Excel 2007


Video:


Description:Visita capacitateexcel.blogspot.com | Para todos aquellos usuarios de Excel 2003 que asignaban un botón de una carita sonriente a sus macros ahora en Excel 2007 lo pueden hacer, solo que ya no hay la carita sonriente, veamos en el video como se hace.

Published:
07/Sep/2010

Macro para Proteger y Desproteger una hoja en Excel 2007

Title:
Macro para Proteger y Desproteger una hoja en Excel 2007


Video:


Description:Visita: capacitateexcel.blogspot.com | En este video veremos como crear una macro para proteger una hoja de excel 2007 y otra para desproteger. Veremos como editar el código para agregarles un Password. Mas temas de interes en http

Published:
07/Sep/2010

Monday 6 September 2010

Review of Nikon Coolpix L110 Digital Camera

Title:
Review of Nikon Coolpix L110 Digital Camera


Video:


Description:The Nikon Coolpix L110 is a 12.1 megapixel, 15x optical zoom digital camera with 720p video mode and solid construction. It has proven to be a camera with a robust feature set... many strengths and few weaknesses. One of the weak spots is the quality of the recorded audio. Ambient noise sounds OK but if you attempt to use this camera to record voice, for product reviews for instance, the sound is thin and "scratchy." You cannot expect an under $300 camera to excel in all areas however so some of the weaknesses just have to be accepted at this price point. Another camera from another manufacturer may have better audio but will inevitably have a weakness in another area. I guess the bottom line is that you have to match your needs and expectations with the right product. If you absolutely need excellent audio, this is not the camera for you. If you are looking for a camera with excellent Macro capabilities, the L110 is up to the task. The L110 has a very strong zoom capability... 15x. When used in conjunction with a tripod you can get some excellent shots when fully zoomed. I've gotten spectacular photos of wildlife using the full zoom plus the 4x digital zoom. The high megapixel count enables you to crop photos with little degradation of quality. A weakness of the L110 is it's lack of true manual control of your aperture, ISO and shutter speed. This will frustrate the more professional photographer who is looking for a smaller camera capable of taking great photos, such as ...

Published:
06/Sep/2010

Friday 3 September 2010

Habilitar Macros e Suplementos no Excel 2007

Title:
Habilitar Macros e Suplementos no Excel 2007


Video:


Description:Como habilitar macros e suplementos no Excel 2007.

Published:
04/Sep/2010

Thursday 2 September 2010

Lanzar macros con iconos y botones

Title:
Lanzar macros con iconos y botones


Video:


Description:excelavanzado.com Podemos lanzar macros de Excel con iconos y con botones. Vemos la palabra clave ActiveCell.

Published:
02/Sep/2010

Wednesday 1 September 2010

video tutorial de excel

Title:
video tutorial de excel


Video:


Description:

Published:
02/Sep/2010

listas desplegables con Excel BUSCARV buscar seleccionar listas crear listados sin macros

Title:
listas desplegables con Excel BUSCARV buscar seleccionar listas crear listados sin macros


Video:


Description:Descarga gratis imprimir preimpresos goo.gl Usa esta plantilla para imprimir facturas preimpresas cheques o cualquier formato que requiera. Descarga gratis imprimir preimpresos goo.gl

Published:
01/Sep/2010