Goal seeking is a useful feature that works in conjunction with your formulas. If you know what a formula
result should be, Excel can tell you which values of one or more input cells you need to produce that
If you want to paste text in your worksheet, you can use Excel's Convert Text to Columns Wizard.
Excel's ability to create automatic subtotals is a handy feature that can save you a great deal of time.