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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
Learn to make a small origami parlor ornament using a single piece of one-sided black origami paper. In a few steps, this instructional video shows you how to fold a rather unexpected miniature paper piano. You may want to use a pen to draw in some tiny piano keys. It also helps to hum a song while following this simple visual guide to folding paper pianos.
You can find many different kinds of flavorful and exotic olives at your grocery store. The problem is, most still come with their pits intact. If you are going to use these olives in your cooking, you need to get the pit out of there. Learn how to remove the pit from olives in three different ways. Method 1: easy olive pitting Method 2: pitting difficult olives and Method 3: pitting very stubborn olives. One of these three methods should work for you as a successful way to pit olives.
If you can't get access to a wifi hotspot or an Internet connection with your PSP, you can use this method to get online. You will need access to a computer that is online, and a USB cord that can connect the computer to your PSP. Then, open up the command prompt on your computer, configure your IP and then add your PSP as a device on the network. This method uses the DNS method of getting to the Internet rather than having to hack a wifi connection.
There are many different methods of wrapping ones hands when they are doing Muay Thai boxing. This clear, concise video shows a simiple method that you can try as well before you start your mortal combat. The emphasis on this tecnique puts wrist protection over knuckle protection.
In Java, everything is an object, which can make it a little scary to start programming using this language. But that's what this tutorial is for! Here is how objects and object methods work when you're designing a program with Java.
Learn how to install a custom ROM on a Google Android mobile device using the One-Click Method. Whether you want to learn how load a custom ROM on your own Android phone or just want to see how it's done, you're sure to be well-served by this three-minute hacker's how-to. For detailed, step-by-step instructions, take a look.
Looking for the easiest way to root your HTC Magic or T-Mobile MyTouch 3G Google Android smartphone? You've found it. Rooting techniques don't come any easier than the one-click method demonstrated in this video guide. For all of the details, and to learn how to hack your own HTC Magic or MyTouch 3G, take a look.
In this video, you'll learn how to cast on with the CHAIN ON method on a rectangular loom. It'll simplify your knitting process a lot! You can use this method for many different types of looms but this video specifically covers knitting on a rectangular loom.
Factorization of a trinomial can be achieved by using the standard method of appropriately "splitting the middle term" or by this method as shown in the video.
There is no one way to remove gum. Depending on the type of gum and where it's stuck - the carpet versus your shirt, for instance - you may need to enlist a different method for each to remove the gum.
In this clip, we learn how to use conditions when using query methods in Ruby on Rails 3. Whether you're entirely new to Ruby on Rails 3 or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For all of the details, watch this quality video guide from the folks at Lynda.
Quadratic equations are easy to solve when they can be factorized. This video teaches another method of solving a quadratic equation when its not easy to find factors for it.
Looking for a quick primer on how to work with Ruby on Rails' migration methods? Let this video be your guide! Whether you're entirely new to Ruby on Rails 3 or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more information, take a look!
If you're scared of curling your hair because you don't want to damage your hair through heated products like flat irons and curling irons, then here is a more eco-friendly, heat-free alternative that costs almost nothing but produces gorgeous results.
The flat braid join is a method of stitching granny squares together using chain-3 loops. This tutorial demonstrates how you can use the flat braid technique to easily and quickly join your own granny squares together for your next crochet project.
In this clip, you'll learn how to return a variable value from a method when coding in Java. Whether you're new to the Java object-oriented programming language or are a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.
Drip coffee makers are fast and easy, but make a lot of coffee that doesn't taste very good. If you just want one good cup of coffee in the morning and don't want to buy any special equipment, watch this video. It will show you how to brew coffee using the pour-over method, in which you make one cup at a time without expensive machines or equipment.
A classic side dish for any hearty meal is roasted potatoes. Works for breakfast too for home fries! (kinda) If you've been trying but haven't quite found the right way to cook your potatoes then you're in luck! In this video, chef Jason Hill goes into detail on his methods of making perfect roasted potatoes every time and it all starts with the right cooking method.
This video demonstrates the tripod method of setting up a campfire for cooking in the wilderness. In order to set up the tripod, you will need three large branches of hazel, some copper wire, and a hooked branch to be used to hang a pot from the tripod. The copper wire will be used to attach the hooked branch to the tripod setup and cord or rope may be substituted. Another method of cooking which is demonstrated is to cook food in a pot over some embers. A hole is dug in the ground and a fire...
Need to get kissably soft lips for an upcoming date where some lip locking action is expected, or just want your puckers to look perfect under lipstick? Then watch this two-part tutorial for two ways to exfoliate and moisturize lips.
Changing your engine's oil yourself isn't just great for your car, it's great for your pocket book. This DIY auto maintenance guide presents an overview of the standard method for changing a car's oil, a method which applies for most modern automobiles. For a detailed walkthrough, and to get started changing your own car's oil, watch this home mechanic's guide.
After an easy way to factor trinomials in algebra? Try the bottoms up method! Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).
Looking for an easy method for discovering the lowest common multiple (LCM) and/or greatest common factor for a set of numbers? Try the Indian method! Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).
Want to write Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to create a simple Java program that utilizes Java's built-in println method. For more information, including detailed, step-by-step instructions, watch this programmer's guide.
One of the most annoying insects out there would be ants. Not only are they small and tiny, but when you find one you'll more than likely find a great big colony. They're annoying to deal with and when not taken care of, can live inside your home for many years to come. So in this tutorial, find out some safe methods to getting rid of ants. Enjoy!
This video shows the method to suture arterial lines using a curved needle. We will use the new arterial line kit for our demonstration. We will use a curved needle as it is safer than the straight needle. Hold the suture with the hamostat at about sixty percent from the tip of the needle. Do the turn the key method to bring the needle out from the other side. Unclamp it and re-clamp it at the tip of the needle. Continue the turn the key method. Pull the suture up and through. Cut the suture ...
Brush up on your survival skills with help from Maine Primitive Skills School instructor Nick Spadaro. In this video, learn how to keep yourself warm on your camping trip & start a fire using the strap drill friction fire method.
Brush up on your survival skills with help from this video conducted by Maine Primitive Skills School instructor Nick Spadaro. Keep warm on your camping trip by learning how to start a fire in the woods using the hand drill method with help from this video.
In this video tutorial, viewers learn how to find an I.P. address. Every computer that has Internet connection has a unique identifier called a Internet Protocol Address. This video provides 2 methods on how to find your I.P. address. The first method is to simply open your web browser and search on the Internet. The second method is to click on the Start menu and select Control Panel. Click on Network and Sharing Center. Right-click on your connection and select Status. There, users will be ...
This video shows the method to multiply two digit numbers using the grid method. First make a grid of three rows and three columns. Put a cross in the first row and first column or the (1,1) position. Separate the ones and the tens in the number. In our example 43 is broken into 40,3 and 56 is broken into 50,6. Put these numbers in the remaining places in the first row and first column. Now multiply every number with the other and place it in the corresponding location in the grid. In our exa...
This video describes about accessing an iPhone in Ubuntu using open SSH, cyber-duck, Netatalk. For accessing using SSH, make sure your iPhone's Wi-Fi connectivity is on. Now open your terminal and type "SSH root@'address'". Here address refers to the IP address of your iPhone. You have to type a password to access the iPhone contents. Once you are authenticated type "ls" and you will be shown with the contents of the iPhone. The second method is using cyber-duck. In it, choose SFTP as the con...
In this tutorial from Mark the Shark, viewers are shown how to apply a hook to a fishing pole. One such method is using a Fishermen's knot, and wrapping the hook around the line eight times, and then wetting it with saliva, before it is tightened. Then, the user must make sure than the knot comes all the way down to the hook, to make sure it does not rotate. Next, pliers must be used to eliminate excessive line, and then the line must be searched for crinks, or any imperfections. Mark the Sha...
Food editor Melissa Roberts shows a few different ways to thicken gravy. The first way that is shown is using either arrowroot or cornstarch. Both of these ingredients are gluten free and must be dissolved completely in cold water before adding to hot liquids as clumping will result if added straight. The next method to thicken your gravy is called a buerre manie'. A beurre manie' is French for needed butter. This method is a paste made by combining three tablespoons of butter and three table...
In this video the instructor shows how to solve quadratic equation by the square root method. The square root property of equations states that if k is positive and a*a = k, then a is equal to square root of k or -1 times the square root of k. So to solve a quadratic equation by square root property first get the equation in the form of a*a = k. Now apply the square root property explained in the previous step to get the result. The instructor now demonstrates these concepts by solving some e...
The gentleman, acting as the Instructor, starts the session immediately by suggesting that to teach early multiplication all parents should practice a method of "Count-by's" with their children when they are very young using ones to ten, twos to twenty, threes to thirty, fours to forty, and so forth. The Instructor then demonstrates this method of counting by tens using a grid behind him on a chalkboard which depicts columns of ten elements. He counts each column from 10 to 100, and then writ...
This is a demonstration on how to use the PLL method to solve a Rubik's cube. The author informs that what people do before and after applying the PLL technique is very important. According to him, people usually tend to first align as many faces as they can, when they see a partial algorithm and then apply the PLL method, which is very time consuming. Instead, one should stop one step short of alignment, apply the Pll method and then align the faces completely. The author, however, points ou...
In this video the instructor shows how to solve a system of equations by elimination method. First you need to know how many possible number of solutions you can get by solving a system of equations. There are three possibilities. In the first case there are two lines with different slopes, so they intersect at a point which is the solution to that system. In second case there can be two lines with same slope but are parallel to each other. In this case the system has no solution. In the thir...
This is a tutorial video on how to play bass, brought to you by How to Play Bass, hosted by Paul Wolf. In this lesson Paul teaches you how to tune your bass guitar down to what is called "Drop D" tuning. Follow along with him, as Paul demonstrates how to achieve this tuning by two different methods. The first method is done by tuning to the 'A' string, and de-tuning the 'E' string to 'D'. The second method involves a similar process, this time using the 'D' string to achieve the same effect.
This seven minute and three second how-to YouTube video, uploaded by user ranash19195, instructs it's audience to 'Change eye color in Photoshop'. There are two methods that are taught: using a hue/saturation mask or a color change mask. The instructor uses clear and concise language to teach both methods. He takes you on a step by step visual and auditory journey and makes learning to change eye colors (retouching photos) both exciting and extremely easy to accomplish.
