To Year Search Results

How To: Create Lunar New Year inspired tiger eyes

In this tutorial, we learn how to create a realistic looking cut using cinema makeup. This is a great look for a new year or holiday look that you want to make yourself look more unique and stand out! First, take a brow pencil and redefine your brows so they are darker and more intense. Avoid using black, most people cannot pull this look off. Now, use eyeshadow primer on the eyelids to enhance the eyeshadow color. After this, use gold eyeshadow and apply on the outer v of the eye. Then, take...

How To: Create a hot New Year's party look for an older woman

In this video, we learn how to create a hot new year look for an older woman. Start off by applying primer to the eyelids, then brush on a light gold eyeshadow to the crease of the inner eyes and below the eyebrows. Next, brush on a aqua blue eyeshadow to the entire eyelid, followed by a sparkly blue eyeshadow on top of it. Next, brush a purple color on the outer edge of the eyes and inside the outer crease of the eyes. After this, apply black eyeliner to the bottom of the eye and the top. Th...

How To: Create a New Year's harlequin mask makeup look

Traditional makeup is too boring for special occasions, so why not try something a little more fun to ring in the new year? This how-to video goes through the intensive process of applying a vibrantly colorful and ornate harlequin mask, using just makeup. The cosmetic products used to create this look are N.Y.C Yellow Concealer, Clinique Super Powder Double Face Make Up # 10 Matte Medium, N.Y.C Black Pencil Eye Liner, Graftobian Crème Foundation Yellow, Graftobian Crème Foundation #89092 Augu...

How To: Add fiscal year sales in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 617th installment in their series of digital spreadsheet magic tricks, you'll learn how see a SUMIFS and SUMPRODUCT functions formula to sum the fiscal year's sales when the year does not end on December 31st. Also see a formula for year-over-year percentage change.

How To: Apply glittery eye makeup for New Year's

This makeup tip is perfect for a glittery eyeshadow for New Year's as inspired by the cover of Sephora's magazine. First, apply a semi-dark gray eyeshadow along your eyelid and on the outside corners of your eyes. Using a fluffier brush, apply a lighter white-silver eyeshadow and then use dark black eyeliner along the line of your eye. Use silver glitter along your eyelids in a few layers and black layer on the outside of your eyelids for that perfect festive New Year's look.

How To: Create a New Year's purple nails look

In this video, we learn how to create a 2010 New Year nail look. First, apply a dark purple nail color to the top half of the nails. Now use a clear nail polish to push the purple color down to the middle of the nail. Next, apply a black color to the very top of the nail and then use the clear polish to again push the color down and blend all of them together. Next, use a dotting tool and clear polish to pick up rhinestones or nail rocks and apply them to the tip of the nail where the color i...

How To: Count dates falling within a given year in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.

How To: Highlight dates falling within a given year in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.

How To: Sum a table of data by year & month in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 183rd installment in their series of digital spreadsheet magic tricks, you'll learn how to sum revenue from a table of data by year and month using the SUMPRODUCT, TEXT, SUM, IF & LEFT functions in an array formula.

How To: Play chess and win in two moves taught by a 6 year old

In this how-to video, you will learn how to win at Chess in two moves. First, you will need a chessboard. Pawns go up twice at the start or once. They attack diagonally. Otherwise they just go up once. The castle, or rook, go up and down or side to side. The bishop goes diagonally in both directions. The knight moves in an L shape in any direction. The queen can go sideways, diagonally, forward, and backward. The king can move only once space at a time. Once the board is set up, you are ready...

How To: Sum year over year sales using MS Excel's SUMPRODUCT

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.

How To: Make an Excel PivotTable year category from text dates

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.

How To: Perform the "year game" magic card trick

What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "year game" magic card trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this year game card trick, a little mathematics goes a long way, so don't fall asleep in math class.

How To: Arrange a Chinese New Year flower table centerpiece

The Flower god gets us all ready for the Chinese New year with a quick and very simple flower arrangement for a table centerpiece. You'll need some good luck bamboo, some ivy, little pieces of ginger and some passion flowers to accent the green. Take some of the ivy leaves and cover the centerpiece base. Cut them short at a sharp angle to cover everything. Next use the good luck bamboo to add height. Cut these at a sharp angle as well so that they will stay secure. The angles help it work as ...

How To: Make summer sausage at home anytime of the year

Put pre-mix into bowl. Add whole mustard seed, coriander, fresh ground pepper, and liquid smoke for flavor. You can also add half a teaspoon of hot pepper mix to make it spicy. For meat, use 1/3 ground chuck and 2/3 hamburger; some fat is necessary for a good sausage. Next, add the sodium nitrates, spices and 1 ounce per pound of meat of water into the chuck and hamburger and mix it with your hands. Continue mixing until the meat gets "tacky". Then, the meat needs to be ground and put into th...

How To: Play "New Year's Day" by U2 on electric guitar

Want to play "New Year's Day" by U2? See how it's done with this free video guitar lesson, which presents a complete (and we mean complete) breakdown of the song and its constituent parts. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "New Year's Day" on your own guitar, just take a look!

How To: Make Wiccan New Year's spell bags

This video demonstrates how to make Wiccan New Year's spell bags or wish bags. Wiccans celebrate the New Year on the Winter Solstice. They like to stay up all night, playing drums round a bonfire. Wiccans also make a wish bag and at the New Year they whisper a wish into this bag and then pop it. This makes it an air spell. Alternatively you can whisper the wish into the bag, seal it, and then put it on the bonfire. This makes it a fire spell. Sometimes the bag is saved all year and then it is...

Prev Page