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:

Excel 2010: Print Preview Full Screen (Old Print Preview)

For Users

From menu controls, the new print preview mode has completely replaced the old print preview.
The new print preview mode offer a streamlined "quick printing" in one screen:
Selecting printer, number of copies, paper orientation,... All in One

However, convenience control "margin manual tuning" (as below) is missing from the new mode.

Actually, the old print preview is still not removed.
You can add it to the quick access bar, or any ribbon (new ribbon customization feature in Office 2010)

The below steps demonstrate how to release the old print preview (Print Preview Full Screen) method to the quick access bar

Step 1:Click on the more 

Step 2:

Finish, Click this button to launch the old print preview screen:

---

For Programmers

If your existing application are accessing the old preview box.

you can still access the old preview mode. It's also not inside the 2010 object model change list:

ActiveWindow.SelectedSheets.PrintPreview

Office 2010 Code (VBA) Compatability Inspector

To check whether existing VBA codes supported by Office 2010 or not,
instead of re-compiling the VBA codes, Microsoft now offering a new inspector for you.

Gray has written a short guide about on how to use the inspector.
If your macros are password protected, remember to unlock it before launching the inspector.

However, this tools is still in beta. I have encountered serveral false alarm about "Range" objects.

As the tools are in beta, you can send any feedback to the development team.
There is also a sweeptakes on bug reporting.

Wanna some game with Excel?

Officelabs now offering a game over the actual Excel application. 

The "game" also has a little practice about the "main" new feature of Excel 2010, sparksline.

Your score could also be published to facebook newsfeed.

Step by Step:Excel Watermark (Excel 2010,2007)

Word has a feature on creating warkmark text, such as "Confidential", "Draft",....
However, there no such direct feature in Excel.

The below steps "mimic" the watermark feature in Excel 2007/2010
1. Select the sheet you want to add the watermark
2. Locate Page setup properties

3. Go to the third tab "Header/footer" Click on the custom headaer

4. a)Enter the watermark text you want in the Center Section.

4. b)Highlight the wording and then Click on "A" button to adjust the font size & light color.

 

In this sample, font "Arial" of size 48 has been used for the word "CONFIDENTIAL"

Click OK two times to return to page setup (one time for "Font setting" and one time for "Header")

4. c)If necessary, image could also be added

5. Go to the second tab "Margin".

"Push" the header to the centre of the paper, by adjusting the Header position. For A4 paper, it's 5" roughly.

6. Click OK to finish the setting.

Preview of printout: (Screen from Excel 2010)

Last Updated 2012-APR-13

Excel 2010 Object Model Changes

Seems the VBA changes on Excel 2010 has been fixed.
A official comparsion to 2007/2003 could be found here


Luckly, there are no critical changes like FileFind in 2007.
Most of them are related to conditional formatings.

Excel 2010 SSAS Cube Sets.

Following up with SSAS features in Excel 2010
Besides creating sets contain only dimension members or calculated members,
you can them both in the same set:



The magic of the sets could be respected to the new "calculatedmember" property in the connection object:

ActiveWorkbook.connections("...").OLEDBConnection.CalculatedMembers.Add Name:="[Set1]", Formula:= "{....}"

What's New in Excel 2010 (Web Resources)

0.General
Official free ebook on Office 2010 features:
First look in Microsoft Office 2010

1. SSAS Cube Related:

Frederik Vandeputte's Blog
Measures:
Running Total (Year To End),
Displaying Single Measure Multiple times
Dimensions
Interactive Filter (Instance selection on typing)
Dynamic Sets (A user friendly approach :-) )
Create Set base Rows Items
Write Backs

Chris Webb Blog
Dynamic Sets
Sets Creation with UI

2. How to show everything with sparklines

Excel Team
- Sparklines as LINE
- Formats: Low / High
- "sparklines are in an Excel table you can add another row of data and the sparkline group would grow and add another sparkline to the table"

Excel Team
- Sparklines as column
- Formats: Negative Points and Styles

Excel Team (1)
Excel Team (2)
-Sparklines as winloss
- Sparkines axis and Reference Line

Excel Team
- Line Up Points

3. Conditional Formatting
Excel Team
- Icon set now customizable
- "Exception handling" in icon set, e.g. negative value

Excel Team
- Proportional Value Bar
- Negative value Bar
- Formating Border/Fills

4. Charting
Excel Team
- Interactivity: Fields button (selection of range and "drilldown" easily)
- Double click objects to format (am... is it so important?)
- Data points: limit of data points extended.

5. Security
Excel Team
Should be something related to this one...


Excel Team
-Protected view for VBA, in control of file access.

General
Overview from Microsoft

Some screenshots in pre-"technical preview"

Excel 2010 "technical preview" Follow up

What's New in Excel 2010
Here are some different that I found it on interface between the 2007 and 2010.
However, I think there should be more in the 2010 release.

In general, there some enhancement on graphics, charts(Sparklines), pivot table (Slicer).
The help there are still in 2007 version.

Excel option, date format

Excel Option Cursor movement (Not sure what it is yet)

Excel option:Pivot table: Prevent hang when undoing

Excel option: Customizable Ribbon finally...

Review unsaved draft version of this excel, they put this visually finally..

An IQ test? All wordings were changed into small icons

Extra "All merging conditional formats" option

Screen clipping(capturing tool) and sparklines

3 Types of sparklines

Images format + background removal

Slicer for pivot table, display selection quickly


VBA... Seems nothing new there, still 6.5

Excel 2010 images from "technical preview" (2009-05-30 Trial followup)

2009-05-30 update: Technical Preview followup
From the looks, it seems that 2010 is a service pack for Excel. XD

For non-Excel images, please go C-Net site here

--------------------------------------------

A nice discussion about windows from a Chinese forum about the leak of office

It's something like the below:
Stack 1: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to windows Vista
Stack 2: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to windows XP
...
Stack 3: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to DOS 6.22
Stack 4: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to ENIAC
Stack 5: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to abacus
Stack 6: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to counting with knots
Stack 7: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to counting with fingers
...

Excel 2010 and SQL2008 R2 Gemini

A screenshot from SQL 2008 R2 Preview

Nice to to see Gemini in SQL08 R2.

So what is Gemini? you may refer it as an upgrade on Analysis Service.

Gemini can handle a large amount of data and relationship in a "lighting" speed.

Anyway, from the points that the add-in is provided for Excel 2010 instead of Excel 2007,

we should see a much more efficient operation with Excel 2010

Office 2010 Technical Preview

UPDATE 2009-05-29 Follow up

The office 2010 will be available in July
Sign up for technical preview here
http://www.office2010themovie.com/


An interesting discussion about the menu style...
Seems most of the comments are on restoring to 2003s' style.
How about a style change again XD