Friday 30 September 2011

Word 2010 Expert, MOS Study Questions

Title:
Word 2010 Expert, MOS Study Questions


Video:


Description:This video covers some possible questions/tasks you might find on the Word 2010 Expert exam. Enjoy

Published:
01/Oct/2011

Monday 26 September 2011

Excel 2003 Tutorial Running Macros Microsoft Training Lesson 33.2

Title:
Excel 2003 Tutorial Running Macros Microsoft Training Lesson 33.2


Video:


Description:Learn how to run and delete recorded macros in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. Get the complete tutoria...

Published:
26/Sep/2011

Excel 2003 Tutorial Deleting Macros Microsoft Training Lesson 33.3

Title:
Excel 2003 Tutorial Deleting Macros Microsoft Training Lesson 33.3


Video:


Description:Learn how to run and delete recorded macros in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. Get the complete tutoria...

Published:
26/Sep/2011

Excel 2003 Tutorial Recording Macros Microsoft Training Lesson 33.1

Title:
Excel 2003 Tutorial Recording Macros Microsoft Training Lesson 33.1


Video:


Description:Learn how to run and delete recorded macros in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. Get the complete tutoria...

Published:
26/Sep/2011

Friday 23 September 2011

Creating a report in SAP BPC 10.0 with new Excel client

Title:
Creating a report in SAP BPC 10.0 with new Excel client


Video:


Description:This demo shows how to create a new report using the new Excel client for SAP BusinessObjects Planning and Consolidation 10.0 that can also be used to create reports across other EPM sources/applications for a unified user experience and greater productivity. New features include drag and drop report creation, IntelliSense, and new report formatting. Note that as of BPC 10.0 SP3 (now available), EvDRE is supported for customers that have created EvDRE based reports in older versions of the software.

Published:
24/Sep/2011

Use the Solver Add-in for Excel to Produce a Specific Formula Result

Title:
Use the Solver Add-in for Excel to Produce a Specific Formula Result


Video:


Description:This is Part 2 of my series of videos demonstrating how to use the SOLVER Add-in for Excel. Remember that SOLVER is not activated by default. I show you how to activate it in Part 1 of this series. Here, I want SOLVER to automatically change the Units Sold so that the resulting Gross Profit Sales are $25000. This is similar to the way that I used SOLVER in Part 1. What is different? I, first, used the SUMPRODUCT Function to determine what would be a "reasonable target" for SOLVER to produce. Even though SOLVER is a very powerful tool to use to produce Business Intelligence Reports, you must use your own intelligence - and understanding of your business - to make the proper decisions. I invite you to visit my online shopping website - shop.thecompanyrocks.com - to view all of my videos and to take advantage of the many resources that I offer you. Danny Rocks The Company Rocks

Published:
23/Sep/2011

Wednesday 21 September 2011

Macro, Importing To Excel 2007

Title:
Macro, Importing To Excel 2007


Video:


Description:This tutorial talks you through the process of importing a macro into Excel 2007. These steps are very simular to the ones used for Excel 2010. Dont forget t...

Published:
22/Sep/2011

Tuesday 20 September 2011

SIAGIE: TUTORIAL PARA INGRESO DE NOTAS

Title:
SIAGIE: TUTORIAL PARA INGRESO DE NOTAS


Video:


Description:Este video te ayudará a esclarecer algunas dudas en la subida de notas a tus registros en el siagie.

Published:
21/Sep/2011

Monday 19 September 2011

insert product's picture using vba in excel

Title:
insert product's picture using vba in excel


Video:


Description:How to insert product's picture using vba in excel Download Excel from link below mrsakon.wordpress.com Ae.

Published:
19/Sep/2011

Tuesday 13 September 2011

Ejemplo de vlookup o buscarv en VBA Excel

Title:
Ejemplo de vlookup o buscarv en VBA Excel


Video:


Description:Es un ejemplo de como hacer una funcion personalizada en excel programando en VBA visual basic. Se busca en tablas, multiplica, suma.

Published:
14/Sep/2011

Monday 12 September 2011

TABLAS DINAMICAS EXCEL 2010 - Plantilla Informe de Ventas

Title:
TABLAS DINAMICAS EXCEL 2010 - Plantilla Informe de Ventas


Video:


Description:www.TablasDinamicasExcel.com Vídeo que muestra cómo importar la plantilla Informe de Ventas para crear una Tabla Dinámica en Excel 2010.

Published:
13/Sep/2011

Saturday 10 September 2011

VBA Excel 2010: Dudas Blog 0002. Importar Imágenes. Vídeo 02. davidasurmendi.blogspot.com.

Title:
VBA Excel 2010: Dudas Blog 0002. Importar Imágenes. Vídeo 02. davidasurmendi.blogspot.com.


Video:


Description:Continuación de: VBA Excel 2010: Dudas Blog 0002. Importar Imágenes. Vídeo 01. davidasurmendi.blogspot.com. La idea o duda era la siguiente. Tenía un documento de Excel en el que por necesidades de trabajo tenía que importar unas 2500 imágenes y no quería importarlas de una en una. Cada una de las imágenes se debía importar en una celda. Debía empezar en una celda concreta ya partir de esa celda se van insertando el resto de imágenes una fila por debajo. Hasta aquí podemos deducir dos problemas principales: Como importar todas las imágenes que contiene una carpeta y como dar a las celdas ya la imagen el tamaño justo para que la imagen quede bien situada en cada celda. Esta es la duda que me planteo. Primero vamos a dar solución a este problema ya continuación modificaremos el código un poco para que en lugar de sacar las imágenes de una carpeta escrita en el código, aparezca una ventana en la que podemos seleccionar la carpeta de la que sacará las imágenes para importar. Esto es lo que vamos hacer en esta sesión. Más información y el archivo del vídeo en el Blog: davidasurmendi.blogspot.com

Published:
11/Sep/2011

Friday 9 September 2011

Using Name Manager in Excel.wmv

Title:
Using Name Manager in Excel.wmv


Video:


Description:Using the Name Manager in Excel 2007. A very brief introduction.

Published:
10/Sep/2011

Saturday 3 September 2011

Excel VBA - How to Import Data From a Text File

Title:
Excel VBA - How to Import Data From a Text File


Video:


Description:Excel VBA - How to Import Data From a Text File 'Use Text To Column to trim the data

Published:
03/Sep/2011

Thursday 1 September 2011

Demo of Our Sales Tracker VBA Application - Excel VBA Crash Cours from Chandoo.org

Title:
Demo of Our Sales Tracker VBA Application - Excel VBA Crash Cours from Chandoo.org


Video:


Description:

Published:
02/Sep/2011