Tutorial Excel: cómo rellenar los espacios en blanco

Title:
Tutorial Excel: cómo rellenar los espacios en blanco


Video:


Description:www.ceparker.com Tutorial excel, en este truco vamos a aprender a rellenar los espacios en blanco, manteniendo el valor entrado. Síguenos en Facebook www.facebook.com

Published:
30/Dec/2010

COMO CRIAR SUA TABELA no Excel 2007 RAPIDO E FACIL. DO JEITO MAIS SIMPLES.

Title:
COMO CRIAR SUA TABELA no Excel 2007 RAPIDO E FACIL. DO JEITO MAIS SIMPLES.


Video:


Description:APRENDA, A CRIAR SUA TABELA DO JEITO MAIS SIMPLES E RAPIDO.

Published:
30/Dec/2010

Lezione di visual basic con Snake - Creare una calcolatrice a 17 pulsanti.wmv

Title:
Lezione di visual basic con Snake - Creare una calcolatrice a 17 pulsanti.wmv


Video:


Description:In questo video tutorial con il visual basic impareremo a creare la calcolatrice con codici di programmazione, se volete copiarvi i codici eccoli elencati: Per il form subito dopo la scritta Pubblicclass form 1: Dim a, b As Double Dim op As String Per i pulsanti numerati da 0 a 9 il seguente: textbox1.text=textbox1.text+ "1" cambiare solo il numero nelle virgolette ad ogni pulsante per programmarlo Pulsante addizione a = CDbl(TextBox1.Text) op = "+" TextBox1.Text = "" Pulsante sottrazione: a = CDbl(TextBox1.Text) op = "-" TextBox1.Text = "" Pulsante moltiplicazione: a = CDbl(TextBox1.Text) op = "*" TextBox1.Text = "" Pulsante divisione: a = CDbl(TextBox1.Text) op = "/" TextBox1.Text = "" Pulsante uguale =: b = CDbl(TextBox1.Text) Select Case op Case "/" TextBox1.Text = a / b Case "*" TextBox1.Text = a * b Case "+" TextBox1.Text = a + b Case "-" TextBox1.Text = a - b End Select Pulsante esci: close

Published:
30/Dec/2010

Tutorial ¿como desbloquear paginas de excel?

Title:
Tutorial ¿como desbloquear paginas de excel?


Video:


Description:Este es el codigo: Sub breakit() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer On Error Resume Next For i = 65 To 66 For j = 65 To 66 For k = 65 To 66 For l = 65 To 66 For m = 65 To 66 For i1 = 65 To 66 For i2 = 65 To 66 For i3 = 65 To 66 For i4 = 65 To 66 For i5 = 65 To 66 For i6 = 65 To 66 For n = 32 To 126 ActiveSheet.UnprotectChr(i) and Chr(j) and Chr(k) and _ Chr(l) and Chr(m) and Chr(i1) and Chr(i2) and Chr(i3) and _ Chr(i4) and Chr(i5) and Chr(i6) and Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox "One usable password is " and Chr(i) and Chr(j) and _ Chr(k) and Chr(l) and Chr(m) and Chr(i1) and Chr(i2) and Chr(i3) _ and Chr(i4) and Chr(i5) and Chr(i6) and Chr(n) Exit Sub End If Next Next Next Next Next Next Next Next Next Next Next Next End Sub Importante: Guarda y luego ejecuta. El codigo no es el escrito por el usuario es solamente el respaldo de archivo

Published:
27/Dec/2010

Solve system of linear equations using Excel matrix functions

Title:
Solve system of linear equations using Excel matrix functions


Video:


Description:Lecture for students of College Algebra on systems of linear equations

Published:
25/Dec/2010

Automatically Copy Excel Data to Other Sheet

Title:
Automatically Copy Excel Data to Other Sheet


Video:


Description:www.contextures.com In Excel 2010 or Excel 2007, follow these steps to use an advanced filter to automatically copy data from a table, onto anther sheet in the workbook. Watch this video to see how to set up a criteria area, and an extract area, and pull the top orders to a different sheet.

Published:
24/Dec/2010

Excel 2007 Solver ejemplo sencillo

Title:
Excel 2007 Solver ejemplo sencillo


Video:


Description:Aprendemos a manejar la potente herramienta de análisis Solver. Utilizamos Solver para simular un pedido.

Published:
23/Dec/2010