All the makeup counters (bareminerals, estee lauder, mac, clinque, etc.) do makeovers. Some have started to charge, some still do it for free, some are appointment based, others are walk in and first come based.
I've found these to be hit or miss.
I used to have my makeup professionally done for work. I quit paying attention, because theatrical/photo makeup is ENTIRELY different than real life makeup (although there are some tricks that I still use, like how to reshape my nose... and how to fake being "fresh" when you're actually strung out or hungover... the trick is blush, btw., everywhere you get sunburned; bridge of nose, top of cheeks -instead of apple-, forehead, and your chin. Which has come in more useful than ANYTHING else... because being a sleep deprived mom I looked FAR worse than I ever did partying the night before! but I'm digressing).
Who I LOVE are the makeup ARTISTS that upperend salons employ. They can do makeup for any occasion (daily wear, special occasion, photos indoors, photos outdoors, bridal, etc.)... and they give LESSONS!!!
In our area a basic makeup lesson is $30-$50 depending on what kind of lesson you want (just eyes, full face, etc.). They're not selling makeup, so there's none of the "You need this, and this, and this and this!". Instead they chart your face, and give you 2 or 3 options depending on your "needs".
For myself... most basically (warpaint)... I need foundaition, blush 1 (the sunburn type... no, you don't actually look sunburned, it's super subtle, but it kills the sleep deprived zombie look), and mascara. That's daily walking around warpaint.
Next level up "looking nice" but still fresh/not made up = foundation, blush1, blush2, eyeliner, mascara, tinted gloss or sheerish lipstick (my face doesn't support lipstick unless I'm fully made up. It makes me look harsh.
And the list continues all the way to club makeup & photoshoot makeup with full shadowing (3 colors of foundation to create angles in my face that people see in normal light, but that cameras don't pick up or that get lost in a dark club/theatre). The "list" changes with everyone. And it changes geographically and with age for everyone (my own list changes when I'm somewhere sunny... my skin evens out and is just luscious. Up here, I'm blochy and uneven.)
An honest to god makeup artist will be able to do a 'warpaint' lesson (daily walking around makeup) very very easily, and very very well. And be giving you tricks of the trade, and have you repeat them, and colors and types of things to look for/buy. They can work with just about any set of makeup, and will know the rather lengthy list of which makeup brands/types would work best for you and your budget.