Excel Functions and Formulas

 

 

Excel tips on functions and formulas

Excel Functions: Examples and Tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

Excel Functions and Formulas

 

 

 

 

Excel Workbooks

10 Excel workbooks are included with the Downloadable Tutorial. They are residing in the directory where you have unzipped the tutorial that you have purchased and downloaded. Open Excel (1997 to 2007) and each of the following files to learn more about functions and formulas in Excel.

The Excel workbooks are:

001-excel-tutorail-sumproduct.xls
A tutorial on the most powerful function in Excel: SUMPRODUCT

002-excel-tutorail-index-match.xls
A tutorial on the formula that searches for values in a table. LOOKUP on steroids

003-excel-examples-text-functions.xls
Examples of formulas using text functions.

004-excel-example-moving-average.xls
Moving average using the OFFSET and INDIRECT functions

005-excel-template-production-planning.xls
Planning production with the IF function.

006-excel-template-accounting.xls
The most versatile accounting system using SUMPRODUCT

007-excel-template-coupons-ann.xls
Working with date and time functions.

008-excel-template-coupons-end.xls
Working with date and time functions.

009-excel-template-inventory.xls
A dynamict invetory using SUMPRODUCT

010-excel-template-invoice.xls
An automated invoice using INDEX/MATCH


Learn more on Excel
Discover our Products

 

 

Excel tips on functions and formulas

Excel Functions: Examples and Tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules