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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.
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...
Making cold brew coffee can be done simply with only a jar, water, a coffee filter, and ground up coffee. Though it seems like it would be more complex, the procedure to making cold brew coffee can be easily achieved in just a couple basic steps. The steps do not require too much work and can be done in a matter of minutes. Simple measures are taken to making cold brewed coffee, such as by mixing the coffee and water through shaking up the jar. Using a coffee filter, just pouring the mixed gr...
DIY Bio-Diesel Recipe What you'll need: Funnel and filtrate paper/cloth, containers (jars/buckets), non-kerosene based white spirit, and a spare fuel filter.
Check out this video tutorial to learn more about the Phishing Filter on Internet Explorer 7. Web browsers such as Microsoft's Internet Explorer 7 have become an important part of the computing experience for business and home users around the world. With the popularity of web browsers for accessing information, running programs, and even accessing corporate resources, the browser has become a target for viruses, malware, and phishing schemes that present real dangers to Internet users. Inter...
After achieving viral and financial success with its Gender Swap and Baby Face camera filters, Snapchat has returned with the augmented reality equivalent of Benjamin Button.
You're a busy, on-the-go professional, so you deserve an email client that keeps up with you. "Mail" on iPhone wasn't always the best option, but thanks to iOS 13, it feels like a completely different app. That said, there are plenty of alternatives that offer a different experience. Better yet, these apps are free. You won't need to spend a dime to try them out for yourself.
Cross-site scripting can be one of the easiest vulnerabilities to discover, but to be successful with this type of attack, it is essential to learn how to get past filters. In the previous guide, we explored some ways to do this, such as abusing attributes and event handlers and tricking the application into accepting unusual characters. Now, let's take a look at more techniques used to defeat filters.
As with most social media platforms, Instagram can be a double-edged sword. On one hand, it's a great way to share and express yourself — but on the other, it can be just as effective at compromising your privacy. Thankfully, there are a few things you can do to protect yourself.
Snapchat just fast-tracked the majority of its app user base into the world of augmented reality production by making its Lens and Filter tools available to anyone with a web browser.
Say goodbye to boring video chats over Messenger. Now the app is rolling out new features that can make any chat interesting and fun.
Deleting emails can be a tedious process on the iPhone, especially since the "Trash All" options have been removed ever since iOS 10 first came out. Though likely well-intentioned, this change places an undue burden on all of us iPhone owners who now have to erase emails individually.
The only way to know which Pokémon are in your area in Pokémon GO is the cryptic "nearby" list, which sometimes doesn't work—and also doesn't tell you which direction to head off to hunt that Pokémon you're looking for.
3D Touch is a new feature on the iPhone 6S and 6S Plus that's reinventing the way we interact with our smartphones. With just a little bit of added pressure when tapping on the display, you can perform Quick Actions from an app's home screen icon, "Peek" at emails, stories, and photos in-app, as well as perform other app-specific gestures. Since 3D Touch is such a new concept, here are some of the apps that currently support it, along with the shortcuts you can use.
If you've ever searched for a new job online, chances are you've been completely overwhelmed by the process. Clicking through pages and pages of semi-relevant job postings, sending out hundreds of emailed résumés, and filling out applications is tiresome and dull.
This is an awesome little science trick that has to be seen to be believed. Simply by emptying a bottle of "supercooled" water into a glass, you can watch it turn into ice right as your pour! It's no magic trick or chemical craziness—it's normal water and you can try it yourself right in your own home.
Many MicroKorg enthusiasts focus on it's synthesizer functions, but it's also a vocoder, and nowhere is that more apparent than in this video. It will teach you how to connect an electric guitar and a mic to your MicroKorg and use them together so that you can hear your voice on your guitar. It's very worth it.
Google is always moving one step closer to pretty much controlling everything in the world, in a good way ofcourse! The latest feature added is Google Instant Search, so for anything that you're searching all you have to do is start typing in the search term and Google will immediately begin giving you results on the fly. In this video you will get a quick hands on demo on how to use the new feature.
The Droid Incredible cell phone by HTC brings the newest Google application right to your fingertips. With "Near me now" Google Search uses your current location to let you search for restaurants, ATMs, gas stations, and more! Verizon Wireless gives you tips on how to search Google on the Incredible Android device.
It's very easy to get a slightly blurry photograph due to a moving subject, camera shake, or just an incorrect auto-focus, but you don’t have to let that ruin an otherwise terrific picture. All it takes is a little finesse in Photoshop or another photo editing software. This guide covers sharpening a blurry image using Photoshop specifically.
One of the cool things in Windows 7 is the new start menu. It is now possible to add an internet search area to your Start Menu. Instead of searching your computer, you can select a separate option called Search the Internet.
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
Create crazy looking images by 'unzipping' a person or object using Adobe Illustrator to create the zipper and then adding it to an image in Adobe Photoshop. Your tools in Illustrator will be the basic shape tool, the brush pallet, and a transform filter. In Photoshop you'll need to use the select, puppet warp, and paintbrush tools.
Start with a Sony Handi-Cam (or any other camera that allows you to film using night vision) and then add in a special infrared filter and a little extra hardware. Now you can film completely in infrared and film in X-ray vision!
You don't have to pay a mechanic to change your automatic transmission fluid, you can do it yourself at home! This video shows you how to execute a perfect fluid and filter change on your car or truck at home.
If you take a lot of photos with your smartphone or cheap digital camera, you can see the difference compared to results from a pro camera. So, if you want to get a professional camera look without dropping the money, check out this video to learn how to enhance your pics. This trick works with Photoshop, or any photo editing software that has a selection tool, a gradient tool and a gaussian blur filter.
The Moog is the original and arguably still the king of the analog synthesizers. It looks like an old phone switchboard, and can create a dizzying variety of unique, warm sounds. This video will show you some advanced features of the Moog, including how to use the sequencer to add filters to your tones.
With this thorough guide, you'll learn how to color correct footage in After Effects of Photoshop using the Curves tool. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
Looking for a general introduction to Photoshop CS5's single-shot sharpener tools? Well, you're in luck, as this clip presents just that. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
In this clip, you'll learn how to work with HD media in Final Cut Pro. Whether you're new to Apple's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...
Google has it fingers in just about every digital pie there is, including the App Store of their leading smartphone OS competitor, Apple. This video will show you how to use the Google Mobile App for the iPhone, a great app that allows you to do Google voice searches and all sorts of other handy search tasks. Apple is pretty sweet, but Apple and Google together is a huge mobile phone combo.
Infrared photos are photos that are taken in such a way that they absorb light from beyond the visual spectrum, giving your pictures a cool, surreal effect. This video will teach you everything you need to know to take them yourself. You'll learn how to determine if you have a camera that will work, get the proper filter, and take the photo. It's pretty quick and easy if you have the right equipment, and looks really, really cool.
In this clip, you'll learn how to use nondestructive layer masks in Adobe Photoshop to create modern-looking posters and backgrounds. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
Polish those not-so-pearly whites with Adobe Photoshop CS5's Dodge & Sponge tools. This clip will teach you what you need to know. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
In this clip, learn how to save and work with animation presets within Adobe After Effects. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
Want to create a realistic-looking fiery explosion? With Photoshop, it's easy. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from TutVids. For more information, including step-by-step instructions on how to create your own custom three-dimensional shapes and how to create a fireball in Photoshop CS3, watch this graphic designer's guide.
Create a cherry wood texture in Photoshop with the noise filter and few other built-in tools. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial, which offers a step-by-step guide on how to generate wooden textures at any resolution in under five minutes.
You can make inexpensive vodka taste as smooth as a top-shelf brand with a few easy maneuvers. Instead of splurging on pricey Grey Goose or Ketel One, grab a cheap vodka from the liquor store, a water filter pitcher with a charcoal filtration system (like Brita), and a mesh collander. Now you can mix up a deliciously fancy martini for a fraction of the price. Na zdarovye!
Bert heads to the dark side and teaches you how to create a reptile-like evil eye in Adobe Photoshop. Be afraid. The reptile-like evil eye's texture are created by using various photoshop filters - Radial Blur, Liquify, Texturizer, Craquelure. Carefully watch and learn how to create your own evil eye.
