Monday 30 November 2009

Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total

Title:
Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total


Video:


Description:See how to extract grant records with highest point value and only extract enough records collectively that are under the Total Funding Ceiling: 1.AND function for 2 criteria 2.Running Total Formula with SUM function and Range half relative and half absolute 3.Sort 4.Delete Columns 5.Macro Recorder 6.Advanced Filter

Published:
01/Dec/2009

Introduccion a como usar Word 2007

Title:
Introduccion a como usar Word 2007


Video:


Description:este video nos introduce a lo que seria word 2007 de microsoft office, sigan nuestros videos para que aprendan a utilizar los programas como verdaderos profesionales.

Published:
30/Nov/2009

Saturday 28 November 2009

Loading a model from EXCEL to CATIA V5

Title:
Loading a model from EXCEL to CATIA V5


Video:


Description:more information at : www.plmlab.fr

Published:
29/Nov/2009

Wednesday 25 November 2009

DoubleClick Fill Macro - 1152 - Learn Excel Video Podcast

Title:
DoubleClick Fill Macro - 1152 - Learn Excel Video Podcast


Video:


Description:Harold from Tulsa asked how to write a macro to simulate double-clicking the fill handle.Episode 1152 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:
25/Nov/2009

Tuesday 24 November 2009

Finance Basics 11 - Annuity Due Calculation in Excel - Present Value and Future Value

Title:
Finance Basics 11 - Annuity Due Calculation in Excel - Present Value and Future Value


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the Annuity Due in Excel. You will learn how to calculate the annuity due for the present value and future value functions in Excel. Annuity due simply means that any annuity payments are made at the end of the period instead of the default situation where annuity payments are made at the beginning of the period. This is a great tutorial for all of those just starting out in finance or for people who need to learn how to calculate an annuity due in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
25/Nov/2009

Finance Basics 12 - Perpetuity Calculation in Excel

Title:
Finance Basics 12 - Perpetuity Calculation in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate a perpetuity in Microsoft Excel. You will learn the mathematical formula for calculating a perpetuity as well as how to calculate a perpetuity using the PV() or present value function in Excel. This is a must see tutorial for people studying finance or those who need to understand perpetuity payments. Basically, a perpetuity is just a series of payments that is never ending or that goes out for a very long time into the future - such as a series of payments for the rest of a person's life. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
25/Nov/2009

Finance Basics 10 - Present Value Calculation With Intra Year Compounding of Interest in Excel

Title:
Finance Basics 10 - Present Value Calculation With Intra Year Compounding of Interest in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the present value of a security or investment which compounds interest at a rate more frequent than once per year. This is intra-year compounding. You will learn how to change the present value function in Excel in order to account for compounding interest on a monthly basis, quarterly basis, and semi-annual basis. This is a great tutorial for anyone needing to learn about finance. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
25/Nov/2009

Finance Basics 9 - Future Value Calculation With Intra-Year Compounding of Interest in Excel

Title:
Finance Basics 9 - Future Value Calculation With Intra-Year Compounding of Interest in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the future value of a security or investment that compounds on a basis more frequent that once a year. This is called intra-year compounding of interest. You will learn how to change the basic future value function and formula to account for compounding periods that are more frequent than just once a year. This is a great finance basics tutorial. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
25/Nov/2009

Finance Basics 8 - Future Value of a Principal Amount With Recurring Annuity Payments in Excel

Title:
Finance Basics 8 - Future Value of a Principal Amount With Recurring Annuity Payments in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the Future Value of a series of annuity payments in Microsoft Excel. You will learn what an annuity is and how to figure out the future value of that annuity. The main method you will learn to do this is the FV() or future value function in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
25/Nov/2009

Utilizar Macros em Microsoft Office Excel Automatizar tarefas repetitivas

Title:
Utilizar Macros em Microsoft Office Excel Automatizar tarefas repetitivas


Video:


Description:

Published:
24/Nov/2009

What is a macro?

Title:
What is a macro?


Video:


Description:A macro is a way to record and reuse oft entered text and more. A Internet tutorial by butterscotch.com.

Published:
24/Nov/2009

Excel Vba User form ile Listbox ve Combobox Uygulamaları

Title:
Excel Vba User form ile Listbox ve Combobox Uygulamaları


Video:


Description:Excel Vba User form ile Listbox ve Combobox Uygulamaları

Published:
24/Nov/2009

Monday 23 November 2009

How To Use MS Office (Navigating Excel Menu) Episode 1

Title:
How To Use MS Office (Navigating Excel Menu) Episode 1


Video:


Description:Hi, guys, my name is Hope, and I'm here to show you just a basic overview of the new 2007 Excel version. So, I'm going to show you where things are that you might have been looking for, and kind of some of the new things that are available now in this new version. So lets' get started. The first thing that I'm going to show you is what I like to call the fancy button. It's up here in the left hand corner. The reason I call it the fancy button is it just looks really pretty. If you click on this fancy button, that is actually your file menu. So if you've been looking for your "save as," that's where it's located. You're going to see a lot more options underneath the "save as" version. You're going to see that you can actually save it as a macro-enabled workbook, which we can get into later. Also, the older versions -- if someone doesn't have a conversion packet, you can save it as Excel 97/2003 workbook, and they'll be able to open it. So if you have any friends out there who are getting your Excel workbook and they can't open it, you can just save it in this version and then they'll be able to open it in their old way. Print button is also here, if you've been looking for that. Some other things that we can get into later are just some "prepare" options. And then "send," if you've ever sent any of your Excel workbooks as an attachment, you can just click on "e-mail" right here and it will open up your Outlook and send it as an attachment in your e-mail. Down here is ...

Published:
24/Nov/2009

Sunday 22 November 2009

Finance Basics 7 - Future Value Examples in Excel - How much something is worth in the future

Title:
Finance Basics 7 - Future Value Examples in Excel - How much something is worth in the future


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial presents 3 Future Value examples and shows you how to solve them using the FV() function in Excel. You will learn how to solve a basic simple future value problem; a simple annuities problem; and then an asset valuation problem. These are great examples to use to help learn and understand what future value means and how you can use it. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
23/Nov/2009

Finance Basics 6 - Present Value Examples in Excel - How much something is worth today.

Title:
Finance Basics 6 - Present Value Examples in Excel - How much something is worth today.


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial goes through 3 Present Value problems and shows you how to solve them using the PV() function in Excel. You will learn some of the basic applications for the present value function and also the different uses for this function. The three examples include how to figure out what a future amount is worth today; valuing annuity payments in the future for today; and how to value an asset with the present value function. This is a great tutorial for all of those just learning finance or for people who need to more accurately find the value of and asset or cash flow. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
23/Nov/2009

Saturday 21 November 2009

Finance Basics 5 - Learn Present Value and what it Means & Does

Title:
Finance Basics 5 - Learn Present Value and what it Means and Does


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial will explain what the Present Value concept means and how you can use it in Excel. You will learn the standard mathematical formula in order to calculate the present value as well as the Excel PV() function. This is a great tutorial for all finance majors or for people who simply need to learn and understand what present value is and means. The present value of anything is simply what the current value or worth of that item is today. In order to figure this out, you do need to know the annuity payments or future value of the item. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
22/Nov/2009

Finance Basics 4 - Calculating Annuities in Excel - Future Value for Annuities

Title:
Finance Basics 4 - Calculating Annuities in Excel - Future Value for Annuities


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the total future value of a series of annuity payments. This is a must for finance majors as well as people who need to know the future value of and series of payments which they may be receiving. This tutorial covers this basic finance concept and shows you how to solve annuity problems by hand in Excel and also using the fv() future value function in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
22/Nov/2009

Finance Basics 3 - Custom Compound Interest Function Made in Excel - Macro - Custom Functions

Title:
Finance Basics 3 - Custom Compound Interest Function Made in Excel - Macro - Custom Functions


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to create a custom Compound Interest Function in Excel. This is a UDF or User Defined Function. It is written within a macro in Excel. This tutorial will show you how to create compound interest future value function in Excel since there is no default compound interest function in Excel. This is a must view tutorial for people who often need to calculate the future value of a series of payments with compound interest. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
22/Nov/2009

Finance Basics 2 - Compound Interest in Excel

Title:
Finance Basics 2 - Compound Interest in Excel


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the future value of an investment with compounded interest. You will learn how to do this by hand in Excel and also how to use the mathematical formula for compounding interest in Excel. This two methods will equip you with the skills necessary to compute compound interest payments and total value for any given period of time and all within Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
22/Nov/2009

Thursday 19 November 2009

How to Record a Macro in Excel 2007 For Dummies

Title:
How to Record a Macro in Excel 2007 For Dummies


Video:


Description:Excel macros allow you to perform repetitive tasks quickly through a keyboard shortcut. This Excel video tutorial shows you how to record a simple macro to help automate your Excel 2007 tasks.

Published:
19/Nov/2009

How to Create a Data List in Excel 2007 For Dummies

Title:
How to Create a Data List in Excel 2007 For Dummies


Video:


Description:Creating a data list, or Excel table, can help you store a large amount of data consistently, as well as give you the ability to easily read, sort, and filter that information. This video tutorial shows you how to create a simple data list in Excel 2007.

Published:
19/Nov/2009

Wednesday 18 November 2009

Access 2007 and Microsoft Excel. Import Excel Data - YouTube stats - into MS Access.

Title:
Access 2007 and Microsoft Excel. Import Excel Data - YouTube stats - into MS Access.Video:


Description:Access 2007 and Microsoft Excel. Import Excel Data - YouTube stats - into MS Access.

Published:
19/Nov/2009

Excel Macro 2003

Title:
Excel Macro 2003


Video:


Description:

Published:
19/Nov/2009

Hacer macro con openoffice

Title:
Hacer macro con openofficeVideo:


Description:Como hacer una macro para imprimir un documento, mediante un boton en Openoffice.

Published:
18/Nov/2009

Importar datos a Excel crear conexion

Title:
Importar datos a Excel crear conexion


Video:


Description:Generar una conexión con una fuente externa a Excel, y emplearla para Importar datos

Published:
18/Nov/2009

Access 2007. Create Macro and add Macro to Form

Title:
Access 2007. Create Macro and add Macro to Form


Video:


Description:Access 2007. Create Macro and add Macro to Form

Published:
18/Nov/2009

Tuesday 17 November 2009

Trailer Excel VBA - video2brain

Title:
Trailer Excel VBA - video2brain


Video:


Description:www.video2brain.com Cette formation vidéo sadresse avant tout à ceux qui débutent en VBA et qui nont jamais programmé.

Published:
17/Nov/2009

Monday 16 November 2009

Excel Macro VBA Tip 26 - Stop Cancel or Close a Macro using VBA in Excel

Title:
Excel Macro VBA Tip 26 - Stop Cancel or Close a Macro using VBA in Excel


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to exit or stop a macro in the middle of the macro being run in Excel. This piece of code is a great feature to add to a macro where you need to check for errors or where you need to simply exit out of a macro if a certain condition has been met. This is a great little feature of VBA in Excel which will help to round out your Excel Macro writing skills. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
17/Nov/2009

Excel Formatting Tip 10 - Quickly Add Professional Formating to Spreadsheets and Cells in Excel

Title:
Excel Formatting Tip 10 - Quickly Add Professional Formating to Spreadsheets and Cells in Excel


Video:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to quickly and professionally format your spreadsheets in Excel. You will learn how to add cell styles using some of Excel 2007's new features in order to quickly change the appearance of cells in Excel. This tutorial will show you how to make a boring sales report look great and it won't take you much time at all. This is a great tutorial to view to learn some good formatting tips for Excel 2007. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
17/Nov/2009

Excel Lookup & Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel

Title:
Excel Lookup and Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial will show you how to use the VLOOKUP() function in Excel in order to return quantity discount prices from a table. This allows you to quickly return the prices for products based on the quantity of that product that is ordered. This tutorial shows you how to use the VLOOKUP() function in order to return an approximate match for numbers. The important thing to remember is that you will have to sort the numbers being searched in ascending order. This is a great tutorial for those looking to learn how to use the VLOOKUP() function in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
17/Nov/2009

Sunday 15 November 2009

filtros avanzados en excel 2003 ( trucos excel )

Title:
filtros avanzados en excel 2003 ( trucos excel )


Video:


Description:Como usar fltros avanzados en excel 2003, estos criterios de filtro son lo que no los explican en los cursos, ahora que estoy desempleado comportiré con vosotros alguna herramientas útile de excel usando ( trucos o atajos técnicos )

Published:
16/Nov/2009

MS Excel 2003 - How to edit macros

Title:
MS Excel 2003 - How to edit macros


Video:


Description:A description on how to do simple editing of your recorded macros.

Published:
16/Nov/2009

Friday 13 November 2009

Finance in Excel 9 - View Live News and Headlines for Publicly Traded Companies and Stocks in Excel

Title:
Finance in Excel 9 - View Live News and Headlines for Publicly Traded Companies and Stocks in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to import live headlines for stock and publicly traded companies into Excel. You will learn how to have the headlines update every minute so that the most recent information is available to you. This tutorial uses Yahoo finance to get the updated headlines. The useful feature of this tutorial on importing data into Excel is that the links to the actual articles will also import with the headlines. This means that if you want to learn more about the headline you can click a link in Excel and be taken to the actual article for that headline. This is a great tutorial to round out your abilities to track your stocks and portfolio in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
14/Nov/2009

Data Analysis in Excel 9 - Filter Data Based on The Frist, Last, or Middle Values in a Cell in Excel

Title:
Data Analysis in Excel 9 - Filter Data Based on The Frist, Last, or Middle Values in a Cell in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to Filter data in Excel based on the First, Last, or Middle Values in a cell. This covers some of the great Filter features in Excel. This tutorial will allow you to better view and analyze large data sets in Excel as well as to drill down content in Excel in order to view smaller subsets of a larger data set. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
13/Nov/2009

Data Analysis in Excel 8 - Import XML Maps and Pull Selected Columns Values into Excel

Title:
Data Analysis in Excel 8 - Import XML Maps and Pull Selected Columns Values into Excel


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to import an XML Map into Excel and then how to display selected information from that map within the spreadsheet or worksheet in Excel. This is a great tutorial for people who need to import XML files and data into Excel. Also, you will learn a simply good and useful technique for viewing the contents of an XML file within Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
13/Nov/2009

Thursday 12 November 2009

Data Analysis in Excel 7 - Quickly Import XML Files and Data into Excel

Title:
Data Analysis in Excel 7 - Quickly Import XML Files and Data into Excel


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to import XML files and data into Excel. You will learn how to import XML data formatted in the new Excel 2007 Table format as well as just formatted as plain text. This is a quick tutorial showing you how to import XML files into Excel but later tutorials will show you more tricks and tips for importing XML file data into Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
13/Nov/2009

Data Analysis in Excel 6 - Fix Broken Links in Excel and Check Data Connections to Other Files

Title:
Data Analysis in Excel 6 - Fix Broken Links in Excel and Check Data Connections to Other Files


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to diagnose, check, and repair external data connections between multiple workbooks in Excel. You will learn how to check the status of a connection to see if it needs to be repaired or updated and then how to search your computer to find the correct Excel workbook to which you need to link in order to fix the original workbook. This is a great tutorial to view if you often work with workbooks that reference external workbooks for information and you need help troubleshooting some problems. In essence, this tutorial teaches you how to edit the links within your workbooks. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
13/Nov/2009

Data Analysis in Excel 4 - Sort Large Data Sets to Display Ordered Information

Title:
Data Analysis in Excel 4 - Sort Large Data Sets to Display Ordered Information


Video:


Description:Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to Sort large data sets ...

Published:
13/Nov/2009

Data Analysis in Excel 5 - Remove Duplicate Entries from Data Sets in Excel

Title:
Data Analysis in Excel 5 - Remove Duplicate Entries from Data Sets in Excel


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to quickly and easily Remove Duplicates from Excel. This tutorial is specific to Excel 2007. You will learn how to remove duplicates based on one single criteria or column being checked for duplicates as well as by checking multiple columns for duplicates in Excel. This feature in Excel 2007 works great when you need to list only the unique values from a list or database. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
13/Nov/2009

Data Analysis in Excel 3 - Filter Large Data Sets to Display Only Specific Information

Title:
Data Analysis in Excel 3 - Filter Large Data Sets to Display Only Specific Information


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial teaches you how to Filter data sets in Excel 2007. You will learn how to use the new filter features in Excel. This allows you to refine data in Excel so that you only see what you need to see. Basically, it allows you to drill down through large data sets in order to display only a subset of that data so that you can more clearly find and analyze only the most important information. This tutorial teaches you how to filter based on only one criteria and how to filter based on multiple separate criteria all at the same time. This is a great tutorial for anyone who often works with large data sets in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
13/Nov/2009

Creare una tabella pivot in Excel

Title:
Creare una tabella pivot in Excel


Video:


Description:Vuoi sapere come usare al meglio le tabelle pivot di Excel? Guarda il breve video. Per vedere tutte le "pillole di tecnologia" di Microsoft PMI: pmi.microsoft.com

Published:
12/Nov/2009

Wednesday 11 November 2009

Microsoft Excel 2007 Tutorial - Get External Data - Stock Pricing

Title:
Microsoft Excel 2007 Tutorial - Get External Data - Stock Pricing


Video:


Description:You can use Excel 2007's new Get External Data feature to get data from other spreadsheets, other data sources like a Microsoft Access database, or even from a web site. I cover this feature in detail in my new Upgrading to Excel 2007 Seminar. This free video will show you how to get stock data from Yahoo Finance.

Published:
12/Nov/2009

Tuesday 10 November 2009

Excel Formatting Tip 9 - Freeze Panes & Prevent Headers from Moving in the Spreadsheet in Excel

Title:
Excel Formatting Tip 9 - Freeze Panes and Prevent Headers from Moving in the Spreadsheet in Excel


Video:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to Freeze Panes in Excel. This allows you to keep a header row or column within the spreadsheet always visible when you are scrolling down or across the spreadsheet. This is a great feature of Excel to use when working with large data sets, databases, employee lists, product lists, etc. where you have to do a lot of scrolling but still need to know what every column and row means and contains. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
11/Nov/2009

Excel Macro VBA Tip 23 - Put a Time Delay in Macros Pause a Macro for a Given Amount of Time Excel

Title:
Excel Macro VBA Tip 23 - Put a Time Delay in Macros Pause a Macro for a Given Amount of Time Excel


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial will show you how to create or write a piece of code in an Excel macro that will pause the macro. This will basically add a time-delay to the macro. That means that you can pause or stop the execution of a macro for a prescribed length of time. You will learn how to pause a macro for any number of seconds, minutes, and hours. This is a really cool thing you can do in an Excel macro and is easy to learn. You will also learn how to stop a paused macro as well as what happens when you pause a macro in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
11/Nov/2009

Excel Macro VBA Tip 22 - Open Workbooks with Excel Macros

Title:
Excel Macro VBA Tip 22 - Open Workbooks with Excel Macros


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to create or write a macro that will open another workbook on your computer. You will learn how to use this macro to open a single workbook on your computer as well as multiple workbooks on your computer. The method talked about here to open the workbooks can do a lot of really cool things to the just opened workbook. However, this tutorial serves as an introduction to this method and will show you only how to open other workbooks from a macro in Excel. Other tutorials will show you how to use the more complicated and powerful features. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
11/Nov/2009

Access 2003 Tutorial Crosstab Queries Microsoft Training Lesson 9.5

Title:
Access 2003 Tutorial Crosstab Queries Microsoft Training Lesson 9.5


Video:


Description:Learn how to use a crosstab query in Microsoft Access at www.teachUcomp.com. Get the complete tutorial FREE at www.teachucomp.com - the most comprehensive Access tutorial available. Visit us today!

Published:
11/Nov/2009

How To AutoCreate a Script for Minitab

Title:
How To AutoCreate a Script for Minitab


Video:


Description:One of the most interesting features of MTBEngine 2.5 version. Like Excel Record New Macro command. more info @ www.sixsigmain.it

Published:
10/Nov/2009

Monday 9 November 2009

Access 2007 Tutorial Assigning a Primary Key to a Table Microsoft Lesson 2.7

Title:
Access 2007 Tutorial Assigning a Primary Key to a Table Microsoft Lesson 2.7


Video:


Description:Learn how to assign primary keys in Microsoft Access at www.teachUcomp.com. Get the complete tutorial FREE at www.teachucomp.com - the most comprehensive Access tutorial available. Visit us today!

Published:
10/Nov/2009

Excel Tips 28 - Display The Current Time in Excel Down to the Second

Title:
Excel Tips 28 - Display The Current Time in Excel Down to the Second


Video:


Description:Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. How to display the current time in Excel using a function. Use t...

Published:
09/Nov/2009

Functions/Formulas in Excel 7 - Learn the IF Statement in Excel & Output Numbers, Text, and Formulas

Title:
Functions/Formulas in Excel 7 - Learn the IF Statement in Excel and Output Numbers, Text, and Formulas


Video:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Step by step explanation of how to write and use the IF function - IF statement in Excel. This tutorial walks you through using an IF statement to check the value of a cell and output text, numbers, or formulas depending on the value of the cell being checked. You will learn how to output values based on if the values being checked pass a logical test. This is a great tutorial for any beginner in Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
09/Nov/2009

Finance in Excel 7 - Calculate The Declining Balance Method of Depreciation in Excel - Using VDB()

Title:
Finance in Excel 7 - Calculate The Declining Balance Method of Depreciation in Excel - Using VDB()


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn the best function to calculate depreciation in Excel. The VDB() function in Excel allows you to calculate the double declining balance method of depreciation or any factor of depreciation while accounting for the switch from the declining method of depreciation to the straight line method of depreciation - this occurs automatically in the function and happens at the optimal time, which is when the straight line depreciation amount is larger than the corresponding declining balance method of depreciation. This is a must see tutorial for anyone that works in finance or accounting or who just needs to learn how to properly calculate depreciation in Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
09/Nov/2009

Finance in Excel 6 - Calculate Double Declining Balance Method of Depreciation in Excel

Title:
Finance in Excel 6 - Calculate Double Declining Balance Method of Depreciation in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Calculate depreciation in Excel using the Double Declining Balance Method and function in Excel. This tutorial explains exactly how to use the DDB() function in Excel and also why you should not use this function in Excel. The Double Declining Balance Method of calculating depreciation is not necessarily a bad method to use, but this function in Excel will not fully depreciate an asset when the salvage value is only a proportionally small amount of the asset's initial cost or purchase price. The VDB() function for calculating depreciation in Excel is the function that should be used and is covered in the next tutorial (Finance in Excel 7). For Excel consulting or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
09/Nov/2009