Excel table formulas driving you crazy? Learn the fix to lock column references, prevent errors, and simplify your spreadsheet calculations ...

This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.

Mentor Public Library announced it is offering six free technology classes in May at its Main Branch, including introductions on how to use Microsoft Excel, Android smartphones and iPhones. The cla… ...

Microsoft Excel is all about tables and data organization, while Microsoft Word is primarily a word processing tool. However, if you’re working on a small table and don’t know how to work with the ...

Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

We show you how to copy a formula in Excel without changing cell references, using mixed references and simple techniques to keep your formulas intact when moving or auto-filling.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by ...

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules ...