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.
Black Friday is undeniably the biggest shopping day of the year. Black Friday, which occurs annually the day after Thanksgiving, is also the kickstart of the holiday shopping season, the big bang that leads swiftly to Christmas.
In this video tutorial the instructor shows how to derive the formula to compute interest compounded annually. He starts with explaining the basic concepts like principle which is the amount you borrow and the rate of interest or annual percentage rate (APR), which is the rate at which you pay the interest up on the borrowed principle. He shows that the amount after the end of one year is amount A = P(1+APR),and he goes on and generalizes how to compute it for n years. This video shows how to...
Looking to get an FHA loan? The Federal Housing Administration, FHA for short, provides mortgage insurance on loans made by FHA-approved lenders throughout the U.S. Here's how to get your FHA-insured loan. Learn how to get one with help from this video.
Happy Chinese New Year! Now that the beginning of another year is upon us, celebrate the cycle of life and of time by making one of the twelve animals from the Chinese zodiac. Check out this video to learn how to fold an origami snake.
Involve your children in Thanksgiving this year by letting them decorate and set the 'kids' table' this year! Here are a few ideas to create a fun and kid-friendly table setting that you can put your children in charge of this holiday season!
It's never too early to begin crafting for one of the funnest and spookiest holidays of the year: Halloween! No doubt you're going to be attending at least one Halloween party or get together this year, so why not show the hostess with the mostest some love for putting together an awesome party?
In this tutorial, learn how to show your support for Brazil in a big way. Follow along with this clip and create an elaborate nail look to celebrate the Brazilian team at this year's World Cup, in South Africa.
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.
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 594th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate age in years using the TODAY and DATEDIF functions.
GardenGirltv shows viewers how to plant strawberries as a ground cover! With a strawberry patch or field you will have to always continually plant strawberries! The plants will last a few years and every year you should add new plants to your areas for each year. First, you need to get a bundle of strawberry plants you need to rake the area you are planting them in. Make sure you put each plant 18 inches apart. First, you should take your strawberry plant dig a trench, lay it flat and cover i...
Using the improper types and colors of makeup may in fact add years to your appearance rather than take them off. This video shows some simple tips to reduce signs of aging in less than ten minutes. For example, rather than using shimmery eyeshadow, which can in fact enhance wrinkles and fine lines, use a matte colored eyeshadow in order to blend the lines in your face. Using light, non-heavy lip liner and moisturizing lip gloss will make your lips look fuller, giving you a more youthful appe...
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.
Add an old-fashioned touch to this year’s Christmas tree by decorating it with popcorn-and-cranberry garlands.
This is a video by a beginner and for a beginner. It goes over the tuning, chords, and strumming for the song "Five years time" by Noah and the Whale.
Watch this video and learn how to pronounce the months of the year in Japanese.
Pesto recipes keep summer going all year long. Rita Heikenfeld, from AboutEating.com, had a bumper crop of basil this year. And one of her favorite ways to keep that basil on her table year round is this pesto recipe for the freezer. Pair this basil pesto recipe with pasta for a fresh and delicious dish that will keep you thinking of your garden all year round. Watch this how to video and learn how easy it is to make homemade pesto with fresh basil. All you need is basil, olive oil, garlic, p...
As government officials scramble to contain the new coronavirus outbreak with bans on large gatherings, travel restrictions, and school closures, the rest of us have to worry about how we're going to safely purchase water, toilet paper, groceries, and other household goods during the global COVID-19 pandemic.
The era of AT&T and Magic Leap has quietly entered a new phase that ramps up the mainstreaming of the cutting edge augmented reality device.
With all the controversy around the Pixel 3 XL, the regular-sized Pixel 3 might be the phone of choice for most users. Thanks to the huge boost in screen size, the little brother is now an easier pickup for those who like a bigger screen. And once more, the internals are the same, giving you the same experience as the 3 XL without the display notch.
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...
Most of us skip through documents like privacy policies and EULAs (end-user license agreements) because they're long and boring. But, as Congress just passed the SJR34 bill in early April, you're probably a little concerned about your personal data, so we summarized the privacy policies for major ISPs and mobile carriers in the US.
Reading through various internet forums, it certainly sounds like the Google Pixel and Pixel XL are attracting more iPhone users than any of Google's previous Nexus devices. The sales figures seem to back that up, too, as the Pixel is outpacing last year's Nexus 6P, and pre-order demand has exceeded Google's expectations, causing delays in shipments. (We reached out to Google but they wouldn't give us any specifics on sales numbers or numbers of switchers.)
In years past, Apple has always waited two years before redesigning the iPhone, but this year they broke the trend. Aside from a few minor changes, the overall design and style of the iPhone 7 models is the same as last year's iPhone 6s models, and the iPhone 6 ones before that, so it's almost as though they've switched to a three-year cycle—just as early reports suggested.
Some things never change. You'd think that with all the focus on web security, people might take the slightest precaution to keep their online activity private. Maybe there are more people suffering from Paula Poundstone's password troubles than we'd like to believe.
If you need ideas for the upcoming New Year's Celebrations then you can try this out, Especially if you want to celebrate by making a lot of noise.
This year's NFL playoffs have been nothing short of spectacular. With Super Bowl XLVIII coming up on Sunday, February 2nd, people are already gearing up for another classic showdown between the NFC and AFC, and this time it's the Seattle Seahawks versus the Denver Broncos.
Assuming that you're not going to knit a sweater and celebrate New Year's Eve with Ryan Seacrest and Jenny McCarthy on ABC's “New Year's Rockin' Eve," it's a pretty safe bet to say that you're probably going to consume alcohol—a considerable amount of alcohol.
The Chinese New Year, which begins this February 3rd and lasts for fifteen days, celebrates the cleansing/purging of the old and the dusty and the embracing of a new, prosperous year and a healthier you.
