Sunday 31 October 2010

Excel VBA - Click Column Heading to Quickly Sort Table

Title:
Excel VBA - Click Column Heading to Quickly Sort Table


Video:


Description:www.contextures.com Add invisible rectangles at the top of Excel columns. Users click the heading to sort by that column. If the column is currently in ascending order, the macro will sort in descending order. This Excel tutorial video shows you how to edit and run the macro to set up the hidden rectangles. After that one-time job, just click on a heading, to run the Sort Table macro.

Published:
31/Oct/2010

categorias y productos: creando un inventario inicial usando microsoft excel jfksoft.com

Title:
categorias y productos: creando un inventario inicial usando microsoft excel jfksoft.com


Video:


Description:www.jfksoft.com Obtenga una membresia Premiun de todas las plantillas Esta es la forma mas rapida de crear su inventario inicial y puedes llevar al sistema de punto de venta con un clic. Descarga ahora y comienza a realizar el inventario de tus productos y servicios. www.jfksoft.com

Published:
31/Oct/2010

Friday 29 October 2010

EstimatePi - ExcelVBASql.com - 20+ hours of FREE training!

Title:
EstimatePi - ExcelVBASql.com - 20+ hours of FREE training!Video:


Description:www.ExcelVBASql.com

Published:
30/Oct/2010

Thursday 28 October 2010

What is a Class and an Object in Excel VBA? - ExcelVBASql.com 20+ hours of FREE training!

Title:
What is a Class and an Object in Excel VBA? - ExcelVBASql.com 20+ hours of FREE training!


Video:


Description:www.ExcelVBASql.com THis is an intro to the Excel Object model that uses classes and objects. Visit ExcelVbaSql.com for more videos and to download macros!

Published:
29/Oct/2010

lynda.com Tutorial | Word for Mac 2011 Essential Training—Welcome

Title:
lynda.com Tutorial | Word for Mac 2011 Essential Training—Welcome


Video:


Description:Watch the entire course at www.lynda.com In Word for Mac 2011 Essential Training, author Maria Langer shows how to create, format, and print a wide variety of documents in Microsoft Word 2011. The course covers building outlines, formatting text and pages, working with headers and footers, using themes and styles, adding multimedia, and more. It also shows how to customize and automate Word 2011, including how to record macros.

Published:
28/Oct/2010

Wednesday 27 October 2010

How to Lookup Values Using Multiple Columns in Excel

Title:
How to Lookup Values Using Multiple Columns in Excel


Video:


Description:There are times when you need more look up power than you can get from the VLOOKUP Function. For example, when you need to return a value that requires you to look up more than one column (eg First Name -1st Column - and Last Name - 2nd Column) in order to return the employees title or manager or hire date. I share my best practices in this lesson - eg using Named Cell Ranges in your Formula. To create this formula you are using an Array Formula and this means that you use the keyboard combination "Ctrl+Shift+Enter" to enter it. Please visit my online shopping website - shop.thecompanyrocks.com - to view additional videos and to access my many resources, I also welcome your comments. Tell me if my video has helped you or suggest additional video lessons for me to post here on YouTube. Danny Rocks

Published:
28/Oct/2010

Tuesday 26 October 2010

Viewing Only Subtotal Related Fields & Data

Title:
Viewing Only Subtotal Related Fields and Data


Video:


Description:Demonstration of Viewing Only Subtotal Related Data using EZ-Format for Excel. View only subtotal break fields, subtotaled fields and dragged fields in one or two clicks. View only subtotal related data at single outline levels below outline level 2. This is impossible when using only Excel without writing advanced Excel Macros.

Published:
27/Oct/2010

Sort a 1 Dimensional Static Array of Strings or Integers - ExcelVbaSql.com

Title:
Sort a 1 Dimensional Static Array of Strings or Integers - ExcelVbaSql.com


Video:


Description:www.ExcelVBASql.com

Published:
27/Oct/2010

How To...Sort Data in Excel 2010

Title:
How To...Sort Data in Excel 2010Video:


Description:Learn how to sort data in Excel 2010. This video will show you how to sort both words and numbers in Excel to make your data more meaningful.

Published:
26/Oct/2010

Monday 25 October 2010

lynda.com Tutorial | Excel for Mac 2011 Essential Training—Welcome

Title:
lynda.com Tutorial | Excel for Mac 2011 Essential Training—Welcome


Video:


Description:Watch the entire course at www.lynda.com In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others.

Published:
26/Oct/2010

Save a Form in Excel: Podcast #1272

Title:
Save a Form in Excel: Podcast #1272


Video:


Description:Kim has designed a simple data entry spreadsheet and would like to have a way to paste the data into the next empty row of a database worksheet she has created. In Episode 1272, takes a look at how to finesse the macro recorder to solve this problem.

Published:
25/Oct/2010

Automate routine tasks with MouseRobot macro recorder

Title:
Automate routine tasks with MouseRobot macro recorder


Video:


Description:www.MouseRobot.com | http MouseRobot is an easy, powerful and versatile tool for automation of repetitious actions, such as filling of forms, image processing, installation and setting of programs, etc. You only have to set desired operations in MouseRobot once and that will do. The program will be able to execute them by itself! MouseRobot adds the visual macro recording to any program! You do not need to worry about the complexity of automation; you should not study the programming and interior arrangement of programs. Macro in MouseRobot consists of simple and common steps, such as opening and closing programs, operations with objects on the screen, pressing the keys of the keyboard and clicking the mouse. Download your free copy of MouseRobot and try it right away!

Published:
25/Oct/2010

Sunday 24 October 2010

#1 VBA for excel tutorial.avi

Title:
#1 VBA for excel tutorial.avi


Video:


Description:first video introduction. hope you like it!

Published:
25/Oct/2010

The VBA Editor - Run, Pause, Break and Design icons - ExcelVBASql.com

Title:
The VBA Editor - Run, Pause, Break and Design icons - ExcelVBASql.com


Video:


Description:www.ExcelVBASql.com This is an intro to the Run, Pause, Break and Design icons in the Visual Basic Editor.

Published:
25/Oct/2010

Demo uso Excel desde Access

Title:
Demo uso Excel desde Access


Video:


Description:Creación de hoja de cálculo, personalización y carga de contenidos, desde Access a base de una macro creada primero por excel y luego adaptada al VBa de Access. Múltiples hojas en un libro, cada una asume una parte de información (Select desde Access).

Published:
24/Oct/2010

Saturday 23 October 2010

What is a variable in Excel? - ExcelVBASql.com 25+ hours of FREE training!

Title:
What is a variable in Excel? - ExcelVBASql.com 25+ hours of FREE training!


Video:


Description:www.ExcelVBASql.com This video introduces variables and their 2 important charateristics: type and size. Visit www.ExcelVbaSql.com to download the working macros!

Published:
23/Oct/2010

Friday 22 October 2010

Access 2010: Find a record on a form by selecting a value from a list

Title:
Access 2010: Find a record on a form by selecting a value from a list


Video:


Description:By using the Combo Box wizard, you can quickly create a drop-down list that lets you find a record on a form. For example, to find a record on a form that displays employee contact information, you might select an employee's name from a combo box at the top of the form, and then the form would display that employee's record. NOTE: At about 1:35 in the video, I say to click the option, "Find a record on my form based on the value I selected in my combo box". There are some situations where this option is not available. If you don't see that option in the dialog box, you can get a workaround by going to bit.ly and then clicking the line, "The Find a record... option is not available."

Published:
23/Oct/2010

Chi-sq. in Excel, Pt. 1: Making the contingency table

Title:
Chi-sq. in Excel, Pt. 1: Making the contingency table


Video:


Description:This video shows how to make contingency tables in Excel, both with counts and with column percents. Part 1 of 4 tutorials on doing Chi-sq. hypothesis tests in Excel. Audio track has some glitches.

Published:
22/Oct/2010

Thursday 21 October 2010

imprimir facil en visual

Title:
imprimir facil en visual


Video:


Description:hola camaradas de youtube hoy les enseñare como imprimir de una manera muy sencilla en visual basic.net espero sea de su agrado este pequeño tuto el cod completo y mas explicado estara pronto en mi blog personal falcom101.blogspot.com

Published:
21/Oct/2010

Wednesday 20 October 2010

g Chart Template in Excel Video

Title:
g Chart Template in Excel Video


Video:


Description:g Charts monitor events that happen so rarely standard control charts are not effective. The g chart is also known as the geometric means chart. There a two main g chart templates in the QI Macros: •Time or units between g chart template which calculates the time or units between events •Missed vs met g chart template which calculates the period (day/week/month) between events For more information: qimacros.com Download 30 day trial at www.qimacros.com The QIMacros Control Chart Software for Excel creates all attribute and variable control charts including c chart, p chart, np chart, u chart, XmR chart, XbarR chart and XandS charts. This video shows you how to create ag chart using the QI Macros

Published:
21/Oct/2010

p prime and u prime Control Chart Templates in Excel

Title:
p prime and u prime Control Chart Templates in Excel


Video:


Description:p charts and u charts work for most data sets. However, if your data meets certain criteria you may need to consider an XmR chart or ap prime or u prime chart. Consider an XmR chart if the denominator does NOT vary widely from sample to sample and your p chart or u chart control limits seem too narrow for the data and most points are highlighted as unstable. A p prime or u prime chart will have wider control limits than the p chart or u chart and it will have varying control limits that may help identify unstable points not identified by the XmR chart. For more information qimacros.com Download a 30 day trial at qimacros.com The QIMacros Control Chart Software for Excel creates all attribute and variable control charts including c chart, p chart, np chart, u chart, XmR chart, XbarR chart and XandS charts. This video shows you how to create ap prime and u prime chart in Excel using the QI Macros

Published:
21/Oct/2010

Sunday 17 October 2010

Macros y Formularios en VBA Microsoft Excel - Tutorial

Title:
Macros y Formularios en VBA Microsoft Excel - Tutorial


Video:


Description:Breve descripción para vincular macros, formularios y el envió de información de un formulario a una planilla y vice versa, utilizando para ello VBA de Microsoft Excel

Published:
17/Oct/2010

Saturday 16 October 2010

How to Add a Check Box Control to an Excel Form

Title:
How to Add a Check Box Control to an Excel Form


Video:


Description:At first glance, adding a Check Box Control (Yes / No, True / False, etc.) to an Excel Form seems easy to do. And it is, once you know where the "got ' cha" steps are and what to do to avoid these traps! I worked hard to make this expanation as easy as possible for you - my viewers - to understand. I feel that this is an Excel concept that is easier to understand when you "see it" being created rather than "reading about" how to do it. Please let me know with your comments: "True or False," did I make it easy for you to understand how to add a Check Box Control to an Excel Form? Best, Danny Rocks www.thecompanyrocks.com

Published:
17/Oct/2010

Friday 15 October 2010

macro guardar pdf

Title:
macro guardar pdfVideo:


Description:DESCRIPCION PARA CREAR UNA MACRO QUE GUARDE UN ARCHIVO PDF DE FORMA AUTOMATIZADA

Published:
16/Oct/2010

Excel 2010 para iniciantes. (Aula 5) - Revisão

Title:
Excel 2010 para iniciantes. (Aula 5) - Revisão


Video:


Description:Ultima Aula do Básico de Excel. Aqui vamos fazer uma revisão. Para mais vídeo aulas: newbievideoaulas.blogspot.com

Published:
16/Oct/2010

ExcelCurso.com: Mejores Secretos Excel. Seleccionar cuadro

Title:
ExcelCurso.com: Mejores Secretos Excel. Seleccionar cuadro


Video:


Description:www.excelcurso.com Excel Trucos Tecnicas Secretos Dominar Aprender Curso saber tablas dinamicas macros avanzado basico intermedio 2007 2003 2010

Published:
16/Oct/2010

Grade verification

Title:
Grade verification


Video:


Description:

Published:
15/Oct/2010

Thursday 14 October 2010

Modelo: VPN de un proyecto de inversión - parte 1 de 5

Title:
Modelo: VPN de un proyecto de inversión - parte 1 de 5


Video:


Description:En esta serie de 5 videos se explica cómo diseñar y construir la aplicación financiera para calcular el VPN y la TIR deun proyecto de inversión usando Excel

Published:
15/Oct/2010

Cómo hacer vínculos en excel

Title:
Cómo hacer vínculos en excel


Video:


Description:cómo hacer vínculos en excel

Published:
15/Oct/2010

Programación Mixta FORTRAN-Excel [Parte 2-33] [Ghost Hack]

Title:
Programación Mixta FORTRAN-Excel [Parte 2-33] [Ghost Hack]


Video:


Description:Programación Mixta FORTRAN-Excel [Ghost Hack] Cálculo de Puntos Críticos de Heidemann y Khalil en Mezclas Multicomponente. Link Visual FORTRAN 6.0: rapidshare.com Link Material: www.rapidshare.com Videotutorial para programar combinando FORTRAN-Excel con el algoritmo de Heidemann y Khalil el cálculo del Punto Crítico de una Mezcla Multicomponente. Espero les sirva, pronto subiré mas tutoriales sobre Ingeniería, Hysys, Excel, y más programas y trucos. NO SE SUSCRIBAN, me conformo con que escriban sus dudas y lo que quiera que les explique o les haga otro tutorial. Gracias por ver el tuto.

Published:
15/Oct/2010

Wednesday 13 October 2010

matrix multiplication, inverse, determinant using excel.mp4

Title:
matrix multiplication, inverse, determinant using excel.mp4


Video:


Description:With the help of this tutorial u can perform matirx multiplication , inverse, determinant using excel

Published:
14/Oct/2010

Tuesday 12 October 2010

Create an XbarR Chart in Excel Using the QI Macros

Title:
Create an XbarR Chart in Excel Using the QI Macros


Video:


Description:X bar R charts evaluate stability of processes using variable data--time, cost, length, weight. Use an XbarR chart when the sample size is between 2 and 5. For more information qimacros.com Download 30 day trial at www.qimacros.com The QIMacros Control Chart Software for Excel creates all attribute and variable control charts including c chart, p chart, np chart, u chart, XmR chart, XbarR chart and XandS charts.

Published:
13/Oct/2010

Create an EWMA Chart in Excel Using the QI Macros SPC Software

Title:
Create an EWMA Chart in Excel Using the QI Macros SPC Software


Video:


Description:EWMA charts can help you evaluate a process when there is only one sample and you are interested in detecting small shifts in performance. The EWMA charts (exponentially weighted moving average chart) performance is similar to the Cusum chart. For more information see qimacros.com Download 30 day trial at www.qimacros.com The QIMacros Control Chart Software for Excel creates all attribute and variable control charts including c chart, p chart, np chart, u chart, XmR chart, XbarR chart and XandS charts. This video shows you how to create a EWMA chart in Excel using the QI Macros

Published:
12/Oct/2010

Monday 11 October 2010

Kleine Macros erstellen mit Excel 2010 Teil2 für Tabellen

Title:
Kleine Macros erstellen mit Excel 2010 Teil2 für Tabellen


Video:


Description:Im Teil 2 wird beschrieben wie eine kleine Tabelle mit Excel 2010 erstellt werden kann. Ziel soll werden eine komplette Dateiverwaltung. Zahlen und Daten sind rein fiktiv. Diese Anleitung soll nur eine kleine Hilfe sein, wer Spass an Tabellen hat. Teile die diese Tabelle erweitern sollen folgen in Kürze.........

Published:
12/Oct/2010

Excel VBA - Macro Runs When Worksheet Changed

Title:
Excel VBA - Macro Runs When Worksheet Changed


Video:


Description:blog.contextures.com Show a message in your Excel workbook by using a macro. Click OK to close message. The message will only appear if a specific cell has a value that is listed in the macro code. In this example, the message appears for customers in Canada. If customer is in USA, message will not appear. Then, add code to check which cell was changed, and only run the macro if the customer name was changed. This will prevent the macro from running when other cells are changed.

Published:
12/Oct/2010

Simplexcel - Cuadro Combinado Excel

Title:
Simplexcel - Cuadro Combinado Excel


Video:


Description:Tutorial del uso de cuadro combinado en excel, ademas de las fórmulas Elegir y sumar.Si Visita el Blog www.simplexcel.blogspot.com

Published:
11/Oct/2010

Sunday 10 October 2010

Kleine Macros erstellen mit Excel 2010 Teil1 für Tabellen

Title:
Kleine Macros erstellen mit Excel 2010 Teil1 für Tabellen


Video:


Description:Im Teil 1 wird beschrieben wie kleine Macros mit Excel 2010 erstellt werden können. Ziel soll werden eine komplette Dateiverwaltung. Zahlen und Daten sind rein fiktiv. Diese Anleitung soll nur eine kleine Hilfe sein, wer Spass an Tabellen hat. Teile die diese Tabelle erweitern sollen folgen in Kürze.........

Published:
11/Oct/2010

Saturday 9 October 2010

PWA tutorial 2 - managing pairs and layers

Title:
PWA tutorial 2 - managing pairs and layers


Video:


Description:Tutorial #2 - Managing pairs and layers in PWA After installing PWA, locate the Excel workbook on your desktop and open it. You will be presented with a login screen. Enter your username and password to login. If this is your first time, you will be asked to enter the account which you intend to use this program with. Enter your account and click the "Reset and Login" button. Only the account you've entered in this step will be allowed to execute real trades. To add more accounts, please contact us. While you're still on the Settings sheet, select the DDE link source applicable to you. When you add new instruments to PW in the next step, this DDE source will be used. Go back to PW sheet. If your DDE source is set to REDI, navigate to DDE links and click on the Get Redi DDE links to populate various real-time fields, such as PnL stats, SPX values, Tick and VIX. These fields are currently not available for other data sources but will be added in the future. Now we'll add some pairs and single stocks: -Click on the "Add" button to add a pair manually: Lead: ABX, LAG: GG, Ratio: 100, Bias: S for short -To import multiple pairs or stocks at the same time, let's batch import -Enter GE into Stock1 and bias as long -Enter Fdx into Stock1, Ups into Stock2, 100 into Ratio column and L into bias -click on Create Sheets button. This will create the necessary accounting sheets for new pairs - double-click on AbxGg100 pair name to go to accounting page of that pair - Click on Add layer ...

Published:
10/Oct/2010

Insert picture into cell comment with Excel Image Assistant 1.8

Title:
Insert picture into cell comment with Excel Image Assistant 1.8


Video:


Description:excel-image-assistant.com Excel Image Assistant is an add in for Microsoft® Excel® With this easy-to-use and time-saving add-in you can easily - Insert picture in Excel cell -Insert picture in Excel cell comment -Insert picture file name in Excel cell -Insert picture in Excel cell based on cell value (file name) -Insert picture in Excel cell comment based on cell value (file name) -View picture in Excel

Published:
10/Oct/2010

Thursday 7 October 2010

QFD House Of Quality Template in Excel

Title:
QFD House Of Quality Template in Excel


Video:


Description:QFD is a rigorous method for translating customer needs, wants, and wishes into step-by-step procedures for delivering the product or service. While delivering better designs tailored to customer needs, Quality Function Deployment also cuts the normal development cycle by 50%, making you faster to market. QFD uses the "QFD House of Quality" (a template in the QI Macros) to help structure your thinking, making sure nothing is left out. For more information see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to create a QFD House of Quality in Excel using the QI Macros

Published:
08/Oct/2010

Sample Size Calculator in Excel for Variable and Attribute Data

Title:
Sample Size Calculator in Excel for Variable and Attribute Data


Video:


Description:To calculate a sample size you need to know: 1. The confidence level required (90%, 95%, 99%) 2. The desired width of the confidence interval (+5%) 3. The variability of the characteristic (eg, mean) The QI Macros Sample Size Calculator is designed to work with both variable (measured) and attribute (counted) data. For examples and more info see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to calculate sample size in Excel using the QI Macros

Published:
08/Oct/2010

How to Create a Levey Jennings Chart in Excel

Title:
How to Create a Levey Jennings Chart in Excel


Video:


Description:Healthcare labs use the Levey Jennings charts to monitor key measures of health like cholesterol and glucose. The Levey Jennings chart, unlike other SPC charts, uses standard deviation as a way of calculating control limits. You can create a Levey Jennings chart in Excel using the QI Macros SPC Software. For more info see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to create a Levey Jennings chart in Excel using the QI Macros

Published:
08/Oct/2010

Create a Control Chart in Excel

Title:
Create a Control Chart in Excel


Video:


Description:Use a control chart to tell you whether your process is out of control, unstable, or not predictable. A stable process produces predictable results consistently. Processes that are "out of control" need to be investigated and stabilized before they can be improved. The QI Macros Control Chart Software for Excel creates p charts, u charts, np charts, c charts, XmR charts, XbarR charts, XandS charts and more. For more info see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to create a control charts in Excel using the QI Macros

Published:
07/Oct/2010

How to Perform Design of Experiments in a DOE Template in Excel

Title:
How to Perform Design of Experiments in a DOE Template in Excel


Video:


Description:Without DOE, you're stuck with the world's slowest method for success-trial and error. With Design of Experiments, you just have to test at the high (+) and low (-) values for any particular "design factor" (eg, pressure, temperature, time, etc.) from your QFD House of Quality, not every increment in between. And you can test more than one factor at a time. For more info see www.qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to perform DOE analysis in Excel using the QI Macros

Published:
07/Oct/2010

Excel Macro Tutorial -

Title:
Excel Macro Tutorial -


Video:


Description:www.ascentcomputertraining.ie Excel Macro Tutorial - Microsoft Platinum Learning Partner - Contact us today for more information on our training courses.

Published:
07/Oct/2010

Ishikawa Fishbone Diagram in Excel to Perform Root Cause Analysis

Title:
Ishikawa Fishbone Diagram in Excel to Perform Root Cause Analysis


Video:


Description:Use the Ishikawa fishbone diagram (aka cause and effect diagram) to identify the special root causes of delay, waste, rework or cost. You can use Excel's drawing tools (View-Toolbars-Drawing) to create a fishbone diagram. This video is an example of how to use the Ishikawa template in the QI Macros for Excel SPC software. For more info see www.qimacros.com Download 30 day trial at www.qimacros.com

Published:
07/Oct/2010

FMEA Template in Excel to Perform Failure Modes and Effects Analysis

Title:
FMEA Template in Excel to Perform Failure Modes and Effects Analysis


Video:


Description:FMEA - Failure Modes and Effects Analysis is a tool used to analyze and prevent disasters. You can use it to analyze a product (car, x-ray, MRI), part (car door), or process (part stamping process or elective surgery). Designing a product or part uses a DFMEA. Analyzing a process uses a PFMEA. For more info see www.qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to perform an FMEA analysis in Excel using the QI Macros FMEA template

Published:
07/Oct/2010

Tutorial: Layout Colegio Jean Piaget para actualización Web

Title:
Tutorial: Layout Colegio Jean Piaget para actualización Web


Video:


Description:Ejemplo de un Tutorial de asesoría para la ejecución de un proceso apoyado en tecnologías Macro para excel. Servicio exclusivo para Clientes AConsultores. aconsultores.info

Published:
07/Oct/2010

Wednesday 6 October 2010

How to Use VLOOKUP in Microsoft Excel 2010

Title:
How to Use VLOOKUP in Microsoft Excel 2010


Video:


Description:How to Use VLOOKUP in Microsoft Excel 2010 from "Power Excel 2010 with Mr. Excel" LiveLessons. Buy product here: www.quepublishing.com

Published:
07/Oct/2010

Tuesday 5 October 2010

Conduct a Gage R&R Attribute Study in Excel

Title:
Conduct a Gage RandR Attribute Study in Excel


Video:


Description:Perform an Attribute Gage RandR Study when the measurement value has only two possible results: go/no go, pass/fail, etc. For more info see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to perform a Gage RandR attribute study in Excel using the QI Macros Gage RandR template

Published:
06/Oct/2010

How to Conduct a Gage R&R Study in Excel

Title:
How to Conduct a Gage RandR Study in Excel


Video:


Description:Conduct a Gage RandR Study to evaluate your measurement system. When you measure, three factors come into play: Part variation, Appraiser variation and Equipment variation. You want most of the variation to be between the parts, and less than 10% of the variation to be caused by the appraisers and equipment. For more info see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to perform a Gage RandR study using the QI Macros for Excel

Published:
06/Oct/2010

How to Create a Run Chart in Excel

Title:
How to Create a Run Chart in Excel


Video:


Description:A run chart is simply a line graph of your data and a line representing the average or median of your data. Its easy to create a run chart in Excel using the QI Macros. See www.qimacros.com for more info Download 30 day trial at www.qimacros.com

Published:
06/Oct/2010

Sunday 3 October 2010

Excel 2007 - Calculando la edad

Title:
Excel 2007 - Calculando la edadVideo:


Description:Veamos como calcular la diferencia entre dos fechas, en concreto haremos uso de esta fórmula para calcular la edad de una persona. Diseccionamos la fórmula para entenderla a la perfección. Aplicable también en Excel 2003

Published:
04/Oct/2010

TUTORIAL MACROS.wmv

Title:
TUTORIAL MACROS.wmv


Video:


Description:Este tutorial les servira de mucha ayuda para aprender a crear una MACRO en WRITER un componente de OPENOFFICE.

Published:
04/Oct/2010