I have updated the Downloads spreadsheet on Skydrive to include all new files added this year, and I have also added two Category columns, which link to the Download by Category page, giving more details and links for each file. The list can be sorted on-line if you select “edit” mode, or download and open in Excel.
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Time in hours and minutes between two dates
- Taming Symbols in Excel
- The angle between two vectors, Python version
- Fitting high order polynomials
- Retrieving unique values from a range or array ...