Subscribe
Tutorial search

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
Category: Excel > Functions - Difficulty:


More cool Excel tutorials:



Cleaning up data using the Data Autofilter
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.
Difficulty:
VBA Tips
VBA Tips
In this tutorial (with the possible exception of the section "Tips for Faster Procedures"), they're indispensable when you do need them.
Difficulty:
Excel 2000 Tutorial
Excel 2000 Tutorial
Learn the basics of Excel 2000 and more including Customizing Excel, Formulas and Functions and Keyboard Shortcuts.
Difficulty:
Using AssumeIT in Excel- simple example
Using AssumeIT in Excel- simple example
Shows how to run a simple sensitivity using the AssumeIT macros in Excel.
Difficulty:
Excel Pivot Tables
Excel Pivot Tables
PivotTables are one of Excel's most powerful attractions, though many people don't knoww hat they do.
Difficulty: