Data in Excel 365 2016 2013 2010 2003

Goal Seeking

Goal Seeking

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 result.
Splitting text strings without using formulas

Splitting text strings without using formulas

If you want to paste text in your worksheet, you can use Excel's Convert Text to Columns Wizard.
Creating Subtotals

Creating Subtotals

Excel's ability to create automatic subtotals is a handy feature that can save you a great deal of time.