Gather your data in Google docs then link it to an Excel document.

This simple method for connecting your excel spreadsheet to a google spreadsheet really works.  I made a calendar in a Google spreadsheet and connected it to an Excel spreadsheet.  Now I have the bennefits of both worlds. Google Docs for Teamwork and Excel for convenience and power.

Using the method described below, I imported the data  to a new page. Then used paste link to connect the data to my spreadsheet. It isn't perfect since I must press Data / refresh all to update the data in Excel. 

• http://productforums.google.com/forum/#!topic/docs/7uJXwnJgPhc

Thank you Mikltk

PUBLISH YOUR SPREADSHEET ONLINE AND "RIP" IT TO EXCEL.  

Step 1: In your Google Docs spreadsheet, click file, then Publish to the Web. 

Step 2: Open Excel 2010 (I cannot promise that this works in earlier versions) (v 2007 is ok, Steve)

Step 3: Click the "DATA" Tab on the top

Step 4: There is a "Get External Data" section, click "from web"

Step 5: Return to your spreadsheet in Google Docs, in the Publish to the Web box, start publishing, then look lower in the box, get a website link to your spreadsheet, copy it.

Step 6: Return to Excel and paste the website into the address bar of the dialog box that opened when you clicked get data from the web

Step 7: Click the check box that appears in the upper left of your website (in the Excel Dialog Box)

Step 8: Import and Enjoy!!

Sincerely, 

Mikltk

Excel -- Dependent Lists - Just download and try

I love manipulating data with Excel. This sample allows pull down list options to change, depending on a choice in an other column! Nice.
Steve

• Try it: Download a sample file for Dynamic Lists
• Tutorial Excel Data Validation -- Dependent Lists

10 ways to use Excel's paste features

•  Excel’s Paste and Paste Special commands harbor a multitude of useful options. Use them to do everything from transposing data to copying Validation rules.10 powerful ways to use Excel's paste features | TechRepublic

The 10 most important things to know about Excel

The 10 most important things to teach your Excel users | TechRepublic: "You can help new Excel users become more productive and self-reliant if you explain these core concepts, efficiency tricks, and essential features"

1: Absolute and relative referencing

2: Limitations

3: Quick help on functions

4: Right-clicking

5: User preferences

6: The fill handle

7: Formula auditing

8: Stored values vs. displayed values

9: Status bar info

10: Paste Special options

Bonus tips: Data Validation and named ranges

DataPig videos on Excel

This link is perfect to enrich your abilities beyond basic excel. They are both neutral in tone and to the point. Perfect for classroom use. Steve
DataPig Technologies

The Excel Magician

The Excel Magician: 70+ Excel Tips and Shortcuts to help you make Excel Magic : Codswallop

Online tutorials & videos

The following online tutorials are mostly free and will teach you quite a bit about Excel. In fact they are better than some of the expensive classroom training courses.

1. Online introduction to Excel: If you are just starting to use excel, this is the perfect resource for you. Here you will find dozens of audio courses that take a step by step approach to learning excel.
2. DataPig Technologies: The guys from Data Pig Technologies made a comprehensive collection of videos that explain almost every aspect of Excel. From basic Excel concepts to VBA programming. And most of the videos are free!
3. Online Charts Tutorial: Jon Peltier is an Excel-charting superstar. You can use his online tutorial to get you started on Excel charting and also as a reference.
4. Basic Formulas Guide: This excellent tutorial will help you master Excel formulas in no time.
5. Common uses for Formulas: This collection of samples will help you understand what can be achieved by using excel formulas.
6. An introduction to Pivot Tables: The Pivot Table is an amazing tool, but people often shy away from it because Pivot Tables seem complicated. The first page of this PDF contains a clear description of Pivot Tables and how they can be used.
7. Creating a Pivot table: A 7-minute video shows you how to create and work with Pivot Tables.
8. Pivot Tables in Excel 2007: Excel 2007 Pivot Tables are much easier to use. If you use excel 2007, check out this slightly promotional yet excellent introduction to Pivot Tables.
9. Practicing Pivot Tables: This step by step tutorial from Microsoft will help you sharpen your Pivot Table skills.
10. Microsoft Excel help / 2007: When all else fails, Microsoft Excel Help is a good source to try.

Excel resources

Excel :: Formula Must Be Confirmed With CTRL+SHIFT+ENTER Not Just ENTER

Excluding dates from calendar:

The BEST WAY:  HOW TO: Use NETWORKDAYS with Multiple Holidays in Excel 

A second, less obvious but workable solution:  Calendar calculations excluding specific dates - Excel Help Forum

Not particularly simple to do but you could use this formula =SMALL(IF((WEEKDAY(ROW(INDIRECT(A2+1&":"&WORKDAY(A2,B2,G$1:G$10))))<>1)*(ISNA(MATCH(ROW(INDIRECT(A2+ 1&":"&WORKDAY(A2,B2,G$1:G$10))),G$1:G$10,0))),ROW(INDIRECT(A2+1&":"&WORKDAY(A2,B2,G$1:G$10)))),B2) confirmed with CTRL+SHIFT+ENTER where A2 is the start date, B2 the number of days to add and G1:G10 contains holiday dates

More listings on this topic: Excel - Calendar Excluding Days - I have a calendar... - Free Excel Help

Excel Formula Translator

I'm often moving formulas between English and French. This works.

Excel Translator:

"Online Excel Translator Translate Microsoft Excel formulas/function names between several languages."

Dictionnaries to excel formulas in

wwwhome.ewi.utwente.nl

English Czeck/Čeština Danish/Dansk German/Deutsch Spanish/Español Finnish/Suomi French/Français Hungarian/Magyar Italian/Italy Norwegian/Norsk Dutch/Nederlands Polish/Polski Portugese/Português Russian/Русский Swedish/Svenska Turkish/Türkçe
Show rows containing:

How to copy Word Tables into Excel spreadsheets

It doesn't take long to discover that copy and paste is useless since every paragraph or line feed in the table becomes a row in Excel.

To prevent this behaviour replace all the "paragraph marks" and "line breaks" with "$$$$"; copy and paste your table normally to Excel then  replace the $$$$ by the ALT+Enter line feeds.  Presto!

Here is how:

1. In most versions of Word search and replace click More / Special / "paragraph mark".
2. Click in the replace box and type $$$$.
3. Click Replace All.
4. Repeat to replace "manual line break" with $$$$.
5. Select the table or cells and choose Copy (or CTRL+C).
6. Switch to Excel.
7. Click on the top left cell where the table will be pasted.
8. Choose Paste (or CTRL+V)
   Warning: if you want your text to look like the rest of the Excel document, remove the formatting by using Paste Special / Unicode Text.
9. Search and replace the $$$$ by CTRL+j *
10. Admire your Excel document, the text is in the same location as it was in the original Word table.

Warning: if you use hyperlinks in your word text, make each is alone in a cell because because that is how Excel needs them.

Related background info:

• Copying a table from Word in Excel Miscellaneous
• Sources: Pasting Table from Word - microsoft.public.excel.misc | Google Groups* Formal method of replacing $$$$ by ALT+Enter: the result is the same as above, just more precice technically. Search and replace the $$$$ by ALT+0010 (you must use the numeric keypad to type 0010, and you will see nothing on the screen, but it is there trust me).
• To analyze characters in Excel  http://www.cpearson.com/excel/CellView.aspx
• Excel Tips, Excel Tutorials and Excel Techniques

Restrict duplicate data using Excel Validation

This is a nice little trick that shows how to adapt of Excel.
To apply a validation rule that restricts input values to only unique values, do the following:

1. Select A2:A8 (the cells you’re applying the rule to).
2. Choose Validation from the Data menu and click the Settings tab. In Excel 2007/2010, click the Data tab and choose Data Validation from the Data Validation dropdown in the Data Tools group.
3. Choose Custom from the Allow dropdown list.
4. The Custom option requires a formula that returns True or False. In the Formula field, enter the following expression: =COUNTIF($A$2:$A$8,A2)=1.

Restrict duplicate data using Excel Validation | Microsoft Office | TechRepublic.com

Curso video de excel xp (primera parte)

Curso video de excel xp (primera parte):

• 0. Presentación

• 1. Introducción

• 2. Desplazamiento por la hoja

• 3. Un ejercicio práctico

• 4. Los valores del texto

• 5. El tratamiento de los datos

• 6. Copiar y mover celdas

• 7. Buscar y reemplazar datos

• 8. Las fórmulas (con vídeo)

• 9. Primera práctica con fórmulas

• 10. Las funciones

• 11. Otras funciones MAX, MIN

• 12. El formato de las celdas

• 13. Las listas

• 14. Validación de los datos

• 15. Euroconversión

• 16. Crear y modificar un gráfico

Descargar el curso en PDF

THE Shortcuts for Excel

Action	Shortcut
Insert a new line within a cell	[Alt] [Enter]
Enable editing within a cell	[F2]
Add a comment to a cell	[Shift] [F2]
Open Print Preview	[Ctrl] [F2]
Fill selected cells with an entry you typed in one cell	[Ctrl] [Enter]
Fill data down or to the right through selected cells	[Ctrl] D or [Ctrl ] R
Create a name	[Ctrl [F3]
Insert the current date or time	Ctrl] and ; (semicolon) or Ctrl and : (colon)
Create a chart from a range of data	[F11]
Toggle the display of formulas	[Ctrl] ~

Source: TechRepublic.com

Date Stamp in Excel

source: http://articles.techrepublic.com.com/5100-10878_11-6025056.html

Suppose your Microsoft Excel workbook contains 10 worksheets, and you want to add a time and date stamp to each worksheet. You could manually enter a time and date formula into a cell in each worksheet, or you can create a named formula that can enter the current date and time without having to retype the formula.

To create the named formula, follow these steps:

1. Press [Ctrl][F3].
2. Enter DateStamp in the Names In Workbook text box.
3. In the Refers To text box, enter the following formula:=TEXT(TODAY(),"d-mmmm-yyyy") & " " & TEXT(NOW(),"h:mm AM/PM")
4. Click the Add button and then click OK.
5. Now you can add a time and date stamp to every worksheet in your workbook by typing =DateStamp in any cell.

more: http://www.ozgrid.com/forum/showthread.php?t=71988

and of course a simple VB macro:

43000 "Excel 2003 - English Tutorials" and more Free to use

Yes, 43000 "Excel 2003 - English Tutorials" | Scribd (convertible to PDF or Word)

COPYRIGHT: Attribution Non-commercial

Samples

1. Excel 2003 - tutorial 1
   Spreadsheet Basics: Screen Layout, Title bar, Menu bar, Standard Toolbar, Other Tools, Task Pane, Adding and Renaming Worksheets
   Modifying Worksheets Moving Through Cells, Adding Worksheets, Rows, Columns, and Cells, Resizing Rows and Columns, Selecting Cells, Moving and Copying Cells, Deleting Rows, Columns, and Cells, Freeze Panes,
   Formatting Cells Formatting Toolbar, Format Cells Dialog Box, Formatting Worksheet, Dates and Times, Format Painter, AutoFormat
   Formulas and Functions Formulas, Linking Worksheets, Relative, Absolute, and Mixed
   Referencing , Basic Functions, AutoSum.
   Sorting and Filling Basic Sorts. Complex Sorts. Auto-fill.
   Comparing Workbooks Compare Side by Side.
   Page Properties and Printing Page Breaks. Page Setup. Margins. Header/Footer. Sheet. Print Preview..Print.
2. Excel-2003-Tutorial-2
3. Charts: Chart Wizard, Chart toolbar, Resizing a chart, Moving a chart, Deleting a chart, Copying a chart to Microsoft Office file, Chart Types, An Overview on Formatting Charts and Cell
   Commonly Used Features: Comments, Use Go To, Use Find and Replace, Increase / Decrease Decimals, Protecting your files (password to open),
   Saving Excel files as Web pages
   E-mail an Excel File: To send by e-mail a single Excel worksheet as a message body, To send by e-mail a single Excel worksheet as an attachment, To send by e-mail an Excel workbook as an attachment, To send by e-mail an Excel workbook for review
   Additional Readings: Tab Color, Hide / Unhide
   Appendix 1: Shortcut Keys
4. Microsoft-Excel-2003-Cheatsheet and basic excercises with tips
   
5. Excel-Pivot-Tables-in-Excel-2003
   
6. 423 page book. Learn Excel

Excel 2007 handouts

1. Overview Excel-2007-Workshop-Handout (2 pages)
   

Español:

Curso de excel xp (primera parte)

Learn to use Excel 2003

Video

1. 1 - Introduction to Microsoft Excel 2003 (Running Time: 5:56)
   Wondering where to start, well this is the basics. In this video John will start out explaining what MS Excel is and how it can help you in your current job and or position. He’ll further explain what a spreadsheet is and how it can help you calculate and modify data.
   3 - Workbooks and Worksheets (Running Time: 23:45)
   Upon entering data within a worksheet you might begin to wonder how could you make things a little less complicated and more organized. Through this video John explores how to do just that. He covers how to open existing workbooks, how to create new workbooks and how to organize workbooks to better help you, and other users of your workbooks, to better utilize your workbooks more productively.
   More: http://www.learnoffice2003.com/index.php
2. http://www.bsu.edu/techclips/microsoft_excel_2003.htm
3. http://www.softwaretrainingtutorials.com/excel-2003-stat.php

Audio & text

1. http://office.microsoft.com/en-us/excel/HA011161281033.aspx
2. http://office.microsoft.com/training/training.aspx?AssetID=RC011055061033
3. http://www.guidesandtutorials.com/excel2003_selecting_cells.html
4. http://www.guidesandtutorials.com/excel-2003-tutorial.html#edit
5. http://www.guidesandtutorials.com/excel-2003-tutorial.html#screen
6. http://www.ischool.utexas.edu/technology/tutorials/office/excel/
7. https://www.videoprofessor.com/index.cfm
8. fuseaction=shoppingcart.landingPage&campaignName=MVP_Excel2003_10Dollar&
   

PowerPoint

1. http://www.educationonlineforcomputers.com/blogs/post/Free_Microsoft_Office_Training_Tutorial_Resources/784/PowerPoint-2003-Tutorial-from-the-University-of-Texas