How To Calculate Km And Vmax With Excel, Clean up the table by removing … Use [Ef] to define Vmax using the equation vmax = kcat [Et].