Choices Range Search Results

How To: Make holiday-inspired peppermint soap & body butter

ThreadBanger's Corinne visits with Luca of Lolibomb to learn how to make winter-inspired vegan beauty products in a DIY fashion. Way to save some money on gifts! In just fifteen minutes and a few easy steps, make an animal-friendly body butter for your best buds with these ingredients: cocoa butter, hazelnut oil, emulsifying wax, stearic acid, liquid glycerin, distilled water, and a vitamin E preservative of your choice. Add the body butter to a decorative jar and you have a great gift that m...

How To: Automatically color alternating rows in Excel

This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the shading, the whole purpose is defeated.

How To: Create collapsible and expandable cell ranges in Excel

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...

How To: Combine images to create HDR photos in Photoshop

Yanick's Photo School demonstrates how to use Photoshop to make HDR images in Photoshop CS3. This tutorial first explains that HDR means "High Dynamic Range" which is a process to get details from a photo from both the highlights and shadows of a particular scene. The first thing that is necessary is to take multiple views of the same image with different exposures. To start off, you will take three exposures: one that is two stops down, one that is normal exposure, and one that is two stops ...

How To: Cross process your photos in Photoshop

Cross processing is a Photoshop version of slide processing. The result would be you get all these weird color shifts. For reasons best known to people who run the fashion magazines, this look became very popular in the 1990s. Start by adding in a curves layer. Add a new adjustment layer for curves. If you've never used curves before it is recommended that you take a curves tutorial first as for this effect we will need to adjust individual color channels. It is not difficult but if you don't...

How To: Select different items in Finder in Mac OS

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

How To: Get bigger biceps by lifting weights

How do you get bigger biceps, the age-old quest for bigger guns. Well, first things first, more is not better. Hefting around 50-pound dumbbells as opposed to 20-pound dumbbells is not necessarily going to build you bigger biceps because what's probably happening, you're probably not using full range of motion, you're jerking a lot, you're not focusing on that muscle alone. Practice lifting weights to get bigger biceps. Learn how to increase arm strength and size in the biceps with weightlift...

News: Thinking of Ditching MoviePass? Directly Compare Movie Ticket Subscriptions with This Chart

It's no secret that MoviePass is a shell of the service it once was. The primary $9.95/month plan for three movies each month is inconsistent and can change drastically depending on your location. Thankfully, MoviePass isn't the only movie ticket subscription service available. We've compared all the best plans on the market to help you find the one that's right for you.

Hacking Gear: 10 Essential Gadgets Every Hacker Should Try

If you've grown bored of day-to-day hacking and need a new toy to experiment with, we've compiled a list of gadgets to help you take password cracking and wireless hacking to the next level. If you're not a white hat or pentester yourself but have one to shop for, whether for a birthday, Christmas present, or other gift-giving reason, these also make great gift ideas.

How To: Avoid Injury While Exercising

When exercising at a high intensity, you know to expect some level of pain. That can make it difficult to identify when your body gives you a warning sign of injury. If you pay close attention, however, you can tell the good hurt from the bad. I talked to Dr. Brian Parr again, professor at the Dept. of Exercise and Sports Science at the University of South Carolina Aiken, who explained which symptoms of exercise are normal and which are bad:

How To: Do ultrawide pushups for a big chest

In this tutorial, we learn how to do ultra wide pushups for a big chest. A basic pushup can be way too easy if you are an experienced body builder, but you can do different variations to strengthen your body further. First, get down on the ground and place your arms much wider outside of your body than they normally would be. This will make you push harder up while your hands are pushing outward. This will make you work hard and squeeze at the same time, and your range of motion will be limit...

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Sum values after a deadline in Microsoft Excel 2010

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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.