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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
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 145.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to a formula that will calculate the mode when you have more than 1 criterion.
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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.
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 138th installment in their series of digital spreadsheet magic tricks, you'll learn how to name individual cells after their cell content (i.e., the name of the cell is in the cell).
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 136th installment in their series of digital spreadsheet magic tricks, you'll learn how to do two-way lookups with the VLOOKUP & MATCH 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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.
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 91st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the FORECAST function to solve linear algebra problems.
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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to import data from Microsoft Access as well as how to use the VLOOKUP function to populate data into a printable form.
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 294th installment in their series of digital spreadsheet magic tricks, you'll learn how to filter a pie chart.
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 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.
Childcareland demonstrates how to make a cupcake shaped book in this video. First, make a pattern page from a regular piece of paper. It should be designed like a cupcake. Place the designed pattern on top of a thicker paper like construction paper or card stock. Place five pages of regular paper behind the thicker page and finally place another thicker page at the back of the stack. Glue the cupcake pattern to the top, thick page, slightly to the left side. Then staple down the length of the...
In this video tutorial, viewers learn how to make a Halloween lanterns. Users will need to visit this website: jennadeangeles/] and download the Halloween template. The materials required for this project are: download template, vellum, poster, rubber stamps, metal ruler, glue and orange card stock. Begin by cutting out the lantern with the openings as well. Now stamp the vellum with some black acrylic paint. Finish by closing the lantern with glue. This video i...
Try making your own nail polish with old eye shadow you don't use anymore or perhaps they are old and you don't want to throw them away.You will need a clear coat nail polish, pigments such as eye shadow or NYX pigments. Put a little pigment on a plastic lid and pour clear coat onto eye shadow. Use more clear coat than pigment. Mix thoroughly and brush on nails. If you like the color and want to keep it, take an index card and fold into a cone like shape. Put bottom of cone into the nail poli...
You will be using a picture of a Nintendo character and perler beads to make the necklace. Start by making an outline of the character using black perler beads. Then begin using colored beads to fill in the character. The color beads allow you to fill in the character and they also allow you to create all the detail on the character. You can shade and use multiple colors in making the characters. After you have put all the beads on the card put a sheet of waxy paper over the character and iro...
This is a great tutorial for photographing beautiful star trails on a 35mm SLR camera. Because only film has low enough ASA to shoot for such long exposures, this tutorial unfortunately apply to digital SLR's.
To figure out a tip without a calculator, first remove the pennies amount in the bill. For example, if your bill is $23.76 becomes $23.70. To figure out a 10% tip, move the decimal point one place to the left. So, 23.70 becomes 2.370 or $2.37. Bump up that number to $2.30 or $2.40 or $2.50 cents, depending on your preference. Since 20% equals two times 10%, double the figure you computed for 10%. So, $2.30 becomes $4.60, or $2.40 becomes $4.80 or $2.50 becomes $5.00. Using this method, you wo...
This is a video games tutorial where you will learn how to connect to XBox Live with your laptop for Vista and XP using a wireless network. Go to the Control Panel -> Network and Internet Connections -> Network Connections. Click on XBox Live. Once you have connected your Ethernet card to your Xbox and you are connected to XBox Live, you have to bridge your wireless connection to your Ethernet connection. Give the connection a name you want, plug the Ethernet cord into the Xbox and laptop and...
This video tutorial is going to show you how to bleach paper to make the color pop. First take a piece of black paper, apply a bit of bleach and see what color it turns. Because, different cards change color differently. Next you will need a stamp, embossing ink and black embossing powder. Apply embossing ink on the stamp, stamp the black paper and put black embossing powder on the paper and dust it off. You then need to heat the paper. Bleach out the portions that you want color. Follow the ...
The video is about Wiccan Runes and to use it for prediction. Runes are small gems or stone with certain markings used for prediction. Firstly sit in a place where you can sit and meditate in peace. Place a clean cloth napkin in front of you where you can place the runes as per the natural elements. Sit and meditate on your questions and try to draw the divine power into yourself. Now pull out the runes one by one from the cloth bag. Place the first rune in the earth corner which is on the ri...
Looking to open an .exe file? In this video, learn specifically how to extract an exe file onto your desktop, but additionally where to find & download the free 7-zip file archiver.
The video starts out with a person holding an iPhone. The narrator begins to say he is about to demonstrate how to jailbreak an iPhone. Step one is to update or restore the iPhone to 3.1.2 using iTunes. After the update is complete, click on the blackrain icon and download Cydia. After the download is complete, the iPhone is jailbroken on 3.1.2. Next click on Cydia icon and search for the package bootneuter. That application will unlock the iPhone after installed. After it is installed, make ...
In this video from sjsharksipodtouch, he teaches us how to jailbreak and unlock your iPhone 3G and iPhone 2G. First make sure you are on firmware 3.0 or 3.0.1. Also make sure you are using iTunes 9 or higher. Then download a custom restore file from the video description, put iPhone into recovery mode, click shift on restore, and select the custom firmware. This will take 10 minutes until it's done restoring. Now the iPhone should be jailbroken and unlocked with Cydia installed. Then he insta...
Goldiestarling teaches you how to apply a snowflake fairy makeup look. You first need to draw the snowflakes on some card stock and then cut them out. Apply those to the face using eyelash adhesive. Use a moisturizer and then a blue powder using a short haired brush. Apply a frosty white metallic color around the eyelids. Also add a darker blue around the snowflake edges. You can also add small rhinestones and glitter to the snowflakes. Use a light brown lipstick for the lips and blend it wit...
You start off with a printed design on your doll. Use regular paper, but you have to print the doll in individual pieces - body, hands, legs, head. You stick those on the front of hard materials like thick card stock or some thick fabric. Now you can putt the doll together and make adjustments. You put the doll together by using small thumb tacks. It's even better if you have ones that have a rhinestone on them. Once you've done the joints, you can also add a little tutu or some fairy wings. ...
Without good navigational skills, your expedition could lead to failure or result in a dangerous situation. Try to use a laminated map which is better in wet conditions. 1:25,000 scale maps provide the greatest detail. One grid square equals 1 kilometer. Use map keys for reference. Don't mistake boundary walls for footpaths. A compass points to magnetic north and the top of the planet is called true north. Magnetic north is constantly moving and its position relative to true north is differen...
The presenter of this tutorial demonstrates how to unlock an iPhone 3G or 3GS using blacksn0w firmware 3.1.2, so you can use it with any mobile carrier company that you want. The tutorial includes 3 main steps: (1) click on the black icon that was added by Blacksn0w software, (2) install "snow", (3) insert your SIM card, and wait. After a minute or so, the presenter shows that that his mobile carrier company is presented as the current carrier and cellular/Wi-Fi supplier.
This is a video tutorial on how to unlock an iPhone 3g or iPhone 3gs with Blacksnow. Tap on Cydia and select manage>sources>edit>add and add the source Now wait for loading to complete. Then tap on blackrain.com>blacksnow>install. You need to install blacksnow to unlock your iPhone 3g or iPhone 3gs. The installation may make a few moments. Once the software is installed to your iPhone 3g or iPhone 3gs, insert your SIM card. Now you can see the service provider's lo...
This is a simple how-to video about unlocking your iPhone 2G using the firmware version 3.1.2.
If you want to know how to make a bibliography master list for your research paper, this video is made for you to watch. At the center of the first line of your index card, write the title of your research paper. Make a list of all your references. It can help you save time locating the source of your notes. Take note of the Bibliography Code number, author, and the title of the material used or needed. Highlight important texts for you to see it easily. Compile your working bibliography alon...
Watch this video to learn how to install the iPhone theme on your LG Cookie. If done incorrectly, you may encounter some errors. Always make sure your battery and sim card are out of your iPhone to prevent damage or confusion. You will need to obtain the following file, found at http://rapidshare.com/files/331254307/InstalliPhonetheme.rar. The second file you will need is found at http://www.megaupload.com/?d=I7ZQEWL5 Do not bother with LG Utilities as this is riddled with problems, instead f...
This segment of this ongoing video series gives you a bit more strategy into the decisions you have to make during Texas Hold 'em. They display a situation that is known as "pot odds". This is when the money you have to put in to see the next card is significantly less then the money in the pot. While majority of people see this as a good time to make the call, in the video they suggest you take a look at your hand and gauge how far behind you are in the hand, and if it is really worth making...
This video is sponsored by My Poker Corner and introduces the novice into how the game "Texas Hold 'em" is played. The complete process of the game from the number of players and their positions such as the Dealer are explained. The Small Blind position and the Big Blind position in the game are forced to place blind bets before they view their cards. Different betting rounds of the game such as "The Flop," "The Turn" and "The River" are explained and how the betting works and the option the ...
This video shows you how to easily copy data to and from your Motorola Droid. The first step is to connect your Motorola Droid to PC, using the data cable. Now, simply drag down the bar in the upper side of the screen and select USB Connected. Then, click on Mount in the popped up window. This will allow your PC to see the SD Card in your Motorola Droid and browse through it. Now, open My Computer, in your PC and open the Removable Disk that appeared. Easily click and drag or copy-paste the f...
This video is about how to make an origami heart out of paper. Origami is the ancient Japanese technique of folding paper into shapes. To do this, you only need to have a piece of paper and follow the brief demonstration on the video. There is no narration. When you learn how to make origami hearts, you can do several things with them, including using them to decorate a package, giving them to friends to show you care, and writing on them to make them greeting cards.
This video is about how to root a Droid smart phone.
Looking to impress your friends with some cool tricks? Why not trying to make water defy the laws of nature?
This video tutorial from bbsiPodtouchhelp shows how to unlock an iPhone using Ultrasn0w. First the iPhone must be jailbroken so jailbreak your iPhone by following the instructions of the video from the link posted in the description. Next add the source given in the video to Cydia to get Ultrasn0w. After installing Ultrasn0w, T-Mobile users need to disable 3G. Thereafter remove the SIM card and reinsert it. Switch the phone off and reboot it. That's it - enjoy your unlocked jailbroken iPhone.
The video is very informative about the using of a Stampin' Up. The blogger explains the different parts of the system and how to use them. She first shows the finished product, in this case a label or gift tag. She then explains the process of how to die cut the various parts and how to use the dies and machine to cut out the shapes. She then explains how to put the Tags together. She then shows how to finish the product. All through the process the video also has pop ups with a brief write ...
This video shows how to clean old records using Titebond II wood glue. He has the record turning slowly on the turntable, and while it's turning, slowly squeezes a line of glue around and around onto the surface of the record, starting from the middle. He explains that it takes between four and twelve hours for the glue to dry completely. After the glue is applied to the entire record, he takes an old credit card and spreads the glue evenly onto the record, all the way out to the edge. When t...
This video is about using an embossing folder. The video begins off by showing how to create a perfect oval for the main emblem in the picture. First you take your whisper white card stalk and attach it to a piece of cardboard. after this process you run it the embossing machine to make the adhesive attaches correctly. The video contains video and audio instructions as well as multiple techniques to complete the task at hand. this video is very informative and help you indefinitely to complet...
