Subscribe
Tutorial search

Excel Solver - Excel tutorial


Excel has a clever and handy tool called solver that helps you find optimal solutions for many decision-based problems in your spreadsheets.
Category: Excel > Basics - Difficulty:


More cool Excel tutorials:



Create an Index of Sheets in Your Workbook Create an Index of Sheets in Your Workbook
Create an Index of Sheets in Your Workbook Create an Index of Sheets in Your Workbook
You can create an index in a few ways: by hand, auto-generated by code, or as a context-sensitive menu option.
Difficulty:
Count Words in a Cell or Range of Cells
Count Words in a Cell or Range of Cells
To get a word count of any cell or range of cells, we'll use a combination of SUBSTITUTE and LEN function/formulas.
Difficulty:
Saving sensitivities with AssumeIT macros
Saving sensitivities with AssumeIT macros
How to save, open and change your spreadsheet sensitiviteis using your AssumeIT macro.
Difficulty:
Chart Printing
Chart Printing
Depends on the type of chart you've created. You can print embedded charts either with worksheet data or on their own. Standalone charts, which occupy separate worksheets, always print on separate pages.
Difficulty:
Current Date & Time
Current Date & Time
The following two forumula are extremely useful. As simple as they may seem, they can play a vital role in many Excel documents.
Difficulty: