Locks Range Search Results

How To: Do hanging dip exercises

Work out and getting in shape with dips. Learn how dip exercises can increase your strength and fitness in this training video. Take action: do not lock elbows, upper arms stay parallel to floor, and no partial reps, use full range of motion! Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she en...

How To: Use the preview range in CINEMA 4D

If you use After Effects you have become familiar with the Work Area, a range of time that allows you to focus on a specific range of time. You can work exclusively in this area, or work in the larger time of the composition, only to preview or render that area of time when you go out to final. In CINEMA 4D, users can achieve similar results using the Preview Range. This tutorial will show you how.

How To: Create high-dynamic range images in MAXON Cinema 4D

This tutorial presents a lesson in generating high-dynamic range images (HDRI) within MAXON C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.

How To: Count the number of characters in an Excel cell range

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.

How To: Use dynamic range names in Excel 2007 tables

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.

How To: Name cell ranges with relative references in MS Excel

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.

How To: Invert a range of values in Microsoft 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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.

How To: Use the sparkline function in Microsoft Excel 2010

There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...

How To: Make a paper blowgun with a 50 foot range

Training to be a deadly assassin? Why not practice on something a little less dangerous, and make a homemade paper blowgun to begin with? In this two-part video tutorial, learn how to make a sturdy paper blowgun that shoots steel-top darts, and can shoot up to fifty feet. To make this paper weaponry, you will need: An old school notebook, scissors, tape, a hot glue gun, a soda bottle, and 2 paper clips.

How To: Instantly Unlock Your iPhone with Face ID — No Swipe Needed

Face ID does an excellent job with keeping your iPhone safe, boasting a million-to-one odds against unauthorized access when compared to Touch ID, which is 20 times less secure. However, it's far from being truly hands-free, as you still need to swipe up the lock screen once it detects your face to access apps. But if you have a jailbroken iPhone X, this issue can easily be remedied.

How To: Lock Your Apple Watch with a Passcode to Increase Security & Keep Prying Eyes Out

While there isn't as much personal data residing on your Apple Watch as there is on your iPhone, it's still a good idea to set a passcode for it and lock it up when you're not using it. If you don't, while it's charging or otherwise off your wrist, others may be able to sneak a peek at your activity, messages, emails, and other personal details. Plus, you won't be able to use Apple Pay without one.

How To: Unlock the Hidden Weather Lock Screen Widget in iOS 12 on Your iPhone

There are a lot of things that make iOS great, but lock screen widgets are not among them. If you want more information on your lock screen other than the date, time, and notifications without having to swipe to a sidebar of widgets, you'd normally look toward Android. However, iOS 12 aims to shake that up a bit with a secret Weather widget for the lock screen — not for the Today view.

How To: Get the OnePlus 5T's Face Unlock on Any Phone

The OnePlus 5T was just released, and it's packing several new useful features. While many OnePlus 5 buyers are feeling frustrated with the quick release cycle, lots of fans are still clamoring to buy the new device. Aside from the larger screen, most of the buzz around the 5T has centered around the new face unlock method. Thanks to a clever hack, you can now get this feature on almost any phone!

How To: New iPhone Exploit Lets You Bypass Someone's Lock Screen Using Siri & FaceTime

With the recent news that New York County's District Attorney's office is trying to get into over 400 locked iPhones for use in criminal investigations, you can see why it's important to keep other people away from your personal data. The fact that it can and will be used against you in a court of law is just one reason to protect your phone, because even if you make sure to stay above the fray, identity theft and bank fraud are still very real threats.

How To: Lollipop's 'On-Body Detection' Smart Lock Keeps Your Android Unlocked While You’re Moving

Google recently rolled out a new Smart Lock option labeled "On-body detection" for Android Lollipop via an update to Google Play Services. As I'm sure you can gather from the name, this new function keeps your phone or tablet unlocked using the built-in accelerometer to determine whether or not your device is being carried on your body, allowing you to set it down and walk away carefree knowing that's it's locked again.

How To: Ditch Your Doorbell for This Front Door RFID Lock That Lets Whoever You Want In (Whenever You Want)

Hate answering the door, but don't trust your friends with a set of keys? This RFID front door lock made by Steve Pomeroy will solve all your party-hosting problems. It reads the RFID tags in his friends' public transit cards and decides who's allowed in based on "groups" that Steve defines. And I have to say, it's also rather stylish. It's controlled by an Arduino serial console and a custom Android app to add and remove cards. The reader can store 50 or 100 tags at a time and allows 7 diffe...