In Excel, you'd calculate average power as avg(all your power data points from the ride).

Normalized power is similar but weights the points differently to approximate how much they "cost" your body. Bigger numbers are found here.