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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.
This video tutorial is in the Sports category which will show you how to properly throw a football. First ensure the football is the correct size for the thrower's hand. You can't throw without a proper grip. To get a proper grip the middle finger should be on and parallel to the white stripe on the football. The 4th and 5th fingers should be on the laces. The index finger must be separated from the middle finger and be parallel to the seam. While throwing, the thumb should be pointing downwa...
In this video, we learn how to find music and movies easier using "insite" in Google. If you are looking for media and can't find it through iTunes or an official site, you can find it on Google. First, go to Google, then type in "intitle:"index.of"(mpg(avi)wmv) (word you're searching for) -html -htm -php -jsp -asp". After you search this, you will see "index of" pages where you can do searched of what you are looking for. Once you click on the links that are available, you will be able to do...
In this tutorial, we learn how to play a ghost catcher. First, you want to place your index finger on the top of the end of the ghost catcher, then use your other fingers to help hold it. Now, place your mouth on the other end of the instrument. You will pick the strings with your right hand and put the ghost catcher in the left corner of your mouth. Start strumming with your index finger, while still holding it with your other hand. Push your thumb the opposite way, going down instead of up....
In this tutorial, we learn how to upload HTML files without a FTP client. First, go to your HTML files and name the home page "index". Next, go to Zymic and sign up with the website. Next, go to your account management, then click "create new web host account". You will now enter in your website, then login. Now, you will click on file manager and click "upload files". Browse to find your index page and anything else you want to upload. When finished, copy your URL, then test it out to see if...
In this video tutorial, viewers learn how to curve a bowling ball. When holding the ball, users will only be using 2 fingers: the middle and index finger. Place the middle finger in the left hole and index finger in the right hole. Make sure that the bowling ball is not too heavy. Do not use your thumb to hold the third hole. When you let go of the ball, spin the ball really hard with just one finger. This video will benefit those viewers who enjoy bowling, and would like to learn how to curv...
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
In this how-to video, you will learn how to throw a frisbee in a comedic fashion. Many frisbees come in different weights, although this should not matter too much as these frisbees are usually made of light weight plastics. First, hold the disc and set them completely under the frisbee with the thumb at the side. Use your index and point it. Now, place the index finger so it is on the rim. Now, hold the frisbee in a chicken wing fashion. Once this is done, toss it to wherever you want to. Yo...
In this how to video, you will learn how to hold a guitar pick. This is useful if you want to successfully rock out. A pick is a triangular piece of plastic. First, lay the back of the pick into the crease of your index finger. Next, lay your thumb perpendicularly across the back of the pick. If you look at it from this angle, the flat of the thumb is on one side while the side of the index is on the other. When playing, you will have a little bit of pick past the finger as you slide along th...
This video shows us the method to do a 360 flip on a tech deck fingerboard. In a 360 flip the board rotates and exactly flips once before landing. Put your middle finger slightly of the side at the tip of the tail of the tech deck. Put your index finger between the tech deck logo and the front bolts in the normal position. Practice 360 flip on the side of your leg on to the top of it. You should apply pressure on your middle finger. As the board reaches 90 degrees point of spin, extend the in...
In this video, bawstansawkscawk99 demonstrates how to throw a slider, as well as the differences between sliders and curveballs. To throw a slider pitch, grip the baseball with your index and middle fingers on top of the baseball in between the two seams and your thumb directly underneath them (on the other side of the baseball and on the middle of the seam.) Throw the ball without flicking your wrist, letting it roll off your index and middle fingers. The ball should dive down and away from ...
The video demonstrated clearly about how to draw and sketch the hand of a girl in an easy way. First the illustrator drew a rectangular circle in the plain window. Then he drew another rectangular shape close to the first and divided the second shape into two halves so that it will look like fingers.
Laura Bateman, of Extreme Fitness Now, demonstrates how to wrap your hands for boxing. Wrapping is important for protecting your wrists and knuckles from injury. Mexican hand wraps are longer than the typical hand wraps. Place the looped end of the wrap over your thumb. Be sure to position the wrap the right side down. Next, wrap it around your wrist three times. Feed the wrap under your thumb, under the palm and up to the knuckle of the index finger. Wrap the knuckle two times. Cross down to...
This video shows us how to open a glass bottle with your lighter. To open a bottle using a lighter: Hold around the top of the bottle using your left hand. The key is that the index finger must be around the top of the bottle. Hold the lighter with your right hand and place the blunt end of the lighter solidly between your lowest knuckle and the edge of the bottle cap. Hold the lighter perpendicular to the bottle. Tuck the lighter so that the edge is under the teeth of the bottle cap. Squeeze...
Check out this magic trick tutorial video to learn how to perform a basic coin roll. This is a crash course explanation on the coin roll, also known as the knuckle roll. The tutorial is quick so you may have to PAUSE IT to read some things in the video. Just follow these simple instructions: Start with the coin on your thumb. then grip the coin between your thumb and index finger. Then release your grip so it rests on your index finger. Use your middle finger to grab the edge of the coin so i...
Palm reading can be complicated because chirognomy, the study of the mounts of the hand, sometimes contradicts chiromancy, the study of the lines of the hand. For that reason, it's best to do a reading as a whole. In this particular video palmistry tutorial, Peter John explains the significance of the Jupiter and Saturn fingers, or the index and middle, highlighting the areas on a detailed map of the hand. Watch this instructional palm-reading video and learn how to interpret the meaning behi...
The beginning of the video lays out a couple quick lessons on hand and finger placement for playing string notes on the ukulele. The first hand placement and is for string C: using your ring finger place it on the bottom string. The right hand will strum the strings in a down, down, up, up, down motion through the rest of the lesson for each cord. Use the middle finger to hold down the next cord A minor on 2nd fret. Strum. Next keeping your finger on first string place your index finger on th...
Make sure you use FLASH Player 9 First: Deinstall Flash Player 10
One of the first steps in reconnaissance is determining the open ports on a system. Nmap is widely considered the undisputed king of port scanning, but certain situations call for different tools. Metasploit makes it easy to conduct port scanning from directly inside the framework, and we'll show you three types of port scans: TCP, SYN, and XMAS.
Scanners are much too cumbersome to fit in a pocket, but with the use of just one application, you can replace all that bulky hardware with your Android smartphone and take it with you wherever you go. All you need to do is find the scanning app that fulfills your needs. Here are our five favorites that are good for business pros and average joes alike.
Welcome back, my fledgling hackers! One of the first issues any hacker has to address is reconnaissance. Before we even begin to hack, we need to know quite a bit about the target systems. We should know their IP address, what ports are open, what services are running, and what operating system the target is using. Only after gathering this information can we begin to plan our attack. Most hackers spend far more time doing reconnaissance than exploiting.
This video tells us the method to remove Trojan Virus from the computer. This can be done in a couple of steps. The first step involves the downloading of a specific application from the web. We have to search this application in Google. Type 'malwarebytes' in the search engine and press enter. Go to the third result starting with 'Malwarebytes Anti-Malware'. Click on 'Download Now' on the resulting page. Open the application and select 'Perform quick scan'. This will scan the computer for Tr...
Scanning is an awesome, fast way to transport a document into your computer. But, what if you want to edit it once you've scanned it? Most scanner programs will import your document as a read-only PDF or image file. With this tutorial, learn how to use the program ClaroRead on a Mac to scan your document directly into Microsoft Word for editing. This will save you a lot of time and a lot of annoying formatting and copy and pastes!
This is a Computers & Programming video tutorial where you will learn how to remove annoying spyware on your PC in Windows XP. Some spyware can be really nasty. This video shows how to remove spyware for free. Go to Download.com, and search for ‘ad aware’, download and install it. This video recommends Ad-Aware. While installing, select safe mode of scanning, otherwise some spyware may not be detected. Then, you need to update the definitions. Keep the definitions updated regularly. After upd...
Buying a digital camera doesn't mean your old prints, slides, or negatives are obsolete. You can easily convert them with a scanner to bring them into the 21st century. Watch this video to learn how to convert photos to digital.
Don't cancel your virus scans because they're inconvenient. Reschedule them! Watch this software video tutorial to learn how to schedule and reschedule AVG anti-virus scans so you can complete them whenever you want to. This how-to video is geared toward new AVG users.
Today is election day, or maybe not, but you're going to have to learn how to vote sooner or later anyway.
As part of the iOS 11 update, Apple added a document scanner function that creates high-quality digital copies of physical documents, but it was only available inside the Notes app. With iOS 13, Apple has built its scanner right into the Files app, enabling you to quickly create PDFs with your iPhone and do more with them.
Before attacking any website, a hacker or penetration tester will first compile a list of target surfaces. After they've used some good recon and found the right places to point their scope at, they'll use a web server scanning tool such as Nikto for hunting down vulnerabilities that could be potential attack vectors.
The Galaxy S9 is full of minor improvements and revisions that come together to make it a worthy upgrade over the Galaxy S8. One such improvement is facial recognition, which Samsung has fortified with machine learning and the inclusion of another sensor. The result of these efforts is called Intelligent Scan.
There are plenty of third-party apps for scanning documents on your iPhone, but they can all be tossed out the door since iOS 11 includes one by default now. Instead of a dedicated app, it's included as part of the Notes app, and it's fairly easy to use. After scanning, you can save it, print it, turn it into a PDF, add markup, and more.
When it comes to antivirus software, you don't want some fly-by-night developer having access to the sensitive data that these apps can scan. Luckily, most of the longest-tenured antivirus companies from the realm of desktop computers offer complete security suites for Android these days.
In this tutorial, we learn how to scan and edit negatives with SilverFast and Photoshop. First, open up the software and lay your negative in the scanner. Make sure you have selected the correct settings when you go to scan it, and click that it's transparent. Also, you will need to increase the size of it and make sure the lighting is correct. Now, scan the image and load it onto the software. Once it's loaded, you will be able edit it by zooming in and then rotating the image so it's the co...
In this Beauty & Style video tutorial you will learn how to braid a fishtail braid. Dampen your hair and apply some styling putty to help the hair stick together. To start, cut a 'V' from the crown of your head, split the strand in to two and cross them over once. The strand on the right side is at the bottom. Put this strand on top of the right index finger and then place the other strand below the finger. Now grab another strand of hair from your hairline with the left hand and put it on to...
With technology nowaday, it has become so much easier to scan documents. In the past, people would always take their work to places like Kinkos and pay others to do something that would be simple and easy to do at home. But since the release of multi-functional printers that not only print, they scan, fax, and can even download pictures directly to your computer. This tutorial will show you how to scan a document and send it to your Word program. Enjoy!
ARHSphysics shows viewers how they can build a simple barometer using household items! First, you need to get a container that is the height of an index card. Your best bet is to get an empty soup can of food can. Make sure you wash the can. Now, you will need a latex glove, cut a semi circle from the glove and attach this to the top of the can using a rubber band. Get two straws and attach them together at the ends. Cut a slit in each one and attach the straws. Attach the straw to the top of...
SOLOMATION Cy Porter, the owner of the mentioned website demonstrates how to draw a hand from the thumb perspective. He says that this tutorial is to bring out the thumb's measurement and relation to the rest of the hand. First he draws the palm and the wrist, giving as a square shape to the palm. The he draws the first joint of the thumb saying that the center point of the line joining the knuckles and the wrist and the center point of the thumb's first joint forms an arc. Then he draws the ...
Are your sinuses killing you? There are ways to relieve this pain by applying pressue. Learn to apply pressure to points of the body with your thumbs or fingers to relieve sinus pain.
Charades is a word-guessing game that's acted out in pantomime by players at parties or other gatherings.
Learn how to cure a headache with acupressure. Instead of reaching for a pain pill, massage away a headache using acupressure, the traditional Chinese curative technique of applying pressure to certain points of the body.
