I had a lot of fun writing this riddle, I think it's probably still on the easier side, but hopefully people enjoy it.
My First is, oh my, a talking horse!
My Second is You, but shorter of course.
My Third is elemental, good for your bones.
My Fourth is a drink which goes well with scones.
My Fifth is a moon, of a giant, who knew?
My Last is a direction, cardinal, true.Put me together and what do you find?
The path to knowledge, and advancing ones mind.
For those up in the north of the UK - you're going to have to fight your natural pronunciation instincts if you want it to rhyme properly! :)