In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
My years in the restaurant business have taught me many things. Some of those things are best left unsaid and other things require a PhD in vulgarity, but the one thing I learned that I keep coming back to night after night is that you do not have to spend a lot of money to drink excellent wine. This is especially true of champagne...I'm sorry, sparkling wines.
A New Year, a new you. At least that's what most of us promised ourselves when the clock struck 12 and 2010 transformed magically into 2011. While not all our New Year's resolutions are easily stuck to, such as dieting and exercising six times a week, you can update your look to look your best. Check out this makeup tutorial by Michelle Phan to learn how to create a simple and clean look.
We realize Christmas is over, but there's no reason you shouldn't surprise a friend with a pretty gift for New Year's Eve! In many other cultures friends and family give each other presents to celebrate their new year, including during Chinese New Year.
Some of our favorite fruits grow in the summer and in the wintertime they just don't taste nearly as sweet. If you would like to keep your fruit all year long, check out this clip. For less than 8 bucks you can turn your favorite fresh fruit into preserves and enjoy them throughout the entire year! Yum!
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.
Each year an apple tree should produce three things: new growth, fruit buds on last year's and older growth, and fruit on those fruit buds formed in previous years. In order to keep an apple tree in balance and fruiting, one must prune. However, pruning is too often done poorly. In this, the second installment of his series on practical apple tree pruning, Stephen Hayes of Fruitwise Heritage Apples looks goes over what to look for in a good secateurs, or pruning shears, and how to thin out sp...
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...
Summer is almost over and that means the end of summer vacation and the start of the new school year. During this transition, parents and students get ready for the new year by purchasing a variety of different materials. Pencils, paper, books, testing sheets, etc.
Looking for some tips on how to apply this year's vampire makeup? Look no further. In this excellent makeup tutorial, learn how to apply professional costume makeup to give yourself a realistic vampiress makeover! Perfect for fans of Twilight, Bella Swan, and Edward Cullen!
The dreidel, the small top that's among the most recognizable symbols of the Hanukkah season, is a fun game of chance to play with friends and family.
Your New Year's party guests will swear these are the real thing and perhaps even pick one up to pour some Chardonnay in if you're not careful! This origami tutorial shows you how to fold realistic - and damn cute - martini glasses.
Check out this Spanish language video that shows you how to say the months of the year in Spanish. This video covers months and some useful phrases dealing with numbers and months. Practice your Spanish language skills and improve your pronunciation of the months of hte year in Spanish with this instructional language video. Hope it's helpful.
Corn is the staple of American agriculture, and fresh corn is a delicious treat. If you want to be able to enjoy fresh corn year-round without paying for imported crops, watch this video. It will show you how to freeze corn and keep it fresh all year.
Lemons have been keeping away scurvy for hundred of years because of their long rotting time, but did you know you can preserve them so that they last for a year? This video will show you how to do it. Preserved lemons are great for Moroccan cooking.
In this video, we learn how to apply gold champagne New Years nail art for New Years. Start off by painting your nails all black and letting them dry. Now, use a thin brush to paint two champagne glasses and the numbers 2010 on the pointer finger of both the hands. Next, paint the top of the nails white onto each of the nails on the hand, except for the pointer finger. Rub out the white a little bit from the top of the nail going down, then apply a very sparkly gold shadow on the top of the n...
Want to know how to perform Five for Fighting's "100 Years" on the piano? Learn how with this free video piano lesson, which presents a complete breakdown of the song and its chords. While this tutorial is best suited for intermediate players, pianists of all skill levels can play along given a little time and effort. For more information, and to get started playing "100 Years" on your own keyboard instrument, watch this how-to!
Learn how to play "Year 3000" by Jonas Brothers, an acoustic guitar tutorial. Follow along with this demonstration, tabs and lyrics here:
Studying to be a pediatric nurse? Then here is a nursing how-to video that teaches you how to assess a five year old's medical condition. Every nurse should know the basics of this technique, follow along and see how easy it is to read a five year old's vital signs. These medical tips are sure to help you pass your nursing exam with flying colors.
Learn how you can say "Happy New Year" in Mandarin Chinese with this language lesson. This is a great phrase to know how to say when celebrating the Chinese New Year. Listen and repeat this phrase to greet them in Mandarin Chinese during the New Year.
The summer's fading fast and it's back to school time again. This week we're breaking you off some tips to help you become the most fashionable in your class, plus we show you how to transform last year's threads into this year's cool, new school gear. Class is now in session!
Microsoft Build 2017, the first of Microsoft's big developer conferences for the year, is just a few weeks away. This very popular conference, which has been going on since 2011, is known to sell out fast. In 2015, it sold out in under an hour, and in 2016, in less than 5 minutes. This year was no different, according to VentureBeat; While not quite as fast as last year with so many rumors of HoloLens on the horizon at the time, this year's Build was sold out in 8 hours. And for this year's B...
Google announced the ADT-1—their first foray into dedicted gaming using their Android TV platform—at this year's Google I/O, in hopes to once again take over your living room on the heels of the immensely popular Chromecast.
Back in the '40s through the '60s, it took very little effort for gorgeous starlet Audrey Hepburn to start new trends. Whether she was sporting a short pixie cute (as in "Roman Holiday") or wearing buggy sunglasses (vide "Breakfast at Tiffany's"), Hepburn was always on the cutting edge.
Ke$ha's music video for "We R Who We Are" is the perfect combination of extreme glitziness (studded eyebrows and glitter littering every corner as well as Ke$ha's face) and extreme party scene gritiness.
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract month and year data from transactional records by filtering, array formula and non-array formula.
Does the sound of the vuvuzela fire up your passion like it does for the South Africa supporters at this year's World Cup? Do you wish you could hear their divine drone more often? This video will teach you how to create a vuvuzela-like sound using common household items: a balloon and some hex nuts. If you can't get the real thing, this will be a good substitute if you think your life needs a little more noise.
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.
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 613th installment in their series of digital spreadsheet magic tricks, you'll learn how to
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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
Southwest Yard and Garden teaches viewers hot to grow blackberries in Southern New Mexico. Blackberries grow in high rain fall areas but they can work in the south west. They will need bee pollination so you need to make sure that you do not spray too much insecticide on them or you will kill of the bees. Make sure you pick the blueberries when they are dull and not when they are shiny. This will give them the maximum sugar content. Blackberries should grow in sandy soil or looser soil. You m...
For all your origami enthusiasts, take your art of origami to greater heights by using a dollar bill to create the impossible—fireworks! In this two-part video tutorial, learn how to fold origami fireworks from a single dollar bill. It's a great origami project for the 4th of July or New Year's Eve.
Thinking you need a little boost in the bra department for this year's Christmas card? Here is a tutorial on how to make your breasts appear larger using Photoshop.
Brian Brushwood reveals the techniques used to make super-realistic fake tongues, like those used in last year's Halloween Horror Nights show. Brian Brushwood on The Road shows how to make fake tongues to use for the magic illusion 'Sword through the Tongue' trick. He's performed this in his stage show at Universal Studios in Orlando.
Make sure this year’s live holiday Christmas tree is not only pretty, but safe, too. Here's how to safely put up a real, live Christmas tree. You will need:
So 2000 was a wash for an election year; we put up with W for four years, then what happened? 2004! Lost again!!! Diebold you just can't seem to fade.
In the past few years (thanks in no small part to "Twilight") vampires and sorta kinda werewolves have been the IT creatures of the night. But ten, twenty years back it was all about the zombies. Bring flesh eating back by dressing up as a super disgusting and realistic zombie.
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...