Need to save a few quarters for laundry? Then skip paying at the parking meter when you're out and about. The video below will show you how to con your way out giving up your hard-earned coins at a city parking meter. With this trick, you'll get unlimited time. It works by simply holding a quarter in the slot for a long, long time. This will create an error in the electronic parking meter system, causing an "out of order" sign to appear, which means... free parking!
It's no secret that MoviePass is a shell of the service it once was. The primary $9.95/month plan for three movies each month is inconsistent and can change drastically depending on your location. Thankfully, MoviePass isn't the only movie ticket subscription service available. We've compared all the best plans on the market to help you find the one that's right for you.
Imagine walking up to enter a live event — but instead of pulling out a physical or mobile ticket to get admitted — you pull out your smartphone which lets out an ultrasonic sound tailored for you that lets you into the event.
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 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
You can get a real steal at a house foreclosure sale, or you can overpay for a money pit. Here’s how to avoid the latter. With the bad economy, now is a great time to take advantage of real estate bargain sales. Watch this video real estate tutorial and learn how to get a good deal on real estate foreclosures.
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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to build a pivot table to calculate year over year sales showing percentage change.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
This is a quirky little how to video that teaches you how to repair and replace that worn out speaker surround you wanted to toss out or just bought at a garage sale for $1. Get to that yard sale and repair those old worn out speakers and make them worth thousands again!
Ready to clean out the clutter in your home and make a little money too? Learn how to organize a tag sale or garage sale and entice people to stop, look, and buy.
Trapster is a cool website that works just like Google Maps or MapQuest, with a twist! In addition to turn by turn driving directions, you will also get the locations of police speed traps along your route. Stay safe and in control- and avoid a costly ticket - with this free web based service.
It is dangerous to talk on the phone while driving - not to mention it carries a hefty ticket fine in most states. In this tutorial, learn how to connect your Bluetooth phone to a 2010 Toyota head unit for both safer calling and streaming music. This is actually quite easy and you can hook up four phones at once if need be. Enjoy this easy, advanced new way to hook up your phone.
Needless to say, we're talking minor traffic violations. If you've just led the cops on a high-speed chase down the freeway, you're on your own.
With the massive popularity of online clothing brands like Missguided and Fashion Nova, it seems that shopping in-store is a thing of the past. I admit that I love browsing from the comfort of my own bed, but there's something to be said for actually going to a store, speaking to people with similar tastes and penchants for shopping. Fortunately, with Frenzy — Shopify's new app for iOS — you get all of the convenience of online shopping, plus the opportunity to interact with other users in pe...
Valentine's Day is going to be here in less than a month, so make sure you keep all of your photo memories safe by placing them inside this miniature floral "I Love You" Valentine's Day mini album.
Looking for some advice on how to book a flight on the cheap? Let this video be your guide. Finding cheap airfare can be easy! So easy, in fact, that this clip can present a complete overview in about two minutes' time. For all of the details, and to get started saving money on airline tickets yourself, watch this video guide.
Hawaii is definitely a beautiful place, and a popular vacation destination. But if you are a foodie, you know that the best part about Hawaii is the food! And in Oahu, the locals know that the best stuff is the garlic shrimp that you can get at the food trucks. But instead of going out and buying a plane ticket to Hawaii, let chef Jason Hill take you through the steps in making your own!
If you want to make a movie with zombies, or the apocalypse, or the apocalypse and zombies, then you are going to have to learn how to create a really haggard-looking, disease-ridden face out of makeup. This video will show you how to do it using Rice Krispies, among other things. The end result is terrifying, and sure to scare your audiences or trick-or-treating targets into doing what you want (buying theater tickets or giving your candy, respectively).
The politics of getting a good seat on a commercial flight are difficult to navigate and not fighting for a good seat can leave you uncomfortable for hours and wrecked when you arrive at your destination. This video features a travel expert outlining some tips for getting good seats on airplanes. Tips include joining a frequent flyer program and buying your tickets online, where you can often pick your seats.
In this video, learn how to connect a cell phone to your Lexus head unit. Most navigation enabled dashboards in 2009 Lexus models are equipped to work with a phone. All you need is a Bluetooth enabled phone and your Lexus and you are ready to roll! Avoid those pricey cell phone tickets in traffic with this handy option.
Removing tint from a car can be complicatedly sticky and leave a really bad result on your windows. If you feel like a change, or if you got a ticket for too dark tint, follow the steps in this tutorial and learn how to remove the tint yourself. This will save you money and save your windows in the process. Check it out!
Take a folder and organize documents based on the actions required. Actions:
Skip the pharmaceuticals and the endless scratch on win lottery tickets. Here are some concrete happiness boosters. You will need more sleep, the willingness to help others, a grateful attitude, strong social ties, an exercise program, fun plans, lowered expectations, and optional: spiritualism. Watch this video for advice on how to become happier.
OnTime 2008 Customer Portal enables you to invite customers and 3rd parties into the development conversation. Through controlled access they can submit bugs, feature requests and request help by intitiating their own support tickets. This installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite will show you the power of Customer Portal.
Radar Roy demonstrates in this video tutorial how to hard wire a dash-mounted radar detector. The advantage of direct wiring your radar detector is getting rid of that wire mess going to your cigarette lighter. So, if you don't want another speeding ticket again, install your radar detector the right way, the direct way! All it takes is a little electrical know-how, and maybe a little automobile know-how.
So you've been pulled over and you need an out. Well, if you're prepared with a water bottle and some skills chances are you may just freak out the cop and he'll let you go!
MoviePass was once the best subscription service on the market for getting cheap movie tickets. For the price and the number of films you could see and save money on, it was unbeatable, but recent changes to the service have made it less enticing. While it still works well for some users, others may have to rely on other options. Personally, I'm leaning toward the latter.
If you or someone you're shopping for has a newer iPhone model or an Android smartphone like the Galaxy Note 9 or Pixel 3, they come with wireless charging capabilities. Problem is, they don't come with wireless chargers. But there's no better time to snag one than on Black Friday, and we've found the best deals out there for 2018's holiday season.
Google has a new smartphone, and if you own a TV or a computer, you've almost certainly heard about it. The ad campaign for the Pixel and Pixel XL is approaching iPhone levels of omnipresence, as Google has reportedly spent over $3.2 million on marketing, with that number expected to skyrocket in the coming months.
Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...
Whether you loved or hated the blockbuster hit Joker for its slapdash violence and unflattering portrayal of mental illness, if you have been online lately, you know you can't afford to miss it.
It looks like Snapchat is becoming the MTV of augmented reality. On Thursday, Ariana Grande, with her new album Sweetner, joined Drake and Nicki Minaj and other artists who are pushing new releases through Snapchat's Shoppable AR e-commerce platform.
OnePlus has officially given us a date for when the OnePlus 5T will be announced. We've known about most of the specs for a while, and we just found out about the potential pricing, so a release date is the final piece of the puzzle. Consider this puzzle solved.
OnePlus just unveiled a new version of their popular OnePlus 3T—a limited edition all-black "colette" version for the boutique's 20th anniversary today. The slick device will feature the iconic colette logo on the back.
Would you like to Have Crispy Chicken in the Oven? If so I will teach you how too.
In this video Andrea Osterkorn demonstrates how to stage your home for sale. It is not a comfortable process to transform your home into a home for sale. The entry way should be inviting because first impressions are important. Closets should be cleaned out. Consider renting different furniture for the living area to make it more open and inviting, and move it around to create an impression of space. Add accessories and let natural light in. Try to depersonalize the room and remove clutter so...
These aren't your mother's bake sale pies. In fact, they're not really pies at all. Rather, these delicious and pretty treats are cupcakes decorated like pies. A simple concept, yes, but these cupcakes make for a divine arrangement. You'll learn how to arrange various colors of jelly jeans to look like food - red for strawberries and blue for blueberries, for instance.
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.
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
If you have created a product that you want to sell, getting a UPC code for it will allow you to track purchases and give your business a more professional air. This video will explain how you go about getting a UPC code and using it to help your business.