Excel the way you've wanted it

You can download a 30 day trial at PUP V6 Home

Here are some features just in the area of Chart & Graphics Tools:

Chart Data Labeler: IMPROVED

Lets you apply labels (contained in a range) to a chart data series -- a feature that is surprisingly missing from Excel. Enhancement: Now ignores data that is hidden as a result of autofiltering.

Resize Charts: NEW

Makes it easy to make a chart an exact size, or make all charts the same size.

Convert Chart To Picture: NEW

Makes a copy of a chart as a static picture. This is useful for saving charts that depict various what-if scenarios.

Chart Report: NEW

Produces a detailed report that documents a chart, or produces a report that documents all charts.

Object Align, Size & Space: NEW

Back by popular demand. This utility was removed from PUP v5, but now it's back. It provides an easy way to precisely align, size, and space a group of objects or embedded charts.

Object Hide / Unhide: NEW

An interactive way to hide or unhide charts and other objects on a worksheet.

There is, of course, PUP v7 Power Utility Pak v7

You can also see his blog at J-WalkBlog.com.

The blog has little or anything to do with Excel.
It covers everything else in all the other worlds.

Labels: Addins

Numbers from the ether

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

Labels: Addins, General

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

A range of expressions

See the screen shots and download the free workbook:
Images to Excel

Excel 2003



This picture covers a range of A1:BL74, 4,736 cells, viewed at 15% zoom.

Excel 2007



This picture covers a range of A1:GR300, 60,000 cells, viewed at 10% zoom.



See all Topics
excel

Labels: Addins, Gadgets

2007 is lacking

"Yes, unfortunately, the Insert from Scanner and Camera feature was removed in Office 2007.
This was a difficult call, but I think for the best of the product overall. The feature supported a limited number of scanners and the camera support had not been updated for some time.
We came to the conclusion that most users would be better off using the software that came with their camera, scanner or even built into Windows, to get their images from their device, to the file system, and then use the Insert Picture command to get them into Office.
The downside, is that for some users, this feature did work and so will be missed."

"The From Scanner or Camera option for adding pictures to a presentation, photo album, or workbook is not available in Microsoft Office PowerPoint 2007 or Microsoft Office Excel 2007.

Instead, you can add pictures from your camera or scanner by downloading the pictures to your computer first, and then copying them from your computer into PowerPoint or Excel."

Support.Microsoft.com
How to insert scanned images in Office 2007

You could also use the Microsoft Document Imaging/Scanning application.
About Microsoft Office Document Imaging

BTW, when the article calls for clicking on the Scan button, it's actually the picture of a scanner.





See all Topics
excel

Labels: Addins, Tips

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

Not everyone is going to jump at once

Microsoft Office Word, Microsoft Office Excel, and Microsoft Office PowerPoint versions 2000 through 2003 cannot natively open documents that are stored in the Office Open XML Formats in 2007 Microsoft Office programs.

You can install the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats to open or to save 2007 Office files.

Microsoft Office XP and 2003

Word, Excel, and PowerPoint

After you install the Compatibility Pack, you can use your existing version of Word, Excel, and PowerPoint to open, edit, and save the file formats that are new to Word 2007, Excel 2007, or PowerPoint 2007. For example:

• You can open Word, Excel, or PowerPoint 2007 files by double-clicking them exactly as you do with your existing Word, Excel, and PowerPoint presentation(s).
  
• You can save Word, Excel, or PowerPoint 2007 files by clicking the Save button in your version of Word, Excel, or PowerPoint.

Microsoft Office 2000

Word, Excel, and PowerPoint

Word 2000

• After you install the Compatibility Pack, you can open, edit, and save the document file formats that are new to Word 2007 within Word 2000.
  
• You can open files in the formats that are new to Word 2007 by double-clicking the files.
  
• You can save files in the formats that are new to Word 2007 by clicking Save in Word 2000.

Excel 2000 and PowerPoint 2000

• After you install the Compatibility Pack, you can open and save the file formats that are new to Excel 2007 and to PowerPoint 2007 from the Microsoft Windows operating system.
  
• You can open files in the formats that are new to Excel 2007 and to PowerPoint 2007 by double-clicking the file on the desktop, in the My Documents folder, or in Microsoft Windows Explorer.
  
• You can save files in the formats that are new to Excel 2007 and to PowerPoint 2007 by right-clicking an Excel 2000 file or a PowerPoint 2000 file and then clicking Save As.

Labels: Addins, Formats