Tutorial search

Tutorials
Stuff
Affiliates

Cool Stuff




The fastest way to master the basics of Adobe Photoshop

Click here to find out how

Photoshop Templates


Featured Photoshop templates - professional ready to use designs for your next project.

View all templates

Create Spreadsheets using SpreadsheetML - Excel tutorial


While exporting spreadsheets as XML is useful, Excel also lets you import information this way, letting you create spreadsheets using SpreadsheetML.

Excel supports SpreadsheetML for both import and export, providing a complete pathway for information. You can open a SpreadsheetML document, make a few changes, and re-open it in Excel if you want.
Category: Excel tutorials > Functions - Difficulty:


More cool Excel tutorials:



Multiple Scenarios
Multiple Scenarios
The scenario feature allows you to quickly change a number of input cells based on some predefined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios easily
Category: Excel tutorials > Functions - Difficulty:
Customizing the Excel Menus and Toolbars
Customizing the Excel Menus and Toolbars
Customizing the Excel toolbars and pulldown menus. Taking the time to get the Excel toolbars and the pull-down menus the way you want them saves your valuable time when creating and editing your spreadsheets.
Category: Excel tutorials > Basics - Difficulty:
Copy Forumulas: Absolute Positioning
Copy Forumulas: Absolute Positioning
Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the Column letter or a $ before the Row number (or both). This is called Absolute Positioning.
Category: Excel tutorials > Basics - Difficulty:
Charts and Graphics in Excel 2007
Charts and Graphics in Excel 2007
This tutorial takes the first approach and explains how to generate straightforward charts. You'll also learn which chart types are out there, and how to fine-tune your charts for maximum effect.
Category: Excel tutorials > Graphs - Difficulty:
CHOOSE in Excel
CHOOSE in Excel
The Choose function allows you to refer to different cells depending on the results of a cell. Often useful as an alternate to the IF function (especially if you are tempted to use nested IF functions).
Category: Excel tutorials > Functions - Difficulty: