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).
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...
Hurricanes can occur any time with out any warning. So it is prudent to prepare you self for disaster recovery in case of any hurricane. To protect your self from hurricane by staying at home or to flee from a hurricane you will need some items ready. The main thing is water. So arrange for one gallon of fresh water for one person per day. It is good to store water sufficient for one week. So store enough quantity of water for all the persons in the home sufficient for one week. Make sure tha...
This video illustrate us how to make a hovercraft with common household items. To build one, first of all, collect all of the items required for making it. You need a CD, bottle cap, balloon and super glue. Then start by applying glue to the lower end of the cap and sticking it to the center of the CD and let it dry. After it has dried, blow up the balloon and secure it up on the bottle cap tightly. Now open the bottle cap and let the balloon deflate.
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...
Do Try This at Home brings us video on how to create a cloud in a container. With just a few simple items household items we can create a cloud. He explains to us the science behind what he is doing and why is works the way it does. After that he demonstrates how to create the cloud with quite amazing results. He easily has created a cloud and suggests that we try this at home because it much easier to see and enjoy in person.
Club Penguin is a flash-based website with an a virtual world of online games for kids to play. Learn how to hack Club Penguin with tricks and cheats. Watch this video tutorial to learn how to find hidden items in the Club Penguin catalog (09/29/09).
The following are some fun booby traps you can set up on friends and family members. They don't require much, just simple everyday household items.
This video tutorial shows you how to make a simple pop pop boat (putt putt boat) out of house hold items. Very simple and easy to do.
Are you playing through Dark Souls and having flash backs to all those times you died in Demon Souls? IGN is here to help you with several tips and tricks on surviving. This guide shows you good spots to grind, what gift to pick for your character, and where to get the Sorcerer's Catalyst item that will allow you to cast magic in the game, even if you aren't a magic user.
If you're interested in finding out how to play Xerath in League of Legends, take a look at the Xerath Champion Spotlight from Riot Games. In it, you'll see what runes, masteries, and items Xerath can be built with, and how Phreak plays him on both Summoner's Rift and the Dominion map of Crystal Scar.
The low price of speakers and MP3 players today make them ideal for adding a bit of sound to different items, and this tip from CNET reveals a few ideas. Add an MP3 player and a pair of speakers to a decoration, for example.
If you want to put the finishing touches on your new BioShock cosplay outfit, of if you just think it would be awesome to charge at your friends with the favorite weapon of Big Daddys across Rapture, this is a guide for you.
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.
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...
Want to create your own camera? The simplest one that you can create is a pinhole camera which can be constructed from everyday household items.
In this video, we learn how to make a new menu in Joomla with Chad. First, log into your Joomla account and go to the menu button. Click on "menu manager", then you will click on the "new" link. After this, enter in the unique name, title, description, and module title in the appropriate boxes. Once you do this, click "save", and now go to the menu items icon under the links menu. Now, go to "new", then "external link". Enter in the menu item details in the appropriate boxes, then add in the ...
Making your own clothes or items from scratch has its advantages. One being able to wear clothes that don't cost very much and will fit you perfectly and the other being that you can design them to look like whatever you want.
If you've purchased a Nook (the Barnes and Noble e-reader), then you probably want to keep it safe and free from cracks or scrapes. While you can certainly purchase a Nook cover from the store, why not personalize it instead by making your own Nook cover?
A great gift to offer someone for Valentine's Day is something you make yourself. In this tutorial, learn how to make a celebrity style keepsake box using decoupage techniques. This box can hold anything from gifts to precious items to little trinkets.
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...
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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER functions.
To make a Christmas wreath with poinsettias, by using synthetic materials you will need a Christmas wreath, pine cones, ribbon, berries, poinsettias, and any other picks you may want to use. You can purchase these items at any craft store. First, shape wreath, make bow out of Christmas ribbon (or pre-purchase bow), and attach on wreath. Next, wrap excess ribbon around Christmas wreath and align evenly poinsettias around wreath. Then, wrap around wire from the ornaments, pine cones, berries, a...
In this video from MacTipsOrg we learn how to print directly form your desktop on a Mac making printing very quick and easy. First, open your system preferences, and then click on print and fax. Now take the printer icon you see there and drag it to you desktop. Place it anywhere on your desktop. Whenever you need to print now, you can take your item, drag it, and drop the item right on the printer that is now on your desktop and it will print! This is a quick time saving technique to use for...
Rafael and Zappos How To demonstrates how to pack your luggage efficiently. First, make a packing list to determine what you will need to bring on your trip. Go through your day in your mind and add things to the list accordingly. Don't forget your toiletries. Ideally bring one pair of shoes and coordinate your wardrobe accordingly. Lay out everything you will be packing and group them by like items. Don't put piles in your suitcase. Instead, roll your garment to prevent wrinkles and save spa...
Backpacking through Europe is a great way to see a new country. This video tutorial shows male travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. As a general rule, you'll want to reach a balance between light packing and thorough preparedness. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. Finally, bring a journal to record important information and for writing down ...
Backpacking through Europe is an exciting and affordable way to see a new country. This video tutorial shows female travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. As a general rule, include clothing that may be easily layered for colder climates.
Using multiple layers of clay, garden of imagination shows how to make a hamburger and fries out of polymer clay. This decorative item would then be placed into a miniature dollhouse being displayed as a food item. She rolls a peppercorn on brown clay to give it the texture of meat. She mixes together green and whit clay for lettuce, and uses another piece of clay to ruffle the edges of the lettuce. She uses small round cuts of clay for tomatoes. Using an embroidery needle with a clay handle ...
In this video from middiablo we learn how to combine multiple PDF files into one document on a Mac. Navigate to where the PDF files are in the finder and command click on them and then open with preview. Make sure the thumbnails button is checked at the bottom right. In order to select them all, click on one page, hold down shift and then click on the last page. It will select every page. Now click and drag and you can put the pages anywhere you want. Now go to File and Save. An even easier w...
The people at Garden of Imagination demonstrate how to make a miniature cream puff. Using a mixture of polymer clay, clay icing, pastel paints and a variety of tools, including a paintbrush, a scalpel, and tweezers, a miniature cream puff is born. This mini item is perfect for any number of occasions. When used in combination with other mini foods and pieces, it makes a cute and cheap decorative item. Creating a tiny and affordable State Fair has never been easier!
The Knit Witch shows you how to do wet blocking to a knitted piece. With specific tools like a blocking board with a grid, a tape measure, and a few other items. The items used can vary based on what kinds of material you are using so it's important to know what each one needs. Reminders and tips are explained when the pertinent step is reached so that you can keep them in order and apply them when needed. Wet blocking will be a breeze after watching this video and following the steps closely.
The organizer pouch, a flat, rectangular, often multi-compartmented, nylon bag with zipper closure(s) is a great item that is becoming hard to find. They sometimes include see-through mesh panels, and are available in a variety of colors. These are terrific for avoiding what could otherwise be a cluttered mess in your bag. Give a little thought to organizing your belongings into categories and storing them in the pouches. This will help you keep track of those small items that have a way of g...
The newly enhanced focus from Magic Leap on enterprise, announced on Tuesday, also came with a few companies opting to weigh in with their experiences developing for the platform.
In iOS 13, Apple finally took the built in Files app from an extremely rudimentary file browser to a full featured app that can serve the needs of most any user. Among the new features is the ability to compress a file or series of files into a standard ZIP archive right from your iPhone.
Apple makes it easy to access your favorite and most recently used applications and documents in Mac OS X. You can simply add your favorite apps and folders to the dock, and you can always visit the Apple menu from the menu bar to see a list of your most recently used apps and docs.
You didn't have to attend this year's CES to have gadget envy. There are so many great smartphones, computers, laptops, and other gadgets available in the market that the real challenge becomes choosing the right one to fit your needs and your budget.
Smash glow? What the heck is that? That's exactly what you'll find out… watch this science video tutorial from Nurd Rage on how to make smash-glow crystals (triboluminescent crystals) with Dr. Lithium.
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to content-Aware scale and create 3D objects in Photoshop.
Learn how to play Graves as a ranged carry in League of Legends with this Champion Spotlight from Riot Games. In it, you'll learn what items, armor, runes, and masteries to get on Graves so that you can do the most damage.
The SOFLAM is a gadget that you can use in Battlefield 3. It is a team based gadget that you deploy and use to laser target. It is different than a mortar and can be a little hard to use. This guide will show you how to get the most out of a SOFLAM so that you can tear up the other team.
