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
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.
More cool Excel tutorials:
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.
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.
Saving sensitivities with AssumeIT macros
How to save, open and change your spreadsheet sensitiviteis using your AssumeIT macro.
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.
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.