Excel TutorialTutorial

Perform Weighted Average Calculations Using Excel’s SUMPRODUCT Function

Weighted Average Calculations A normal average calculation sums values and then divides by the number of values.  This basic average calculation works fine unless you need to give a different weight to each value.  For example, our students take 5 exams a year and we need to calculate their overall percentage at the end of…

Read More
Excel TutorialExcel VBA TutorialTutorial

Excel VBA File Management Using The FileSytemObject

Using the FileSytemObject The FileSystemObject (FSO) provides a useful way to access the filing system on your computer and network drives.  To use the FSO you first need to create a reference to the Microsoft Scripting Runtime Library.

In the VBE click Tools | References. Check the option Microsoft Scripting Runtime and…

Read More
Excel TutorialExcel VBA TutorialTutorial

Excel VBA – Storing Data in Arrays & Dynamic Arrays

What is an Array? An array, like a variable is a somewhere to store data.  An array can however hold more than one value, for example an entire database of information with tens of thousands of records. Using arrays in your procedures makes your code potentially quicker than alternative methods for say performing calculations on…

Read More