In a Microsoft Excel spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate. These relationships are called references. When a ...

Microsoft Excel is designed to alert users whenever a circular reference is causing problems. Folks who are unable to spot the error can take full advantage of the ...

Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option. If you create spreadsheets to record business information about sales, personnel ...

When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you'll ...

You can sum up entire columns or rows in Microsoft Excel using the AutoSum feature. The AutoSum tool automatically selects a column or row of numbers, but you can select any set of numbers by clicking ...