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 663rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to add or average while ignoring #N/A errors in hidden rows.
If you've proven yourself beautifully adept at making snug and cozy granny squares (usually used as coasters), then why not add some spice to your crafting by adding different colors to the mix?
In this clip, learn all the basics about bobby pinning. These classic clips are popular with dancers and performers because they are easy to hide and hold a style really well. If you are new to bobby pins or just need a refresher course, watch this clip and start pinning!
Take your Halloween celebrations into another realm entirely by making these disgusting bloody brain soaps. Hidden within each brain soap is a gooey slime that'll ooze out after several washings.
Looking to get super creative with your shoelaces? In this video, fifteen different shoelace styles are gone over with diagram as to how they were done. Such styles include the checkerboard, the double back, loop back, sawtooth, riding bow, twistie, lattice style, footbag, ladder, bushwalk, bi-color, display, hidden knot, and the zipper style. Use two different colored laces when doing these styles to jazz things up!
Hidden features of the Patch tool revealed as we wipe out some nasty looking tattoos. Use Photoshop CS4 to fix the tattoos or body scars with the Patch tool. Remove your ugliest mistakes with the Patch Tool, a tutorial from TutorialBucket.
This video shows how to setup and use your DynaSpy wireless video surveillance camera.
In this software tutorial Barton Damer explains the hidden secrets behind Adobe Illustrator's pattern brush. Watch and learn how to create an intricate and unique pattern with the pattern brush in Illustrator CS3. Some of the graphic elements used in the tutorial come from the Go Media arsenal sets.
Need to adjust your microphone's input volume using the Realtek Sound Manager but aren't sure how? The 20db mic boost gain appears to be in a buried spot in the Realtek HD sound cards software, but it's there! In this video tutorial you'll see how to get to it.
This video will show you how to replace a wick in a standard Zippo lighter. This method can also be used in many other similar style lighters. As you will see in the video, you might not even need to change it, but rather just use what's left. There's a lot hidden in there!
Learn how to etch an iron meteorite to reveal its hidden crystalline structure. This guy is specifically etching a Campo Del Cielo meteorite. Why? So you can see how to do it yourself.
Design your own font characters for windows, using a hidden application in windows xp. Try it now!
Learn how to make a pen in which to easily conceal and retrieve test and exam answers by watching this how-to video. If you're too lazy to do your reading, or you don't think you have a prayer of passing, try a cheat sheet. Check out this video tutorial and learn how to hide answers or notes on a pen. Just remember, you're only cheating yourself by not studying.
James (The Amazing) Randi speaks on spoon/key bending and hidden picture reproduction. These were tricks pulled by Uri Geller to show he had psychic powers. Arthur C Clarke was one of many who spoke out against Geller and sought to distance the paranormal studies from Geller's bogus performances.
See how a simple rubber band can become a hidden answer key for a school test.
Want a safe place to hide your stash? Here's how to build a miniature electronic safe out of an Altoids tin and a Hallmark musical greeting card.
Here's a classic throw-back to times past with a timeless game of kick the can. Just because you don't need expensive equipment doesn't mean you can't have tons of fun. You can play this game just about anywhere.
Have something you want no one else to find? The best hiding places are in plain sight. Follow these steps to create a shockingly sly storage space.
Have you ever looked behind your desk and found a clutter of cords? Cords tend to find ways of tangling themselves up, so watch this video to learn how to reduce the clutter.
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to hide secret data inside a photo.
What if you could combine the fun of Halloween with the process of learning? Well, if you were wise enough to have already snagged a Magic Leap One device, we have good news: the app you're looking for is here, and it's called Zombie Math.
Slack is meant for business, but it's inevitably used for personal reasons too, or even just to goof off with colleagues. However, you never know who's looking over your shoulder (nosy coworker? boss?), and you could get in trouble for something sent to you. That's why you might want to hide images and GIFs to help keep your conversations private.
Ever since the introduction of Google's SafetyNet feature, it's been an ongoing battle with apps trying to detect root access. For a while, there was a lot of back and forth between Magisk and certain apps. Pokémon GO was a high profile example of an app aggressively checking for anything related to root. Luckily, Magisk has made great strides to keep apps from detecting root for good.
With the new navigation gestures in Android 10, you reclaim a lot of screen real estate that used to be occupied by the back, home, and recent apps buttons. But there's still a small bar on the bottom edge of the screen, and in most apps, it still sits atop a black background. Thankfully, an easy hack will give you true full-screen without breaking the new gestures.
Just because Developer Options is hidden by default doesn't mean you shouldn't unlock it. While for rooters its benefit are obvious, even for the average user it opens the door for tools which enhance your experience. From animation speed to improving gaming graphics, Developer Options has something for everyone.
Less than four months after Snapchat introduced its Snappables platform, Facebook has met the challenge with its own AR gaming feature that surpasses the originator.
The famous Flappy Bird (technically Flappy Droid) game is still around in Android 9.0 Pie. First introduced in 5.0 Lollipop, the game was originally the version number easter egg for the new Android update. But after Android Marshmallow, Google began to hide it from its usual location, and Pie continues this tradition.
After several Android phones started incorporating the iPhone X's notch, the online community was vocal, with many expressing hatred for the trend. Well, thanks to XDA Forum Moderator Zacharee1, we already have an app to undo the incoming wave of notches.
Many OEMs create skins that run on top of Android to differentiate themselves from their competitors. One example is the LG UX 6.0+ found in the new LG V30, which is Android at its core, but improved upon by the addition of unique features. One such feature is the ability to change the buttons at the bottom of your screen.
With Instagram's archive feature, we have the pleasure of hiding all our stupid photos of #gettingcrunk from back in the day. This wonderful new IG feature will still allow us all to cherish those embarrassing moments in our life, yet hide them from those people we hope would never scroll so far down.
The Galaxy S8's AMOLED display is prone to screen burn-in, particularly with the navigation and status bars. But hiding these bars would make it hard to navigate your phone — that's where Pie Controls come into play.
The Galaxy S8 continues to be a treasure trove of hidden features that, with a little digging and experimenting, can be easily unlocked to further enhance your overall experience with the device. DPI scaling, or the ability to adjust the size of on-screen content, is among these hidden options that come standard with Samsung's newest flagship.
If your Android device wasn't manufactured by Samsung, chances are it uses on-screen navigation buttons. Colloquially referred to as "Soft keys," these have become commonplace due to their flexibility, as well as the fact that manufacturers don't have to include extra hardware buttons with a propensity to fail.
As familiar as it may look at first glance, there are still tons of subtle changes in Windows 10. Many options that existed in past versions have been moved, and virtually every system menu received at least a small visual makeover.
In a bit of a strange decision, Microsoft has made it to where some users don't have a choice in the matter of applying failed automatic updates. When a Windows or driver update comes your way and fails to apply for any reason, your computer will continue to attempt applying the broken update at seemingly random intervals. The Pro and Enterprise editions of Windows 10 will allow you to delay or stop updates altogether when something like this happens, but the Home edition has no such setting.
Welcome back, my hacking friends. We use our smartphones every day, for business, socialization, and leisure. The number of iPhone users is increasing in dozens of millions every year, with a whopping 63.2 million users in 2014 alone. That's a lot of users.
Upon getting the new Samsung Galaxy S6 Edge here at the office, there are countless things we wanted to do before actually diving in and using the device. One of those things is removing all of the unnecessary pre-installed applications we never asked for.
Cleaning the clutter off of your desktop every so often is a great idea. Unfortunately, that doesn't mean that you're actually going to do it. Whatever the reason, you may not have time to get everything organized, but luckily there is a way to temporarily "clean" your desktop in a hurry.
While there isn't a "Camera Roll" anymore in iOS 8 for your iPad, iPhone, or iPod touch, the photos that were once in it are not missing—they're just not as convenient as they once were. In the upcoming iOS 8.1 update, Camera Roll will be making a comeback, but we've found something better that you can use right now—even after Camera Roll returns!
Viewing all of the attachments in a message thread within iOS 7 has never been particularly easy. To see every single picture and video dating back to the beginning of the conversation, you have to manually scroll through the entire conversation and refresh it until all of it appears on your screen. Depending on how long the conversation is, that could take some time.
