Items Lists Search Results

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...

How To: Input values & formulas into a cell in Excel macros

This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...

How To: Make a Christmas wreath with poinsettias

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...

How To: Print directly from your Mac desktop

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...

How To: Pack a backpack for Europe as a male traveler

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 ...

How To: Pack a bag for Europe as a female traveler

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.

How To: Make a mini polymer clay hamburger for a dollhouse

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 ...

How To: Combine multiple PDF files on a Mac

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...

How To: Make a miniature cream puff

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!

How To: Do wet blocking to a knitted piece

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.

How To: Use packing tubes to contain clutter when traveling

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...

How To: Use the SOFLAM item in Battlefield 3

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.

How To: Farm for wheat and grass with seeds in Minecraft

Farming in Minecraft isn't the most exciting part of the game, but it's essential for making the high-level food items like cake so you'd better get used to it. This video will walk you through all aspects of Minecraft farming, including getting seeds, using your hoe to til the soil, planting the crops, and then using bonemeal to make them grow fast.

How To: Use Slide and SlideToggle() Effects in jQuery

The slide effect is a popular feature of many websites that allows information to cascade out from an item on a page and the rest of the page to adjust accordingly. This effect is created using the SlideToggle() function in jQuery, the popular Javascript library. This video will teach you how to use it to make your website much easier for your users to access.

How To: Perform complicated looking magic tricks anywhere

In this video, Justin Kredible will teach you how to perform a ton of cool magic tricks using items you already have around the house. Justin is a master illusionist and in this clip he shows you some of his easiest (yet still fascinating) magic tricks. Like Justin says, he doesn't reveal secrets..he teaches magic. Have fun!

How To: Convert text to SmartArt in PowerPoint: Mac 2008

Dull and drab bulleted lists are no longer necessary with the help of PowerPoint 2008 for Mac. When you make a bullet list in PowerPoint, you can now transform those boring text charts with actual visual charts and graphs and more. The Microsoft Office for Mac team shows you just how to convert text to a SmartArt graphic in this how-to video.

How To: Use Mail Merge in Pages for Mac

A step-by-step guide that will walk you through Mail Merge on a Mac computer. You will gain how to prep and print envelopes, letters or any document that you need to send to different names and addresses on each item. You can pull the data from your address book or from a Numbers Spreadsheet and will see how to modify and merge the information you will need to successfully set up your documents.

How To: Content-Aware scale and create 3D objects in Photoshop

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.