Create Pivot Tables by Using VBA - Excel tutorial

Category: Excel tutorials > Formatting - Difficulty:

The PMT function calculates the required repayment amount to amortize (pay off) a debt or loan based on the original capital amount, interest charged and term of the loan

Learn how to use Excel's Data Tables feature to automatically run multiple scenarios through a model, based on either one or two variables.

This video tutorial shows how to multiply matricies in Excel using the MMULT function.

Organize worksheets in Excel 2007 by adding new worksheets, deleting worksheets, renaming worksheets and customizing the worksheet tabs.

Although Excel and other spreadsheet programs are the traditional interfaces for creating and reading spreadsheets, sometimes you might need to create .xls files directly from other programs.

Whether you're creating Excel files from databases on an Apache server or you just want to present the information stored in a Java program to Excel users, there are a variety of packages out there that will enable you to create and access .xls files without actually using Excel.