2010-06-12

Excel 2010: Where is the "Office button -> Prepare" in Excel 2010?

The Prepare Tab in office button of Excel 2007 has been reorganized completely into Info Tab of File menu in Excel 2010.
If you are going to take MOS 2010 Exam, it is better to take a look at the new locations:

Properties: (The most "hidden" one) Now you can go to advanced properties with fewer click(s).

Inspect Documents

Encrypt Documents, Add a Digital Signature & Mark as Final
The Encrypt Document is the same as Tools->General Options->Password to Open in the Save As dialog box

Run Compatibility Checker:

2010-06-06

Excel 2007/2010: "World Cup 2010" Excel Template: Dynamic Image

A good template that demonstrated how to use a dynamic image.
World Cup 2010 Excel template
In the "Group Stage" sheet, the content of image on the right side is based "Group Standings" sheet.
There is a formula in the image to redirect content from specified cell location.

2010-06-02

MOS 2007 logo changes

Just a very short blog about MCAS (Microsoft Certified Application Specialists)

This month, MCAS title and logo has been changed back to Microsoft Office Specialists

New logo









Old logo