Items - Search Results

How To: Create a list of items with a 2-array formula in Excel

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 187th installment in their series of digital spreadsheet magic tricks, you'll learn two different array formula types for creating a unique list of items for a large list containing duplicates.

News: The 5 Weirdest Items on the In-N-Out Super Secret Menu

As a California resident, I'm all too familiar with the delicious western fast food chain In-N-Out. The food is great: the fries, the shakes, the fresh ingredients, the secret sauce. And of course, the secret menu. There are only 4 items posted on the in-store menu, but for customers in the know, there are more "secret" items available:

How To: Create and manage items and loot in the StarCraft 2 Editor

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 work with items and loot in your custom levels. You'll learn how to create items, create ancillary i...

How To: Style list items with Cascading Style Sheets (CSS)

With help from this free video tutorial, you'll learn how to style list items with CSS. Whether you're using a fancy WYSIWYG (or what-you-see-is-what-you-get) page editor like Adobe Dreamweaver CS5 or a barebones text editor like Notepad, if you want to build websites, you'll need to have some understanding of HTML (for the structure of your web pages) and CSS (for their style). And this free coder's guide will get you started along that path.

How To: Make musical instruments from household items

This SUPER cool video shows how to make some fantastic percussion instruments out of items you can easily find around your house, or for cheap around your neighborhood. From plastic pails, PVC pipes, tin cans, buckets, 45 gallon drums and more. This video is short, but very inspiring when you see what cool things you can build on your own. Musical instruments can cost thousands of dollars, but with this video you can make dozens of instruments from items around your home!

How To: Build a durable bottle rocket using common items

Benson Trenh and Mark Norris show viewers how to build a bottle rocket using common household items. To build this creation you will need tape, a hole puncher, scissors and string. Also use a black plastic bag, or any color, for the parachute! Cut the black plastic bag into a square, any size you would like! Next, take the square and punch a hole at each edge of the square and string the string through the hole tying a knot. You should now have the parachute! For the body of the rocket, get a...

How To: Make a small robot gripper out of household items

A perfect project for the budding roboticist in you! This video shows you how to make a small robot gripper using basic household items. Press the button and make the robot's come together! You will need: a small blow torch or butane lighter, a glue gun, a dremel or rotary tool (along with several different bits), the free cutting pattern, a permanent marker, a micro servo, some small nails or pins, a small piece of Plexiglass and a paperclip. If you don't have access to a dremel, you can fak...

How To: Make animal masks using household items & John Lithgow

It's time to teach your kids about animals! To get your little one thinking like an animal, why not help them look like one? In this tutorial, featuring John Lithgow, learn how to turn common household items like paper plates and paints to create fun, realistic looking animal masks with your kids! You will also learn how to make special doggy treats and bird feeders so that you can really get on all fours with your animal buddies! Have fun!

How To: Count unique items in a list in Microsoft Excel

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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.

How To: Return multiple items by array formula in MS Excel

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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).

How To: Clean your game disc, DVD or CD with household items

In this instructional video, the young host demonstrates an excellent method for cleaning your DVD's, CD's, and Game discs using simple, easily found items that you always have laying around your house. The toothpaste he uses acts as a super mild abrasive (almost exactly the same that is used in professional kits, except they don't get the benefit of a minty fresh smell) that removes minute dirt and debris that gets stuck on the disc. When cleaning your discs, be sure to rub the toothpaste in...

How To: Count unique items with multiple criteria in Excel

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. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...

How To: Move list items when programming in Java

Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to use the Collection framework when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.

How To: Hide sent items on your BlackBerry

Darci Larocque, Blackberry Expert, explains a quick way to hide sent messages from your inbox folder with a few simple clicks, leaving clutter and needless distractions behind. This easy-to-understand tutorial is fully complete from start to save with visible screen shots and clear concise directions. There is even a simple two-button solution to see your sent messages again as needed. With a few easy steps, your inbox clutter can be a thing of the past.

How To: Make a vintage style jewelry box with household items

This video shows how to make a cute vintage looking jewelery box. A cardboard cheese box forms the body of the jewelery box. Other items you will need include mod podge, white glue gesso, masking tape, ribbons, a mirror from a compact, some fabric, and some faux pearls and flowers. Begin my removing the labels from the box. Paint the inside and outside of the walls of the box and the lid. Paint the areas of the box that you just primed with gold metalic paint. Now use the box to trace three c...

How To: Preview pasted items in Microsoft PowerPoint 2010

This video is describing how to preview the pasted items such as from another PowerPoint or any other articles. These are all features available in the "Microsoft Office Power Point 2010". We will take the "conference1" presentation in that the first slide and we would like to add some text from another "Document" from another application like "Microsoft Word". So, we click and drop the mouse to select that and click the Copy button on the top of the word file or we can copy by the keyboard i...

How To: Compare two tables and list unique items in MS Excel

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 156th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will check two tables and find the values that do not match and then create a new list.

How To: Make a robot out of household items

This do it yourself robot can be made out of many materials you can find around your house. You'll need a few special non household items, such as an arduino and a class 3 laser. However, once you assemble everything correctly, you can make a sentry robot inspired by the robots in the game PORTAL. Even if you've never built a robot before, as long as you have a basic knowledge of electronics, you can start with this simple and fun project.

How To: Build a wave machine out of household items

In this tutorial, we learn how to build a wave machine out of household items. You will need: 20 straws, 40 paper clips, 2 pieces of tape, and 1 washer to make this. First, you will need to pull out a long string of tape and lay it down with the sticky side up. After this, you will need to stick the straws on top of the tape in a row all going next to each other. Do this from the top to the bottom until all of the straws are stuck on. Then, stick the washer to the top and you are finished wit...

How To: Return many items for a single lookup value in Excel

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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...

Prev Page