Thursday 24 December 2009

Run Chart Tutorial for Excel 2007

Title:
Run Chart Tutorial for Excel 2007


Video:


Description:Quality Improvement 106, Lesson 4: Author Kevin Little gives step-by-step instructions for completing the run chart assignment.

Published:
25/Dec/2009

Run Chart Tutorial for Excel 97-2003

Title:
Run Chart Tutorial for Excel 97-2003


Video:


Description:Quality Improvement 106, Lesson 4: Author Kevin Little gives step-by-step instructions for completing the run chart assignment.

Published:
25/Dec/2009

Wednesday 23 December 2009

Using Excel Macros to Process Real Time Data Acquired by the Excel Server from LowCostBoards.com

Title:
Using Excel Macros to Process Real Time Data Acquired by the Excel Server from LowCostBoards.com


Video:


Description:This video shows how to use an Excel macro and a very small VBA program to display a scrolling chart of real time data aquired by the Excel Server from LowCostBoards.com

Published:
23/Dec/2009

Thursday 17 December 2009

Funcion coincidir indice excel

Title:
Funcion coincidir indice excel


Video:


Description:tutorial con ejemplo de funcion coincidir indice de escel trucos excel

Published:
18/Dec/2009

Wednesday 16 December 2009

Data Validation 8 - Custom Error Messages in Excel

Title:
Data Validation 8 - Custom Error Messages in ExcelVideo:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Learn how to create custom error messages with this free Excel video tutorial. This shows you how to change the default data validation error messages to something that actually describes the error that was encountered. This is a particularly important feature to use when you need to let users know exactly what the error was that they caused so that they know how to correct the error. This tutorial shows you how to change the error message image, title, and error message itself. This is a very important feature of data validation that should be implemented in most cases where there is data validation present 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/Dec/2009

Data Validation 6 - Run Macros from Drop Down Menus in Excel

Title:
Data Validation 6 - Run Macros from Drop Down Menus in Excel


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that teaches you how to run macros from drop down menus in Excel. This Excel video tutorial walks you through the steps you need to take in order to make a macro run when you select an option from a data validation drop down menu in Excel. This includes teaching you how to create the drop down menu in Excel; how to create the basic macro to run based off of the drop down menu; and, how to change the macro to run your own macro code. This is a really great tutorial to view in order to perform more powerful tasks with your drop down menus and lists 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/Dec/2009

Data Validation 5 - Create Drop Down Menus That Accept Other Values in Excel

Title:
Data Validation 5 - Create Drop Down Menus That Accept Other Values in Excel


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that describes how to enter data into cells that contain drop down menus using data validation. This method teaches you how to be able to enter data into a data validated drop down menu cell that is not contained within the drop down menu. Basically, you will be able to enter values that are not contained in the drop down menu into a cell with a drop down menu. This allows you to simply use the data validation drop down menu feature in Excel in order to make entering values in cells easier for users while at the same time not preventing them from entering other values. 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/Dec/2009

Excel Tips 31 - Add Multiple Lines to Text within Cells - Use the Enter key within a cell

Title:
Excel Tips 31 - Add Multiple Lines to Text within Cells - Use the Enter key within a cell


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Neat Excel tip for adding extra lines to cells in Excel. This allows you to have paragraph style formatting for text within a cell whereby you can enter text on lines below other text within the same cell in Excel. This allows you to have better looking and better formatting spreadsheets in Excel. You can also use this technique to insert blank lines after or before text within a cell in Excel. This method of entering text into cells allows you to avoid using the text box to enter large amounts of text 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/Dec/2009

Tuesday 15 December 2009

Data Validation 2 - Create Drop Down Menus From Source Data on Separate Tabs in Excel

Title:
Data Validation 2 - Create Drop Down Menus From Source Data on Separate Tabs in Excel


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Create drop down menus in Excel with source (list) data from separate tabs within Excel. This Excel video tutorial shows you how to create a drop down menu that uses data from separate worksheets within Excel. This is a great tutorial to view because of the fact that you can just point to a range in a separate worksheet in Excel through data validation. Instead, you have to use named ranges with data validation in order to reference data that is not on the same worksheet as the drop down menu that you want to create. 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:
16/Dec/2009

Data Validation 1 - Create Drop Down Menus in Excel

Title:
Data Validation 1 - Create Drop Down Menus in Excel


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Step by step guide to creating drop down menus in Excel. This Excel video tutorial shows you how to use data validation in Excel in order to make a drop down menu that displays from any cell within a worksheet. This is a great tutorial for anyone who is not familiar with data validation but who still needs to make a drop down menu in Excel. The real benefit to using drop down menus in Excel is that you can make it easier for a user to enter the correct value into a cell. This works well when creating a user form from an Excel worksheet. 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:
16/Dec/2009

Friday 11 December 2009

Excel Dynamic Chart #10: OFFSET Function Dynamic Range

Title:
Excel Dynamic Chart #10: OFFSET Function Dynamic Range


Video:


Description:See how to use the OFFSET function for two different types of dynamic ranges for a chart: 1)Dynamic Range that adds latest records 2)Dynamic Range that shows only last 4 Months of data Learn about named formulas that use OFFSET function to create dynamic ranges and see how to insert named ranges into a chart. Learn about the OFFSETs 5 arguments: 1)Starting point 2)How many rows (up or down) do you want to move the starting point? 3)How many columns (left or right) do you want to move the starting point? 4)How tall is the range? 5)How wide is the range?

Published:
12/Dec/2009

Wednesday 9 December 2009

How to Create a Barcode in Microsoft Excel 2007

Title:
How to Create a Barcode in Microsoft Excel 2007


Video:


Description:***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. This is a tutorial for creating barcodes in Microsoft Excel 2007 using IDAutomation's Barcode Fonts and Barcode Macros by adding the Developer Tab to Excel. 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)

Published:
10/Dec/2009

Sunday 6 December 2009

Tutorial en Excel: Sum Product,Sum If y Count If

Title:
Tutorial en Excel: Sum Product,Sum If y Count If


Video:


Description:Rápido tutorial para explicar algunas funciones útiles en excel.

Published:
07/Dec/2009

Saturday 5 December 2009

Show Formula Bar in Excel for MAC

Title:
Show Formula Bar in Excel for MAC


Video:


Description:Quick Video to show how to display the formula bar in Excel For MAC

Published:
05/Dec/2009

Friday 4 December 2009

Printing in Excel 7 - Repeat Row & Column Titles on Every Printed Page from Excel - Page Setup

Title:
Printing in Excel 7 - Repeat Row and Column Titles on Every Printed Page from Excel - Page Setup


Video:


Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to repeat title rows and columns in Excel for every page that is printed. This allows you to view the same rows at the top of a column on each page so that you know what every column stands for in the printed spreadsheet. You will also see how to do this for columns when your data is organized left to right instead of up to down. This is a great tutorial to view to increase the usability of printed spreadsheets and simply to make them much easier to read and understand. This tutorial shows you how to repeat single rows and columns as well as multiple rows and columns on every page of the printed Excel spreadsheets. 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:
05/Dec/2009

Printing in Excel 6 - Adjust Margins in Excel - Spreadsheets that Will be Printed - Page Setup

Title:
Printing in Excel 6 - Adjust Margins in Excel - Spreadsheets that Will be Printed - Page Setup


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to adjust the page margins for an Excel spreadsheet when printing that spreadsheet. This allows you to fit more information or data, or less information or data, onto a printed Excel spreadsheet or worksheet. This tutorial shows you how to increase and decrease the size of margins within Excel. When you decrease the size of the margins, that means that there is less white space between the printed information and the edge of the page. Margins in Excel are just like those in Microsoft Word and are just as easy to adjust. 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:
05/Dec/2009

Printing in Excel 5 - Fit More Data on a Printed Page - Scale Data for Printing

Title:
Printing in Excel 5 - Fit More Data on a Printed Page - Scale Data for Printing


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This video tutorial shows you how to scale data in Excel so that more of it will fit on a printed page. This method effectively shrinks the data when it is printed while leaving everything looking the same within Excel and is called scaling. Using scaling in Excel allows you to put more information on a printed page; however, that information will be a smaller size and font than if you did not scale it. This is great for formatting spreadsheets for printing and helps to make your spreadsheets look just at good on paper as on the computer screen. 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:
05/Dec/2009

Printing in Excel 4 - Prevent Specific Cells in Excel from Printing

Title:
Printing in Excel 4 - Prevent Specific Cells in Excel from Printing


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you three different ways that you can quickly and easily prevent a specific cell, a row, or a column from printing or from showing up when you print a worksheet or workbook in Excel. You will learn how to effectively hide a cell, row, or column as well as to group them or change the font color. This tutorial teaches you ways that you can keep data private when you go to print a worksheet or to just help you clean up the document before it's printed. This tutorial covers some tips for hiding the data that you don't want to be printed from Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
05/Dec/2009

Printing in Excel 3 - Add Headers and Footers in Excel

Title:
Printing in Excel 3 - Add Headers and Footers in Excel


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Add headers and footers to Excel files when printing. This Excel video tutorial shows you how to quickly and easily add headers and footers to your worksheets and workbooks in Excel. You will learn how to add a header and footer for Excel 2007 and previous versions of Excel. Also, you will learn exactly what you can add as a header; how to print the first page's header different than the rest of the pages; how to add the time, date, file name, page number, total pages, and more to the header and footer; and, how to add custom text to the header and footer in Excel. You also learn about the new page layout view for Excel 2007. This feature allows you to intuitively and easily add headers and footers to your documents. This is a great printing tutorial for Excel that walks you through what you can do to add headers and footers in Excel when printing a worksheet or workbook. 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:
05/Dec/2009

Thursday 3 December 2009

Printing in Excel 2 - Print Specific Data from a Worksheet in Excel - Set Print Area Excel 2007

Title:
Printing in Excel 2 - Print Specific Data from a Worksheet in Excel - Set Print Area Excel 2007


Video:


Description:Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Print only selected or desired data in Excel. This excel video tutorial shows you how to select a single section or multiple sections within a worksheet or workbook in Excel and then to print that area. This video tutorial covers the Print Area feature in Excel. You will learn how to print a single area of a worksheet, set multiple print areas within the worksheet, and how to clear all print areas from the worksheet so that you can print the entire Excel worksheet. This is a very useful tutorial for printing in Excel and allows you to print only the data that you need printed. 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:
04/Dec/2009

Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed

Title:
Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed


Video:


Description:Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to print an Excel worksh...

Published:
04/Dec/2009

Import RSS Feeds - News Headlines - into Excel

Title:
Import RSS Feeds - News Headlines - into ExcelVideo:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to import RSS feeds into Excel. Specifically, you will learn how to import Yahoo News story RSS feeds into Excel. This will allow you to quickly and easily read up-to-date headlines in Excel and to then follow a link to the full story if it interests you. Specifically, you will learn how to import and create and XML map in Excel. This is due to the fact that RSS feeds are simply XML files. As a result, you will also learn how to import XML files into Excel from the web. 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:
04/Dec/2009

Excel Tips 30 - Install Add-Ins to Excel - Analysis Toolpak - Solver - Etc..avi

Title:
Excel Tips 30 - Install Add-Ins to Excel - Analysis Toolpak - Solver - Etc..avi


Video:


Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Learn how to install add-ins in this Excel video tutorial. You will learn how to install add-ins such as the Analysis Toolpak and Solver in Excel. This is a very good tutorial to learn if you just upgraded to Excel 2007 or just need to find out where to install add-ins in Excel. Installing the Analysis toolpak will allow you to perform regression analysis and t-stat and anova analysis in Excel in a much more efficient fashion than just using functions such as LINEST(). 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:
04/Dec/2009

View Twitter Updates from Excel 2007

Title:
View Twitter Updates from Excel 2007


Video:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. View Twitter updates from Excel 2007. This Excel video tutorial walks you through all of the steps that you need to follow in order to be able to view all of your Twitter updates from Excel 2007. This means that you will be able to view your Twitter account activity from any computer with an internet connection and Excel. This is a great feature to use in Excel if you need to use Twitter in a discrete fashion or if you just want to do it through Excel. The real benefit of this tutorial is that you don't have to have your browser open in order to check Twitter. 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:
04/Dec/2009

Wednesday 2 December 2009

Functions-Formulas in Excel 9 - Highlight Cells With Formulas Without a Macro in Excel

Title:
Functions-Formulas in Excel 9 - Highlight Cells With Formulas Without a Macro in Excel


Video:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial showing you how to highlight all cells that contain formulas within a worksheet in Excel. The benefit of this tutorial is that you will learn how to highlight cells with formulas without using an Excel macro. This is a really useful feature of Excel, especially when you need to find out what is going on in a spreadsheet that you haven't used in a long time or that someone else sent you. This tutorial is the first part in a series of formula auditing tutorials and serves to help you better troubleshoot problems and errors with formulas and functions 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:
03/Dec/2009

Excel Formatting 12 - Quickly Copy Formats to Other Cells in Excel

Title:
Excel Formatting 12 - Quickly Copy Formats to Other Cells in Excel


Video:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that shows you how to quickly and easily copy formatting from one cell or table to another cell or table. Specifically this tutorial shows you how to copy the formatting from an entire table and paste only the formatting onto other similar sized tables in Excel. This allows you to very quickly make many professional looking tables and worksheets in Excel without having to create your own theme in Excel. This is a great Excel tip that will save you time and improve the look of your spreadsheets. 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:
03/Dec/2009

Excel Formatting 11 - Quickly Clear ALL Formatting From a Worksheet in Excel

Title:
Excel Formatting 11 - Quickly Clear ALL Formatting From a Worksheet in Excel


Video:


Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to remove formatting from an entire worksheet in Excel with the press of one button. You will see how to remove fonts, bold, italics, colors, alignment, borders, underlines, etc. This method allows you to remove in seconds what it would take you minutes to do by hand. This is a great tip in Excel that not many people know about and that just about everyone can benefit from. Learn this Excel formatting tip and you will save yourself a lot of time. 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:
03/Dec/2009