Ideas and links: MS Office 2010

Showing posts with label MS Office 2010. Show all posts

Tuesday, December 13, 2011

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

Tuesday, November 01, 2011

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

Tuesday, October 25, 2011

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

Thursday, April 07, 2011

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:

In most versions of Word search and replace click More / Special / "paragraph mark".
Click in the replace box and type $$$$.
Click Replace All.
Repeat to replace "manual line break" with $$$$.
Select the table or cells and choose Copy (or CTRL+C).
Switch to Excel.
Click on the top left cell where the table will be pasted.
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.
Search and replace the $$$$ by CTRL+j *
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

Friday, January 14, 2011

Office Add-in for Moodle

I'm still trying to get exited over using Moodle; but it all seems like a lot of work. Maybe this tool will make my life easier. Steve.

"Uploading files to Moodle has never been easier. The Office Add-in for Moodle (OAM) is an add-in for Microsoft Office (versions 2003, 2007 and 2010) that allows teachers to open and save Word, Excel, and PowerPoint documents to a Moodle website.

Today, teachers who use Office and Moodle have to switch back and forth between their web browser and Office applications. With the OAM, teachers can create, open, edit, and save Moodle documents from within the Office applications. You no longer need to use your web browser when working with Office documents stored in Moodle." Office Add-in for Moodle

	Download the Office Add-in for Moodle version 1.1 x86
	Download theOffice Add-in for Moodle version 1.1 x64

Sunday, December 12, 2010

IT training Office 2010

How to use Microsoft Office picture manager:
http://ittraining.lse.ac.uk/Documentation/OnlineGuides/Picture-Manager.htm

Vocabulary & concepts:
http://en.wikipedia.org/wiki/Image_editing

some general references:
http://en.wikipedia.org/wiki/Microsoft_Office_Picture_Manager

How to install it:
http://office.microsoft.com/en-us/help/HP011454871033.aspx
IT training - IT training - IT Services - Administrative and academic support divisions - Services and divisions - Staff and students - Home

Friday, November 19, 2010

Get MS-Office Pro Plus - Educational Pricing for all our STUDENTS!

You can now get Microsoft Office 2010 Pro Plus at student pricing of $141 (taxes and shipping included see below) without school board email account. Here is a list ofparticipating school boards.

NOTICE: this is a more elaborate package than the
Microsoft Office Professional Academic 2010 for $89 I mentioned last week and only available to users with a school board email account.

-------------FRANCAIS

Vous pouvez vous procurer la suite Microsoft Office 2010 Pro Plus pour environ 141$ (taxes et livraison inclus) sans courriel de la commission scolaire. Voici une liste des commissions scolaires qui participent a cette offre.

AVIS: Cette offre comporte plus de logiciels que le Microsoft Office Professional Academic 2010 for $89 présenté la semaine dernière qui n'est disponible qu'aux utilisateurs ayant une adresse de courriel de la commission scolaire.

Pour commander votre CD-ROM (aucun manuel) de Softchoice:

Demandez une preuve d'inscription de l'école (Ceci peut-être tout document officiel de l'école qui affiche votre nom).
Imprimez ce Contrat
Complétez le bas de la page 1 (ne pas compléter le haut)
Complétez le bas de la page 3 (ne pas écrire Numéro d’identification de l’étudiant en majuscules)
Imprimez ce Bon de commande
Fournissez vos détails au haut de de la page 1
À la ligne du deuxième produit, soit Office Professionnel plus 2007, rayez le 2007 et écrivez 2010
Au bas du formulaire indiquez 15$ de livraison, 125$ total partiel, pour un total de 141$
À la page 2, indiquez vos détails de carte de crédit.
Transmettez les documents au télécopieur 1 800 268 7639 à Maxime Larivé chez SoftChoice etudiantqc@softchoice.com

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

Voici une copie des consignes tirées du site Secteur de l'éducation - Québec de Softchoice

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

Téléchargez et remplissez les documents PDF suivant qui comprennent un bon de commande et un exemplaire du " Contrat de licence Sélect à l'intention des étudiants".

Contrat de licence Sélect à l'intention des étudiants

Bon de commande : licence Sélect de Microsoft à l'intention des étudiants

Consignes importantes

Lisez attentivement toutes les clauses du contrat.

Complétez les sections 1 et 7 du contrat; ne remplissez pas l'en-tête.

Inscrivez vos coordonnées et les renseignements de crédit sur le bon de commande.

Faites une photocopie d’un document attestant que vous êtes un étudiant ou un employé de la commission scolaire; assurez-vous que les renseignements demeurent bien lisible.

Télécopiez-nous le bon de commande, le contrat et la photocopie de la preuve d'identité au 1-800-268-7638.

SI VOUS ÊTES ÂGÉ DE MOINS DE 18 ANS : tous les documents que vous nous transmettez doivent être remplis par un de vos parents ou votre tuteur.

Notez qu'aucun retour de marchandise ne sera accepté. Si vous recevez un produit endommagé ou défectueux, veuillez nous aviser en écrivant à etudiantqc@softchoice.com. Dans ce courriel, inscrivez vos coordonnées et les détails de votre commande originale. Le cas échéant, la marchandise sera remplacée.

Pour plus de renseignements, écrivez-nous à etudiantqc@softchoice.com.

Tuesday, August 24, 2010

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).

Friday, August 13, 2010

SKYDRIVE Microsoft finally delivers a punch to Google Docs

This new interface holds great promise, students can use it to practice at home for free and store up to 25 GB in the Cloud. Not bad. Sync is very cool if you install this on othe PC you want to sync.

Install this to Sync https://sync.live.com/clientdownload.aspx?ibm=10
Open this to manage your files and edit documents skydrive.com

Saturday, May 01, 2010

Moving controls around isn't always an improvement.

I'm tired of software redesigning the user interface, would you buy the car with the following "features" Office 2010: a deeper dive

- The 2012 cars will be changed:

> the gas pedal is now where the horn used to be,

> the horn is where the brake pedal used to be,

> the brake pedal is now where the turn signal activator used to be

> the turn signal activator is where the gas pedal used to be

> the gear shift mechanism is where the sunroof used to be

> the steering wheel doesn't turn anymore steering the car has been replaced with the 4 arrows of a computer keyboard

> the rear view mirror now shows you what's in front of you

> the clutch for a manual transmission is where the door handle used to be

> the door handles are now under the seat

> the cruise control buttons are where the Radio / CD player used to be.

> the Radio / CD player controls are now on the head rest of drivers seat

> etc.

Source: Ask E.T.: PowerPoint Does Rocket Science--and Better Techniques for Technical Reports

...requires all federal employees and contractors employed at NASA centers to have a current version of MS Office installed on their desktop computer. Back of the envelope cost*: $13,200,000 every time a new version comes out.

Friday, April 30, 2010

Some useful comments about Office 2010

Ok, it sounds like office 2010 is 2007 finished. Source: Office 2010: a deeper dive

Much of the work in Office 2010 is cleanup and polishing, smoothing over rough edges, making common features work the same across apps, improving performance. In some striking ways, Office 2010 is to its predecessor as Windows 7 is to Windows Vista. And that’s not a bad thing.