Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.
This video will show you how to send a text message with the Samsung Galaxy I7500. Just follow these simple steps to start sending text messages from your Samsung Galaxy I7500: From the home page, tap the messaging icon. Select "New Message" Tap the "To" field and enter either the name or the number of the person you wish to send a text to. Type in your message, and when you are done, tap the "Send" key.
First, part the curtain to enter the voting machine. Then, start the voting process on the ELECTronic 1242 voting machine in Delaware. All that's left is to press the big green VOTE button on the voting machine and you're done. So get down to your county and VOTE in this coming election. The pol's need you.
Watch this video to learn how to create a beautiful and practical water wall (or water bottle wall) for energy savings at home. it helps to cut down the amount of sunlight that enters your home. You can make a frame that will fit into your window.
Once each day, or according to your doctor's instructions, you will need to clean the urethral meatus - the opening where the catheter enters the body. The procedure to do this is explained in this video.
We realize that celebrities change their hair color a lot, and oftentimes without consideration as to their skin tone. But that's because they're frequently gearing up for movie role that require a certain shade of hair color.
Unless you're genetically blessed - and we mean SERIOUSLY genetically blessed, a la Halle Berry, you will get pimples in your life. In fact, you will get many of them, especially in your teens and twenties.
Jealous of thin as a rail models with those chiseled, sculpted cheekbones so sharp they could grate cheese? You need not be. We normal folk can look just as defined and ready to strut our thangs down the runway by learning how to contour our faces.
You know those cool skintight black bodysuits they wear in "Tron"? They seem like costumes only the best of movie costume designers - and CG artists - can produce, but you can make a pretty good replica at home.
Tattoo lady and reality TV star Kat Von D is obviously extremely talented with the tattoo needle. Creating interesting designs for clients that include celebrities, Kat Von D exudes a distinctive style that includes looking like a tougher version of a classic pin up.
Like all famous artists, Frida Kahlo had a very colorful life. Raised in a small town outside Mexico City, she lived through the Mexican Revolution and was struck by a bus as a teenager, an incident which caused a broken spinal column, broken collarbone, broken pelvis, fractures, and a punctured uterus which led to infertility problems later on.
Peacocks are some of the most gorgeous animals on earth. Their electric blue and green bodies are colorful enough, but their extravagant tail really takes the cake with a fan-like display of long, luscious feathered with eye-like ends that are multicolored.
Celebrities are at the cutting edge of makeup. You can love them or hate them, but what matters is that they have access to the wolrd's best makeup artists, hairstylists, and stylists, which means they always look like human perfection on the red carpet.
Resonator guitars (also known as steel guitars) are a unique type of guitar made with tricones or a single aluminum cone, and are great for slide guitar for both Blues and Country music. Made famous by artists such as Son House (see deathletter blues). If you're not really sure which would be the best, what a resonator (steel) guitar is exactly, or how to pick out the right slide for the sound you're going for, this fantastic video will you guide perfectly! You will learn a little history abo...
The absolute hottest shade this fall for makeup is a deep eggplant or aubergine. At the Fall 2010 fashion shows, we saw models with purple smokey eyes or neutral lids and a deep berry lip. But however the color was worn, it was used by many makeup artists to add extra sultriness to the makeup look.
Kesha, love her or hate her, is statistically the most successful music artist of this decade, and she has become a full-fledged icon in a very short time. This video will show you how you can create the makeup look from the bowling alley scene in the music video for "Blah Blah Blah". If you like your eyes to be blue, there is no shortage of that here.
You can't accurately draw a human face - heck, any part of a human body - without knowing about how the underlying bones and muscles contribute to structure. And while disecting is by far the best thing you can do to improve your knowledge in these two fields, we don't all have the ability to do such things. So this video is the next best alternative.
We can't seem to divulge ourselves from our stick figures, which we perfected to an art in second grade. But if you're a true artist who's looking to become better at realistically rendering a human body, then you've come to the right place.
Polymer clay is a favorite material for many crafters because it's so versatile. Those interested in creating miniatures - like small version of Domo Kun or tiny, hamster-sized apple pies - can easily mold the clay into any shape they wish, while jewelers enjoy polymer clay because you can experiment with different colors to produce all types of effects.
With the "Thor" movie coming out in 2011 and the actors recently debuting a five-minute trailer at Comic-Con, fanboy buzz about this Norse comic book hero has officially reached fever pitch. Guys like the story - the son of a king cast down to earth as punishment, who seeks to redeem himself while falling in love with a human nurse - while gals like the fantastically ripped men.
When you muse on the topic of origami, you're probably imagining some pretty advanced stuff that sends your head - if not your fingers - for a spin. Modular dodecahedrons (what?) and magic squares, done by the more advanced origami artist, make the art seem too difficult for common butterfingers like us. But fear not; no matter how clumsy you are with crafting, we've got an origami project that you can do easily.
As adults who were forced through numerous piano lessons as a child, we know one thing's for sure: Major scales are often the easiest to learn, and they're also the most commonly used scales in major songs. Which is why knowing how to play minor scales is so important to improving your skills as a piano artist.
To give you an indication of what you're getting yourself into, drawing a jumping figure is about as difficult as it is to get up from the couch after a long day of work and doing 100 jumping jacks and push-ups. It sure isn't fun and it sure isn't easy, but both will make you a stronger individual in the long run. While exercise of any sort helps you get fit, drawing figures in motion will help you greatly advance as an artist. That's because sketching out moving figures forces you to take in...
Neutral, universally flattering colors should be the bread and butter of both your makeup collection and makeup routine. Not that we're not a fan of bright and bold hues; it's just that neutrals like taupe, ecru, and smokey grays make every gal look fantastic, no matter her skin tone or eye color.
We're addicted to "True Blood." And, if we're going to be honest here, it's not just because the show has labyrinthine plot lines and exciting vampire vs. human vs. werewolf action. With hot chicks and hot guys, the show seems to be a breeding ground of good looks. And we're not complaining.
Makeup artists often throw around terms like "cool undertones" and "warm neutrals," but when it comes to buying a foundation, most women select one by swiping it on and then wiping it off.
Origami seems super complicated if you're just starting out. After all, with projects like 30-sided modular spheres and magic cubes, it's easy to find your beginner level crane a bit pathetic.
We really hope that by now you're not careless enough to head out for a day at the beach without a single drop of sunscreen. While many gals prize deep bronzy tans that seem to make us glow and look skinnier, real tans are horrible for your skin (even if you don't get a sunburn) because anytime your skin changes your it means your skin's outer layer has been damaged and is healing itself by creating more melanin, or pigment. Which is not so attractive, right?
Drawing eyes is often the most difficult part of nailing down a comic book or manga character, but also the most vital part. Eyes really animate a face, so it's important to master all types of eyes if you wish to become a good artist. This tutorial will teach you how you can contain the eyes and eyebrows in the same plane, or basic shape, to make sure they align evenly. When this sort of method isn't used, often people will draw eyebrows that are disconnected from the rest of the eye.
Any good crochet artist will tell you that most crochet patterns can be mastered more easily simply by sticking to one color yarn. Once you begin adding different colors to the same stitch, it becomes an integrative process as well as a learning one.
Conceptually, what is node-based compositing and what do nodes do? This clip uses the factory analogy to convey the concept. Blender can process video, images, sequences, and families of images in a directory. Then you'll fire up Blender and talk about threading nodes and how images are duplicated and routed through the compositing network ("noodle"), how threads are created between sockets. Creating threads, cut threads. The clip also points out common threading errors and misrouting threads...
In this clip, you'll see how to create a new Screen Layout (workspace, desktop) to use when Compositing: 8-Nodes. and initialize this new default User setup used in all future tutorials. This clip will also teach how to move the window around, what the starting nodes are and do (RenderLayer, Composite, Viewer) Backdrop, , how threads work in the noodle, rendering the composite and discusses basic window management and splitting, and using the UV/Image Editor to view images/results. Whether yo...
This tutorial presents a general introduction to the basic editing functions and tools available within Blender 2.49 & 2.5. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look.
Learn how to use influence objects in a smooth bind to help ease your blendshape woes...or if you like blendshapes, use them to help get that extra little tweak you always wished you could have. And this guide will show you how. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with application and its workflow, you're sure to be well served by this video tutorial. For more information, including detailed instructions, ...
Paint Effects are a great tool that help us fill out scenes and do all sorts of things quickly and easily. Learn how to find the brushes and use them, as well as some of the up sides and down sides of using them. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with application and its workflow, you're sure to be well served by this video tutorial. For more information, including detailed instructions, watch this free ...
Any good makeup artist will tell you both that good makeup starts with good skin and mature/older women look much more radiant with less thick foundation and eye shimmer.
To become a truly good and believable drag queen you must either get rid of or cover up any vestiges of your, well, manhood. This includes tucking down there, wearing heels and dresses, and wigs.
Any artist who excels enough in his profession will create some sort of signature on his painting to notify other it's his work. Some painters, like Jan van Eyck, are cryptic with their inscriptions, putting it in almost impossible to see areas in the painting, while others, like Chinese painters, put their literal stamp on paintings with a carved seal stamp.
This clip provides detailed, step-by-step instructions on how to texture a head with projection painting when working in Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, and to get started texturing modeled heads yourself, take a look!
This timelapse video shows how to start a simple model in Blender 3D and set up a render in LuxRender. The video also demonstrates how to create a daylight simulation and set up UV Maps in LuxRender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step inst...