Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
Robert Scot, from ModernMom, shows viewers how to shrink an enlarged skin pore. Scott reminds us that genetics and aging do contribute to enlarged pores and skin condition, but there is still a way to deal with this. There is no way to permanently shrink enlarged pores but you can handle them with time. You can use cleansers and exfoliation to do the trick. Your cleanser should be for oily skin that will naturally purify your skin. You really want to focus on exfoliation and use exfoliates wi...
Watch this science video tutorial from Nurd Rage on how to make copper sulfate and zinc batteries. They show you how to make the classic copper sulfate and zinc battery using the incredibly easy "gravity" battery design approach. Great for science fairs and similar projects this battery can be used to explore many basic concepts in batteries.
This easy-to-follow video tutorial walks you through steps of converting old VHS tapes to DVD. Roxio Easy VHS to DVD is a combination of software and hardware that allows you to easily and quickly digitize old analog recordings. You simply attach the included hardware to a free USB 2.0 port on your computer, then capture from virtually any analog video or audio source.
An emergency battery charger for your mobile phone comes in handy, but it's not the ultimate solution; once it's dead it's useless (what a waste). If you want to really get off the metaphorical grid, you can follow the steps in this video to construct a more robust circuit that will not only bail you out of an inconvenient situation but also recharge in between uses. The simple addition of a low voltage solar panel and rechargeable batteries makes this possible. Enjoy!
This video from AT&T describes the process for giving your original iPhone to someone else when you buy iPhone 3G.
Watch this video tutorial, and learn how to turn an ordinary inexpensive webcam into a hidden home security system, viewable anywhere in the world from your cell phone! With a cute and cuddly teddy bear and a cheap webcam, you can make the perfect homemade security camera, or just a camera to spy on your sister and her friends during sleepovers. Follow along with the steps in this how-to video and learn how to set up this spy system. Note: this video is NOT recommended for people who are perv...
To borrow from the canon of Game of Thrones, what is dead may never die. And while the Meta Company that we knew this time last year is no more, the patent infringement lawsuit filed against the company lives on.
US blood banks have assured the American public that they have the tools to prevent a Zika contamination, despite the rapid spread of the disease.
A rose by any other name may smell as sweet, but one annoying invasive weed may hold the answer to treating the superbug MRSA. Researchers from Emory University have found that the red berries of the Brazilian peppertree contain a compound that turns off a gene vital to the drug-resistance process.
Forget headphone jacks and "Courage." Look past the shiny Jet Black finish and beyond the minimized antenna lines. Sure, quad-LED flash and dual cameras are nice—but dual-SIM would've been much better.
How much you've actually spent and how much you think you've spent are usually two completely different results, and is especially true on Amazon when it's so easy to click and buy. You might think you've given Amazon a couple thousand over your lifetime, when the fact is that it's three or four times that amount.
What's a penny worth these days? Not much. But could there be some free energy hidden inside your spare pennies? You'd be surprised! See how I hack together stacks of pennies into makeshift batteries that can drive small-current devices like LEDs and calculators.
If you're not performing your absolute best when it comes to cell phone games, it could be because of a distracting on screen keyboard. With the Nokia 5800 Xpress Music you can remove the keyboard by applying your own designated options. This video tutorial starts off pretty straight forward, but you'll have to witness an Uno game in Italian after the instructions finish.
Thanks to the PlayStation 3 and Xbox 360, video games are constantly evolving to higher degrees of sophistication, with complex graphics, lifelike resemblances and storylines that create exciting experiences that relieve the tediousness of our everyday lives.
If you've made a game using Unity3D and want to present it in the best way possible, you're going to have to use the engine's GUI tools to make some snazzy 3D menus. This video series will show you how to do so.
If you've already watched our videos on basics of Unity3D, the awesome free 3D game design engine, and want something more meaty to dig into, watch this video series for a guide to making C4KE, a charming little 4-player action / strategy romp designed by the creator of this video for a game design contest.
If you've ever wanted to make your own video games and not known where to start, try Unity3D. It's a game development engine for the PC that has a free basic version and allows you to create pretty good 3D games easily. This video series will teach you the basics of Unity, including object creation and scripting.
The concept of video game etiquette is foreign to many people, including a disgraceful number of frequent gamers. The combination of anonymity and role-playing in online games can lead people to be dicks in all sorts of obnoxious ways, making a fun activity distinctly less fun for everyone. Watch this video to learn about proper online gaming etiquette in the context of Call of Duty Black Ops. These lessons extend to most games, however, and practicing them will results in people liking to pl...
The new Samsung Galaxy Tab isn't a cell phone, but that doesn't stop you from making phone calls! With this Android tablet, it's a breeze to make phone calls. Just hit the PHONE icon on the homescreen and dial your number. Press CALL and wait for the connection. You can MUTE the mic, use a HEADSET or MINIMIZE the dial pad. See how!
If you want to save some money on an iPod holder, you might want to watch this video tutorial. You will learn how to make a cool iPod holder out of a sock. It's very easy to do and more importantly... it will save you money. You can even use that dirty, raunchy, gym sock to protect your iPhone or other cell phone too! Really though, make sure you wash your socks before making this iPod protector. You may not be protecting the ingenious mp3 player is you don't.
Want to set up WiFi tethering on your rooted T-Mobile G1 cell phone? How about save space by moving apps and onto your phone's SD card? Multi-touch? It's easy! All you have to do is install a custom ROM! Learn how to load a costom ROM onto your T-Mobile G1 Google Android smartphone with this six-minute mobile phone hacker's how-to.
In this video, we learn how to install games to the Xbox 360 hard drive (Xbox 101). When you install a game to your console, it can have a lot of positive effects. The first one is: the disc won't spin constantly. This means less stress on the console, making it happier. Next, it will have a better overall performance and make the games load faster. Your system will also run quieter than before! You can install any game by going to the game details and then installing your choice of game. Usi...
Cleopatra was not modest about makeup. After all, this was the woman who bathed in tubs filled with rose petals and milk (a good idea even today, if extravagant, since lactic acid exfoliates dead skin cells), invented perfume, and always wore makeup.
You can create basic 2D games with Objective C and the frameworks that the Apple iPhone already has, but the cocos2d framework allows developers to make their games much better, with animations, sprites, cool menus, special effects and more! Most game developers for the iPhone start out using cocos2d because it's a powerful tool, and best of all— it's free.
This video tutorial is in the Education category which will show you how to make sodium bromate and potassium meta-periodate. This experiment uses toxic chemicals and releases harmful gases. First you have to make a saturated sodium bromide. To this solution then add a small amount of potassium dichromate. The solution now becomes concentrated. Then make the circuit as shown in the video. You need a 3 - 5 ohm resistor in order to reduce the current. Then let the cell run for around 6 hours. S...
Looking to create your own mod or write a game to round out your design portfolio? By using the free Reality Factory software, you can create levels, weapons, monsters and everything else that goes into writing a video game. This tutorials shows you how to create an FPS game using this freeware.
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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
Interested in rooting your Sprint HTC Evo 4G Google Android smartphone but aren't sure how to proceed? Never fear: this three-part hacker's how-to presents a complete step-by-step overview of the rooting process. For the specifics, and to get started rooting your own HTC Evo 4G cell phone, take a look.
In this clip, you'll learn how to use layer styles, blending modes and cell pattern effect to create a fun, glamorous pre-roll sequence in Adobe After Effects CS3, CS4 or CS5. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step inst...
Making web games using Flash and all the other plugins out there is fine, but compatibility and resource use are always going to be issues for them. Amazingly enough though, HTML5 is far enough along now that someone has made BioLab Disaster, one of the first if not the first web game to be made entirely with HTML5 and Javascript with zero plugins. The game's maker, Dominic Szablewski, was nice enough to make this video describing what he did to program this landmark game. It even describes w...
Despite the discontinuation of Microsoft's KIN mobile phones, some still have a KIN ONE or KIN TWO cell phone. Actually, it can probably be found on the market somewhere for a relatively cheap price. Almost too cheap.
If you read a lot of video game press on the internet, you've probably salivated at the high-quality HD video footage of console games that reviewers are able to record and use to illustrate their points about games. If you too want to be able to record HD footage of XBox 360 and Playstation 3 games and put them on your computer for editing and distribution, this video will show you how to do it. All you need is a $200 device called an HD PVR, which is an external device that records your gam...
Monday Night Combat might be the surprise hit XBLA game of the summer, but it can be very hard to get going in the game's two main multiplayer modes. The competition is fierce and the help sparse. Fortunately for you, this video is here. It will show you a pretty foolproof strategy for winning Crossfire games while controlling the Support character.
The prank is one of the most cherished traditional forms of expression around the world, from Japan to the Middle East to the good ol' US of A. Without them, how would people settle their disputes with one another while having a good laugh at the same time? Every time a new phenomenon enters our lives, new pranks emerge that can be performed with it. We at Wonderhowto love pranks as much as anybody, and to that end we've scoured the internet for videos demonstrating the proper setup and execu...
Starcraft 2, like it's predecessor before it, has a very robust level editor that allows you, the DIY modder, to create nearly any scenario within the bounds of the Starcraft 2 engine that you could imagine. We have compiled videos on how to do all sorts of fun things with it, from making RPG's and Tower Defense games to just making you dream Starcraft 2 level. This video will teach you how to create a complete and advanced Tower Defense game in the Starcraft 2 editor, allowing you to create ...
This video tutorial belongs to the Beauty & Style category which is going to show you how to wear a wrist watch. These days not many people wear watches. They find out time with their cell phones. If you want to improve your image, wearing a watch will help. If you are going for a job interview or on a date, you should wear a watch. Because watches co-relate to responsibility and hence project a better picture of yourself. A solid stainless steel watch is universal and matches with formal as ...
In this tutorial, we learn how to calculate and add running percentages in Excel. First, write out your value and percentage into the different columns. Next, write the formula in the cell where you want the answer to appear. To have the answer appear, highlight the box and drag it down, then the answers will start to appear in each of the different columns for the different equations. This is an extremely simple way to calculate these percentages without having to do any math! As long as you...
In this tutorial, we learn how to use templates in Dreamweaver. First, go under "create new" and click on "hdml". Start with a table that has three rows and one column at 100% width. Click in the middle one and split the cell into two columns. Now, click "insert", "template objects", then "editable region". Type text into this box, then it will show up on your page. Whenever you open a file, this will be the part you can edit, while you won't be able to change anything else. Now go to "file" ...
In order to do the resting crocodile pose, you will need to lie on your stomach. Separate your legs. Space your legs greater than hip distance apart. Your toes should be pointed. Cross your arms. Your arms and chest should form a triangle with the floor as the base. Rest your head on your hands and breathe deeply. As you inhale this will work your lower abdominal muscles, while it sends more oxygen to the cells of your body. This pose is a recommended pose for anyone who is rehabbing muscle o...
