Tuesday 30 June 2009

144 Videos EXCEL UNI 2007 AVANZADO para aprender en CASA con Certificacion CEPS UNI OFIMATICA

Title:
144 Videos EXCEL UNI 2007 AVANZADO para aprender en CASA con Certificacion CEPS UNI OFIMATICA


Video:


Description:www.peruviantec.blogspot.com autocad uni cursos uni cursos en la uni ceps uni autocad en la uni infouni.edu.pe carreras para estudiar uni autocad infouni.edu.pe ceps uni cursos libres ceps uni peru lenguaje php modelamiento de sistemas estudiar autocad excel uni videotutoriales solidworks...

Published:
30/Jun/2009

Excel 2003 Tutorial Lookup Functions Microsoft Training Lesson 30.2

Title:
Excel 2003 Tutorial Lookup Functions Microsoft Training Lesson 30.2


Video:


Description:Learn how to use lookup functions in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. www.teachucomp.com - the most comprehensive Excel tutorial available. Visit us today!

Published:
30/Jun/2009

Excel 2003 Tutorial Managing Multiple Woorkbooks Microsoft Training Lesson 2.12

Title:
Excel 2003 Tutorial Managing Multiple Woorkbooks Microsoft Training Lesson 2.12


Video:


Description:Learn how to manage multiple workbooks in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. www.teachucomp.com - the most comprehensive Excel tutorial available. Visit us today!

Published:
30/Jun/2009

Monday 29 June 2009

Web Scraping a Search Results Page with OutWit Hub Data Extractor

Title:
Web Scraping a Search Results Page with OutWit Hub Data Extractor


Video:


Description:A tutorial on how to (1) scrape a search engine results page using (2) a custom scraper created with OutWit Hub data extractor, and (3) export to an Excel spreadsheet. Companion blog post at www.marketing2oh.com shows how to create basic scrapers for Google, Yahoo and Bing.

Published:
30/Jun/2009

Excel & Statistics 49: Outliers & Box Plot with Median and Mean

Title:
Excel and Statistics 49: Outliers and Box Plot with Median and Mean


Video:


Description:See how to find Outliers with the +/- 3 Z-score rule and the ABS function. See how to do a Box Plot by hand and in Excel. For the Excel Box Plot see how to record MIN, QUARTILE 1, MEDAIN, QUARTILE 3, MAX, AVERAGE on a Stacked Bar Chart with the mean added as an XY Scatter. Also see the CHAR 10 function to create label for BOX PLOT.Chapter 03 Busn 210 Business and Economic Statistics and Excel Class. Descriptive Statistics Numerical Measures This is a beginning to end video series for the Business and Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin

Published:
30/Jun/2009

Saturday 27 June 2009

Diario Simplificado V2.00 en Excel

Title:
Diario Simplificado V2.00 en Excel


Video:


Description:Para mayor información www.excelnegocios.com Version Final de la aplicacion en excel para el llenado de este formato del libro diario Simplificado. PUEDES CONTACTARME A: excelparacontadores@hotmail.com Celular: 970982933 Rpm: #265789 Atte: Gustavo A. Sebastiani Cépeday para cualquier informe G_sebastiani@hotmail.com celular: 949898944

Published:
28/Jun/2009

EXCEL 2007 AVANZADO UNI en VIDEOS para CASA con Certificacion

Title:
EXCEL 2007 AVANZADO UNI en VIDEOS para CASA con CertificacionVideo:


Description:www.peruviantec.blogspot.com Windows XP vista Word 2007 Excel 2007 Powerpoint Access Autocad Solidworks Cosmosworks Flash CS4 Action Script Dreamweaver Fireworks PHP CorelDraw X4 Photoshop CS4 Ilustrator Indesign 3D Studio Max 2009 Premiere Director after effects FruityLoops FL Studio Mezcladores Editores Reparación y Ensamplaje de Computadoras Diagnostico y Configuracion Electronica Basica Mantenimiento y Reparación Redes y Conectividad Protocolos TCP IP Windows 2003 Server 2008peruviantec ceps uni cepsuni infouni unimaster sistemasuni sisuni estudiar en casa estudia en casa cursos uni trilce roma salaverry chorrillos breña comas marsano los olivos miraflores faucett san miguel

Published:
27/Jun/2009

my Rapid Meter tool

Title:
my Rapid Meter tool


Video:


Description:This is a macro that exports measures from Autocad to Excel. Macro per esportare misure da Autocad ad Excel. Macro para exportar mediciones desde Autocad a Excel. È una applicazione realizzata con Visual Basic for Application, lavora in due modi: generando un file csv contenente area e lunghezza di ogni oggetto selezionato oppure generando un foglio di calcolo excel dove è possibile inserire del testo, misurare superfici e lunghezze, in pratica è utilizzabile per fare un computo metrico direttamente da Autocad.

Published:
27/Jun/2009

Friday 26 June 2009

MXI Plugin™ - SAS Analytics Delivered to Microsoft Office

Title:
MXI Plugin™ - SAS Analytics Delivered to Microsoft Office


Video:


Description:MXI Plugin™ is a software that Deliver SAS Reports and Data to Excel Users, User Friendly Office Interface for Parameter Selection without Programming, Capture Real Time Data from SAS Directly from Excel or Word, Does not Require SAS on Client or other SAS Modules on Server Deliver Power of SAS to MS Office Any SAS macros, programs or data can be delivered to MS Excel and MS Word. By simply registering the programs or SAS libraries, you can make this available to specified users who connect via standard TCP network protocols and results are delivered into a spreadsheets or MS Word documents. This is executed in real time so the user gets always the latest data. User Friendly Users do not need to be SAS programmers since the parameters of the SAS Macros are delivered as selection boxes and pull down menus. The standard familiar MS Office interface is now the front end to customized powerful analytical summary reports from a SAS server. The registration of SAS programs, data and definition of parameters is flexible with a user interface or a macro interface. Cost Effective MXI Plugin minimum requirement is BASE SAS running on the server. The user machine within the same organization which accesses the SAS data only requires MS Office such as Excel. This is therefore a cost effective, elegant yet powerful solution.

Published:
27/Jun/2009

How to Add Hyperlinks to a PowerPoint Presentation For Dummies

Title:
How to Add Hyperlinks to a PowerPoint Presentation For Dummies


Video:


Description:Putting hyperlinks into PowerPoint presentations links a slide to another slide in the same or another presentation, or to a Web site, an e-mail address, or another file. This PowerPoint video shows you how to insert a hyperlink into your next slide show.

Published:
26/Jun/2009

How to Create Macros in Word 2007 For Dummies

Title:
How to Create Macros in Word 2007 For Dummies


Video:


Description:Writing macros in Office Word 2007 gives you free shortcuts to make your word processing life easier. Tips in this video for creating, recording, and editing macros streamline the process of developing and editing Word documents.

Published:
26/Jun/2009

Wednesday 24 June 2009

OpenOffice Calc - Tutorial - Removing Duplicate Data (Deduping) by Phillip J Rhoades

Title:
OpenOffice Calc - Tutorial - Removing Duplicate Data (Deduping) by Phillip J Rhoades


Video:


Description:youtube.com Check out my HowToPhil channel for more tutorials This is a tutorial for OpenOffice Calc openoffice.org showing how to remove duplicate data (deduping) by Phillip J Rhoades http Video recorded in gtk-RecordMyDesktop recordmydesktop.sourceforge.net Editing in Blender http Synfig synfig.org and Avidemux http

Published:
24/Jun/2009

Saturday 20 June 2009

mengatur ukuran kertas folio pada excel

Title:
mengatur ukuran kertas folio pada excel


Video:


Description:video tutorial mengatur/membuat ukuran kertas folio pada microsoft excel

Published:
20/Jun/2009

Thursday 18 June 2009

FÓRMULAS BÁSICAS "SI" EN EXCEL / CONDICIONALES PARTE 2

Title:
FÓRMULAS BÁSICAS "SI" EN EXCEL / CONDICIONALES PARTE 2


Video:


Description:Parte 2 de los 8 ejercicios, fórmulas básicas en excel de la condicional "Si"

Published:
19/Jun/2009

OriginLab® Origin 8: Copy Excel Data and Paste to Origin 8

Title:
OriginLab® Origin 8: Copy Excel Data and Paste to Origin 8


Video:


Description:Learn how to copy Excel data and paste it into Origin 8 in the correct format.

Published:
18/Jun/2009

Wednesday 17 June 2009

Drop-Down List with OpenOffice.org Calc

Title:
Drop-Down List with OpenOffice.org CalcVideo:


Description:Video tutorial guide on how to use OpenOffice.org Calc to make drop-down list. orgcalcdroplist.blogspot.com

Published:
17/Jun/2009

Thursday 11 June 2009

Excel Tutorial - Number of Work Days Between Two Dates - Custom VBA Function

Title:
Excel Tutorial - Number of Work Days Between Two Dates - Custom VBA Function


Video:


Description:In this tutorial, I will show you how to calculate the number of working days (MF) between two dates. I'll use the NETWORKDAYS function to exclude Saturdays, Sundays, and holidays. Then, I'll show you how to create a custom VBA function to exclude any days you want. Let's say you work Mon thru Sat, but not Sun. This function will cover that.

Published:
12/Jun/2009

Recording Macros in Excel

Title:
Recording Macros in Excel


Video:


Description:This video demonstrates how to record a macro in Excel. This is an excellent way to automate repetitive tasks. The video can also be accessed at blanchard.ep.wisc.edu These videos were recorded for a course I teach as part of a distance masters degree. See mepp.engr.wisc.edu

Published:
11/Jun/2009

Wednesday 10 June 2009

Excel Formulário 1-2

Title:
Excel Formulário 1-2


Video:


Description:Por que levar tão a sério o Excel? Brincando também se faz algo útil... veja neste vídeo um pequeno e rápido exemplo. ... visite WWW.LUCIOREZENA.COM.BR e adquira as video-aulas com matérias completas e interessantes.

Published:
11/Jun/2009

Fiscal Quarter UDF - 1033 - Learn Excel from MrExcel Podcast

Title:
Fiscal Quarter UDF - 1033 - Learn Excel from MrExcel Podcast


Video:


Description:If your fiscal year does not end on December 31, then all of the cool date grouping functions available in pivot tables will not work for you. In Episode 1033, you will see how to add a couple of user-defined functions to your personal macro workbook to simplify the conversion of date to Fiscal Quarter or Fiscal Year. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Published:
10/Jun/2009

Monday 8 June 2009

AutoCad VBA tool

Title:
AutoCad VBA tool


Video:


Description:Tool (VBA Macro) that exports several points from a function "x" (from AutoCad) into a table that you can open and work in excel.

Published:
09/Jun/2009

Saturday 6 June 2009

como crear una macro en excel

Title:
como crear una macro en excel


Video:


Description:en este video se muestra de la manera mas facil como crear una macro en el programa excel 2007

Published:
07/Jun/2009

Wednesday 3 June 2009

Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions

Title:
Excel Magic Trick 333: #DIV/0! Error IF and ISERROR or IFERROR functionsVideo:


Description:IF and ISERROR or IFERROR functions for errors? See how to fix errors with the Excel 2007 IFERROR and the Excel 2003 IF and ISERROR functions. See how to fix a divide by zero error. See the SUMPRODUCT function used to calculate monthly costs per contacts. IS functions, IF functions, Logical Test. Formula Errors.

Published:
03/Jun/2009

Generalize Recorded Macro - 1028 - Learn Excel from MrExcel

Title:
Generalize Recorded Macro - 1028 - Learn Excel from MrExcel


Video:


Description:While yesterday's podcast was created with the macro recorder, you can switch over to the VBA editor to change 4 lines of the macro. This will create a macro that will work without requiring you to rename the pivot table.Episode 1028 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Published:
03/Jun/2009

Tuesday 2 June 2009

How To Make a Game In Excel

Title:
How To Make a Game In Excel


Video:


Description:How to make a maze game in excel. You can have teleportation places, lava, enemies, doors, keys and more. I am just going to show you the basics. A lot if it is excplained in the website. If you are looking for the what the text box said... Go to www.gamedev.net Click on open my xls File. Do as I do From there. save as macro enabled excel sheet. I already have it saved, so it wont let me do it again. Make sure you change the maze up, or it is considered plagiarism. Keep the start spot and finish spot the same To make a wall, just draw a border. The blue ones are teleportation places. On the website it will explain that. you don't have to have them it just enhances the game. There are many other things you can add to the game like doors keys and enemies. This is just the basics. let me show you one I made. Oops I blocked the finish. I will go back and fix it later, but now you know how to make a maze.

Published:
03/Jun/2009

Format Pivot Macro - 1027 - Learn Excel from MrExcel Podcast

Title:
Format Pivot Macro - 1027 - Learn Excel from MrExcel Podcast


Video:


Description:Cheryl asks how to format all new pivot tables that she creates. The macro recorder can handle this, if you change the name of the pivot table before recording the macro.Episode 1027 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Published:
02/Jun/2009

Monday 1 June 2009

Automatically and Completely hide the Ribbon in Excel 2007 as soon as it opens - Macro

Title:
Automatically and Completely hide the Ribbon in Excel 2007 as soon as it opens - Macro


Video:


Description:www.TeachMsOffice.com This tutorial will show you how to completely hide the Ribbon menu system for Excel 2007. This shows you how to make the Ribbon disappear immediately after Excel 2007 opens. The tutorial will also show you a quick way to partially hide the Ribbon menu system in Excel 2007. In order to completely hide the Ribbon, you will need to write a macro, which is explained in detail in the video. This macro will go in the ThisWorkbook section and is really simple to make. This is a really neat trick to use in Excel when you want the Ribbon, the Office button, and the Mini toolbar to be completely gone. Toget the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http You can also visit the forum there if you have any questions. Have a great day!

Published:
02/Jun/2009

Completely hide the Ribbon in Excel 2007 - Macro

Title:
Completely hide the Ribbon in Excel 2007 - Macro


Video:


Description:www.TeachExcel.com This tutorial will show you how to completely hide the Ribbon menu system for Excel 2007. The tutorial will also show you a quick way to partially hide the Ribbon menu system in Excel 2007. In order to completely hide the Ribbon, you will need to write a macro, which is explained in detail in the video. This is a really neat trick to use in Excel when you want the Ribbon, the Office button, and the Mini toolbar to be completely gone. Toget the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http You can also visit the forum there if you have any questions. Have a great day!

Published:
02/Jun/2009

Use AutoCorrect in Excel 2007 - add/delete words from autocorrect. Tips/Tricks Vid 2

Title:
Use AutoCorrect in Excel 2007 - add/delete words from autocorrect. Tips/Tricks Vid 2


Video:


Description:www.TeachMsOffice.com This tutorial explains what AutoCorrect is and how it can be used in Excel 2007. This also shows you how to add and delete words from the AutoCorrect feature in Excel 2007. Toget the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http You can also visit the forum there if you have any questions. Have a great day!

Published:
02/Jun/2009

Hide scroll bars, sheet tabs, and charts, graphs, pictures, and objects in Excel 2007

Title:
Hide scroll bars, sheet tabs, and charts, graphs, pictures, and objects in Excel 2007


Video:


Description:www.TeachMsOffice.com This tutorial shows you some neat ways to make your spreadsheets idiot proof, sleeker looking, or simply to annoy a co-worker. This is the first video in a series which will show you neat tricks and tips regarding how to change the way Excel 2007 looks or operates. Toget the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http You can also visit the forum there if you have any questions. Have a great day!

Published:
02/Jun/2009

Highline Excel Class 52: Recorded Macro Basics

Title:
Highline Excel Class 52: Recorded Macro Basics


Video:


Description:Learn about: 1.How to Record a Macro 2.Macro = VBA code 3.Macros are great for repetitive tasks 4.What file extension to use for Excel 2007: .xlsm 5.How to show Developer Ribbon in Excel 2007 6.Relative and Absolute References in Excel Macros 7.Paste Special Values Absolute Macro 8.Paste Special Values Relative Macro 9.Learn about VBA editor window 10.View code for a Recorded Macro 11.View List of Macros 12.See the difference between Range(A1) and OFFSET(0,2) 13.Create an Income Statement Template with a Macro 14.See how to edit a Macro when you make a mistake This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Published:
02/Jun/2009

Highline Excel Class 54: Excel VBA code From Internet

Title:
Highline Excel Class 54: Excel VBA code From Internet


Video:


Description:Learn about: 1.Formatting a simple Static Report (Common Macro task in the working world) 2.Posting question to Mr Excel Message Board to get VBA code 3.Search Google for Excel VBA code 4.Copy code from internet and paste into VBA editor window 5.Open VBA editor 6.Insert VBA module 7.Insert Procedure in a Module 8.A Macro to separate Last Name, First Name and Middle Initial into separate cells 9.A User Define Function that will convert numbers to English words This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Published:
01/Jun/2009