How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Multiple Scenarios - Excel tutorial
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
More cool Excel tutorials:
Cleaning up data using the Data Autofilter
Excel is often used as a means of cleaning up data and producing reports. Often the most time consuming aspect is the data cleanup. Using the Data AutoFilter it is possible to achieve more in less time.
In this tutorial (with the possible exception of the section "Tips for Faster Procedures"), they're indispensable when you do need them.
Excel 2000 Tutorial
Learn the basics of Excel 2000 and more including Customizing Excel, Formulas and Functions and Keyboard Shortcuts.
Using AssumeIT in Excel- simple example
Shows how to run a simple sensitivity using the AssumeIT macros in Excel.
Excel Pivot Tables
PivotTables are one of Excel's most powerful attractions, though many people don't knoww hat they do.