Yes, switching to the ribbon for an experienced "Menu" user is a royal PITA. MS says the Ribbon is "Better" for NEW USERS. It groups commands in ways that user tracking (of the menu) has shown they were used. MS has NEVER said that the ribbon was better
for experienced users...
Yes, my original reply contains an overwhelming collection of links on learning the ribbon. I provide them ALL because they cover a large range of subjects and ways of learning the ribbon. Not all of them are usable by everyone, so all I can suggest you
do is look quickly at the various links and pick ones that "work" for you.
I'll summarize the links down to ones that are specific to "where the HE** did MS hide the commands in the new ribbon" ...
Stop Clicking booklet - how to get into a good frame of mind to survive the ribbon
This first booklet really helped me get into the right frame of mind for adapting to the ribbon:
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.
As well as the "Stop Clicking ..." booklet you may want to invest a LOT of time reading this file:
"pdf version office07 ui bible v05i- Jensen Harris"
(in my skydrive download section, at bottom of this reply)
contains a collection of blog entries by Jensen Harris, one of the managers on the Office 2007 development team. In these blogs he describes some of the reasons for design choices that were made, if you are willing to believe them ... <grin>. They won't really
make the ribbon more palatable, but at least you may understand why they did various "stupid" things ... <grin>
MS Search Command Addin
The "Search Command" tool created by the MS "Lab" group did a good job of telling you where to find commands in those versions. I think (haven't tested recently) that the 2010 version did carry over into a 2013 installation:
Search Commands 2010/2007 –
http://www.microsoft.com/en-us/download/details.aspx?id=28559
Office Watch Command Finder Page
The Office Watch newsletter/web site provided web pages where you can search for Word (and Excel) 2007 and 2010 commands to see a description of the command and where to find
them on the ribbon. You can create a macro, and put that macro on your QAT (Quick Access Tab) in Word so that you can quickly access the Office Watch search page:
http://office-watch.com/commandlist/Word_2010.aspx
Word 2010 Command Finder
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_2007.aspx
Word 2007 Command Finder
http://office-watch.com/commandlist/Excel_2007.aspx - Excel 2007 Command Finder
Office Watch Word Command List
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
MS "Upgrading to" 2007/2010 Resources
When Office 2007 and 2010 were released, MS created resources that helped users "upgrade from 2003 to ....". Unfortunately they did not bother doing this for 2013 <sigh>.
The 2007 resource pages don't appear to be available, but the 2010 resources are still there ...
http://www.microsoft.com/en-us/download/search.aspx?q=interactive+menu+to+ribbon+guide
You can install the "Interactive menu to ribbon" guides. They are small applications that allow you to click on a 2003 menu and the application shows you the command on the
2010 ribbon. Most of the 2013 commands are in the same place as in 2010 so it is reasonable to use these 2010 guides
(Note: I've included these resources and several others in the link to my skydrive)
*********************
2003 to 2007 Training Manuals
This page has links to free training manuals for going from 2003 to 2007
http://www.techsupportalert.com/content/free-training-manuals-ms-office.htm
******************
Download free MS menu to Ribbon Resources
Finally, here is a link to my skydrive where I've uploaded various free MS resources for the migration from 2003 to 20?? since it so hard to find them on the web: http://1drv.ms/1JctyQh