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 Excel tutorial from ExcelIsFun, the 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
Wireshark is the world's foremost network protocol analyzer, and is the de facto (and often de jure) standard across many industries and educational institutions. This video tutorial demonstrates how to get the Wireshark packet sniffer up and running to do a capture as well as how to run a traceroute command. To get started hacking with Wireshark, watch this how-to.
In this automotive repair video Chris gives you a few tips on your fuel filter and what to look out for when your VW bug gas tank may be dirty. If your fuel lines are dirty and your Volkswagen beetle bug isn't running as well as it should, it's time to change your fuel filter. Chris shows you how to keep your classic beetle running properly.
As phones' screens get closer to seven inches, now is the perfect time to take advantage of Android's split-screen mode. This feature has available since Android 7.0 Nougat and allows you to divide the screen into two halves, with a different app on each side.
Hacking web applications can sometimes be challenging due to the sheer amount of moving parts they possess. At the core of these apps are HTTP requests and parameters, but these things are often concealed from the user, due to security reasons, convenience, or both. However, a tool called Arjun can be used to discover hidden HTTP parameters in web apps.
There are many password-cracking tools out there, but one of the mainstays has always been John the Ripper. It's a powerful piece of software that can be configured and used in many different ways. Metasploit actually contains a little-known module version of JTR that can be used to quickly crack weak passwords, so let's explore it in an attempt to save precious time and effort.
Apple added "Announce Messages with Siri" with the release of iOS 13.2, and it came as a welcome surprise for me; I missed the feature from its initial run during iOS 13 beta testing. However, while users online gleefully showed off their newfound Announce Messages with Siri capabilities, I was frustrated to see that I didn't have the setting, even though I just updated my iPhone to 13.2. So, what's the fix?
Smartphone hardware surpassed the most popular portable game devices long ago in all but one category — control. Your iPhone is more than capable of running impressive, fully-realized games, but touch controls only go so far. That's why it's so exciting that Apple has added support for PS4 and Xbox controllers with iOS 13.
A rainbow table can be thought of like a dictionary, except instead of words and their definitions, it holds combinations of characters on one side and their hashed form on the other. What is a hash and why would you want to know what random combinations of characters are hashed into?
The ability to stay organized and be resourceful with data gathered from recon is one of the things that separates the true hackers from the script kiddies. Metasploit contains a built-in database that allows for efficient storage of information and the ability to utilize that information to better understand the target, which ultimately leads to more successful exploitation.
With each year that we anxiously await Apple's next big version of iOS, there comes the sad reality that the eldest iPhones will not continue to receive support. That's not the case with iOS 12, however, as the software is compatible with all iPhones currently running iOS 11, going back as far as the iPhone 5S.
Despite the abundance of sci-fi titles in the iOS App Store, very few of these mobile games ever have the staying power keep us glued for more than a few hours. Enter Space Pioneer, an awesome space exploration game that soft-launched in Canada ahead of a worldwide debut. With a little spoofing, you can experience the game yourself right now.
With Wrestlemania 34 right around the corner, WWE has partnered with GLU to soft-launch WWE Universe. While the game is currently only available in New Zealand, there's a simple loophole that you can exploit to download the game right now and play as your favorite WWE wrestler.
Just yesterday, Google announced that it is banning all apps that contain any form of lock screen ads. Today, they posted a list of the Best Apps of 2017 for the Play Store. Given the new policy of cracking down on apps with advertisements on the lock screen, you wouldn't expect to see one of those in the list of top apps. Unfortunately, that's exactly what happened — Google is promoting obvious adware in their list of best apps.
Networking is built largely on trust. Most devices do not verify that another device is what it identifies itself to be, so long as it functions as expected. In the case of a man-in-the-middle attack, we can abuse this trust by impersonating a wireless access point, allowing us to intercept and modify network data. This can be dangerous for private data, but also be fun for pranking your friends.
A new Windows Insider Preview, version 15055, was released on Friday, March 10. Along with the normal collection of bug fixes and new features came a secret addition to the Mixed Reality Portal in the update. Windows Mixed Reality, along with Cortana, can now teach you how to use the platform, and, hopefully, usher in with it some understanding of what mixed reality is.
People like to cite the iPhone as the device that started the smartphone craze, but the truth is, smartphones had existed for years by the time Apple got into the game. The real groundbreaking feature that this device brought to the table was a multi-touch screen to go along with its "smart" functionality, and this is still the main method we use to interact with our devices today.
Many of Google's stock Android apps are some of the best options out there—especially now that they've all been made over with Material Design. But generally, as these are pre-installed system apps, they cannot be used on non-Nexus devices.
While some of the additions to the emoji keyboard in iOS 8.3 have been criticized for actually doing the opposite of their intended purpose, they've been well received overall. But the biggest winner of the new emojis was one that actually wasn't even released—the "Vulcan salute" emoji.
The Apple Watch may be a much simpler device than your iPhone, but that doesn't mean it's free of bugs, glitches, and crashes just like your other devices. A common problem that you'll run into is a frozen screen due to a malfunctioning app. While this can be frustrating, the solution can be as simple as a quick reboot.
Getting a good night's sleep is critical to maintain good health, a better mood, and clear your mind for whatever the day has planned for you. But in practice, whether you're tired or not, the world has a way of preventing it, either through your partner's snoring, your neighbor's music, or the road construction going on right by your bedroom window. It can get rough.
We live in a time where privacy is rare and our files can be easily accessed by just about anyone. Having your phone protected by a passcode is great, but if someone figures it out, they can easily access anything on your phone.
Coffee is a topic that everyone has a strong opinion about, especially when it comes to brewing the perfect cup. Even if you buy the best beans and grind them yourself, chances are you're skipping one necessary step to make sure your coffee tastes the best it can: cleaning your coffeemaker the right way.
When I first started cooking, there were a few steps I always skipped in recipes. I never added zest to anything because it seemed like too much trouble, I rarely separated wet and dry ingredients in baking recipes because I was lazy, and I never let meat rest after it was done.
Rock-hard ice cream is the bane of my culinary existence. If I try and scoop it out with a spoon, the spoon invariably bends. If I use a traditional ice cream scooper, I end up with a torqued wrist and one or two pathetic curls of ice cream for my efforts.
In the wake of the NSA controversy and its subsequent fallout, many dashed towards finding means of secure communication—using private internet browsing and encrypted text messaging applications—out of fear of being spied on.
Managing multiple applications on an iPhone is as simple as double-tapping the home button, long pressing the app you want to close, and tapping on the minus sign in the red circle. If you're using Mac OS X, the dock at the bottom of the home screen plays the role of the multitasking bar on the iPhone, just not as sleek or simple.
Anyone who does a lot of photography knows that the right exposure can make all the difference in the world. Taking a picture of something in motion requires a long exposure, so if you've ever wondered why your fireworks photos never quite turn out right, your shutter speed could be the key. Photographer David Johnson decided to put a twist on the classic long-exposure fireworks photo. Normally, when people take photos of fireworks displays, they just set a long exposure for somewhere over 3 ...
If you want to run multiple windows operating systems at the same time you first need a Windows computer, the installation disk for the operating system you want to run, and Windows Virtual PC 2007. To install this, first type in Virtual PC 2007 to Google, go to the Microsoft link and download and install the program. Now, open the Virtual PC and click next on the wizard. Name your hard disk and click next until you choose where you want this at. Now your virtual hard drive is created. Now, p...
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to install the latest Wine on Ubuntu Linux.
Running on a track might be a little repetitive, but it’s also easy, even and a simple way to measure your pace.
Nurturing a long-distance romance takes patience, understanding. A working knowledge of the latest technology is also pretty helpful. Watch this video dating tutorial and learn how to maintain a long-distance relationship. Maintain your long-distance relationship.
The Windows 8 Developer Preview is out, and judging by the system requirements, Windows 8 can run on a whole range of devices. Try running Windows 8 on your netbook with this tutorial. Pick a Windows 8 version below and watch this guide for instructions on how to install it!
Sexpot and sexy mama Adriana Lima would probably look good without makeup, hitting up 7-11 for a slurpee run (well, in her case more likely a oolong tea run), but she looks downright gorgeous when she gets in full Victoria's Secret Angel garb.
Ever wish you could watch your favorite Hulu shows on your TV using your Roku media player? Before November 17th, 2010, you were out of luck — now, in most cases, it's as easy as running a software update! This clip will show you what to do you get Hulu Plus up and running on your own television using your Roku set-top box.
Pro Tools can be resource-heavy when it comes to running on your computer. This tutorial walks you through all the necessary steps so you can configure Windows 7 in just the right way to maximize the performance of Pro Tools on your computer.
Don't let Bejeweled Blitz get the best of you. Show it who's boss and get the highest score possible. Of course, you'll need Cheat Engine to overpower the game, so make sure you have Cheat Engine 5.5 or higher and check out this video for the hacking Bejeweled Blitz (10/09/10).
Here's a quick tip for Android phone users! You can use the App Launcher (the icon is at the bottom of your phone, near the center) to open up your app screen, listing all your apps. From there, run all your favorite Android apps!
Hack your remote control so you only need one battery to run it! All you need is one paper clip to let you complete the circuit between the battery and the hardware on your remote control. It'll run at a lower voltage, so you'll have to be closer to the TV, but it will still work!
Want to install SensMe on a Sony PlayStation Portable running custom firmware like 5.00 M33, 5.50 GEN and 5.50 Prometheus? It's easy! So easy, in fact, that this hacker's how-to can present a complete overview of the process in just over four minutes. For more information, including detailed, step-by-step instructions, watch this video guide.
