Heir of Aurelian - Chapter 76 Marching on Hispania

A teenager named Evan Mason was reincarnated into the magical world of Harry Potter and goes to school at Hogwarts!
With only his knowledge of the future and great talent for magic, he takes the path towards the top of the magic world, only to realize that ever step he took, changed everything!

- Description from Novelupdates

From brewing whiskey out of car tires to brewing immortal potions just because they are tasty.Regressed from a world where the only issue technology failed to solve was boredom, Theo, an adept nanomancer and master brewer, finds himself in the literal shoes of magic academy's trash teacher.Cultivation? Magic? Martial arts? Craftsmanship?No.Now is the time for this world's first Nanomancer to rise and establish alchemy as the fifth great subject for others to follow!

He was on his way to buy some beer to celebrate his acceptance as a civil servant when he was suddenly isekai’d by truck-kun.

An ordinary student, a wretched peeper, a cowardly teenager with a kind heart. In a terrorist attack, he inherited the knowledge of countless elites, embarked on a path of God Jagged Tu…

He is an artist!

He is a mathematician!

He is a psychology Doctor!

He is a master of fighting!

In fact, he is a man

Taken off raw site:

A wretched, dirty young man is working during the summer when he was caught up in a mysterious explosion. After that explosion, the young man is then left with the memories and knowledge of dozens of the world’s experts.

He has changed, his heart has become cold, iron-blooded. He became a killing machine, his mind turned mechanical, calculative. Everything goes according to his plans and calculations!

In this magical, slaughterous world, a door is opened for him…

- Description from Novelupdates