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.
Apple just upgraded its Reminders app for iPhone, and there are some powerful new tools and improvements for task management that'll make you wonder how you ever lived without them.
More information is available to us now than ever before. We simply cannot make sense of so much data on our own. Thankfully, we have programs to do the heavy lifting for us.
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.
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.
With the growing list of products Apple offers, the number of devices connected to your Apple ID can get quite extensive. Having all those devices connected to your Apple ID helps you keep track of them, but when it comes time to part ways with an Apple TV or Apple Watch, those devices can still be attached to your Apple ID. In some cases, this could affect the overall security of your account.
Despite being at the helms of the RCS push, Google Fi has yet to support the new messaging protocol. It would've made too much sense if the Google-created MVNO was one of the first to support the feature Google's been pushing on other OEMs and carriers for years, but alas, they haven't. Well, better late than never — Google has finally announced support for RCS Universal Profile on Fi.
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.
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.
While attempting to hack a web app, there may come a point where the attacker may have to escape the default directory in order to access unauthorized files. This is known as a directory traversal attack. Much as the name implies, this attack involved traversing the servers directories. But in order to move to an unauthorized directory, we need to know where those directories are. Today we'll be building a tool to brute force these directory locations based on HTTP response codes. Before we g...
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.
The big fireworks day is almost here, but most of you are limited in what you can do when it comes to celebrating the Fourth of July with a bang. Unless you live in a dry area prone to wildfires, one type of fireworks you can probably still legally buy are sparklers.
A deck of cards may be a magician's best way to demonstrate his or her's sleight of hand, but for the prankster, it's the perfect way to deliver a shocking 300 volts of electricity! And that's exactly what I'm going to show you how to do today. Stuart Edge used it in his "Electric Shock Kissing Prank" to show the ladies how a man can really put the sparks in a kiss.
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.
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.
Learn how to add someone to your contact list in Messenger on your BlackBerry. This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.
Learn how to add a new contact to the contact list in BlackBerry phone. This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.
Want to build your own infrared motion detector? It's easier than you think! So easy, in fact, that this video tutorial from MAKE can present a complete overview of the build in under five minutes! For more information, including a full list of materials and detailed, step-by-step instructions, and to get started building your own passive infrared motion alarm, take a look.
Sometimes there is more than one option for a particular finger Swype. When this happens, Swype will give you a list to choose from so that you can pick whichever word you were hoping to use. Swype is the fastest way to send texts and e-mails available and with a bit of practice you will have it mastered. Just think of Swype as the T9 of 2010 and you will catch on fast.
Want to make kalua pig for your next backyard luau without going whole hog, so to speak? Never you fear. This free video cooking lesson demonstrates an easy-to-follow Hawaiian-style pulled pork recipe. No imu required. For detailed, step-by-step instructions and a full list of ingredients, watch this tropical culinary tutorial.
In this video richpin explains to us how to remove the inside rear passenger-side door panel on a Nissan Altima. He doesn't explain why you would want to do this, but if you feel compelled to, herein you will find the most detailed instructions you could ask for. Here is a list of the readily available tools that he uses:
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 230th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel List Table feature to make a dynamic stock price line chart.
Buttermilk is a great thing to have around in your kitchen. Unfortunately, most of us don't have buttermilk on our regular grocery list, so those buttermilk pancakes will have to wait for another day. Think again! You can easily make tasty buttermilk alternatives with common refridgerator items. This video will show three easy ways to make a buttermilk substitute.
This square video teaches the following square dance calls on the mainstream list: Promenade Full 3/4, Grand Square, Half Sashay, Roll Away with a Half Sashay, Ladies In, Men Sashay
