How To: Draw Beyoncé Knowles
Watch this tutorial to learn how to draw Beyoncé Knowles. Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.
Locked Indexing Search Results
How To: Disable the 'Good Morning' Message on Your iPhone's Lock Screen
I'm not a morning person, so getting a "Good Morning" message on my iPhone when I wake up makes me want to toss it across the room. If you feel the same way about this morning greeting, there's an easy way to stop it from showing up on your lock screen. This also applies if your "Good Morning" is actually "Good Afternoon" or "Good Evening," depending on your sleep schedule.
How To: Get a Transparent Quick Settings Panel on Your Galaxy S8 or S9
With the re-emergence of Samsung's Good Lock app, you're once again able to tweak parts of your Galaxy's interface with no root or major modifications required. One add-on in particular even lets you fully customize the Quick Settings panel on your S8, S9, or Note 8 in a full spectrum of colors to truly make it your own.
How To: Ads Taking Over Your Lock Screen? Here's How to Fix It
Android has gotten significantly better at handling intrusive ads over the years. Things have gotten to the point to where these nuisances are largely a non-issue for most of us. However, there are still a few ad-laden apps that fall through the cracks — particularly the kind that bombard your lock screen with ads.
How To: Quickly Disable Fingerprints & Smart Lock in Android Pie for Extra Security
Following in iOS 11's footsteps, Android 9.0 Pie will include a security feature that lets you immediately disable the fingerprint scanner as well as extended Smart Lock features. After initiating the feature, you will be required to insert your PIN, pattern, or password before any other unlock methods will work again.
Apple Pay Cash 101: How to Quickly Access Your Card on the Lock Screen
With Apple Pay Cash in iOS 11.2, your iPhone potentially becomes the only form of payment you need. Whether you're sending money to a friend via iMessage or paying for your groceries, you can use Apple Pay Cash to complete those transactions. It makes sense, then, that Apple would allow you to add your Apple Pay Cash card to the lock screen, for quick access wherever you are.
How To: Get the iPhone's Calendar View on Your Android Lock Screen
Starting with iOS 7, the iPhone has had a cool feature that lets you see upcoming calendar events right on your lock screen, and it only got better with iOS 10. Android used to have this feature with its lock screen widget system, but that was removed back in the Lollipop days, so there's nothing quite like iOS 10's "Today View" feature anymore.
How To: Lock Any App with a Fingerprint on Android Marshmallow
To serve as a framework for the "Nexus Imprint" feature in their new Nexus 5X and Nexus 6P smartphones, Google added native fingerprint scanner support to Android 6.0. Sure, Android devices have had fingerprint scanners in the past, but this is a unified, system-wide implementation that all devices can use—meaning that in the near future, we may finally start to see apps that let you log in to your account with your fingerprint instead of a password.
How To: Enable or Disable the Wallet from Showing on Your iPhone's Lock Screen in iOS 9
To use Apple Pay in iOS 8, you had hold your iPhone to the card reader first, and then you could either switch to a different card or pay with your default one. Now, in iOS 9, you can access your Wallet (which replaces Passbook) on the lock screen before you get to the reader.
How To: 9 Ways to Lock Your Android Without Using the Power Button
Given how much use it gets on a daily basis, the power button is always one of the first hardware features to call it quits on an Android phone or tablet. So if your power button is acting up, or you don't want it to, you can extend its lifetime by simply finding ways to use it less.
How To: Turn Off Your iPhone's Flashlight Faster in iOS 8 Without Using the Control Center
I've used the flashlight feature on my iPhone more times than I can count. It's an invaluable tool that's super easy to activate; just pull up the Control Center and hit the flashlight icon. However, turning it off isn't always as easy, especially when you're on the lock screen.
How To: Use “Smart Lock” on Android Lollipop for More Convenient Security
Keeping expensive mobile devices safe and secure is a priority for most of us, but the process of repeatedly unlocking a phone or tablet can seem like a pointless task. This leads to disabling the lock screen altogether, especially when in a safe place (e.g., home, office, car, etc.).
Siri Exploited—Again: How to Bypass the Lock Screen in iOS 8 (& How to Protect Yourself)
It's becoming more and more apparent that Siri continually drops the ball when it comes to lock screen security. In the past, Siri was exploited in iOS 7.0.2 to send messages without needing a passcode. Then in iOS 7.1.1, Siri was use to bypass the lock screen again to access contacts, make calls, and send emails and texts.
How To: Finally, an App That Forces Your Kids to Answer Your Calls
When a Houston mom got tired of her kids seemingly refusing to return her calls, she decided that she'd take action. Sharon Standifird's vision was to create an app that would somehow force children to get into contact with their parents. Having no experience with app development, Standifird quickly taught herself the ropes and hired an experienced developer to help with coding.
How To: Get Smarter Every Time You Unlock Your LG G3 or Other Android Phone
There are countless lock screens you can apply to your Android device, but very few offer more than just quick access to apps or advanced security functionality. Since you probably unlock your device a gazillion times every day, why not use this to your advantage and let it teach you something new?
How To: 10 Hidden LG G3 Features You Need to Know About
The new LG G3 is the latest Android flagship-level device to be released this year, and it's ready to give the Galaxy S5, HTC One M8, and the OnePlus One a run for their money. Sporting a gorgeous 5.5-inch QHD display, 3GB of RAM, and a huge 300mAH battery, the device looks great and has tons of power to boot.
How To: Search Your Chrome History More Easily by Indexing All Text from Webpages Visited
Let's be real, browser histories are virtually useless. Trying to find something you passed up a week ago is like, pardon the cliché, finding a needle in a haystack.
How To: Activate the Hidden AOSP Lock Screen on Your HTC One M8
Sense 6 is great, don't get me wrong, but sometimes I start to miss the vanilla Android experience that comes with Nexus devices. You can always convert your M8 to the Google Play Edition, but then you'd have to ditch all the Sense exclusive features, and we wouldn't want that.
News: Twitter (Sorta) Buys a Lock Screen
Earlier this morning, Twitter announced (through a tweet, naturally) that it has acquired Cover, roughly a minute after Cover made the same announcement. Cover Lock Screen, a lockscreen replacement app, has been vastly popular during its first year. The app places relevant shortcuts on your lockscreen that adapt to your habits, so whether you're at home, work, or in the car, you'll find the apps you use the most in these situations readily available for you. For more information on Cover, inc...
How To: Get Android-Style Lock Screen Shortcuts to Favorite Apps on Your iPhone
There are countless mods and apps for Android devices that give them an iOS-style look, but maybe it's about time we take some notes from Android, especially when it comes to the iOS 7 lock screen.
How To: Prevent Snoops from Accessing Private Messages, Photos, Videos, & More on Your Nexus 7
My friends can be pretty shitty sometimes, but they're my friends nonetheless. On various occasions, they've secretly taken my device and made me look foolish by posting crude and embarrassing posts to Facebook, Instagram, or Twitter. With friends like these, who needs enemies, right? And it's because of these types of friends that we need to substantially upgrade the app security on our devices.
How To: Get a KitKat-Style Music Lock Screen on Your Samsung Galaxy Note 3
Android 4.4 KitKat has begun rolling out for the Galaxy Note 3 in India, Poland, Russia, Switzerland, and several other countries, and an unofficial build for AT&T customers has been leaked for all of us stateside.
How To: Set Different Wallpapers for Home & Lock Screens on Your Nexus 7 Tablet
There are countless things you can do to your lock screen to customize it, including adding app shortcuts that adapt to your time and location or custom widgets with DashClock. However, one thing you can't easily do in KitKat is change your lock screen background to be different from your home screen wallpaper.
How To: Skip Lock Screen Security on Your Samsung Galaxy Note 3 When Using Trusted Networks
Whether it's because you have nosy family and friends or you're just cautious about losing your device, having a passcode on your Android smartphone is essential for protection. However, you don't always need or want a passcode, especially when you're home alone or in your car on the way to work.
How To: Get Adaptive App Shortcuts on Your Nexus 7's Lock Screen
There are a gazillion lock screen apps available on Google Play, but the majority of them are subpar and not worth your time. However, in my opinion, there is definitely one out there worth your time—one that constantly learns and adapts to what apps you use when and where to determine which shortcuts to give you.
How To: Get the iOS 7 Home & Lock Screen on Your Samsung Galaxy S3 or Other Android Device
Big bad Apple recently announced its next iterations of iPhones and the world went crazy—as usual. Displaying an array of cool colors and futuristic features, the new iPhone 5S and 5C will both be rocking iOS 7, a sleek, modern operating system that gets rid of the old icons and glossy finish for a more flat and contemporary design.
Open a Door Lock Without a Key: 15+ Tips for Getting Inside a Car or House When Locked Out
A spare key is one of those things that never seems like a huge deal until you need it. If you've ever lost your keys, had them stolen, or locked yourself out of your house or car, you know how difficult and embarrassing it can be trying to get your door open.
How To: Repair a Door Lock. The EASY WAY!
PUT THE PHONE DOWN!!! Don't call the locksmith just yet! Watch this video and l will save you at least $100.00
How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.
How To: Find, download and use an FTP client
Select an FTP client that allows you to connect to the webserver. Download a free Core FTP Le software. Install the program. Use the site manager to name the internet site. Create a host/url, a user name, password and a connection. Connect to the web server. Create an index file to make files viewable. Open the Core FTP LE software. Drag files from the desktop (left side of the dialog box) to the internet server (right side of the dialog box.)
How To: Create a dynamic frequency table & chart in MS 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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....
How To: Do reverse lookups with VBA code 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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...
How To: Retrieve data from many tables on many sheets in Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...
How To: Calculate variable commission totals in MS Exce
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...
How To: Hold your guitar pick for different types of chords
In this how-to video, you will learn how to hold your pick in different ways for certain styles of guitar playing. You must have a pick and guitar. Hold the pick between your index finger and thumb. Feel free to modify the way to hold it so that you are comfortable with it. For strumming, keep your picking hand loose. This will allow you to comfortable strum up and down. For picking chords, relax your picking hand and allow the pick to be slightly more perpendicular when picking. For shreddin...
How To: Return a row's first non-blank cell 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 364th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the INDEX, MATCH & NOT functions that will return cell content from the first non-blank cell in a row.
How To: Return every tenth value in an Excel spreadsheet
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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.
How To: Create a dynamic break-even chart 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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
How To: Extract the three largest values from a list in Excel
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. In this Excel tutorial from ExcelIsFun, the 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.
How To: Use an array formula to filter data in Excel
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. In this Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...