Add, map, and unmap XML elements

Monday 17 November 2008 @ 11:11 pm

Here’s what you need to know about getting XML data mapped into and out of your workbook.

More: continued here





Filter by using advanced criteria

Monday 17 November 2008 @ 11:11 pm

Yes, you can filter by multiple criteria and even by using functions.

More: continued here





List of worksheet functions (by category)

Monday 17 November 2008 @ 10:11 pm

Add this to your browser favorites, and get all of the Excel functions in one tidy little package.

More: continued here





Install updates for Microsoft Office 2007 Help

Monday 17 November 2008 @ 9:11 pm

The first wave of updates to offline Help files for the 2007 Office system is now available. To see the latest Help articles when you work offline, you can download and install the updated Help files.

More: continued here





Watch this: Use Print Preview to get things just right

Monday 17 November 2008 @ 9:11 pm

Before you send your worksheet to the printer, use Print Preview to make it a thing of beauty. You can control the number of pages that print, make sure headings appear on every page, and print gridlines. You can save paper, too. Watch this demo to learn how.

More: continued here





Watch this: Let the status bar do the work

Monday 17 November 2008 @ 9:11 pm

Why struggle with creating formulas when the answers are already at the bottom of the screen? Select some data, and Excel immediately analyzes that data and shows you the results on its highly informative status bar. Watch this demo to learn how.

More: continued here





Import or export text files

Monday 3 November 2008 @ 10:11 pm

Get text data into and out of your workbook.

More: continued here





Dynamically display the contents of a cell or range in a graphic object

Monday 3 November 2008 @ 10:11 pm

You can link a shape, text box, or chart element to data in worksheet cells. Any changes that you make to that data will automatically appear in the shape, text box, or chart element.

More: continued here





About hyperlinks

Monday 3 November 2008 @ 9:11 pm

Use hyperlinks to navigate to Web pages and documents, and even to send e-mail messages.

More: continued here





Print a worksheet in landscape or portrait orientation

Monday 3 November 2008 @ 9:11 pm

By default, Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape (wider than tall) on a worksheet-by-worksheet basis.

More: continued here





«« Previous Posts