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 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!
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 92nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data series to a chart, change the chart type for just one data series and see an excellent copy data to chart trick.
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 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.
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 165th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a logical formula to extract values associated with dates occurring in the next two weeks.
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. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formula for a stem and leaf chart for numbers that have more than two digits. This is accomplished through use of the IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL and ROW functions.
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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.
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 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.
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 236th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a database for keeping carpentry measurements as well as how to use a COUNTIF function formula for calculating how many lumber pieces you'll need to cut for your home improvement project.
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 270th 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 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?
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.
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.
Check out this instructional dance video that demonstrates how to dance the Cha-Cha with Jules Helm. The Cha-Cha (or Cha-Cha-Cha) is a dance from Cuba popular among ballroom dancers. Learn to dance the cha-cha, the moves and steps, in this ballroom dancing video.
Check out this instructional dance video to learn how to dance the mambo. The mambo is a popular dance of Cuban origin, a favorite in ballroom dancing competitions. Learn to dance the mambo, the moves and steps, in this ballroom dancing video lesson.
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.
Origami is a creatively fun and entertaining artform that can relieve stress and help you with your hand eye coordination. This video will demonstrate how to create an 8 Point Origami star.
You will need: a sharp knife, a steady hand, and patience. First carve 5 equally sized 1/4 spheres out of carrot.
Don't just use a belt for keeping your pants up, use it to give you some style! As important an accessory as a handbag, a belt doesn’t just hold up your pants or pull in your tummy. Change your look by creatively matching your belt with your outfit.
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?
