Excel techniques:
How to .... videos
Number & text formatting
Formulae & replication
Using $ prefix constants
Plotting scatter graphs
Underlaying model curves
Lines of best fit
Plotting error bars
IF statements in formulae
Printing to PDFs and PNGs
Dealing with lots of data
Solar system Excel sheet
Download the whole course (85.1MB)
Errors Excel sheet
Lines of best fit Excel sheets & notes
Simple calculators
Speed converter
Snell’s law of refraction
Radio frequency & wavelength
All the downloads are
.zip
files. To edit the Excel sheets you will need
to extract them to one of your own personal folders
Virtual experiments
Specific heat capacity of water
Ball vs parachute
Faraday’s law
Solar System
Ball projectile
Beta decay of Protactinium
Hubble’s law
Exoplanets
Capacitor discharge
Simulations
1D gravity + drag
Epidemics
2D projectiles + drag
1D water rocket
Orbits & galaxies
Project vs skills matrix
Maths tools
First created July 2012