Shake hands with a worksheet

• Add a Get Started tab to the Ribbon
  
  
• Take advantage of the Quick Access Toolbar
  
  
• Minimize the Ribbon, maximize your workspace
  
  
• Choose your own default font
  
  
• Restore missing worksheet tabs
  
  
• Freeze panes here, there, and everywhere

Labels: 2007, Tutorials

Different can be good

• Why changes were made in Microsoft Office Excel 2007
  
  
• What happened to the File menu?
  
  
• Different screen resolutions can change what you see
  
  
• Put commands on your own toolbar
  
  
• Using the new keyboard shortcuts
  
  
• How to work with people who don't have Excel 2007

• Demo: Up to speed with Excel 2007
  
  
• Interactive: Excel 2003 to Excel 2007 command reference guide
  
  
• Reference: Locations of Excel 2003 commands in Excel 2007
  
  
• Keyboard shortcuts in the 2007 Office system

Labels: 2007

Beta Toy

"The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel. The add-in plugs into Excel 2007 seamlessly, its entry point located on the Data Tab under the From Web option.

The system extracts data by learning from a user's selection of data they wish to capture into Excel. The more selections, the more the system is trained.
An example scenario: You wish to import and track data from MSN's weather page. Visit the site using the tool, enter Data Capture mode, and select a row or two of data from the table. Then click Select Similar, and the system will find similar data based on your previous selections.

You then can click Import and leverage Excel's rich data-editing capabilities, including the Refresh command, which will revisit the Web page and extract potentially new, updated data."

Labels: 2007, Addins

Exchange the future and the past

"Microsoft has added new file formats to Microsoft Office Word, Excel, and PowerPoint 2007. To help ensure that you can exchange documents between Microsoft Office releases, Microsoft has developed a Compatibility Pack for the Office Word, Office Excel, and Office PowerPoint 2007 File Formats"

Use earlier versions of Excel, PowerPoint, and Word to open and save files from 2007 Office programs

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007



See all Topics
excel

Labels: 2007, Addins

Curmudgeon candy

Bring back the Office 2003 menus and toolbars to your copy of Microsoft Office 2007.

Frustrated by endless searches for features on the Ribbon? Download and install this software and easily use the familiar main menu, the standard toolbar and formatting toolbar in Office 2007, as you did in Office 2003.

All new features items of Microsoft Office 2007 have been added into the main menu and toolbars.

• Classic Menu for Word 2007
  
• Classic Menu for Excel 2007
  
• Classic Menu for PowerPoint 2007

Labels: 2007, Addins

Where'd they hide that thing?

Wondering where your favorite Word 2003 commands are located in the new Word 2007 interface? Or just want to explore the rich, new design with a little guidance?

... rest the mouse pointer over a Word 2003 menu or button to learn its new location in Word 2007. To see an animation of the location of the command or button in Word 2007, just click it.

Command reference guides for:

Word
Excel
PowerPoint

The versions above require an internet connection.
Below are the links to download the guides to your machine.

PowerPoint
Excel
Word



See all Topics
excel

Labels: 2007, Addins, Shortcuts, Tips

Ribbon add-in tutorial portal

" This add-in adds a Get Started tab to the Excel 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 Excel 2007 quickly.

An Office Online interactive command mapping tool, also available on the Get Started tab, shows you where to find Excel 2003 buttons and commands in Excel 2007. Office Online Community discussions are also available directly from Excel with this add-in."

Labels: 2007, Addins, Shortcuts, Tips