How do I know it's real?

What is a digital certificate?

What is a digital signature?

What occurs when I use a digital signature?

What Word files can I sign?

How can I obtain a digital signature?

• Method 1: Obtain a digital certificate from a certification authority
  
• Method 2: Create your own digital certificate

Labels: Addins, General, Tips

ToolPak Translator

"Ever wanted an oversight of the Analysis-ToolPak Add-In functions, their descriptions, their arguments, their VBA and Procedure names, and all of this in your LOCAL language including translations versus the corresponding English names?

This utility extracts this data from your LOCAL MS Excel edition.

As such this table can be generated for ANY LANGUAGE EDITION of MS Excel, even when this language is not yet integrated in the utility."

Labels: Addins, Reference

Define Print & View Areas

"Using the Report Manager add-in program, you can combine worksheets , views (a set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.), and scenarios (a named set of input values that you can substitute in a worksheet model.) into printable reports. For example, if you have a Best Case and a Worst case scenario, a Summary view, and a Details view, you can create a report that presents the Best Case scenario in the Details view and another report that presents the Best Case Scenario in the Summary view. Reports that you create are automatically saved with your workbook so that you can print them at any time."

Create a report for printing

1. On the View menu, click Report Manager.
   
2. Click Add.
   
3. In the Report Name box, type a name for the report.
   
4. In the Sheet box, click the sheet you want to use for the first section of the report.
   
5. Do one of the following:
   
   • To use a view for the first section of the report, select the View check box, and then click the view in the View box.
     
   • To use a scenario for the first section of the report, select the Scenario check box, and then click the scenario in the Scenario box.
     
6. Click Add to enter the view or scenario as a section in the Sections in this Report box.
   
7. Repeat step 5 and 6 until you've created all of the sections you want in the report.
   
8. To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
   
9. To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.
   

Edit a report for printing

1. On the View menu, click Report Manager.
   
2. In the Reports box, click the report you want to edit, and then click Edit.
   
3. Do one or more of the following:
   
   • To add a new section, click the sheet, view, and scenario you want under Section to Add, and then click Add.
     
   • To delete a section, click the section in the Sections in this report box, and then click Delete.
     
   • To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
     
   • To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.
     
   Note Microsoft Excel prints sections of a report in the order in which they're listed in the Sections in this report box.

Print a report

1. On the View menu, click Report Manager.
   
2. In the Reports box, click the report you want to print.
   
3. Click Print.
   
4. In the Copies box, type the number of copies you want to print.
   

Labels: Addins, Tips

Search with Excel, Word, PowerPoint

"Google Search 6.0/7.0 places a new sub-menu item under the Help menu of whatever program you call it from. When that item is selected, up pops a user-friendly interface. This allows a largely intuitive completion and execution of a Google Search.

On clicking the Search button a lot goes on behind the scenes.

• Your default (i.e. your usual) web browser is loaded and, without further instructions,
  
• It's off to the Google Advanced Search Page.
  
• It then fills in an Advanced Query to your specifications
  
• Executes that query.
  
• Once results are found (or not found) you are shown those results just as if you had carried out all of the steps of the process."
  

Labels: Addins

Outlook, Excel, and VBA

• Mail Workbook
• Mail one Sheet
• Mail more than one Sheet
• Mail the Selection or range
• Mail Every Worksheet with Address in cell A1
• Mail sheet or sheets to one or more people
• Mail range or sheet in the body of the mail (Send personalized email)
• Mail a message to each person in a range with Outlook
• Mail a message to each person in a range with CDO (no security warnings)
• Sending a different file to each person in a range with Outlook
• Zip the ActiveWorkbook and mail it with Outlook
• Security (Prevent displaying the dialog to Send or not Send)

Also Download Addins for Excel e-mail information

Also see:

John Walkenbach:
Sending Personalized Email from Excel




See all Topics
excel

Labels: Addins, Tips, Tutorials, VBA

Add it back in

"The Microsoft Excel 2002 Template Wizard is an add-in program that sets up a database to store data entered from an Excel form. When you load the add-in program, the Template Wizard command is added to the Data menu in Excel."

When you download the WZTEMPLT.XLA, you must install it in the Office11 folder:
X:\Program Files\Microsoft Office\Office11\Library

How to install the Excel 2002 Report Manager add-in and Template Wizard add-in in Excel 2003 and 2007

The Wizard can be downloaded here:
Excel 2002 Add-in: Template Wizard with Data Tracking

(When you run the executable, be sure to change the destination to the Office11 folder, if you are using Office 2003, Office 12 for 2007.)

How to use the Template Wizard with the Data Tracking add-in
Also see:
Report Manager



See all Topics
excel

Labels: Addins

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