Upgrade from Office 2003 to Office 2010

Here are some "what's new in 2010 links":

Office 2010 Technical Preview: No ‘Wow,’ Just Solid Improvements

**http://www.cio.com/article/497135/Office\_2010\_Technical\_Preview\_No\_Wow\_Just\_Solid\_Improvements**

What Your Organization Should Know About Office 2010

**http://www.techsoup.org/learningcenter/software/page12579.cfm******

MS Word Blog – Co-authoring tag search

**http://blogs.office.com/b/microsoft-word/archive/tags/co\_2D00\_authoring/******

MS Office 365 and MS Office 2010: Better together – Co-Authoring

**http://www.techrepublic.com/blog/msoffice/microsoft-office-365-and-microsoft-office-2010-better-together/7626******

Office 2010 Collaboration / co-authoring User’s Guide

**http://www.informationweek.com/news/smb/hardware\_software/226400004**(Tells how to make co-authoring work, conversely, how to ‘break’ it!)

Document collaboration and co-authoring from Sharpoint Server

**http://office.microsoft.com/en-us/sharepoint-server-help/document-collaboration-and-co-authoring-HA101812148.aspx******

Core Apps?

**http://www.infotech.com/research/ss/make-the-decision-to-upgrade-to-microsoft-office-2010/whats-new-in-office-2010-core-apps?c=guest******

What’s New in Office 2010 Peripheral Apps

**http://www.infotech.com/research/whats-new-in-office-2010-peripheral-apps******

New Features 2007 - 2010 - Features in Compatibility Mode

**http://office.microsoft.com/en-in/word-help/use-word-2010-to-open-documents-created-in-earlier-versions-of-word-HA010368874.aspx******

What’s New in Word 2010

**http://technet.microsoft.com/en-us/library/cc179199.aspx******

**http://www.computerworld.com/s/article/9218066/Word\_2010\_cheat\_sheet**

The File tab/Backstage

File tab in Word 2010 replaces the Office orb button in Word 2007, which replaced the old File menu

Navigation Pane (aka Document Map)

Find has been moved into nav pane

Find shows brief preview of around each hit

Display thumbnail page view

Re-organize headings using drag and drop

Paste Preveiw

When you paste anything into Word, a small icon of a clipboard appears next to what you’re pasting, with a downward-facing triangle next to the clipboard. If you click the triangle, you will see small thumbnails for all the paste options available to you for the specific type of content you’re pasting.

Image Editing Tools

new tools for performing basic image editing on a graphic or photo

Text Effects

add all kinds of special effects to any text on the page -- make the text outlined, make it look as if it glows, apply a gradient, apply one color to the outline and another to the fill, add shadows

the text remains as text, rather than being turned into a graphic

Protected View

is designed to keep you safe when opening Word documents sent to you via e-mail or that you downloaded from the Web

you can’t edit those documents, or even print them -- you can only read them

Compatibility Mode in 2007 - 2010

**http://office.microsoft.com/en-in/word-help/use-word-2010-to-open-documents-created-in-earlier-versions-of-word-HA010368874.aspx******

Check Compatibility

**http://www.informit.com/articles/article.aspx?p=2032681&seqNum=7**

Prepare a File for Sharing

The Microsoft Office applications also give you tools for checking a document before you share it. These features are primarily designed for both security and accessibility issues. For example, you can check the document for any personal information that might be contained in it; this is a security check because you don’t necessarily want to share personal information in the shared document. Or you might have text in the document that will be difficult for people with disabilities to read; this is an accessibility issue.

The Check for Issues button on the Info window in the Backstage provides three tools that check your file for possible issues related to sharing:

·      Inspect Document: This tool inspects the document for specific content such as comments, annotations, document properties, and hidden text. The main purpose of the inspector is to help ferret out personal information that you might have inadvertently stored in the document.

·      Check Accessibility: This tool opens the Accessibility Checker task pane in the document and provides a list of warnings related to accessibility issues in your document. For example, several blank lines between paragraphs might signal to a person using a screen reader that the document has ended. As you select each warning in the task pane, you are presented with information on why you should fix the issue and suggestions on how to fix it.

·      Check Compatibility: This tool checks the file for items that are not supported by earlier versions of the application that you are using. For example, I might have used the Citation and Bibliography features in Word 2013, but the Compatibility Checker tells me that earlier versions of Word (Word 97–2003) need to convert these items to static text.

As already mentioned, you can run these tools from the Backstage in the Info window. The purpose of these tools is to negate the chance of sharing personal information (inspect document), make sure that the file is accessible to users with disabilities (check accessibility), and ensure that users of earlier Office products can access the file and view its content (check compatibility).

What’s New in Word 2007

**http://www.computerworld.com/s/article/9010482/Word\_2007\_Cheat\_Sheet******

Each tab along the Ribbon is organized to make it easy to get your w ork done. (so they think)

Office Button

·      Think of the Office Button as a greatly expanded File menu

·      Prepare - when you’re ready to send it to someone else. New options: marking a document as final or marking it read-only; encrypting the document; inspecting it for hidden metadata and information you’d prefer remain private; and editing the document’s properties, such as title, keywords and author

·      Publish - as a blog to a variety of blogging services, including Blogger, Windows Live Spaces, TypePad and WordPress, and SharePoint

·      Convert  documents saved in older formats to the new Microsoft Office Open XML format (.docx)

·      Word Options button, located at the bottom of the Office Button’s box, lets you customize Word

·      There’s just one customizable toolbar in Word 2007, the Quick Access Toolbar

Quick Access Toolbar – QAT

·      the nearly invisible Down arrow to the right of them is the key to the toolbar. Click it, and you’ll be able to add and remove toolbar buttons for a preset list of commands.

Mini- Toolbar - Highlight text and point the cursor at it, and a nearly transparent mini toolbar appears above the text, with a set of commands relevant to the text you’ve chosen

New File Format

·      files are automatically compressed

·      saves different data components -- such as tables and charts -- separately from one another

Themes - create a single, overarching theme, with colors, logos, paragraph styles and so on, and then use that theme for all of your Office documents.

Quick Parts – aka AutoText

·      complex headers and footers, objects such as decorative text callouts, and fields for dates, file names, bar codes

·      “Document Property” for objects that relate to the entire document, such as Author, Company and Keywords

·      Field to insert a field such as the number of words or the page number

·      Building Blocks Organizer to see every single Quick Part available

Live Preview - move your cursor over the format you want to apply. The text you highlighted will change so that you can see how it will look with the new formatting.

Changes in Office Word 2007

**http://technet.microsoft.com/en-us/library/cc179199%28office.12%29.aspx**-This article lists the changes in Microsoft Office Word 2007 from Microsoft Office 2003.

What’s new in Excel 2010

**http://www.computerworld.com/s/article/9220441/Excel\_2010\_cheat\_sheet?taxonomyId=86&pageNumber=1**

**http://office.microsoft.com/en-in/excel-help/what-s-new-in-excel-2010-HA010369709.aspx?CTT=1******

Sparklines -are smart, simple graphics you add to a single cell to give quick visual representations of data, especially data that changes over time -- for example, unit sales of a particular item over the course of several years. A Sparkline can show you at a glance the historic ups and downs of that item.

Slicers -are small windows that make it easy to click values to add or remove them from a PivotTable filter.

Paste Preview -When you paste anything into Excel, a small icon of a clipboard appears next to what you’re pasting, with a down-pointing triangle next to the clipboard. If you click the triangle, you will see small thumbnails for all the paste options available to you for the specific type of content you’re pasting -- whether to retain formatting of the data you’re importing, or to paste the formula itself or the data created by the formula, or to retain the borders of the cell you’re importing, and so on.

Pivot table Enhancments-Show Values As feature adds several new automatic calculations, such as percent of parent row/column total, percent of running total, or rank.

Pivot Chart Enhancements -now include buttons to help you control what is displayed. They repeat the controls you find in the Field List sidebar, and all can be turned off at once before you print the chart.

Proactive Protection -Excel will now protect you from yourself by letting you recover previous versions of a file -- even those you didn’t save. Excel by default disables the macros and displays a warning message.

Image Editing Tools- new tools for performing basic image editing on a graphic or photo.

Other Tweaks– 64-bit removes 2gb file size limit. Other limits have been raised: number of data points in a chart.

Speed– multi-threading pivot tables, faster saving large files, graphics related performance improved, faster filtering and sorting, asynchronous user-defined functions. More accurate calculations. New stat, engineering, math and trig functions.  Full list, see Microsoft’s Excel 2010 site.

Conditional Formatting- more options added since 2007

Icon Sets– can now customize which of the icons in a set are displayed

2007 Vertical Gradient Bars– negative value bug fixed

---

What’s removed from Excel 2010

**http://office.microsoft.com/en-us/excel-help/discontinued-features-and-modified-functionality-in-excel-2010-HA101811053.aspx******

Excel 2010 Object Model Changes Since Earlier Versions

**http://msdn.microsoft.com/en-us/library/ee836187.aspx** (includes links to earlier Object Model change pages).

Understanding potentially impactful changes in the Office 2010 object model

**http://blogs.technet.com/b/office\_resource\_kit/archive/2011/09/08/understanding-potentially-impactful-changes-in-the-office-2010-object-model.aspx******

There are over 22,000 items (properties, methods, and constants) in the combined object models of Excel 2010, Word 2010, PowerPoint 2010, Outlook 2010, and Access 2010

There are 2,134 changes in the object models

There are 49 potentially impactful changes

49 potentially impactful changes. Across 5 applications. Spanning 4 previous versions. That’s it. Here’s a chart that sums up our findings:

---

What’s New in Excel 2007

**http://www.computerworld.com/s/article/9218066/Word\_2010\_cheat\_sheet**

Excel 2010 cheat sheet – What’s New- http://www.computerworld.com/s/article/9220441/Excel\_2010\_cheat\_sheet?source=ctwirhr\_excelcs\_reg

Increased Limits

·      increased the number of columns per spreadsheet (and per PivotTable) to 16,384 (up from 256)

·      number of rows to 1,048,576 (up from 65,536).

·      Text cells can now contain more than 32,000 characters (up from 255).

·      PivotTables can manipulate more than 16,000 fields (up from an already generous 255),

·      formulas can now refer to up to 8,000 cells (memory permitting),

·      it’s fortunate that Excel 2007 lets you drag the corner of the formula bar to expand it.

·      Excel 2007’s memory manager can handle 2GB (double the amount in Excel 2003), so calculations execute faster.

·      takes advantage of dual-core processors and multithreaded chip sets,

·      nesting levels has increased, from seven in Excel 2003 to 64

·      New Visualization Tools

·      Charts and graphs now support 16 million colors

·      use conditional formatting to set the background color of a cell

·      use a colored bar (called a data bar) -- the length corresponds to the cell’s value.

·      icons to cells based on their value, giving your worksheet a dashboard-like quality

·      four- or five-icon set (such as set of vertical bars similar to what your cell phone uses to indicate signal strength) displays icons based on which quartile or quintile the value falls into.

Better Sorting & Filtering

·      sort by value or the icon used in conditional formatting

·      sort expanded to 64 levels from 3

·      sort by font, color and icon using conditional formatting

·      visualization tools eliminate the need for complicated macros or formulas

·      New conditional formatting options let you highlight duplicates, unique values, the top/bottom 10%, values above or below the average, cells less than or greater than a specified value, or cells within a range (highlighting cells containing values between 1 and 10, for example).

·      Filter feature offers check boxes to let you pick which rows you want to see.

Working with Pivot Tables

·      Instead of dragging and dropping elements within the table itself, you can use the wizard to make choices -- checking boxes to select which fields to display or choose sorting options, for example

·      easier to switch columns and rows, filter values, and use or hide field names

·      conditional formatting can be applied to cells displayed in PivotTables.

Styles and Themes

·      apply styles using Gallery on Ribbon

·      preview selections by hovering mouse over choice

·      autoformat alternate row patterns now automatically adjust for inserted rows

·      Themes are style collections that include a color scheme, font, fill effects and more. Shared by several Office 2007 applications, themes can be applied to charts, tables and PivotTables in Excel, giving your work a consistent look and feel with Word documents and PowerPoint presentations.

·      ability to more easily apply graphical effects, such as bevels and shadows, to individual elements

·      control everything about charts, from shadows to the amount of rounding on the corners of bars and columns

Table Tools

·      you identify a contiguous range of cells as a table, Excel provides calculated columns

·      if you add a column to the right of your table and enter a formula in any row, the formula will be copied to all cells in that new column

·      add a row and Excel is sure to include it in a total on the bottom row

·      as you scroll down through a lengthy table, Excel replaces the column headings (the gray boxes with A/B/C above the columns) with values from the table’s header row -- a subtle improvement

·      Table Gallery makes it easy to select and apply styles

Other Changes

·      51 new functions

·      new functions, SUMIFS and AVERAGEIFS, let you choose cells that meet multiple conditions without having to use nested functions

·      save as PDF and XPF formats

·      Name Manager helps you organize and manage your named ranges

·      changes keep Excel’s user interface consistent with Word and PowerPoint (well only kinda, Ron)

·      SmartArt is shared across Office 2007 applications

·      Access to SharePoint library

·      If you use PowerPoint to build charts, you’ll find that its old graphics tool (MSGraph) has been replaced by Excel’s charting and worksheet engine

---

Wikipedia Office 2010 version comparison

https://secure.wikimedia.org/wikipedia/en/wiki/Microsoft_Office_2010****

Feature behavior changes

**http://office.microsoft.com/en-in/word-help/compatibility-changes-between-versions-HA010370116.aspx******

******************

Features removed from Office 2010

https://secure.wikimedia.org/wikipedia/en/wiki/Microsoft_Office_2010****

Removed from the entire suite

Microsoft Office Document Imaging application

Microsoft Office Document Scanning application

Office Startup Assistant (Osa.exe)

Office Diagnostics tool

Support for MSXML version 5[36]

Research and Reference pane for Internet Explorer^[37]^

Features removed from Microsoft Word

Smart Tag auto-recognition^[38]^

Person Name smart tag

AutoSummary feature

Support for Word Add-in Libraries (WLL)^[37]^

---

First thing, take a close look at your license. If you simply bought "consumer" retail licenses, you have the option of keeping 2003 installed along side of 2010. It requires a simple registry hack to avoid a constant "configuring" error when you switch between versions.

Question: is there a specific reason you are going to 2010 and not 2013.  The simple reality is that 2010 is on it's way out and as long as you don't find the look of 2013 too objectionable you would probably be better served by going directly to 2013 now ... consider it.

The main customization in 2003 to consider is custom toolbars.  That option is no longer available as such in the ribbon.  BUT you can bring those custom toolbars into the ribbon. You need to keep copies of 2003 available to maintain them

Use Word 2000/3 Toolbars in Word 2007/2010

http://www.gmayor.com/Toolbars\_in\_word\_2007.htm

You asked for it, here is part of my link collection on upgrading from 2003 to 2007/2010 ...

Note; when you are searching for tips, tips written for 2007 will usually work in 2010 too.  Also look at articles on "Whats new in 2007" because that content wouldn't be covered in the 2010 articles.

****************************************

Learning the Ribbon Links

A key point to keep in mind is that from the point of view of the “Average User”, Office 2007 and 2010 and 2013 are 99% identical. Tips specific to 2007 almost always are still valid in 2010 and 2013 apps so don’t automatically ignore tips and articles that were created for 2007 or 2010 (and even for menu versions of the tips. The underlying concepts are the same, you just have to adjust for changes to the UI from menu to ribbon!).

This next link is one of the best resources I’ve looked at for getting you into the right frame of mind for learning and using the ribbon gooey.

Stop Clicking and Exploring Excel 2007 like a Newbie - http://www.scribd.com/doc/29093109/Stop-Clicking-Exploring-Excel-Ribbon-Like-Newbie

• applies to any Ribbonized app. This is an excellent booklet to get people into the right frame of mind to learn and use ANY ribbonized app.

24 new Office 2007 interface elements (and what most of them are really called)

http://blogs.techrepublic.com.com/msoffice/?p=139

Mini-glossary: Office 2007 terms you should know

http://i.i.com.com/cnwk.1d/i/tr/downloads/home/\_dl\_mg\_office2007.pdf

TechRepublic  Feature guide: What you need to know about Microsoft Office 2007

---

2010 / 2007 Search Command Addon www.officelabs.com/projects/searchcommands/Pages/default.aspx

(http://www.markshuttleworth.com/archives/939/ - The Linux answer to the ribbon, supplement menus with it’s version of the “Search Command” addon everywhere)

Office Watch Word/Excel Command Finder -

The Office watch command finders are really good tools, they actually provide a more focused result, but the path it describes is sometimes wrong. (They got all of the info from MS ...). They have also added some commands that are not on the “official” MS command list.

http://office-watch.com/t/n.aspx?a=1558 - Word 2010 Command Finder Description

http://office-watch.com/t/n.aspx?a=1569&z=0 - 2010 Command Finder improvements

http://office-watch.com/commandlist/Word\_2010.aspx  Word 2010 Command Finder

http://office-watch.com/commandlist/Word\_2007.aspx  Word 2007 Command Finder

http://office-watch.com/commandlist/Excel\_2007.aspx - Excel 2007 Command Finder

---

You can add the link to OWW Command Finder tool to the Word QAT using this macro:

Public Sub command_finder()

‘ Ed Weber

‘ Call the Office Watch Command List applet

‘ Equivalent to the Search Tab addon

‘

    ActiveDocument.FollowHyperlink _

    Address:=” ***http://office-watch.com/commandlist/Word\_2010.aspx***”, _

    NewWindow:=True, AddHistory:=False

End Sub

---

This is the macro you need for Excel

Private Declare Function ShellExecute Lib “shell32.dll” Alias “ShellExecuteA” _

    (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal _

    lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Sub command_finder_2007()

‘ Launches a webpage.

‘

    Dim strURL As String

    strURL = “http://office-watch.com/commandlist/Excel\_2007.aspx”

‘Navigate to the address...

    On Error Resume Next

    ShellExecute 0&, vbNullString, strURL, vbNullString, vbNullString, 3 ‘SW_SHOWNORMAL

End Sub

---

Map 2003 menu to 2010 Ribbon Silverlight applets and spreadsheets- https://office.microsoft.com/en-us/support/learn-where-menu-and-toolbar-commands-are-in-office-2010-and-related-products-HA101794130.aspx?CTT=3 – Another way of finding “lost” commands

I just watched the video on this page:

http://blogs.msdn.com/b/jensenh/archive/2008/03/12/the-story-of-the-ribbon.aspx

It’s just under 1.5 hours. I found it quite informative. It explains a lot of the (ir)rational behind the Ribbon design, including the name by the Manager in charge of it’s development (not that I agree with it all...).  The slides download just don’t tell the story.

---

---

**Jensen Harris: An Office User Interface Blog** –

This one can be used to find answers to the inevitable question: “why did stupid MS do this, that or the other stupid thing in the stupid ribbon’:

Original source:  http://pschmid.net/blog/2006/10/09/58 

alternate source http://blogs.msdn.com/b/jensenh/archive/2008/03/12/table-of-contents.aspx 

     This is an organized Table Of Contents to a large collection of links to MS Dev Team Blogs about the design and building of the 2007 ribbon. A LOT of reading, but interesting to understand the underlying (il)logic of the Ribbon

12 Steps to become awesome in Excel (and your work) in 2012 - http://chandoo.org/wp/2012/01/06/12-ways-to-learn-excel/ - although this tip is identified as being specific to Excel, it applies to any software (ruined by ribbonization or not), and life in general.

http://www.askvg.com/download-free-microsoft-office-2010-getting-started-screensaver-for-windows-7/

Download a free screensaver from MS that presents short video tips. New tips constantly downloaded from a MS RSS feed.

Good site, lots of good tips. Their newsletter is worth signing up for.

Map 2003 menu to 2007 Ribbon Flash Applets, spreadsheets- https://office.microsoft.com/en-us/support/guides-to-the-ribbon-use-office-2003-menus-to-learn-the-office-2007-user-interface-HA010229584.aspx

http://www.worldstart.com/ms-office-2010-still-having-trouble-locating-things-on-the-ribbon/comment-page-1/#comment-26505

2007/2010 Getting Started Tab addin Download

The optional “Get Started” addin also has a button to the “Interactive Word 2003 to Word 2007 Command Reference Guide”, but this button activates an internet link to the MS website.  Personally, I prefer using the downloaded flash applet.  Note: I have had problems trying to run the online version on FireFox, it worked fine in IE.

https://office.microsoft.com/en-us/training/download-help-to-get-started-with-office-2007-HA010214685.aspx?pid=CL100788241033

This download adds a Get Started tab to the end of the Word 2007 Ribbon. Commands on this tab give you easy access to free content on Office Online, such as training courses, video demos, and other Office Online content designed to help you learn Word 2007 quickly. An Office Online interactive command mapping tool, also available on the Get Started tab, shows you where to find Word 2003 buttons and commands are in Word 2007. Office Online Community discussions are also available directly from Word with this add-in.

Ribbon Hero  - **http://office.microsoft.com/en-us/help/be-ribbon-hero-and-have-fun-doing-it-HA010390372.aspx****** A learning game that guides you through various Office features.

Ribbon Hero 2: Clippy’s Second Chance -**http://www.ribbonhero.com/news.html****** New version of the learning game.

Office 2010 Getting Started resources downloadspage- Articles, interactive guides and guidance to help you be more productive with Office 2010 more quickly. - http://www.microsoft.com/download/en/details.aspx?id=17339

2010 Migration Guides - https://office.microsoft.com/en-us/excel-help/office-2010-migration-guides-HA101982272.aspx

*3 ways to learn the Office 2010 ribbon* http://blogs.office.com/b/office-education/archive/2011/01/10/3-ways-to-learn-the-Office-2010-ribbon.aspx

**10+ ways to help your users transition to Word 2007** http://blogs.techrepublic.com.com/10things/?p=407

1**0+ ways to train your users on Office 2007 for free** http://blogs.techrepublic.com.com/msoffice/?p=144

Word 2010 / 2007 Free Tutorial - http://www.wordtutorial.net/****

Mini-glossary: Office 2007 terms you should know- http://articles.techrepublic.com.com/5100-10878\_11-6180692.html

**10 new Office 2007 interface elements (and what most of them are really called)** **** http://blogs.techrepublic.com.com/msoffice/?p=139

Dictionary of Windows UI terms - http://www.askvg.com/complete-guide-for-windows-customization-terms-and-resources/****

Word 2007 Cheat Sheet - Intro to Ribbon UI http://www.computerworld.com/s/article/9010482/Word\_2007\_Cheat\_Sheet   

Excel 2010 cheat sheet – What’s New- http://www.computerworld.com/s/article/9220441/Excel\_2010\_cheat\_sheet?source=ctwirhr\_excelcs\_reg

Explore what is new and different in Microsoft Word 2007 http://articles.techrepublic.com.com/5100-10878\_11-6153797.html?tag=content;leftCol

A few things you’ll miss when you upgrade to Office 2007 http://articles.techrepublic.com.com/5100-10878\_11-6161683.html?tag=content%3bleftCol 

Changes in Office Word 2007 http://technet.microsoft.com/en-us/library/cc179199%28office.12%29.aspx  -This article lists the changes in Microsoft Office Word 2007 from Microsoft Office 2003.

Word 2010 Beginners Guidebook - Good intro to Ribbon based Word $20, 236 pghttp://store.tips.net/T010905\_Microsoft\_Word\_2010\_Beginners\_Guidebook\_Table\_of\_Contents.html

10 cool add-ins for Office 2007 and 2010: http://www.techrepublic.com/blog/10things/10-cool-add-ins-for-office-2007-and-2010/2455   Everything, E-mail Follow-up, More Add-in, FreeFile Viewer, ASAP Util (excel), Proposal Pack Wizard, Visual Bee (PowerPoint), iSpring Pro (PowerPoint), Pop-Up Excel Calendar,  Excel Fuzzy Dup Finder.

**http://www.gcflearnfree.org/office2010 - Learn Office 2010****,**ie Word has 24 lessons alone.

10 Quick Tips to Get the Most from Microsoft Office - http://www.howtogeek.com/98499/10-quick-tips-to-get-the-most-from-microsoft-office/

---

Backup and Restore Your Office 2010 Ribbon and Quick Access Toolbar Customizations - http://www.howtogeek.com/72670/how-to-backup-and-restore-your-office-2010-ribbon-and-quick-access-toolbar-customizations/

Outlook http://office.microsoft.com/en-us/outlook-help/make-the-switch-to-outlook-2010-RZ101809884.aspx

Word http://office.microsoft.com/en-us/word-help/make-the-switch-to-word-2010-RZ101816356.aspx

http://www.baycongroup.com/wlesson0.htm Free Tutorials to other apps too

Excel http://office.microsoft.com/en-us/excel-help/make-the-switch-to-excel-2010-RZ101809963.aspx

PowerPoint http://office.microsoft.com/en-us/powerpoint-help/make-the-switch-to-powerpoint-2010-RZ101791923.aspx

http://www.editorium.com/editkit/TH\_18.htm - Word Functions for Editors. A good list of Word features to learn as a starting point for new users.

Blake Handler’s Ultimate lists - https://blakehandler.wordpress.com/2010/10/11/ultimate-lists-of-microsofts-free-office-windows-software-for-download/

Free MS Customized ribbon with “Favorites” tab - https://office.microsoft.com/en-us/excel-help/download-free-customized-ribbons-HA101885823.aspx

Office Sounds addin - http://www.microsoft.com/download/en/confirmation.aspx?id=7015****

Ribbon Creator 2007/2010/2013 - http://www.ribboncreator2010.de/en/?RibbonCreator\_2010

Reveal Codes in Word - Is there life after “Reveal Codes”?

 http://sbarnhill.mvps.org/WordFAQs/RevealCodes.htm .  This is an excellent article describing all of the native Word tools for discovering formatting.

http://support.microsoft.com/kb/271478/en-us  WD2000: “Microsoft Word 2000 Equivalents to WordPerfect Reveal Codes” White Paper Is Available as download “Reveal00.exe”

Formatting Problems? Install CrossEyes -

http://www.levitjames.com/Products/CrossEyes.aspx**http://www.howtogeek.com/164343/easily-view-formatting-codes-in-word-2010-using-crosseyes/** -a product review of the tool

Menu Tab addins

**http://www.addintools.com/english/menuword/default.htm** - menu addin 2007 only,free trial

---

http://toolbartoggle.com/ - I haven’t tried it yet, but it looks good. It allows drag and drop customization of the menu and toolbars.

http://www.ubit.ch/software/ubitmenu-languages/    (free fro private use or 0.65 Eur per user & per language!!!)

---

http://news.office-watch.com/t/n.aspx?articleid=799&zoneid=12 – a review of UBitMenu

http://software.techrepublic.com.com/abstract.aspx?docid=862867&promo=100511 – Classic Menu for Office 2007 ($30)

http://www.addictivetips.com/microsoft-office/add-classic-menu-in-office-2010/

http://pschmid.net/office2007/customize/

http://download.cnet.com/Classic-Menu-for-Office-2007/3000-18483\_4-10637184.html

http://www.obutilities.com/classicmenu/ - a COM add-in that displays the classic menus and toolbars in Microsoft® Excel® ,Microsoft® Word and Microsoft® PowerPoint® (Office 2007 and 2010).

http://www.indelibleink.com/WordMenu.html - Indelible Ink Word Menu addin

http://software.techrepublic.com.com/abstract.aspx?docid=847883&promo=100511 – Ribbon Customizer for Office 2007 ($40)

http://word.mvps.org/FAQs/Customization/CustomizeRibbon.htm Customizing the Office 2007 user interface. Info about 2 purchased addins, Ribbon Customizer™ and ToolbarToggle™ add-ins for Office 2007.  They also have limited functionality trial versions

http://accmsoft.com/office-2007/classic-style-menus-toolbars/ - A powerful and easy-to-use add-in for showing the classic menus and toolbars of Microsoft Office 2003 on Ribbon of Microsoft Office 2007 and 2010.

http://www.indelibleink.com/WordMenu.html - Free version of 2003 menu addin.  There are several different install options, quite cool.  Installed cleanly on my admin ID, but not in my user ID.  Installs a template in the C:\users\USERID\AppData\Roaming\Microsoft\Word\STARTUP folder.  WordMenus.dot is the 2003 menu alone.  WordMenu.dot is the 2003 menu with the standard toolbar.  WordMenusTB is the vertical orientated 2003 menu.  It looks like this

http://software.techrepublic.com.com/abstract.aspx?docid=927295 - Saavvii for Microsoft Word 2000, free to try

http://www.toolbartoggle.com/Contact.aspx - ToolbarToggle ($20) - 2 modes, full toggle replacement for Ribbon or Adds new tab to ribbon.  Allows customization of menu portion, adding macros using right click “customize togglebar” feature, not Word customize.  I haven’t tried it, but if it lives up to propaganda it looks best yet**. 5 day free trial.**

Jensen Harris 2007 Blog - Ribbon UI rationalizations

Microsoft’s traditional Windows and Office interfaces have grown more complex and inscrutable over time. (Microsoft always claims it conducts extensive user interface research, but still revamps the UI every chance it gets. It must be using a different species of alien each time.) In a touch-oriented environment, rows and rows of small, undecipherable icons just don’t work. Someone at Microsoft seems to have realized that, and perhaps Office for ARM will be truly usable. That alone could move many users away from the “heavy” x86 version of Office and, thus, Windows.

**Jensen Harris: An Office User Interface Blog** - A LOT of reading, it provides insights into the design of the Ribbon and the underlying (il)logic of the design.

http://abc.salem.consulting.home.comcast.net/~abc.salem.consulting/services.html - A PDF collection of the blogs, easier to read than the original blogs (257 pg). There is a button on the bottom of the page to download the PDF.

http://blogs.msdn.com/b/jensenh/archive/2008/03/12/table-of-contents.aspx This is an organized Table Of Contents to a large collection of links to MS Dev Team Blogs about the design and building of the 2007 ribbon.

Why the Ribbon

Why the ribbon, in Word 2003 and earlier MS Stats show:

·    only 13% of commands/ features are actively used

·    of new feature requests, only 6% did NOT already exist

---

Embracing the Most Important Attitude

**http://askleo.com/embracing\_the\_most\_important\_attitude/******

Word 2007 2010: Intro Ribbon tutorial

http://www.shaunakelly.com/word/management/word-2007-and-word-2010-ribbon-tutorial.html

New to the Office Ribbon. 2007 2010 links to all of the “Transition guides” and spreadsheet downloads 

• http://office.microsoft.com/en-us/support/office-ribbon-find-commands-FX101851541.aspx

******************************