Video Tips

A wealth of modelling-related white papers, videos, brochures, articles and tips & tricks, all available at no charge.

Resource: Video Tips

IRR - Internal Rate of Return

Resource: Video Tips

Why the NPV function may not behave as you expect

Resource: Video Tips

PresentValue - The time value of money

Resource: Video Tips

How a pivot table hid data - and cost Blackpool NHS £185k

Resource: Video Tips

R1C1 Part 2 - Finding different formulae

Resource: Video Tips

R1C1 referencing in Excel

Resource: Video Tips

Merging Cells in Excel (Should not be allowed!)

Resource: Video Tips

Getting context sensitive help for functions in Excel

Resource: Video Tips

Flash Fill in Excel

Resource: Video Tips

Quick Access Toolbar in Excel

Resource: Video Tips

Number formatting in Excel

Resource: Video Tips

Grouping rows in Excel for easy navigation