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...
This video shows you how to dry-mount a painting done on rice paper with silicone release paper. This method is to transfer the silicon adhesive film to the backing material first, then take the release paper off and mount the painting on. Artist, Henry Li gives you everything you need to know to properly mount your beautiful painting on the silicone to transfer as you please.
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).
If you're buried in e-mail (and who isn't?), Instant Search in Microsoft Office Outlook 2007 can save the day for you. The new Instant Search helps you quickly find e-mail messages, appointments, contacts, or any Outlook item. You don't even need to know which folder the item is in. Watch the demo to see how to use this fast search feature in Outlook 2007, and start finding what you want instantly.
One of the great features of the Zelda games is the number of magical items at Link's disposal. In Zelda: A Link to the Past, the magical mirror item was used to switch between the dark and light worlds. In this instructional video, learn how to get the cape item early before the Master Sword and the Titan's Mitt. Note that this glitch does not work on the Super Nintendo console, only for the Game Boy Advanced and the SNES emulator.
Add even more personal touches to your handmade crochet items. This how to video is a tutorial on how to crochet beads into yarn projects. You can add large or small beads to decorate your crocheted items.
G4's Cheat! will get you though the toughest parts of Resident Evil 4 for the PS2 and how you some hidden items including a futuristic gun.
This video will show you how to create the Smallville effect in After Effects. He doesn't talk, so if you see new items show up on the timeline, it's him hitting CTRL-D and duplicating the selected item. Also, some areas where it's repetitive are sped up.
When we reviewed the best file managers on Android, MiXplorer easily topped our list with its abundance of features, including tabbed browsing, support for up to 19 different cloud services, file and folder encryption, and much more. The only major complaint we had was the fact it couldn't be installed from the Play Store, but now, that is no longer the case.
Smartphone manufacturers do their best to keep you tied down to their ecosystem, but the reality is that there's not much keeping you from switching. Transfer some files, install a few apps here and there, and all of a sudden, you're knee-deep in a new operating system.
If you've just ditched your Android phone for a new iPhone, you're in luck, because Apple has a way to make your transition as simple as possible with their Move to iOS app for Android. To help make things even easier on you, we've outlined the process of using Move to iOS to transfer images, messages, contacts, mail accounts, calendars, and more over to your iPad or iPhone running iOS 10.
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.
Smoked foods are popular all over the world, but most of us don't have smokers at home. If you want smoked salmon, brisket or Gouda, you usually have to go out and buy it. Outdoor smokers aren't usually an option for city-dwellers, and the indoor versions can be pricey.
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.
If you've never heard of cookie butter, it must be because you live in a town where there's no Trader Joe's. It was their most popular item in 2012, and when it started to become popular, the Internet promptly went nuts, posting recipe after recipe using it as an ingredient. For those of you who don't live near a Trader Joe's but still want to see what all the fuss is about, there's good news—you can make it at home—and you don't need spiced Speculoos shortcrust biscuits either!
It's been a rough week for Instagram. First they came out with a new terms of service that suggested the right to let companies use people's photos for advertisements without the user's permission. Then everyone started freaking out and debating whether or not to leave the online photo-sharing and social networking service. Now, they've changed the controversial wording saying that the selling of user photos "is not true and it is our mistake that this language is confusing".
In order to completely delete items from Mac OS X. Download Google desktop. This will search your computer and the web and your computer. Go to Applications. Right click on Google Desktop. Go to Show Package Contents. Drag contents into the trash. Next, go to Google Gadgets. Click and drag it to the trash as well.
The video demonstrates how you should pack to be fully equipped and prepared for a backpacking trip that lasts 2-3 days. Gather all of your equipment including clothes, food, water, climbing gear, emergency kit, sleeping back, and more. When you start to pack, you want to make your center of gravity is very low so pack your heavier items near your back and lighter ones that aren’t required immediately during your trip such as your sleeping bag at the bottom of the backpack. Also remember th...
Keeping a computer desktop organized is tough, but clutter can quickly and easily become a thing of the past. Learn how to organize your computer desktop with this how to video.
Wearing vintage clothing is one of the best ways to reduce the environmental impact of your fashion choices—short of walking around naked.
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...