Welcome
In simple terms:
Offset voltage raises the CPU vcore udring load ONLY!
Fixed Voltage raises the vcore when idle and under load..
So in offset mode, your idle voltage can be 1.02v (lets say) but will rise to 1.30v (set by you in BIOS) under load (to keep your overclock stable)
In fixed voltage mode the voltage will be at 1.30v idle and 1.30v under load (depending on LLC settings).
Offset voltage is good but i (and a few others) have had issues with need more load vcore on offset mode compared to fixed. (example: Fixed 1.30v needed under load, Offset 1.35v needed under load)