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 301st installment in their series of digital spreadsheet magic tricks, you'll learn how to change Regional Settings to force Excel to accept 20th century (1900) dates.
One of the benefits of Blu-ray and DVD is the ability to share discs with friends and family without any hassle. Want to show off your favorite movie? Just lend them your copy. A digital movie isn't so kind, as it's typically locked to the account that purchased it. But now there is a way to share your digitally purchased movies with friends and family — and it won't cost you or them a dime.
The hype for HBO's Game of Thrones reached proportions as epic as the series itself this week with the latest release of the final season's official trailer, but it's a Snapchat promotion that will truly make fans at SXSW bend the knee.
You might be proficient at sending your family and friends money using Apple Pay Cash on your iPhone, but what about when you need some digital currency in your wallet to buy in-app purchases or to get back the money you spent on someone's lunch? Requesting some Apple Pay Cash can be done a few different ways, none of which are hard.
Disasters can happen at any moment, and when they do, it's often hard to find the right information to help you get to safety as quickly as possible.
A new app called Roadie now makes life a little easier by connecting users to people who can transport their stuff. The app allows users to transport anything from dogs to getting rid of your ex's things. Furthermore, anyone can register as a sender, or become a driver to make an extra buck. The app is very easy to use: simply download (the app is available on both iOS and Android) and register using an email address or with Facebook. Using the profile you've created, users then select whethe...
With over 2 million uploaded videos and over 28 million people who had talked about it online by the end of August, the ALS Ice Bucket Challenge was the most viral social media event of 2014. Its popularity provided the ALS Association with $115 million in donations to date, with everyone from students to veterans to celebrities contributing.
Only scumbags hide their call and message history, right? Wrong. While it may seem like a tactic for the unfaithful, it's still a good thing to do for certain contacts on your phone that you don't want to block outright.
We've all walked into a restaurant with the best of intentions only to order something absurd, like a cheese-injected burger topped with bacon on a brioche bun. It's delicious for the few minutes it takes to eat the thing, and then you're left with a bellyful of regret and an inability to directly look at the numbers on your scale. Turns out that getting yourself to make healthy choices isn't as hard as one might think.
If your Samsung Galaxy Note 2 has been feeling sluggish lately, or you've noticed the battery not lasting as long as usual, the problem could be that you have too many applications running in the background.
When we surf the web, we tend to do it for selfish reasons. Whether it's on Facebook, Twitter, YouTube, Pinterest, or Wikipedia—we're trying to connect with people, voice our opinions, watch funny videos, or do research for that 12-page paper due tomorrow. Whatever it is, it's usually to benefit ourselves. Well, what if you could not only benefit yourself while surfing the web, but benefit others in need, without even having to alter your habits?
If you don't know much about engines, you may want to find out more before attempting this tutorial. Anyway, in the video you'll find out how to grind down a bell housing
Thinking about building a rocket stove? A rocket stove is simply made and accepts small-diameter fuel such as twigs or small branches, yielding high combustion efficiency and directing the resultant heat onto a small area. In this video learn how to make a rocket stove with the help of a few friends and items you can find in your own barn!
There's nothing like buying an awesome new gadget, but it leaves you with one problem (besides an empty wallet)—what do you do with the ones you already have? There are plenty of ways to put your old gadgets to use, but if you'd rather get rid of them, you may as well get something out of it, right? Here are five places where you can recycle your electronics and replenish your cash stash.
Some of us use our smartphones for almost everything. Manufacturers know this, so they try to make their devices as convenient as possible to use, but sometimes that convenience comes with a cost to security. The very same technology that allows you to easily share music with friends and make purchases can also put you at risk. Photo by sam_churchill
If you ever use NS lookup in Microsoft Windows Server 2008, you have to permit the machine running it to accept zone transfers. To do so, follow the instructions in this video. This video will show you how to use the name servers tab in DNS to allow machines to receive DNS lookups.
Thanksgiving should officially be known as the holiday of comfort food. After all, it's night impossible to get through the occasion without gaining at least five pounds from all the turkey, mashed potatoes, gravy, sweet potatoes, apple pies, etc.
This is a small exploit of a glitch that can give you infinite xp and money when you play Dragon Age: Awakening. After you complete a certain mission, hold off on accepting the follow up mission. Just talk to the commander again and again, getting money and XP each time you do it.
With many states accepting laws about banning the use of cell phones while driving, bluetooth is becoming an important feature to have. Not only does it make things easier when talking on the phone, but it's something that is being featured in many new cars. So in this tutorial, you'll find out how to setup your bluetooth on a 2011 Sorento. So good luck and enjoy!
One of the great features in cars nowadays, is the ability ti connect it with your cell phone. With states accepting laws about driving and cell phone use, this feature can be a much needed addition to your vehicle. In this quick and easy tutorial, you'll find out how to setup your bluetooth phone with a 2010 Ford Fusion. Enjoy!
In this gardening tutorial, you'll find instructions for building an aeroponic fogger, or mister, for a hydroponic growing system. Nutrified fog is accepted by the roots at a much faster rate than nutrients from spray or soak system. So I modified my Aerospray system to have both nutrifog and timed sprays. To learn more about this method for constructing an aeroponic fogger, take a look!
Learn how to use the cable key to tighten your Knit Picks Options Interchangeable Knitting Needles. Each needle tip has a hollow base that is grooved to accept the threaded stem of the cable. To insure a secure fit, use a cable key to tighten the knitting needle tip. You can also use the cable key to unscrew your knitting needle when you are ready to start a new knitting project.
You don’t have to accept fatigue and sleeplessness as the cost of traveling to distant lands. There are a half a dozen things you can do to lessen the impact of crossing time zones.
Children hate going to bed, but they certainly need their sleep. How can you get a toddler to accept that it's bedtime without having to deal with a temper tantrum? Here are a few good stratgies for getting a toddler to go to bed peacefully.
Want to know how to set PDFs up so that they can be digitally signed? In this Adobe acrobat tutorial you'll see how to set up a PDF to accept a digital signature. You all also see how to create your own digital signature for signing and a strategy to work with your clients so that you know who is signing those documents.
One of Android's biggest strengths, when compared to other mobile operating systems is its open file structure. Google introduced a built-in file manager with Marshmallow that provides basic file management, but like with most apps on Android, there are alternatives. Third-party file managers are readily available, providing deeper access and control of all your files.
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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.
You're already spending a ton of money on your dress and everything else for prom, so why spend even more on getting your hair done? You can make sure you look beautiful for your special day at home and still look like a million bucks! In this tutorial, curl your hair in a Hollywood glam style that is actually quite easy to do.
In this video from theXBox360GameReview we learn how start and join an Xbox Live party. Once signed into Xbox live, scroll to the friends channel, and select the friend you want to have your party with and press Y. Now that you have a party going, you can play some Halo wars. If you want more friends to join the party go to your friends list using the guide button and tap X to select who you want to invite. If you want everyone in the party join in, select Party and choose Invite Party to gam...
There are about fifteen states of matter: solid, liquid, gas, plasma, et cetera. Plasma is commonly found in stars, and is a rare natural phenomenon here on Earth. In this video, I show you how to make artificial plasma in your microwave.
Ivy League schools are a students wet dream, but not everyone can get into them. Even fewer get scholarships for them. But in recent years, Ivy League universities have raised the number of scholarships they award to students. More students are seeking awards, making the application process for these scholarships very competitive.
1. Open the web browser and type www.facebook.com and press enter. 2. In order to be a member you will have to first sign up as a facebook member.
This video explains how to delete cookies in Windows XP, Mozilla Firefox, Internet Explorer and Opera. To delete cookies in Mozilla Firefox, choose the "tools" option from the tool bar, then choose "options", then choose "privacy". Many options will be given under the "privacy" menu, but make sure to choose the following options- "accept cookies from site" and "accept third party cookies", then choose the option "I close Firefox option" under "keep until" then choose "ok" to delete the cookie...
Fantasize about role playing? One of the most popular venues for role playing medieval fantasy is the board game, Dungeons and Dragons. Get a group of three or four together and have a blast!
Flashing people in an oversized trench coat is both old-fashioned and exhausting (and also very illegal). But like the evolution from school-yard bullying to cyber-bullying, it seems as if the new trend is "cyber-flashing" (it's even has an official hashtag). In the U.K., police are now investigating what they are calling the first cyber-flashing case.
As you're probably well aware by now, the Apple Watch isn't just for sending text messages and checking Instagram—you can also use it as your wallet. With Apple Pay compatibility, you can use your Watch to make purchases at any retailer that accepts the payment service.
Watch this video and learn how to convert a Super Wide Polaroid camera into a pinhole camera. This conversion will also work for super shooter and colorpack cameras. Strip down the camera, "chop" the body and prep to recap for a super wide angle pinhole camera. This project works for cameras that accept 3.25 x 4.25 polaroid and fujifilm instant pack films.
In this tutorial we learn how to rig a fly line. Start by preparing the floating line or sinking line to accept the fly. Carefully unwind your leader, then fasten it over the perfection loop and thread it through the fly line perfection loop. This should make a nice tight knot so you have a nice tight fly. When finished, you can remove the leader then coil it back up and make three loops and save for use later on. It's also smart to carry a pack of weighters in your vest so you can throw them...
This video discusses the basic steps necessary to start an online business. The first thing you need is a name for your business. Keep it simple, easy to spell and remember. Once you have your name, register it with the government. Next, find a good hosting company for your website. He recommends Godaddy.com. Also a good web designer is a necessity. They will meet with you to discuss your ideas, and your website should be ready in about a week.
This video shows how to setup the Firefox as your browser for web, on Macbook Pro. First, Open the Safari browser by double-clicking, from the list of Applications. Then, enter the URL of Firefox website, in the URL address field of Safari, to open it. When the website is opened, click the link "Firefox 3, Free download.", which will automatically start downloading. Then when asked to proceed, a message comes, click "Continue". It starts to download Firefox 3. When done, it will open a window...
