Subscribe
Tutorial search

Excel What-If Analysis - Excel tutorial


This tutorial teaches you how to perform what-if analysis in Excel.
Category: Excel > Basics - Difficulty:


More cool Excel tutorials:



Convert Formula References from Relative to Absolute
Convert Formula References from Relative to Absolute
Change absolute formula references to relative references, vice versa, or a mix of absolute and relative columns and rows.
Difficulty:
Track and Report Changes in Excel
Track and Report Changes in Excel
To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA and Excel's Change Events feature.
Difficulty:
Create a Drop Down List in Excel 2007
Create a Drop Down List in Excel 2007
Here is an illustrated tutorial, showing you step by step how to create a drop down list inside a cell, from a given list written in the worksheet.
Difficulty:
Excel Three-Criteria Limit for Conditional Formatting
Excel Three-Criteria Limit for Conditional Formatting
You can use VBA to tutorial conditional formatting to use more than three criteria on your data. In fact, you can use the code to apply virtually an unlimited number of criteria.
Difficulty:
Use the Mini Toolbar in Excel 2007
Use the Mini Toolbar in Excel 2007
The Mini Toolbar in Excel 2007 is a small toolbar that comes up when you are editing data in a cell.
Difficulty: