it's not magic, it's just really boring and stupid if you explain it well.
it's just a decentralized authentication network built on cryptography algorithms. but i guess if you don't know what any of those words mean it seems mysterious. you need a baseline understanding of networking and cryptography, and well, very few people have that.
and people attribute financial value to each bitcoin (or whatever coin), which is just a piece of code you uniquely possess when it is in your 'wallet'.