Monday 28 February 2011

Excel 2010: Conditional Formatting

Title:
Excel 2010: Conditional Formatting


Video:


Description:www.gcflearnfree.org Imagine you have a spreadsheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of these tools is called conditional formatting. With conditional formatting, you can apply formatting to one or more cells based on the value of the cell. You can highlight interesting or unusual cell values, and visualize the data using formatting such as colors, icons, and data bars. In this lesson, you will learn how to apply, modify, and remove conditional formatting rules. Conditional formatting applies one or more rules to any cells that you want. An example of a rule might be "If the value is greater than 5000, color the cell yellow." By applying this rule to the cells in a worksheet, you'll be able to see at a glance which cells are over 5000. There are also rules that can mark the top 10 items, all cells that are below the average, cells that are within a certain date range, and many more. Watch the video to learn about creating conditional formatting If you are interested in learning more about this topic, please visit our site to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you've learned.

Published:
28/Feb/2011

Excel VBA Macro by HalogenCorporation.avi

Title:
Excel VBA Macro by HalogenCorporation.avi


Video:


Description:visualize the power of Excel VBA macros to automate your data analysis by extracting, transforming and manipulating data to turn it into meaningful information, glean insights and make informed decisions.

Published:
28/Feb/2011

Sunday 27 February 2011

VBA - Excel Sum Function in VBA Code

Title:
VBA - Excel Sum Function in VBA Code


Video:


Description:We create a VBA function called SumCode() that does the same thing the Sum Function does in excel to illustrate how functions work in VBA Function SumCode(rng As Range) sumx = 0 For Each cell In rng sumx = sumx + cell.Value Next SumCode = sumx End Function

Published:
28/Feb/2011

Programa: EcB-Vanos -0- EcObO - Visual lisp - Programación Autocad

Title:
Programa: EcB-Vanos -0- EcObO - Visual lisp - Programación Autocad


Video:


Description:Programa para arquitectura e ingeniería que ayuda en la creación de cuadros de vanos para puertas y ventanas, además proporciona una opción para la exportación de los cuadros de vanos generales a Excel; el formato final en Excel esta adecuado para ser incluido en los metrados o computo de materiales; excelente programa para Arquitectos e Ingenieros dedicados al ramo de la construcción. Un saludo a todos los que ven este video Dios les bendiga EcObO Tema: Presentación del programa EcB-Vanos Nombre del Programa: EcB-Vanos Versión: 1.0 Ámbito de aplicación: Arquitectura e Ingeniería civil Entorno: Autocad Lenguaje utilizado: Visual Lisp y Auto Lisp Autor: Edison Condori Boza - EcObO Correo electrónico: ecobo24@hotmail.com Dirección de descarga: www.4shared.com Razón: La razón por la que comparto este programa es porque los tiempos en la construcción y cualquier tipo de trabajo son siempre un obstáculo con muchas malas consecuencias a nivel macro, pero que podemos aprender a acortar con inteligencia, espero de corazón que mis compatriotas y tu también al usar este programa le den un buen uso ya seguir adelante amigos. Dios les bendiga EcObO

Published:
28/Feb/2011

Macro Guardar Nombre.avi

Title:
Macro Guardar Nombre.avi


Video:


Description:Pedir nombre al usuario y guardar resultado en una celda

Published:
28/Feb/2011

Ejercicio capítulo 9.mp4

Title:
Ejercicio capítulo 9.mp4


Video:


Description:Este es un ejercicio propuesto sobre el capítulo 9 de los formularios.

Published:
28/Feb/2011

Software para entrenadores personales IntelliTrainer.avi

Title:
Software para entrenadores personales IntelliTrainer.avi


Video:


Description:El software para entrenadores personales IntelliTrainer le permitirá sistematizar y administrar bases de datos de ejercicios, programas de entrenamiento; podrá planificar programas de entrenamiento, consultar informes estadísticos, calcular adipométricas y somatotipos corporales automáticamente, entre muchas otras funcionalidades. Puedes consultar mayor información en www.macrogym.com

Published:
27/Feb/2011

Saturday 26 February 2011

Tablas dinámicas y Macros - Excel 2010

Title:
Tablas dinámicas y Macros - Excel 2010


Video:


Description:

Published:
27/Feb/2011

Thursday 24 February 2011

Excel tutorial for growth accounting

Title:
Excel tutorial for growth accounting


Video:


Description:Excel tutorial on how to construct a capital series and how to do growth accounting with the Kehoe and Prescott method (part 2 of 2)

Published:
24/Feb/2011

Tuesday 22 February 2011

Excel 6.mp4

Title:
Excel 6.mp4


Video:


Description:Pequeña explicación de manejo de macros en excel

Published:
23/Feb/2011

Numbering Raffle Tickets in Microsoft Word 2010

Title:
Numbering Raffle Tickets in Microsoft Word 2010


Video:


Description:This video tutorial demonstrates how easy it is to automatically number raffle tickets in Microsoft Word. Simply download a raffle tickets template, download our number series file, and Mail Merge to create the ticket numbers. Files used in this video can be found through the link below www.desktopsupplies.com For a text version of this tutorial or Microsoft Word 2003 Tutorial visit www.desktopsupplies.com

Published:
22/Feb/2011

Monday 21 February 2011

Driving Distance and Time Calculations in an Excel Template

Title:
Driving Distance and Time Calculations in an Excel Template


Video:


Description:www.cdxtech.com - Calculate driving distance, driving time, cost, and total trip duration in a Microsoft Excel template.

Published:
21/Feb/2011

Microsoft Excel Training (Part 5 of 5)

Title:
Microsoft Excel Training (Part 5 of 5)


Video:


Description:Stratus Marketplace course: Microsoft Excel Training Video - Delete Macro stored in personal workbook

Published:
21/Feb/2011

Sunday 20 February 2011

base de datos de simpatizantes

Title:
base de datos de simpatizantes


Video:


Description:TUTORIAL BASE DE DATSO

Published:
21/Feb/2011

ISM Tutorial Blog 2 - Excel Macro Recording Part 2

Title:
ISM Tutorial Blog 2 - Excel Macro Recording Part 2


Video:


Description:

Published:
21/Feb/2011

ISM Tutorial Blog 2 - Excel Macro Recording Part 1

Title:
ISM Tutorial Blog 2 - Excel Macro Recording Part 1


Video:


Description:

Published:
21/Feb/2011

How to Create a Code128C Barcode in Excel using VBA

Title:
How to Create a Code128C Barcode in Excel using VBA


Video:


Description:The tutorial explains how to create a Code 128C barcode in Excel 2010 using the IDAutomation VBA. For the written tutorial, please visit: www.idautomation.com For UPCa, use =UPCa(cell location) For UPCe, use =UPCe(cell location) For Interleaved 2 of 5, use =I2of5(cell location) For POSTNET, use =POSTNET(cell location) For Intelligent Mail, use =IntelligentMail(cell location) For Code128 A, use =Code128A(cell location) For Code128 B, use =Code128B(cell location) For Code128 C, use =Code128C(cell location) For Code128 Auto, use =Code128(cell location) ***NEW EXCEL and WORD ADD-IN AVAILABLE*** To QUICKLY CREATE BARCODES, please use our EXCEL-WORD ADD-IN. This free tool allows you to select a barcode option to encode and select the barcode font. It is for Windows users creating barcodes in Excel or Word. Word Video: www.youtube.com Excel Video : www.youtube.com Written Tutorial and Add In Download: www.idautomation.com is a tutorial for creating barcodes in Microsoft Excel using IDAutomation's Barcode Fonts and Barcode Macro's.

Published:
21/Feb/2011

How to Create a Code128B barcode in Excel using VBA

Title:
How to Create a Code128B barcode in Excel using VBA


Video:


Description:The tutorial explains how to create a Code 128B barcode using the IDAutomation VBA in Excel 2010. For the written tutorial, please visit: www.idautomation.com For UPCa, use =UPCa(cell location) For UPCe, use =UPCe(cell location) For Interleaved 2 of 5, use =I2of5(cell location) For POSTNET, use =POSTNET(cell location) For Intelligent Mail, use =IntelligentMail(cell location) For Code128 A, use =Code128A(cell location) For Code128 B, use =Code128B(cell location) For Code128 C, use =Code128C(cell location) For Code128 Auto, use =Code128(cell location) ***NEW EXCEL and WORD ADD-IN AVAILABLE*** To QUICKLY CREATE BARCODES, please use our EXCEL-WORD ADD-IN. This free tool allows you to select a barcode option to encode and select the barcode font. It is for Windows users creating barcodes in Excel or Word. Word Video: www.youtube.com Excel Video : www.youtube.com Written Tutorial and Add In Download: www.idautomation.com is a tutorial for creating barcodes in Microsoft Excel using IDAutomation's Barcode Fonts and Barcode Macro's.

Published:
21/Feb/2011

EXCEL - TICKBOX (case à cocher)

Title:
EXCEL - TICKBOX (case à cocher)


Video:


Description:La tickbox (case à cocher) permet de générer des scénarios à la volée en activant/désactivant le paramètre d'une équation.

Published:
21/Feb/2011

Vba excel: boton de opcion(option button) - www.ofimaticaparatorpes.com

Title:
Vba excel: boton de opcion(option button) - www.ofimaticaparatorpes.com


Video:


Description:ejemplo de cómo funciona un control de tipo "option button" o "boton de opcion" en vba aplicado a Excel.

Published:
20/Feb/2011

Friday 18 February 2011

Ficha Programador en excel 2010

Title:
Ficha Programador en excel 2010


Video:


Description:Muestra como obtener la ficha programador en MO Excel.

Published:
19/Feb/2011

Secuencias de comandos SCRIPT para AutoCAD y el uso de plantillas en Excel

Title:
Secuencias de comandos SCRIPT para AutoCAD y el uso de plantillas en Excel


Video:


Description:Este video tutorial te mostrará paso a paso, mediante dos ejemplos, como crear un SCRIPT para AutoCAD, haciendo uso de plantillas en Excel. Los archivos utilizados los podrás obtener desde www.construcgeek.com

Published:
18/Feb/2011

Truco Excel : Poner un botón de opción en Excel

Title:
Truco Excel : Poner un botón de opción en Excel


Video:


Description:www.ceparker.com En este truco de la semana vamos a ver como insertar un botón de opción en Excel office. Síguenos en Facebook: www.facebook.com

Published:
18/Feb/2011

Thursday 17 February 2011

24-Excel Formula In Urdu Hindi by apniclass.com

Title:
24-Excel Formula In Urdu Hindi by apniclass.com


Video:


Description:www.apniclass.com Video Tutorials in Urdu MS-Excel, MS-Word, MS-PowerPoint Corel Draw, Macromedia Free Hand Mx, 3D Studio Max, Java Scripting, PHP Scripting Forum for chatting , Updated price list of computer and accessories. and much more

Published:
17/Feb/2011

16-Tools Menu Create Macro Excel In Hindi Urdu by apniclass.com

Title:
16-Tools Menu Create Macro Excel In Hindi Urdu by apniclass.com


Video:


Description:www.apniclass.com Video Tutorials in Urdu Urdu Video Tutorials MS-Excel, MS-Word, MS-PowerPoint Corel Draw, Macromedia Free Hand Mx, 3D Studio Max, Java Scripting, PHP Scripting Forum for chatting , Updated price list of computer and accessories. and much more

Published:
17/Feb/2011

Tuesday 15 February 2011

Excel 2007 Overview Guide - Part 3 - The Ribbon (Data, Review, View & Contextual Tabs)

Title:
Excel 2007 Overview Guide - Part 3 - The Ribbon (Data, Review, View and Contextual Tabs)


Video:


Description:Provides an overview of The Ribbon in Excel 2007. This includes the following tabs: Data Tab Review Tab View Tab Contextual Tabs I cover each tab in detail, highlighting the options contained in each section. Visit me at Spreadsheet Republic for more Guides, Videos and Spreadsheet Templates.

Published:
16/Feb/2011

Importing data into Excel 2007 from Databases and Websites

Title:
Importing data into Excel 2007 from Databases and Websites


Video:


Description:From the Journal of Accountancy June 2009 by Rayman D Mersevy, Nicholas L Ball, and Marshall B Romney. This tutorial will help you understand and demonstrate how to import data from websites and databases into excel. Importing data will help you better analyze it in excel with pivot tables and sort functions.

Published:
16/Feb/2011

Spreadsheet Safety

Title:
Spreadsheet Safety


Video:


Description:Excel 2007 video tutorial on a Journal of Accountancy article from November 1998 by Jennifer Kreie and John Pendley about ensuring a safe spreadsheet design including how to password protect cells and worksheets.

Published:
16/Feb/2011

Habilitar la ficha del programador en Excel 2007

Title:
Habilitar la ficha del programador en Excel 2007


Video:


Description:Esta es una opción la cual permite al usuario tener más a la mano las opciones "avanzadas de excel" tales como las macros, el editor VBA, referencias relativas, insertar controles, formularios, paquetes de expansión, etc.

Published:
15/Feb/2011

INSTRUCTIVO DV 302.avi

Title:
INSTRUCTIVO DV 302.avi


Video:


Description:tutorial para el manejo de DV 302 software generador masivo de digitos de verificacion

Published:
15/Feb/2011

Monday 14 February 2011

Access 2010 tutorial: How to filter data | lynda.com

Title:
Access 2010 tutorial: How to filter data | lynda.com


Video:


Description:This Access 2010 tutorial shows several ways to filter form data. Watch more at www.lynda.com This specific tutorial is just a single movie from chapter one of the Access 2010 Power Shortcuts course presented by lynda.com author Alicia Katz Pollock. The complete Access 2010 Power Shortcuts course has a total duration of 3 hours and 43 minutes, and includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Access 2010 Power Shortcuts table of contents: Introduction 1. Top Tips 2. File Management 3. Ribbon and Quick Access Toolbar Tips 4. Interface Shortcuts 5. Navigation Shortcuts 6. Data Entry and Editing Shortcuts 7. Table Techniques 8. Relationship Techniques 9. Query Techniques 10. Form Techniques 11. Report Techniques 12. Formatting Shortcuts 13. Macro and Event Techniques 14. Database Management Techniques Conclusion

Published:
15/Feb/2011

How to use Input Masks in Access 2007 | lynda.com tutorial

Title:
How to use Input Masks in Access 2007 | lynda.com tutorial


Video:


Description:This Access 2007 tutorial shows how to work with Input Masks to create standardized formats. Watch more at www.lynda.com This specific tutorial is just a single movie from chapter one of the Access 2007 Power Shortcuts course presented by lynda.com author Alicia Katz Pollock. The complete Access 2007 Power Shortcuts course has a total duration of 3 hours and 25 minutes, and includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Access 2007 Power Shortcuts table of contents: Introduction 1. Top Tips 2. File Management 3. Ribbon and Quick Access Toolbar Tips 4. Interface Shortcuts 5. Navigation Shortcuts 6. Data Entry and Editing Shortcuts 7. Table Techniques 8. Relationship Techniques 9. Query Techniques 10. Form Techniques 11. Report Techniques 12. Formatting Shortcuts 13. Macro and Event Techniques 14. Database Management Techniques Conclusion

Published:
15/Feb/2011

Friday 11 February 2011

SQLite 03: Importing EXCEL into SQLite

Title:
SQLite 03: Importing EXCEL into SQLite


Video:


Description:In this tutorial you learn how to import an EXEL Spreadsheet into SQLite including the correct column names and assigning a primary key.

Published:
12/Feb/2011

Thursday 10 February 2011

Cronograma do Projeto

Title:
Cronograma do Projeto


Video:


Description:Planilha e Gráfico do cronograma de um projeto. Aula de como montar no Excel uma planilha com um gráfico que se torna a representação do cronograma de um projeto, muito útil para trabalhos acadêmicos e apresentações profissionais.

Published:
11/Feb/2011

Wednesday 9 February 2011

Microsoft Excel - If Then Equation Tutorial with School Grades -Mouseflip

Title:
Microsoft Excel - If Then Equation Tutorial with School Grades -Mouseflip


Video:


Description:

Published:
10/Feb/2011

VBA Utilizando Application.Visible

Title:
VBA Utilizando Application.Visible


Video:


Description:Pequeno tutorial que ensina como utilizar a propriedade visible para ocultar o excel

Published:
09/Feb/2011

Tuesday 8 February 2011

Beyond Excel: Animating a Logo in Excel w/VBA

Title:
Beyond Excel: Animating a Logo in Excel w/VBA


Video:


Description:Animate you company's logo using Excel and VBA. Download the code at: dl.dropbox.com

Published:
09/Feb/2011

Beyond Excel:Add Drilldown to Excel Charts Part 1 Before_DoubleClick Event

Title:
Beyond Excel:Add Drilldown to Excel Charts Part 1 Before_DoubleClick Event


Video:


Description:Part 1 Shows how one line of VBA code adds drilldown to any PivotChart. Download code at: dl.dropbox.com Part 2 Improves on Part 1's "quick and dirty" approach by adding formatting and keeping all drilldown results to just one worksheet (where as Excel's Pivot Table drilldown adds a new worksheet for each drilldown event).

Published:
09/Feb/2011

How to Change the X and Y axis in Excel 2007 when Creating Supply and Demand Graphs

Title:
How to Change the X and Y axis in Excel 2007 when Creating Supply and Demand Graphs


Video:


Description:Footnotes: Turn up your volume (it's low, sorry) Simple example shown first then 3 column Column A is normally the X axis (horzizontal) Column B is normally the Y axis (vertical) Description: This video will show you how to change/switch the X and Y axis. This video will also show you how to make supply and demand 3 column scatter graph in Excel 2007.This method will manly help you in microeconomics.

Published:
09/Feb/2011

Excel Macro Tutorial - The Digital Sea Cow

Title:
Excel Macro Tutorial - The Digital Sea Cow


Video:


Description:Here I show a quick way to highlight cells using recorded macros.

Published:
09/Feb/2011

VBA and Macros 2010- Tint and Shade: Podcast #1336

Title:
VBA and Macros 2010- Tint and Shade: Podcast #1336


Video:


Description:Today, in Episode #1336, Bill discusses the new color themes in Excel 2010. The new themes come with six (6) accent colors - but today, Bill shows us how to take those six theme colors and turn them into 1200 colors using Tint and Shade.

Published:
08/Feb/2011

Monday 7 February 2011

Excel Developer Tab Tutorial - The Digital Sea Cow

Title:
Excel Developer Tab Tutorial - The Digital Sea Cow


Video:


Description:In this tutorial I show how to locate/show the Developer tab in Excel 2010 and then show the basic features of the tab.

Published:
08/Feb/2011

Saturday 5 February 2011

Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

Title:
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)Video:


Description:Download files at: people.highline.edu The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. PivotTables are easy: Just envision the table in advance 2. Field list has fields and areas that you can drag fields to 3. Column Labels -- Column Headers 4. Row Labels -- Row Headers 5. Value Area -- this is where the calculation goes 6. Cross tabulation (row label and column label) 7. Double Click to create new sheet with data 8. Filter area -- filters whole report 9. Slicers 10. Value Field Settings Dialog box 11. Number Format For Value Field in Value Field Settings Dialog box 12. SUM function 13. Change Function in Value Field Settings Dialog box 14. Average Function 15. Format PivotTable 16. Layout For PivotTable 17. Multiple calculations: just drop field into value area multiple times and change function 18. Change Field Names in Value Field Settings Dialog box 19. Frequency Table to Count 20. Group By Dates

Published:
06/Feb/2011

Friday 4 February 2011

Learn Excel - "Map Data": Podcast #1335

Title:
Learn Excel - "Map Data": Podcast #1335


Video:


Description:Today, in Episode #1335, Lisa Marie asks if you can get Excel data on to a map. In this episode, Bill shows us how to create a Shaded Region Map using Microsoft MapPoint "Excel 2010 In Depth", by Bill Jelen aka MrExcel.

Published:
04/Feb/2011

Thursday 3 February 2011

Excel 2010 Tutorial HD Charts

Title:
Excel 2010 Tutorial HD Charts


Video:


Description:

Published:
03/Feb/2011