Using Microsoft Excel

The history of how the term "workbook" came to be used by Microsoft for the Excel program is interesting, even nostalgic for us old-timers, but what is a workbook and how to use an Excel workbook is what you're here to find out.

A workbook is the concept that Microsoft chose to illustrate the working theory when using Excel and is merely what Microsoft calls it's Excel files or documents. Excel files are computer files that end in the .xls (pre Excel 2007) and .xlsx (Excel 2007 and...

Don't want Excel to adjust references when you copy a formula to a different cell? Use an absolute reference. Absolute reference in Excel is handy when you want to re-use a formula across a spreadsheet and need it's calculation to stay fixed in a constant fashion.

Perhaps you need to build a multiplication table that will multiply row 1 times it's counterpart in column A. If you copy your formula to the other cells in your table, the formula will move "relative" to the cell. We get...