Home

How to Set up and use input areas in Microsoft Excel

Spreadsheet showing financial data with Excel formatting options.

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Beauty of Excel" series of free video lessons, you'll learn how to set up the input/assumption area for formulas so that subsequent formulas, functions and charts update beautifully. Learn how to build Excel spreadsheets that are efficient.

What is the beauty of Excel? Excel's Beauty is its ability to allow users to put formula input numbers in cells, refer to those cells in formulas using cell references so that everything updates automatically!

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.