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.
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...
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.
In this tutorial, learn how to take funky items from around your home like a picnic basket, an easel, a backpack and other fun things and turn them into creative gift baskets. In this clip, learn how to accessorize the perfect gift box for a creative friend or family member. The recipient will love these personality specific, interesting presents!
Mastery & Unique loot/items mobsters2/vendetta click here
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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.
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.
Using products from Stampin' Up you are able to create this great looking easel card. This quick and easy project uses card stock, stock lace created with a border punch, stock cutter, embossing plates, a few dimensionals, and a few other items that can be bought in the Stampin' Up kits. Each item adds it's own unique look to the creation of this easel card. The process to create these cards are sped and simplified with the kits and a variety of items can be created to add a personal touch to...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...
In this video, learn how to take things you find in thrift stores and repurpose them as cool, new items. In this clip, you will learn how to cut up a frumpy old skirt and turn it into an adorable, stylish oversized tote. This is a fun project that costs just a couple of bucks and will become a unique bag you will love for years to come!
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 ...
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 381st installment in their series of digital spreadsheet magic tricks, you'll learn how to merge two lists into one list while keeping unique items from list 1 and list 2 and removing duplicates.
In this how to video, John W. Nixon from Eagle Lake Woodworking demonstrates how to build an Arched-Top keepsake made from Cocobolo. This unique arched-top keepsake box is an eye catching item with a unique feature on the inside, a place to frame a picture. The process for making a dovetailed box is detailed in this video, as well as, the procedure for shaping the arched lid. Watch this how to video and you can create an arched top keepsake box to give as a gift or keep for yourself.
Duplicating, or "duping" items has been around for as long as PC RPG's, and allows you to use glitches to duplicate your items in the game. This video will teach you how to use the stunningly easy-to-use dup glitch in Dragon Age 2 to duplicate as many of any item you have 2 or more of your want, up to 999. This essentially gives you unlimited money and items.
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...
Orianna is a unique champion that focuses her abilities on the use of a ball she carries with her. The ball allows you to pull off some pretty cool tricks, including slowing your opponents in an AOE around it and harassing with it during the laning phase.
From Fold Something, learn how to fold an origami heart-shaped bookmark! Follow as origami instructor Josiah Hills shows the viewer how to fold a heart shaped bookmark using a square piece of paper. He calls the unique bookmark design "Mark of Love". The project requires two items: a square sheet of paper and a pair of scissors. Josiah Hills takes the viewer through the step by step process to make the required folds, creases, and cuts needed to turn a square piece of paper into a perfect hea...
Don't have the cash to spend on a brand new leather wallet? Why not make one out of duct tape? All you need is a pair of scissors and a roll of duct tape (specifically the "thinner" "cheaper" kind, as DuctTapeStuff explains makes for an easy-folding wallet). By following these easy folding instructions, you'll have yourself your very own unique duct tape wallet complete with bill fold, credit card slots, coin pouch and more.
About a minute into the video, the narrator/instructor, Kathryn, shows the viewers the items that were used in making the mini album scrapbook. She shows the layers in which the contents are placed. She also shows what the finished product should look like, in the beginning of the video. A little past halfway, she shows her audience how the scrapbook is organized. Her prime examples were having a picture on one page and the person's written thoughts on the adjacent page. With each page, Kathr...
If you're interested in changing the recommended items presented to you each time you open the shop in League of Legends, check out this guide. You will need to have access to your Riot Games and League of Legends directories first.
Keeping your supplies of caps and ammunition high in Fallout 3 is one of the game's biggest challenges. No more! This video will teach you how to use a glitch in the game's shopkeeping interface to attain unlimited caps, ammunition, and free item repairs. You should have no trouble beating this epic game after following these instructions.
Watch the world famous Trophy Hunters destroy God of War 3 on the PlayStation 3. In this video series, watch them show you how to play Mount Olympus in God of War 3. They cover the whole level and all the little tips and tricks associated with beating it, so pay close attention.
Easy steps on how to move and delete items on the LG GW620. 1. To move an item, press and hold the item on your Home Screen. 2. After a second you will feel a slight buzz at which point you can move the item to where you want to put it. 3. Release your finger from the screen to drop the item. Move the item between screens: 1. Press and hold the item you wish to move and bring it to the edge of the screen. 2. The screen will rotate and you can place the item where you wish by removing your fin...
Crochet has never been easier to learn. Make unique crocheted items with this free crochet instructional video series.
If you're running either the Minecraft 1.9 pre-release, or the actual release of Minecraft 1.9, this video tutorial on how to download and install the Too Many Items mod should give you some help. The Too Many Items mod helps you organize your inventory in a much better way.
A Pack Tite Unit is used to treat items that may be infested with bed bugs. It can be used to treat suitcases and other items that can't be easily washed in hot water. Be careful not to allow any items to touch the heating unit. Place your item in the center of the rack. Place the metal safety rack on top of your item. There are also side racks available. Zip it closed. Make sure it is zipped as far as it will go. This will kill bed bugs and eggs, because it will heat items up to 140 degrees....
Duct tape isn't only good for making sure your items don't fall out of your eBay shipments and for securing a rear view mirror in place after your drunken cousin knocked it off one night during a temper tantrum.
In this video, JD, from Tying It All Together, demonstrates how to tie a knot known as a "Ringbolt Hitch". This is also known as "coxcombing". This type of knot was once a common tie used by sailors to dress-up items and parts of their ships. When tying a wheel, a "Turk's Head" knot was used to cover the part of the wheel where the two ends of the ring bolt met, which would firm up the hitch, and help to keep the tied ends from unraveling. It is a nautical tradition to use this type of knot t...
In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...
Crochet has never been easier to learn. Make unique crocheted items with this free crochet instructional video series.
Get more stuff without cheating! You need an empty chest and a bag of the items you would like to duplicate. Put the items in the bag and then execute a save and reload maneuver so you can come back and get even more items!
In this video, we learn how to knit with color with Brandon Mably. Get inspiration from the world around you to get different colors and make out different patterns. Carry your colors around the item that you are knitting to make a nice pallet that you love. You can use inspiration from the outside, different states, stores, plants, and anything else that you love! Once you find something you want, get started knitting and find a way to knit that works for you. Use the color range that you ar...
Have you ever thought about creating small boxes out of newspaper? Tomoko Lipp shows you a simple folding and cutting method to do this. Making these can be another way to recycle and be environmentally conscious. You might also consider using them for a unique gift box idea or for storing small items. All you'll need is some newspaper, a pair of scissors, and a pen to mark a few measurements.
Great unique and interesting glassware gifts. Learn how to etch glasses, jars and and other glass items in this homes crafts series from a glass project expert.
At the time of writing, there is an unpatched glitch in the Xbox 360 and PS3 version of Dead Island that allows you to dupe or duplicate some of the weapons and items in the game. It requires you to hit the right controls at the right moment, but if you can accomplish it you can end up with two of the same item.
In this tutorial, learn how to make fun kid's crafts by recycling items that you would normally throw out. You will learn how to save things like cardboard, paper, old books, dirt and even an old shoe! Turn these items into something fun and educational for your little ones with guidance from beloved actor, John Lithgow.
A lot of commonly used household items are actually poison for your furry friends. In this clip, learn all about which items can pose a danger for your dog or cat. It's not only chemicals that are bad for your pets, innocent seeming items like fruit, veggies, chicken bones, chocolate, human medications and many other hidden dangers exist as well.
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!
Apple's Keynote is a great piece of software, but one of the tricks is setting up transitions between slides. This how-to shows you clearly the way to get the look you want as you make your presentation.
One of the many cool GUI effects that you can create on your website using jQuery is the slide effect, whereby information can cascade out from one item and the other items on the page will slide up or down automatically. This video will show you how to create slide effects with jQuery and little bit of CSS3.
