Julia is a low level mage who is in school, but is well aware of the life of the adventurer and how she is probably going to do that in a few years.
Celia is a person who has some inherent magic stuff, but otherwise is very close to someone from our world transplanted into OotSverse: she has permadeath in effect, she doesn't want to kill things, she focuses on her job, family/relationships and schooling moreso than smithing or raiding the countryside, and she really doesn't understand how things work from a "what do I do" standpoint.