Tools in Excel 2016

How to add the Developer tab in Excel

Enable the Developer tab in Excel to manage Excel add-ins, create and run recorded macros, or VBA applications with Microsoft Office programs in 3 simple steps.

Using Solver

The Solver tool allows you to specify multiple adjustable cells and constraints on the values that the adjustable cells can have, generate a solution that maximizes or minimizes a particular worksheet cell, generate multiple solutions to a problem.

AutoCorrect for data entry

You can use Excel's AutoCorrect feature to create shortcuts for commonly used words or phrases.

Using the formula bar as a calculator

If you simply need to perform a calculation, you can use the Formula bar as a calculator.