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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function formula.
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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER functions.
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.
If Internet Explorer 8 is being a nuisance in Windows 7 watch this video to learn how to uninstall it! Start by clicking your Start Menu, then to Control Panel and then to Programs. From there click Uninstall Programs. It will bring you to a list of all the programs that are currently on your hard drive. Next click Turn Windows features on or off. From there another list of programs will appear, but these programs are all Windows programs that come with Windows 7 Operating system. Watch the r...
Rafael and Zappos How To demonstrates how to pack your luggage efficiently. First, make a packing list to determine what you will need to bring on your trip. Go through your day in your mind and add things to the list accordingly. Don't forget your toiletries. Ideally bring one pair of shoes and coordinate your wardrobe accordingly. Lay out everything you will be packing and group them by like items. Don't put piles in your suitcase. Instead, roll your garment to prevent wrinkles and save spa...
The video starts out with the narrator explaining the benefits and uses of a compost pile. He then begins to demonstrate the steps to start a compost pile. He lists the ingredients and demonstrates how to mix it up with a pitchfork and shovel. He advises to put brown organic matter such as wood chips, leaves, sawdust, etc. as the first layer in the pile. Then add a layer of green organic matter such as grass clippings. A layer of kitchen scraps or manure can be added. He then shows how and wh...
Get to know how to use Logic Pro's arrange page in this short tutorial. Use the arrange area to work with the audio of your song. Change the timeline by choosing a time and beat. Use the toolbar area to do some functions. Use the icons to easily open up media and list areas. Use the bin to store your audio. Use the browser to look for your audio songs. Use the event list editor to edit your MIDI information. Use the inspector to view the channel strips of your track. Use the editors in the bo...
This video demonstrates the usefulness of the aluminum welding ice carving technique. The technique allows carvers to easily "Get Outside the Block" and create sculptures that are hardly limited by the dimensions of the ice block.
If you have a group of iPhone users to manage, whether for work assignments, planning a trip, or organizing an event, Reminders might just be your new best friend. With iOS 14, the app now lets you assign reminders to contacts, so everyone knows what they're supposed to be working on.
The iPhone's built-in Reminders app got an overhaul last year with iOS 13, giving us a more modern design and plenty of new features, and iOS 14 doesn't mess with a good thing. Instead, iOS 14 brings lots of small tweaks all over the app to smooth out the experience and make Reminders more powerful and more customizable than ever.
As of May 27, HBO Max is taking over your HBO Now or HBO Go account. If you have your devices set up to auto-install new app updates, you should pause it right now if your HBO app hasn't been updated yet. There's one thing you'll want to do before you make the leap. However, you're not out of luck if you already upgraded.
Apple Pay can be used at retail stores, restaurants, markets, and millions of other locations in the US and abroad. It's used to buy everything from clothing to groceries and vending machine snacks, so it's important to ensure that the cards in your Wallet are always up to date with the correct billing and shipping addresses.
Apple seeded the official version of iOS 13 to compatible iPhones on Sept. 19. Since then, we've seen two major updates — iOS 13.1, which, by our count, introduced 22 new features, and iOS 13.2, which also added 22 new features. Today, Dec. 10, Apple introduced the third major update: iOS 13.3.
All of your partially written, unsent emails live in your "Drafts" folders, in limbo until the day they are sent off or deleted. In Apple's Mail for iPhone, you can access all drafts from all accounts in a combined "All Drafts" folder from the app's main Mailboxes list — but only if you added it manually. But there's an even better way to access all of your drafts in Apple Mail in iOS; it's just not obvious.
Most of us have had a cloud-connected address book for years now. The result of this is an ever-growing contact list that will continue to get harder to navigate and manage. With the increased size of our contact lists, it becomes more important to sort contacts in a way that works best for us.
While the Reminders app has been largely ignored by Apple for years, iOS 13 finally makes it a force to be reckoned with. The app has been completely redesigned with easier navigation and more useful features that can compete with other task managers. After giving the new Reminders a shot, you may want to ditch that third-party to-do app you've been using.
Things are a bit more organized in Apple Reminders, so the cluttered mess that it once was is no more in iOS 13. The slapped-together feel in older iOS versions was the main reason I never used it that much, but the updated version for iPhone has finally got me hooked.
While iOS 13 might have made waves for some of its more prominent features — most notably system-wide Dark Mode — some of the more interesting tools lie with its smaller, unannounced updates. One of those updates is a new Reminders setting to tag contacts in a to-do task so that iOS pings you when texting that person in Messages.
One day after the official release of iOS 12.1.3, Apple released the first beta for iOS 12.2 to developers. The software appears to be the first in some time to be a major update. Apple's last beta cycles included 12.1.2 and 12.1.3, incremental updates to iOS 12.1. Now, we've entered a new version of iOS 12 entirely, hopeful for new features.
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.
Beginners learning brute-forcing attacks against WPA handshakes are often let down by the limitations of default wordlists like RockYou based on stolen passwords. The science of brute-forcing goes beyond using these default lists, allowing us to be more efficient by making customized wordlists. Using the Mentalist, we can generate millions of likely passwords based on details about the target.
Whether you've stumbled upon an interesting location you want to bookmark for later, need to remember where you park your bicycle or vehicle, or want to keep track of your favorite food truck locations, Apple Maps makes it easy.
The past year brought about a number of trends in the smartphone space. More immersive displays, better processors, and portrait mode for cameras come to mind as big steps forward. One of the most polarizing trends that continued in 2017 is the removal of the 3.5 mm headphone jack from flagship phones. The number of manufacturers that have completely dispensed with wired audio is staggering, so let's run down the full list!
Those of us that work with or around augmented and mixed reality have seen a powerful shift in the last year as the popularity and interest have grown in the field. With Microsoft's HoloLens release, the popularity of Pokémon GO, and the constant rumor mill known as Magic Leap, the terms augmented reality and mixed reality have started to become a part of the modern vernacular more and more each passing day.
The native dictionaries in iOS, which have been around since 2011, let you define words on your iPhone on the fly in Safari, News, Notes, and other apps. But if you read or write in more than just English, you won't be able to see accurate definitions unless you add those other languages to your list of dictionaries manually.
Reddit's overall design has stayed relatively unchanged for as long as I can remember. It's easy to use and is as popular as ever, so why mess with a good thing, right? Well, everyone's different, and if you're looking for ways to beef up your Reddit experience, try out the Chrome extension SHINE.
Welcome back, my fledgling hackers! In an earlier tutorial, I introduced you to probably the most popular scripting language for hackers, Python. To become a professional hacker, you need to have some scripting skills and Python is a good choice if you want to master just one. In this latest guide, I will expand your background in Python and offer you a tidbit of Python code to whet your appetite for all of the hacking to come.
You've undoubtedly used your email address to sign up for a chance to win something online or to purchase something on sale. Often, these offers are too enticing to pass up, and you reason that you'll live with the consequences of handing out your information for the chance at making out big.
Why can't I see who is stalking my Facebook profile?
I check my email every morning as part of my daily routine (usually while I'm brushing my teeth, if you really want to know). As a result, there have been many, many times where I've read an email on my phone or computer and forgotten to respond in a timely fashion.
Ever been halfway to work or school and suddenly remembered you forgot to log off your computer? A lot of people are constantly logged in to email and social media accounts, so if you have a mischievous roommate or sibling, this situation could be disastrous. That's where TweetMyPC comes in—it's a free Windows application that lets you send commands to your computer just by tweeting. Image by Twittermania
If you want to create a shortcut in Mac OS X, or if you want to change the default hotkey for a function on your Mac computer, check out this quick tip from Tekzilla. It will help you learn how to access the system preferences on your Mac and gain access to the full list of keyboard shortcuts, allowing you to remove, add, or change all the hotkeys on your Mac.
The Red Riding Hood movie by Catherine Hardwicke is a decidedly dark take on the story, which is pretty dark to begin with. This presents great opportunities for dark, sensual makeup both in the film and on your though, should you decide to watch this video and try out this dark, almost Victorian makeup take on Red Riding Hood.
High speed photos are very artistic and look awesome, but taking them without special equipment is nearly impossible. Without this hack and an Arduino, that is. This video will teach you how to use an Arduino and other electronic components to make a DIY high speed photo trigger and take more awesome shots.
The Mitsubishi Endeavor, like most vehicles, has it's own list of common problems. One of them is the back door locks not working. Watch this video for a guide to diagnosing your door opening problem and, hopefully, fixing it successfully.
The Eldar Harlequins are some of the most charismatic and seldom-played models in the Warhammer 40,000 universe, but did you know that you can make an entire powerful army out of them? You can. Watch this video to learn how to make an awesome 1750 point army list out of Eldar Harlequins.
If massive strength is not among your list of strengths as an MMA or jiu jitzu fighter, you need to learn ways to apply harder pressure from the half guard in order to pass better. Watch this video to learn some details that will help with this from MMA Girls Hillary Williams and Joanne.
You don't have to have a smartphone to use Google Voice, but there are certain advantages if you do, including having your Google contact list at your fingertips. In this clip, you'll learn how to install and run Google Voice on most any smartphone.
Look up "bombshell" in the dictionary, and you're sure to find Sophia Loren listed as example numero uno. The beautiful Italian actresses, who was and is the epitome of womanly curves and sultry bedroom eyes, made waves during her film career with her raw sexuality, beauty, and confidence.
