This video is an Excel magic trick which shows how to select cells in Excel through keyboard shortcuts. He starts by the basics where he shows how to select a range of cells in excel work book. He shows how to jump to the top and bottom of the selection area. He even shows how to use shift key to select the whole range. Finally he shows how to hold control, shift and click to select the whole ranges. He even shows how to select ranges top to bottom and from left to right. This video shows how...
Multiplying positive and negative numbers may seem confusing. However, in this math tutorial, multiplying numbers with different or same signs is made easy and eliminates all confusion. The narrator of the video explains the key rules to remember when dealing with the possible combination of positive and negative numbers. The video breaks it down to two key rules. When you have a negative and a positive number; the result will always be negative. When you are given two numbers that have the s...
This video is about how to root a Droid smart phone.
For quarterbacks who want a competitive advantage over their opponents, Dub Maddox shows, how to throw a football using playaction. Maddox reiterates throughout the tutorial the importance of set, show, snap, and sell when learning the handoff of the football. With a step-by-step live-action tutorial and real game examples, Maddox shows ,how the four key steps are used in games. Those four key terms provide the foundation of mechanics that a quarterback must exercise on every run play if he o...
One thing that can really set a amateur from a pro when it comes to poker is the ability to read your opponent. Picking up on "tells" from your opponent can be the key from folding your hand or making that extra bet to take the pot. One of the main keys they factor on is that you need to take into affect the possible strength of your opponents hand and your position on that opponent. Good players do not win on a consistent basis just from getting good hands. While it takes much practice if yo...
Want tour-like spin on your swing? There are several keys to imparting tour-like spin on your wedge shots, including proper set up, a correct angle of attack, and quality contact. Tim Mahoney, Director of Education for Troon Golf, explains these keys and how you can make them part of your game.
Whether you're on a job interview or a first date, follow these simple steps to give the impression that you're quite intelligent – even if you're quite average.
Think about how many times a day you touch your keyboard... ready to clean it yet? Check out this Howcast video tutorial on how to clean a computer keyboard.
How do you draw people doing the things you want them to do? Watch this instructional drawing video to draw people in dramatic poses. First, become clear on your intent. Draw a person in perspective by giving them a set action within a set space.
Watch this instructional drawing video to draw people within a landscape. Remember, objects that are up close appear larger and more defined than they do from a distance. When you draw people in a landscape, you should treat them the same as any other form in the landscape. Imagine that a close up view of a person is actually a landscape drawing.
Because of its portability, the acoustic guitar can be wonderful songwriting device. However, having a pocket symphony in your head–or pocket, as it were–does you little good if your hands aren't on board. Fortunately, YouTube user Sawlon is here to help you train your head and hands with his series of free video guitar lessons. In this installment, you'll learn how to use chord substituions in they key of G major on acoustic guitar. Remember, the more you practice and the more theory you kno...
Because of its portability, the acoustic guitar can be wonderful songwriting device. However, having a pocket symphony in your head–or pocket, as it were–does you little good if your hands aren't on board. Fortunately, YouTube user Sawlon is here to help you train your head and hands with his series of free video guitar lessons. In this installment, you'll learn how to play use chord substitutions in the key of E major on guitar. Remember, the more you practice and the more theory you know, t...
Autofold is part of the move tool and allows you to automatically create folding edges for new geometry. Take a look at this instructional video and learn how to use the move tool to autofold in Google SketchUp. The autofold can be activated by pressing the Alt key on the PC or the Apple key on a Mac. Autofold let's you move a point, edge or surface in any direction automatically creating fold edges as needed to do so.
In this keyboard tutorial, you'll learn how to play John Legend's "Ordinary People" on the piano. While this tutorial is best suited for intermediate or advanced piano players, players of all skill levels can play along. Watch this tutorial to get started playing "Ordinary People"!
This cinematography tutorial video provides the basics of working with a photographic light meter as well as how to read the meter. A light and flash meter is nothing expensive. All you need is something that will measure the light and your flash. Most light meters are relatively the same. Metering is a relatively simple process. Just key in the ISO, key in the shuttle speed, push the button, and it gives you the f-stop to use on your professional photo camera.
Do you need some extra cash? Is your clutter piling up on you? The perfect summer solution is a how-to on throwing and attending a yard sale. This week we show you how to prep and carry-out a successful yard sale, and show you how to spot a score. A few key points will help you spot the key piece for your wardrobe or next DIY project, whether it involves a yard sale or garage sale or what.
A journey to Africa requires a certain amount of open-mindedness and flexibility to interact with people of a culture vastly different from anything in the West. This video travel-tutorial offers advice for how to relate and get along with the local hosts during a trip to Africa, what to expect, and how to behave when encountering people from a different area of the world.
Drawing an anatomically correct human figure isn't difficult when broken down step by step. Learn how to slow sketch people by building the frame from simple boxes to a refined and finished human body. Follow along with this video tutorial and start drawing people in no time!
This video gives a ten minute tutorial on how to achieve the superimposition effect for web videos with a little props and software.
While some in the augmented reality space are tweeting about future amazing immersive experiences and others are showing off cool experiments, Microsoft continues to move forward with tangible business solutions right now that show how the HoloLens can improve business.
Many guides on Null Byte require using the Secure Shell (SSH) to connect to a remote server. Unfortunately for beginners, learning to use SSH can become a confusing mix of third-party programs and native OS support. For Chrome OS users, using SSH is even more difficult. We'll fix this by using the Chrome Secure Shell to establish an SSH connection from any device that can run a Chrome browser.
During a penetration test, one of the most important aspects of engaging a target is information gathering. The more information you have coming into an attack, the more likely the attack is to succeed. In this article, I'll be looking at SpiderFoot, a modular cross-platform OSINT (open-source intelligence) gathering tool.
Another day brings another Apple ARKit demo, this time for a first-person role playing game that inserts villagers, vendors, and villains into real world locations.
A few years ago, the Hilton hotel group unrolled the Digital Key, a feature of the Hilton Honors app that allows you to unlock your hotel room with your smartphone.
Augmented reality could come in very handy for those of us prone to losing things—namely, our wallets. Pixie Technology, a company from Los Altos, California, has developed a way to locate your lost wallet and keys using AR technology and tracking chips, a platform they call the "Location of Things."
Hello again, readers! In our previous crypter tutorial, we looked at how we could obfuscate our malware (or any program) by using a simple one-byte XOR key. In this quick tutorial, we will be looking at how a simple little tweak can create a better means of obfuscation. Let's get right into it!
Welcome back! In the last iteration of how to train your python, we talked about functions, and we even made our own! We're going to move on to more types of data arrays (much like lists) in today's discussion.
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.
The buttons on most Android devices are laid out (from left to right) in a Back, Home, Recent Apps format. Samsung is the lone exception to this rule, which flip-flops them, so this can make for an inconsistent experience if you own multiple Android devices.
Most people's fascination with social media these days is the instant gratification that can come with it. Whether you post an image on Facebook, Instagram, Snapchat, or Twitter, a minute or two later your phone will receive a notification informing you of a buddy or two who liked it.
By eliminating the need for hard keys on phones, manufacturers are able to use that extra space for a larger display, which is clearly evident on the bezel-minimal LG G3. In order to replace the physical home, back, and app switcher keys, we now have stylish soft keys.
A couple months ago, I attended a Pokémon-themed party. Everyone dressed as their favorite Pokémon or trainer, Poké balls flew around the backyard, and more importantly, there was a lot of Poké booze. My friend who created the colorful drinks you see below informed me that they were infused with Skittles. This, my humble readers, was a defining moment in my life.
Sometimes you need more than just your brain to split the bill at a restaurant or to calculate how much your cable company is ripping you off.
It used to be that you only had to worry about maids rummaging through your belongings in your locked hotel room. But now anyone with 50 bucks of hardware and some programming skills can hack their way in—as long as it's locked by keycard.
With how quickly technology evolves in this day and age, it's only natural that people replace their computers every couple years—even sooner. It seems that right when you get a new desktop, there's always a faster model with more features released the following week.
If you're new to Google+ and want to know how photos that are uploaded by Google+ users can be browsed or viewed, take a look at this tutorial. You can use the arrow keys to navigate the Google+ photo galleries, or simply click on the photos at the bottom of the lightbox.
What better way to enjoy the beauty of the blocky world of Minecraft than by flying across the land? If you want to fly in the new release of Minecraft 1.8, take a look at this tutorial on how to download and install the Fly Mod, a part of Zombe's mod pack, with the help of MC Patcher HD. The guide will also inform you on how to bind keys to the different flying controls.
Marvel vs. Capcom 3 is a frenetic modern fighting game, and learning how the combo system works and being able to apply that knowledge on the fly is the key to arcade success in the game. This video will teach you how the combo mechanics in MvC3 work and how you can use them to come up with new combos on the fly and beat any character, as any character, any time.
The Recon character class in Battlefield Bad Company 2: Vietnam is a thinly veiled sniper, and utilizing their target-spotting functionality is key to effective sniping in this game. This video is a complete guide to effective Recon play, teaching you about all your abilities, guns, and how you can spot targets to make yourself much more effective from much further away.
The concept of video game etiquette is foreign to many people, including a disgraceful number of frequent gamers. The combination of anonymity and role-playing in online games can lead people to be dicks in all sorts of obnoxious ways, making a fun activity distinctly less fun for everyone. Watch this video to learn about proper online gaming etiquette in the context of Call of Duty Black Ops. These lessons extend to most games, however, and practicing them will results in people liking to pl...
