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

Educational resourcesby Microsoft - Nice

Step-by-step guide for Microsoft Office 2007

Step-by-step guide for OneNote 2010   Microsoft OneNote getting started guide

WEBAPPS-STEPBYSTEP. 
 rosoft Office getting started guide


http://www.microsoft.com/education/en-ca/teachers/plans/Pages/index.aspx
http://www.microsoft.com/education/en-ca/teachers/how-to/Pages/index.aspx?q=Word

--------------------------------------

Chemical Add-in for Word - Unexpected depth:
http://www.youtube.com/user/mspartnersinlearning

Power Point Web App - For Teachers on the Go

Windows Live Photo Gallery + Movie Maker overview

Caption Control in Microsoft Word - The definitive technique

When to use caption commands   teachers/how-to/Pages/insert-caption (video)

With the caption commands, you can automatically insert labels, such as Figure 1 or Table 1. Word 2007 keeps track of the numbering. For convenience, you can also enable AutoCaption (which automatically inserts a caption when you add a picture or table). You can also quickly insert a table of all the figures in your document, or add a text box over a picture so that the caption and picture can be moved together.

Way too much detail about keeping captions with pictues: keep-with-caption

Desktop Publishing in Microsoft Word 2007

This handout covers many of the finer theoretical points of DTP in Word 2007.

DesktopPublishing.pdf

Do Desktop Publishing With Word

While Microsoft Word is still first and foremost a word processor, it is frequently used to create publications normally created by page layout programs. For some users, it may be the only desktop publishing tool they need. Designers may cringe at the thought of designing in a word processor, but within reason it is possible.

Don't Do Desktop Publishing With Word

Microsoft Word is able to create complex layouts for brochures or newsletters that print great to your desktop printer but it is not a true desktop publishing program. More significantly, Microsoft Word is not designed for creating digital files for commercial printing.

More: Microsoft Word Tips and Tutorials

Inserting the current Monday's date in a Word document

A less boring macro for Word. OK, it isn't so exiting, but it might be an interesting lesson for someone studying macros. Steve

Inserting the current Monday's date in a Word document | TechRepublic: "Use this easy-to-implement Word macro to return the date for the current Monday, any day of the week"

 Sub ReturnCurrentMonday()

 'Return Monday of current week.

 Dim dteMonday As Date

 dteMonday = IIf(Weekday(Date) = 1, Date - 6, _

 Date - (Weekday(Date) - 2))

 Selection.InsertBefore dteMonday

End Sub

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.

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

Multi-task tricks of the Table Move handle in Word | Microsoft Office

Multi-task tricks of the Table Move handle in Word | Microsoft Office | TechRepublic.com

• Click the Table Move handle to select the table so you can apply formatting to the entire table.
• Click and hold the mouse to drag the table to another position—this is especially handy when you insert a table at the beginning of a new page and then realize you want to add text at the top of the page, above the table.
• Double-click to open the Table Properties dialog box (in Word 2003).
• Click and press Backspace to delete the entire table and its contents (in Page Layout view in Word 2007 and 2010 ).
• Click and press Delete to delete only the table’s contents (in Page Layout view in Word 2007 and 2010).

Unexpected page break in Word

Unexpected page break in Word
In Microsoft Word, when you insert a section break into a page, a page break may be inserted instead.

To resolve this issue in Microsoft Office Word 2007, follow these steps:

• Click the Microsoft Office Button, and then click Word Options.
• In the left pane, click Advanced.
• In the right pane, expand Layout Options under Compatibility, click to select the Lay out footnotes the way Word 6.x/95/97 does check box, and then click OK.

Thanks Ginette and Helene

Where is the Office 2003 in Office 2007?

Français

Word 2007
http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT100766331036&vwidth=1044&vheight=788&type=flash&Origin=HA100744321036

Excel 2007
http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT101493291036&vwidth=1044&vheight=788&type=flash&Origin=HA101491511036

English

Word 2007 training courses - Word - Microsoft Office

Word Help and How-to - Microsoft Office

Why do I see blue underlines in Word?

They warn you of formatting inconsistencies. You may have type a 10 point character in a 12 point sentence.

• A red line indicates a possible misspelling.
• A green line indicates a possible grammatical error.
• A blue line indicates a formatting errror (source).

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

Tips on access 2007 control security

Limiting access to Access 2007, check out these articles; they cover the basic "hide your tables" to the complex

• 10 tips for securing a Microsoft Access database | 10 Things | TechRepublic.com
• Tip: Hide sensitive data in Access | Microsoft Office | TechRepublic.com

Français

• Sécurité dans Access 2007 - Présentation - Access - Microsoft Office Online
• [ACCESS] lancement formulaire au démarrage [Résolu]

Power Point Points

Preflight checklist for your PowerPoint presentations | Microsoft Office | TechRepublic.com

Using Open Office Documents in Word 2003 and 2007

for office 2003 users

If you have Office 2003, Download and install the Sun ODF Plugin should just work.You can download the Sun ODF Plugin from here

For office 2007 users

1. First you need to Install Service Pack 1 for Office 2007.
2. Install Sun ODF Plugin for Microsoft Office.
3. Open ODT document via File > Open, or by double-clicking the ODT file and when prompted for the application to open it with, choose Word.

If you don’t have administrator privileges to install software, you can try an online converter such as Zamzar or Media Convert. You can also upload ODT documents to Google Docs orZoho Writer.

If you want to open ODT documents locally but want to stay away from MS Office, try the lightweight, cross-platform Abiword or the full-blown suite of OpenOffice.org.

Source : How to open .ODT files in Microsoft Word 2007/2003 | Windows Reference

Thanks Hermann

Programming with Access 2007 (Français) Programmation en Access 2007

• http://www.lecompagnon.info/access/macros.htm - accessmacroattache
• http://www.lecompagnon.info/access/macros.htm - accessmacroautoexec
• http://search.microsoft.com/results.aspx?form=MSHOME&mkt=fr-CA&setlang=fr-CA&q=access+2007+programmation
• http://office.microsoft.com/fr-fr/access/HA012142131036.aspx
• http://office.microsoft.com/fr-fr/access/CH063664351036.aspx

Windows Live Sync vs. Live Mesh vs. SkyDrive: Which is Right for You?

As usual, MS product bloat leaves me feeling a little woozy.

• Live Mesh is the most complete. Everything that Windows Live Sync has to offer plus two extra features – cloud storage and remote desktop (with support for copy-paste).
• Windows Live Sync Live Sync also lets you remotely access your files on the hard drive. ...sync files and folders across different computers. You can synchronize up to 20 folders containing up to 20,000 files each. Individual files cannot be larger than 4 GB in size.
• Windows Live SkyDrive requires no installation and you get 25 GB of free storage space though the maximum size of an individual file / document cannot exceed 50 MB.
  

...As expected, each of these Live services do have some overlapping
features. Live Skydrive is for online storage, Live Sync is primarily for folder
synchronization across computers (no storage) while Live Mesh offers a good mix
of both though with limited storage space(5GB). Therefore my suggestion would be
to go with SkyDrive as well as Live Mesh – you’ll get plenty of storage space
plus remote desktop plus you can access important files from any other computer. Here is the full answer.

...Windows Office Live Workspace also support documents created in
OpenOffice and StarOffice to create greater compatibility on their services. source

More on tests of Office Live Workspace

This could be the best solution, for shared file storage and editing if your documents are in MS Office format.

• How to create a workspace video.
• Save Microsoft Office documents to Office Live Workspace
• Demo: Access your workspace from Microsoft Office
• What do you want to do?
  Install the Office Live Update
  View Office Live options in Office XP and Office 2003 programs
  View Office Live options in the 2007 Office system programs
  Open a workspace document
  Save a document to Office Live Workspace
  Uninstall the Office Live Update
  Troubleshoot

BULK UPLOAD in IE with Silverlight only. video
Office Live Workspace has a bulk uploader tool that lets you upload multiple files (documents, images, PDFs) from the local computer to your online Office Live account.
This is quite similar to the Flickr Bulk Uploader but a reason why most of us are unaware of this useful feature is because it is available only inside Internet Explorer, not Firefox.

Can I access MOLW from my desktop? NO.

Microsoft Office Live Workspace is a secure and online website. You can try to save the default URL of the website in Book Mark, but I want to inform you that there is no way to access the account (with complete features) directly from the Desktop.
You can open your documents (created by your own ID) from your Microsoft Office applications using Open from Office Live option. However, you won’t be able to access shared folders or other lists from the desktop. To get full access to your account, you need to sign in to your account from browser.
Regards, Sunil Raina http://ask.officelive.com/workspace/qna/p/4403/10330.aspx

Mr Excel will take your Excel to the next level

• http://www.mrexcel.com/podcast/learnexcelpodcast.html
• A fine list of basic tips for Excel 2007 Table of Contents - LTS Online Help Collection, UWEC