New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
In this two part video series, BBQ pit master Rick Browne shares his tried and true method to making sweet, succulent brown sugar ribs. Follow the instructions in this video and you will surely have the most popular dish at the next BBQ.
The Amazing Origami channel takes you through step by step instructions of how to build a triangle origami box in this video. Six pieces of origami paper, three different colors, are all the supplies you will need to make your very own box! First, separate the origami paper into two groups of three, all three colors should be in both groups. These groups will make the top and bottom of your box. The three pieces of paper used for the bottom will all use the same folding technique, this is als...
In this video, Hamid Reza Ebrahimi indulges the viewers in the world of copperplate writing through a short tutorial on how to accurately form the shapes of capital and lower case V. The video requires that the viewer has some previous experience with copperplate writing since it is not accompanied by instructions. Mr. Ebrahimi does a great job and the final result is honestly a true work of art. This video is an inspiration to anyone interested in learning how to write copperplate or just im...
This video describes how to create a jumping letters in Flash, first create the text for example "JUMP" and using Break the letters each and then make the layer and now convert the letters into "Movie clips" and now we should add the key frames to our "time line”. Then moves the letters up by using the up arrow now copy the key frames from font end and paste on the back again for go up and come down the letters again and add the "motion between" for each letters and now skip the key frames by...
Learn how to touch up images in Photoshop and bring out the true potential of your art. Using subtle strokes of image enhancement you can redefine the effect that shadows have on your images and use them to bring out the aspects of the photos that you want to highlight. Similarly you can hide those nasty imperfections with ease as shown in this tutorial. Never again let your images befall an embarrassing fate. You too can produce professional quality work with minimal effort and time on your ...
For all you women out there who do not fall into the normal categories, Anna Saccone offers some styling tips for both tall and petite women. For petite women, Anna suggests that you should wear just one color in order to elongate your body and fool people into thinking that you are taller. If it is not possible to wear simply one color, it is suggested that you have a 2 to 1 ratio of color in your outfit and that the colors do not clash too much, as this will seem to cut your body in half, e...
Got video files on your computer? Watch them on your big-screen TV – using your Xbox! You Will Need
Do you dream of standing on stage in front of millions of fans with a guitar in your hand? You can make this dream come true, if only you could play the guitar! This guitar tutorial series from Robert Renman teaches you the basics of guitar playing along with a few beginner and intermediate techniques. You can learn how to play a a great Freddie King song "Big Legged Woman" with this guitar lesson. Freddie King, also known as the "Texas Cannonball" was a very influential American blues guitar...
In this video tutorial, you'll be working in Adobe Photoshop and learning a little bit about a very specific skill that I think is important for all designers. That is, the Pen Tool and using it to hand-draw clipping vector paths. There are a variety of ways to make selections in Photoshop, but drawing a real vector path is the most tried-and-true and highest quality way to do so. Mastering this tool will make you a better designer and help unleash your creative potential.
There is not an actress who walks the red carpet without a quantity of hair that her mother didn't give her (we know that's a lot of negatives, but hopefully you get our gist). While it's true that many actresses are genetically blessed, that doesn't mean that each and every one of them was born with thick, Victoria's Secret hair.
The video begins by explaining the characteristics of the video game character Mario. The narrator begins by finding a sample picture to use as a starting point to mirror for accuracy. The first part of the character Mario drawn is the head and facial features. After finishing a simple outline of Mario's Face is to begin the outline of the characters body. After the basic outline of Mario is finished the excessive lines must be erased to give me lively hood to the drawing. One of the last ste...
In this tutorial, we learn how to wish someone a happy new year in Vietnamese. To say this phrase in Vietnamese, you will say "Chœc M_ng N_m M_i". You can add on phrases, such as 'prosperity' by saying "An khang th_nh v__ng". You can also add on "good health" by saying "S_c kho_ d_i dˆo" and "good luck" by saying "Nhi_u may m_n". Last, you can say "may all your wishes come true" by saying "V_n s_ nh_ _". Whatever you decide to add to the phrase, it will all need to be said correctly to get th...
In this video we learn how to draw hands without references. First, draw the basic structure of the hand using a photo to make sure it's true to size. After this, draw on boxes and circles to create the wrist, hand, and the knuckles. Then, you will draw on straight lines for the bones in the thumb. After this, start to add details of the fingers and make out their basic shape. As you continue with details, erase any background lines and start to add lines in for wrinkles on the skin. Finish t...
What would "Star Wars" be without its infamous red-faced villain, Darth Maul? True, we never thought he was the prettiest character in the "Star Wars" franchise (that title still goes to hottie Natalie Portman as Princess Amidala), but he had some pretty cool makeup going on.
Smoky eyes are all the same, right? Wrong. While it's true that 99.9% of smoky eyes consist of some form of smoked out black, brown, silver, and sometimes purple, you can make your smoky eye interesting by adding an unexpected pop of color.
Bring pretty back this Halloween by dressing up as a flirty yet mischevious fairy. Though fairies haven't been all too popular recently in comparison to vampires and werewolves, the revelation of Sookie's fairy lineage on "True Blood" has gotten people interested in these mini nymph-like creatures once again.
Emma Watson put it best when she said in a recent "Teen Vogue" interview that there's nothing interesting about looking perfect. And it's true: A few undone hairs here, a stained red lip instead of a perfectly painted on one, and mixing fashion styles when you dress help add interest to your look and show off your personality.
In this tutorial, we learn how to write a unique personal statement essay. Personal statement is the heart of the application where you can give voice to your accomplishments, dreams, and goals. You want to stand out from the rest of the applicants, so you need to express what's important to you. You can show them how well you write and show passion, your smarts, and sense of humor as you write. You can do this because you are prepared and you are being true to yourself. Once you understand t...
Contouring your nose is your knife-free alternative to plastic surgery. True, the results don't last as long as going under the knife, but contouring, when done correctly, can make your face go from puffy to sharp and angular.
The Western film, once the end all be all of great American filmmaking, is now rare to behold at all at the movie theaters. Whereas in the old days directors made the films about true American gung-ho spirit and handsome, stoic John Wayne cowboys championing the greater good, these days the genre gets ruined by CGI and other absurd additions.
Disney starlet Selena Gomez was once called "the next Miley Cyrus," but over the past year or two she's really stepped out on her own as a bonafide movie star and pop singer. With recent hits like "Naturally" and "Round and Round" to add to her long list of accomplishments, the actress is setting the curve for a new era of stars.
In this tutorial, we learn how to understand a securitization. This is a type of structured finance that has three key elements. the first is that there is a pooling of credit sensitive assets. In pooling the assets, you introduce diversification. The second element is to transfer credit risk to the third party and make rules around whether there has been a true transfer of credit risk. The third element in this is trenching of liabilities. This means when cash flows are transferred to a spec...
When you're in a band it's important to sound in tune with the rest of your band and to compliment your bandmates rather than stand out too much. And while for the most part that's true, if you're the lead guitarist then there will frequently be times where you'll be spotlighted to play a jammin' guitar riff.
The phrase "you can never have too much of a good thing" isn't particularly true when it comes to jewelry. While we love our bohemian tree pendants and dangling chandelier earrings, we don't like the fact that they weigh five pounds and pull down on our ears and/or necks.
Are you a big fan of origami but scared to try it out yourself for fear that your creations will turn out more like balled up pieces of paper than strong, sturdy shapes? We hear you.
Origami is a lot of fun (okay, and also a lot of frustration), but what often turns beginners off from the Japanese art form is simply that it requires special origami tissue paper. While it's true that thin paper made exclusively for origami is preferable for any origami project, you can substitute plain old printer paper instead if you're low on money or just out of origami tissue paper.
Did you know that the "Victoria's Secret" makeup look (you know, dark, sultry smokey eyes and nude lips) is the most often requested look at MAC counters and cosmetics counters everywhere? Okay, we're not entirely sure that's true, but every time we hit up MAC we always see girls getting primped with that same exact look.
Android smartphones have all sorts of connectivity chips built in, including Bluetooth, Wi-Fi, GPS, NFC, and mobile data. But what about AM or FM radio, two of the most common methods of wireless communication?
3D is very new to Photoshop only really coming into existence when CS3 was released. In CS3 however the 3D capabilities were pretty limited, but with the release of CS4 3D exploded into Photoshop and now has it's own set of tools and even it's own panel. You are now able to even create true 3D objects right from within Photoshop and texture them. In the following tutorial we will learn about creating a base 3D object and creating a few basic textures for that object. We will also take a momen...
Do you have a shopaholic girlfriend whose 30th birthday is slowly coming up? It's true that a lot of women dread their 30th, but your gal pal will be simply delighted at her bash if you bake and decorate this purse cake for her.
In order to insert movies into Microsoft Word 2007, Click on Insert. For AVI, go to Object, Create From File, and select the location of the file. Then, click on Insert. It will now appear on your document. The video should play. The video can be repositioned or adjusted. It can be saved with your document, although this is not true for other movie formats.
For some people out there, whenever they get their hands on something new, the immediately need to know how it works. This can be especially true for electronics. That's no exception for the new Xbox 360 slim.
It's safe to say that not many people like hanging around bees. True, we've formed a sort of working relationship with them, raising them in batches and extracting their honey for our own personal uses, but with a sharp stinger primed and ready to go, they'd backstab us exploitative humans in the blink of an eye.
This video tutorial belongs to the Computers & Programming category which is going to show you how to install custom fonts in Mac OS X. It is very quick, easy and simple. Open your browser and do a Google search for free fonts. From the search result you can choose any of the top links and download the fonts file. Then open the file and choose the font ending with 'ttf' which means true type font. Double click on it and a font book opens up. Then you click 'install font' and it is installed. ...
In this tutorial, we learn how to make Columbian crevice. You will need: precooked shrimp, any other seafood you like, finely chopped red onions, juice from half a lime, salt, garlic water, hot sauce, tomato sauce, mayonnaise, pepper, and cumin. To make this like they do in Columbia, you will need to take a cup and add in your ingredients one on top of each other. Start with the shrimp and work your way up to the dollop of mayonnaise on the very top. To finish, mix the cup together and enjoy ...
In the plant world, not all things are green. This also is especially true for ferns. These plants can grow in a variety of different colors and differ from many other types as well.
Are you a budding potter who's looking for a skilled tutor but can't afford taking pricey classes every week? Then watch this kiln conversion tutorial by master potter Simon Leach.
If you think about it, it's actually easy to make friends and acquaintences - you move to a new town or go to college and you're immediately immersed in the culture and the people around you. Those in close proximity you'll definitely talk to an a regular basis if not establish a friendship. But true friendships which lasts years, decades, and even lifetimes are extremely hard to come by.
Each year, new gadgets and features are being put into cars to help the overall experience when driving. Massagers, seat warmers, and mp3 player jacks are just a few of the new things. One thing that remains true, but has gone through a bit of a change, is the car radio. People can still tune in and listen in to their favorite stations with just a push of a button. But setting the radio stations is easier than ever. Instead of always switching back and forth from AM to FM, there are ways that...
