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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
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 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.
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.
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.
If you fish in a lot of weeds or where there are a lot of rocks, then check out this video tutorial. A fisherman will show you how to bait a fishing rod so you won't catch weeds and other things on your hook. Take action: be careful not to hook fingers, use a Gamakatsu hook and long plastic bait, and bury tip into bait. Ron, the instructor in this how-to video from Live Strong, is a professional bass fisher and has qualified for the Bass Master Classic and has won two B.A.S.S. Western Divisio...
When fishing you want to have a strong knot attaching your hook to your line. Learn how to tie a polymer knot from a fisherman in this video tutorial. Take action: put line through the jig, keep slack in the line loop, and run the jig through the loop. Ron, the instructor in this how-to video from Live Strong, is a professional bass fisher and has qualified for the Bass Master Classic and has won two B.A.S.S. Western Divisionals. He has also recorded multiple top ten finishes on F.L.W. tourna...
There are tricks to hooking plastic baits. A fisherman will show you how easy it is to hook a grub bait in this video tutorial. Take action: push hook into nose, noting where hook should come out of bait, and push nose up over hook barbs to secure. Ron, the instructor in this how-to video from Live Strong, is a professional bass fisher and has qualified for the Bass Master Classic and has won two B.A.S.S. Western Divisionals. He has also recorded multiple top ten finishes on F.L.W. tournament...
Casting a fishing rod can be tricky, and we've all had knots in our spools. This fishing clip will show you how to adjust your reel so that you never have knots again. Take action: set the spool tension knob and set the reel breaks. The reel should stop when bait hits water. Ron, the instructor in this how-to video from Live Strong, is a professional bass fisher and has qualified for the Bass Master Classic and has won two B.A.S.S. Western Divisionals. He has also recorded multiple top ten fi...
Stringing a fishing reel is not as simple as throwing line onto it. Learn tips from a fisherman on stringing, spinning, and regular reels in this fishing video tutorial. Take action: set reel line to come off spool counter-clockwise, set line to come straight off spool for bait casters, and set spinning reel to come opposite off spool. Ron, the instructor in this how-to video from Live Strong, is a professional bass fisher and has qualified for the Bass Master Classic and has won two B.A.S.S....
There are three main line types in fishing, but how do you know what you should be using? In this video tutorial, a fisherman will give you some tips so you can decide for yourself. Take action: determine bait type, determine type of fish to catch, and look at line weight and strength. Ron, the instructor in this how-to video from Live Strong, is a professional bass fisher and has qualified for the Bass Master Classic and has won two B.A.S.S. Western Divisionals. He has also recorded multiple...
Many teenage girls want to wear makeup but might not have the skills for natural, beautiful makeup. Learn how to teach makeup skills for a teenager in this beauty video tutorial. Take Action: use round motions, apply through neck line, use primer and set makeup Jessica Flores, the instructor of this how-to video, is an Esthetician/Make-Up Artist for Maxim Day Spa in Clearwater, Florida. As a qualified Esthetician, Jessica offers a unique combination of relaxing spa facials with modern skin ca...
Check out this home repair tutorial video that demonstrates how to repair a lead on a Dyson vacuum cleaner. After a long period of time, the lead will get metal fatigue within it and the machine will work intermittently. Follow the step by step instructions in this domestic appliance repair video to properly troubleshoot the Dyson vacuum's switch unit. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe repair of yo...
Does your vacuum cleaner suck by not sucking?
Media subscriptions are all the rage these days. Between Netflix, Apple Music, HBO Now, and countless more, your TV, movie, and music options have never been better. Unfortunately, all these choices weigh heavily on your wallet. So, when there's an opportunity to snag not just Spotify but Hulu and Showtime as well, all for just a tad bit over five dollars a month, how could you turn that down?
This is a great demonstration of a Baroque era dance. This dance originated from Central America in the 16th Century, and worked its way to Europe. However, the dance transformed into a slower, European style dance as it was brought overseas. This video is for the man's part of the dance. This demonstration unfortunately does not give step by step instructions on how to learn the dance.
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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data form in both Excel 2003 and 2007 as well as how to add a button to Excel's Quick Access toolbar.
This video tutorial program is designed to promote ground crew safety when working under and around helicopters during external load operations. This is not a safety-training and is only intended to be used with the participation of a ground crew safety officer, trainer or other qualified personnel. All training and refresher courses must be done in accordance with federal and provincial regulations and the Canada Labour Code.
Newly appointed Ford Motor CEO Jim Hackett admitted yesterday that demand for driverless transportation could take many different forms and that Ford was rethinking how it would tailor its cars and mobility services for self-drive modes of transportation in the future.
The Galaxy S8 and S8+ come equipped with all of the hardware needed to access live FM radio, but this feature was never really advertised or even spoken about. Thankfully, though, all you need is an app to enable it.
Most people's fascination with social media these days is the instant gratification that can come with it. Whether you post an image on Facebook, Instagram, Snapchat, or Twitter, a minute or two later your phone will receive a notification informing you of a buddy or two who liked it.
The newest firmware update for Android, Jelly Bean 4.1.1, has been out for a while now, but not every device has gotten it yet (some never will). One popular device that has recently gotten it is the Samsung Galaxy S III, only they'll be pushing the update out overseas during the next couple weeks, with the UK already seeing Jelly Bean from the cellular provider Three (if you're on Three, see how to update your device here). Unfortunately, stateside users will have to wait a bit longer. There...
Assuming everyone knows of the recent "String of attacks" passed between Obama and Romney, I just want to talk about how useless this entire thing is. I'll try to be as un-biased as possible.
While it's not the best shopping holiday of the year, Labor Day does have a few sweet deals on smartphones this weekend. There are phones from OEMs such as Apple, Motorola, and Sony on sale, to name a few, from stores such as Amazon, Best Buy, and Walmart.
Getting your green card can be an extraordinarily complicated and difficult task. Often times it seems so daunting that it's hard to know where to begin. Thankfully, Facebook Messenger introduced "Visabot" last year, a chatbot in the app that helps with all things immigration. Now including applying for your green card.
Dutch police are using a system very similar to Pokémon GO on smartphones, but they aren't walking around trying to catch little pocket monsters. The purpose of this system is to give augmented reality help to first responders who may be less qualified to work a fresh crime scene. If successful, the idea of a contaminated crime scene could be a thing of the past.
While text messaging has become one of the most frequent ways we communicate with our friends, the missing body language, tone of voice, and eye contact can make it difficult to tell when someone is being dishonest. That said, it's not impossible. There are a number of subtle hints you can train yourself to recognize that will to help you detect written lies hiding in your SMS and iMessages. Here's what you should look out for.
Apple has acknowledged a problem with the sleep/wake key, better known as the power button, on a certain number of iPhone 5's manufactured through March 2013. As a result, the company has announced the iPhone 5 Sleep/Wake Button Replacement Program, which will replace the power button mechanism, free of charge, for certain iPhone 5 models.
The day I picked up my iPhone 5S was a very exciting day. I had taken all the correct steps in backing up my old device so that after a quick restore-from-backup (which turned into half an hour), I was right at home on the new hardware.
It's that time of year again. No, not Thanksgiving. Black Friday. There are a lot deals available this holiday weekend, many of which include flagship Android devices. Whether you are thinking of buying a phone for yourself or looking for a gift for someone else, you can find a little savings to shop smart during the holidays.
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.
Want a free meal at McDonald's restaurant? Forget those money-saving (supposedly) weekly coupons, that's nothing compared to an actual free meal. Coupons won't get you that. But this method of free food, perfect for the freegan or the poor (or maybe just the rude). This would technically be qualified as a prank or con, but hey, you got to eat, right?
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 337th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank numbers in Excel using 10 different methods:
"Foodborne illnesses are responsible for more than 75 million illnesses, more than 230,000 hospitalizations, and approximately 5000 deaths each year in the United States." In this six-part video lesson, learn about the basics of food safety in a commercial food enviornment. In the first video, three types of contamination are gone over as well as how improper handling can allow food to become dangerous to your patrons. In video two, learn about proper holding times and temperatures, and what ...
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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:
New to 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 Excel tutorial from ExcelIsFun, the 237th installment in their series of digital spreadsheet magic tricks, you'll learn how to
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 514th installment in their series of digital spreadsheet magic tricks, you'll learn three methods for conditionally formatting duplicate values:
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 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
There are a lot of Android phones out there, and chances are that someone in your life is looking for one this holiday season. Well, there also happens to be a lot of Black Friday deals on Android phones this year. So we've rounded up the best deals taking place on Black Friday weekend to help you save big.
New to 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 Excel tutorial from ExcelIsFun, the 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to
