Tuesday 29 January 2008

Consolidate Data from Multiple Worksheets in Workbook

Title:
Consolidate Data from Multiple Worksheets in Workbook


Video:


Description:www.advanced-excel This macro will consolidate data from all the worksheets in a workbook and present the total from all the worksheets. The video here is on consolidating data from preparing income tax returns forms.

Published:
29/Jan/2008

Thursday 17 January 2008

Excel 2007 Demo: Hide or unhide rows and columns

Title:
Excel 2007 Demo: Hide or unhide rows and columns


Video:


Description:See more Excel 2007 demos at office.microsoft.com In Microsoft Office Excel 2007, you can hide rows and columns in several ways to change your view of the worksheet. When you finish your task, you can unhide the rows and columns to return the worksheet to its original state. This demo shows you quick ways to temporarily hide the data you don't want to see — so you can focus on what you do want.

Published:
18/Jan/2008

Monday 7 January 2008

Excel 2007: Insert and delete rows, columns, and worksheets

Title:
Excel 2007: Insert and delete rows, columns, and worksheets


Video:


Description:See more Excel 2007 demos at office.microsoft.com In Microsoft Office Excel 2007, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — with a few clicks. Watch the demo to see how fast you can insert and delete individual or multiple rows, columns, cells, and worksheets.

Published:
08/Jan/2008

Thursday 3 January 2008

Convertir minusculas a mayusculas excel

Title:
Convertir minusculas a mayusculas excel


Video:


Description:Macro para convertir Minusculas a mayusculas y viciversa . Autor MARCO AGREDA MATIAS de TECNOLOGIA MASTERSOFT

Published:
04/Jan/2008

Excel 2007: Use simple formulas to do the math

Title:
Excel 2007: Use simple formulas to do the math


Video:


Description:See more Excel 2007 demos at office.microsoft.com You can use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later.

Published:
04/Jan/2008

Excel 2007: Combine contents of multiple cells into 1 cell

Title:
Excel 2007: Combine contents of multiple cells into 1 cell


Video:


Description:See more Excel 2007 demos at office.microsoft.com Excel offers 2 formulas for combining the contents of multiple cells into one cell.

Published:
04/Jan/2008