In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...
External hard drives are cheap and widely available. You don't want any of those models though do you? You want to make the drive yourself because you are a DIY FIEND! This video will teach you how to take an internal hard drive and a separately-bought hard drive case, put them together, and make your very own custom external hard drive. If you have an old internal drive lying around this is a great way to give it new life.
In this video, jenny Jones shows us how to store potatoes and onions correctly. Most people want to keep their vegetables fresh and for the longest time possible. Unfortunately, both of these vegetables give off gases that aren't good for each other so they cannot be stored together. The onions will get soggy and the potatoes will start to grow things. If you want your onions and potatoes to stay fresh , make sure you store them separately. Keep them stored in a cool area and you will have fr...
This video shows you how to create a building explosion (more specifically, the Statue of Liberty) in Adobe After Effects in less than ten minutes. The smoke and fire are downloaded separately, while the shattering of the statue is created in After Effects. First, duplicate the layers into what will and what will not explode, then create a mask around each one. Then, set the shatter effect to the exploding layer. Set the shape pattern to glass to make it more realistic. Also, you can raise th...
Here we look at squaring expressions that involve radicals because people tend to make some common mistakes while solving such expressions. Take 5 times the square root of y quantity squared, the answer here is not 5y. Here's the reason, square means to multiply something with itself so the square of 5 root y would be 5 root y into 5 root y. So 5 x 5 is 25 and under root y into under root y equals just y so the answer will be 25y.
In this tutorial the author explains how to compute the area of a complex figure. Now he first defines what a complex figure is by saying that a complex figure is a figure made up of two or more basic shapes. He uses an example to convey his idea and breaks that sample figure into basic squares and rectangles. Now he computes the areas of these individual units separately and finally puts them together to arrive at the final area of the complex figure. If you are looking to compute the area o...
To make barbecue brick chicken, start with a whole chicken. Remove the spine. After that, spread the bird apart and flatten with your hands. Then put it in a plastic bag and add any citric juice and marinate for 4-24 hours. After that, put in a baking dish and apply a wet rub. Coat evenly. Next, apply a dry rub. Taking two bricks, wrap both separately in two layers of aluminum foil. Place chicken on the grill skin side down and put bricks on top. Flip after 20 minutes and return bricks to the...
The Playstation 2 is a very cool video game console, but it does cost a hefty penny. Play don't come cheap, especially when you have to purchase each game separately.
Need to access Windows XP or Vista? Have programs that only run on Windows, but love your MAC. Ya, we get it and agree. Run Windows and OSX on the same computer using Bootcamp, Parallels or other software. You can run simultaneously or separately depending on your needs. Parallels and simultaneous boot of both OS will drain your RAM so make sure you upgrade memory before endeavoring. Learn how to use Boot Camp in Mac OS X to set up a drive partition to allow you to run Mac OS and Windows on y...
Android 10 is officially out, but a lot of phones didn't get it in 2019, and others may not get it at all. With this page, you'll at least know when or if.
| Updated Aug. 22, 2019 with new phones. When will my phone get Android Pie? For the first time since Android's inception, this question shouldn't have an answer that lets you down. That's because Android Oreo introduced Project Treble, a new low-level arrangement that makes updating a lot easier. So with Pie, it's not if your phone will get it, but when.
Just because your car shows an error code doesn't mean you should pull any parts. This video will show you how to confirm error code P 0340 on a Nissan (Bad Cam Sensor) by using a lab scope to check the cam sensor.
This video is a step by step guide to clear cache for Internet Explorer version 7.0. On your Internet Explorer browser version 7.0, go to tools. Click Internet options. Go to general tab, then click browsing history and hit delete. Window will pop up. Click delete on temporary files and click yes to confirm. Click delete on cookies and click yes to confirm. Click delete on history and click yes to confirm. Click x to close the window and the current Internet Explorer window. Pull up a new Int...
If waveguide display maker DigiLens has its way, enterprise businesses and consumers will soon be able to purchase smartglasses for less than $500 — as long as they can supply their own computing and battery power.
In this tutorial, we learn how to make fried kimchi rice. To make this you will need: 1 c kimchi, 2 bowls cooked rice, 2-3 tsp sugar, 1/2 tsp salt, 2 tbsp kimchi liquid, 1/2 tsp sesame oil, and sesame seeds for garnish. First, cut up kimchi into small pieces that are bite sized. Next, fry the kimchi with oil, the add in sugar and fry for five minutes. Next, add in the rice, salt, kimchi liquid, then sesame oil and fry for 10 more minutes. Fry your egg separately, then add them in with the ric...
This style of chicken biryani is called the ‘Pakki-Biryani’, where the chicken and the rice are cooked separately and then combined in the final step. There are a lot of different ways of making biryani and here is one simple, easy and yet incredibly delicious recipe that is just ‘too good’ and we had to pass it on. Watch the how-to video to learn how to make Indian style chicken biryani.
Chef John shows you a fantastic, all-purpose salad dressing using sherry vinegar. The second is a technique that makes emulsifying a dressing a fast and easy process. The reason I like sherry vinegar so much is that combines the complex, tartness of really good wine vinegar, with the rich, sweetness of balsamic vinegar. The vinaigrette shown today literally goes great with everything; whether it’s under a delicate filet of poached fish, over a grilled steak, or with an avocado salad, as you s...
Delicious, Simple & Quick Wok BBQ Pork Fried Rice Ingredients
In a series of news about the OnePlus 5, the company posted its first teaser of the upcoming device on its Weibo account. According to GSM Arena, the teaser doesn't show us any sneak peaks of what the phone might look like — co-founder Carl Pei took care of that — though, we are greeted with the caption "Hey Summer! Give me five!"
Apple Pay has been available to use in stores, as well as in select apps and websites, ever since its first appearance in iOS 8.1. Now, with iOS 12, there are currently 13 different iPhone models that support Apple Pay functionality without the use of an Apple Watch, and the list of partnered stores that accept Apple Pay has only grown. Here's our always-up-to-date list to keep you in the know.
Are you tired of uploading videos to different sites separately? It's really time consuming and difficult. Finally, there is a way to upload and distribute your videos to YouTube, Facebook, Dailymotion, and many more video-hosting websites in one go. No need to upload to every site separately and one by one.
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.
Here Christopher Walken shows us how to roast a chicken with pears. It is a simple recipe, recorded supposedly as an audition tape for Food Network. We cannot confirm.
In this how to video, you will learn how to unlock your iPhone 3G 3.0 firmware with Ultrasn0w. First, turn on your device and go to Cydia. Click manage and sources. From here, go to edit and click add. Enter repo666.ultrasn0w.com here and click add source. Once that is done, go back to Cydia. Go to search and look for Ultrasn0w. Click install and confirm to install it. Now you have Ultrasn0w installed. Reboot your iPhone. Next, insert your SIM card. Go to your settings to confirm that the SIM...
Insert DVD containing Mac OS software into system drive. Reboot system. Confirm installation and agree with license. When prompted to select drive, select disk utility from menu bar. Select hard drive and click on erase button. Select Mac OS extended file system. Confirm erasing all data. Once drive formatted, close disk utility. Select to install in hard drive that was erased. After installation completes and system reboots, select Language and Keyboard for your country. When asked if alread...
Find out how to change your middle name on Facebook. 1. Sign into your Facebook account. Go to "Settings" on the top right of your main Facebook home page. 2. From there click on "Account Settings". Find where it says name and click on "change". 3. Enter your middle name and click on "Change Name". 4. Read the legal paragraph and be sure to check the box that says "I confirm. " then click on "Confirm Request".
With a slab-style touchscreen device, butt dialing is always going to be a problem. While you're moving about, your phone can unlock itself and give your most recent contact a ring, leading to an awkward one-sided conversation where the other person gets to eavesdrop on everything you're doing or saying at that moment.
Scrabble isn't just for playing Scrabble anymore— there's a whole world of uses for the game and its pieces. One particular use is in jewelry— those Scrabble letter tiles are the perfect size for creating DIY pendants!
In order to make Pork Noodle Soup, you will need the following ingredients: noodles (any variety), sliced pork, vegetables (cabbage, bok choy, etc.), sesame seed oil, shallots, ginger, white pepper, green onions, salt, and chili sauce.
Chef Jui Chin demonstrates how to make Lo Mein. First, he starts with cut up meat and vegetables: green onions, white onions, shrimp, bean sprouts, julienne cabbage, julienne carrots, and separately he has some julienne sliced pork. You want precooked lo mein noodles or you can substitute with linguini or spaghetti. After preparing your meat and vegetables heat up the wok (you may want a bigger wok to avoid spilling) on the stove. Add a couple of tablespoons of oil and rotate the pan around t...
This video from Southwest Yard and Garden tells viewers why it is important to wash your hands after gardening, and when and how to do so. It also emphasizes the importance of cleaning cutting boards. You should wash your hands before eating, after using the bathroom, and while you are handling food. While handling food, if you handle any meat, you must wash your hands before touching anything else. You should wash your hands for twenty seconds, with soap and water. To demonstrate the importa...
This video shows how to properly set up a green screen, to set up the screen we are taking into account this four factors:
This video tutorial shows you how to cook braised beef shanks. Ingredients:
Eleusis is a fun card game that is pretty easy to learn how to play. Grab a few buddies, and check out this video tutorial!
In this video, we learn how to delete your Facebook account. First, go to your Facebook account and then go to your account options. From here, find the link on the page that will allow you to delete your account. Next, you will need to confirm you want to delete your account and enter in your password along with a Captcha phrase. Now, you will need to go to the e-mail address associated with the account and click on the link from here. With this, you will have completely confirmed that you w...
In this tutorial, we learn how to delete a Facebook account. First, log onto the internet and log into your Facebook account. Once you are logged in, you will be presented with your home page. Now, click on the account settings on the right hand side and find the button that says you want to cancel your account. Once you have confirmed you want to cancel your account, Facebook will send you an e-mail that asks you to confirm it one last time. After you are done with this, your account will be...
Pokemon's Darkrai is one of the most coveted levels of the game. With this tutorial, learn how to find Darkrai in a few easy steps, as well as secure a Membership Pass and a Mystery Gift in Pokemon Platinum. So grab your Nintendo DS and follow along!
Learn how to delete your old Yahoo account from this video in simple steps. First open your web browser on your computer and go to the Yahoo home page. Now sign into your account using your username and password. Now copy and paste this link "http://edit.yahoo.com/config/ delete_user" in your address bar. Enter your password to confirm the deletion of your account. Finally enter the code to confirm and delete your account.
The belly roll is a great place to start for aspiring belly dancers. The belly roll can be mastered by first isolating the upper abdomen and the lower abdomen separately. Combine these two movements for a perfect belly roll with instruction from an expert: Yasmeen began dancing at the young age of 3 and studied ballet, flamenco, folkloric, hip-hop and modern dance styles, as well as tribal fusion belly dance and Oriental Classical Egyptian belly dance. Learn more belly dancing dance moves fro...
Tom of Videomaker teaches how to use the green screen to make a character appear in front of a set or to achieve the website spokesperson effect. Install a green screen in such a way that the fold at the corner of the wall and the ground is instead curved in order to create an even transition from the top to the bottom of the green screen. Build the base at the bottom part of the screen by weighing down the fabric at the corners and stretch it evenly. Light the green screen separately from th...
