Indexes Scanned Search Results

Spotify 101: How to Easily Share Music to Friends from Android & iPhone

If you're anything like me, when you first find a good song, album, or playlist on Spotify, your initial reaction may be to share it with your family and friends. While there are the usual share methods available in Spotify that are available in other streaming music services such as Apple Music and Google Play Music, Spotify goes one step further with QR-like codes users can easily scan.

Hack Like a Pro: Digital Forensics for the Aspiring Hacker, Part 10 (Identifying Signatures of a Port Scan & DoS Attack)

Welcome back, my budding hackers! As I have mentioned many times throughout this series, knowing a bit of digital forensics might keep you out of a lot of trouble. In addition, digital forensics is a burgeoning and high paying career. Some knowledge and certifications in this field will likely help you land a Security Engineer position or put you on the Incident Response Team at your employer.

How To: See Who's Clogging Up Your Wi-Fi Network with These Free Mobile Apps

Android has released a new application called ezNetScan, which is a free app that scans the wireless network you're connected to and gives you a full log of all of the devices connected to that network. This isn't new for smartphone users, let alone Android users. Fing has been around for a while and does practically the same thing that exNetScan does. It gathers information such as the IP and MAC addresses, device vendors, and ISP location. But while Fing is a great program, it does lack a f...

How To: Get free, non-intrusive virus protection with Avira

In this tutorial, we learn how to get free virus protection with Avira. To do this, first go to Free AV, and download the software. After you install everything, open the program up. Next, you will want to scan your computer for any viruses that may be present already. It may take a while to scan your entire computer, but it will search all of your different files. If something comes up, you can choose how to deal with it and get rid of the virus if you wish. This is also great for any emails...

How To: Copy DVDs to a Mac computer with Handbrake

This video shows you how to copy a DVD to a Mac using a free application called Handbrake. Open the Handbrake window, select the DVD you want to copy from where it's listed on the side, and click open to start scanning. After the scanning is done, a window will come up where you can choose which file on the DVD you want to copy. If you're copying a movie, it's usually the largest file. Choose what type of file you want to convert it to, and it will start copying. If the DVD is encrypted, you ...

How To: Find and install Windows PC drivers quickly & easily

This video shows us the method to find and install Windows PC drivers. Install the software from www.DirectDriverChecker.com. Click on 'Start Scan' to list the drivers you have and which ones need an update. Choose 'All Drivers' to see all drivers and 'Outdated Drivers' to see the outdated ones. Check the drivers and click 'Next' to update them. Use the 'Back Up' option to back up the drivers in case of a malfunction in the computer. Use the 'Restore' feature to restore the saved drivers whic...

How To: Hack Cube Crash using Cheat Engine (07/01/09)

In this video tutorial, viewers will learn how to hack the flash game Cube Crash using Cheat Engine. Begin by opening Cube Crash. Then open Cheat Engine. Start the game and earn some points. Multiply the points by 8 and add it to the value box in Cheat Engine. Click First Scan. Repeat this step again and click Next Scan. This time, there should only be one address. Double click it and change the value to any desired number. Now when you play, you will receive that amount every time you score ...

How To: Delete corrupt files on USB pen drives

A quick tutorial on how to effectively removed corrupted files from your USB pen drive Insert USB drive into computer. Click on "My computer". Right click on your USB drive (e.g., Removable Disk Drive E: )Go to "Properties" and select "Tools". Under "Error Checking" select "Check now". On the "Check Disk Options" menu select "Automatically fix file systems errors and scan". Click start. Once completed the corrupted files should be removed. It is advisable to also get virus software to scan yo...

How To: Warm up your thumb and index finger when playing the ukulele

In this clip, you'll learn how to warm up your thumb and pointer fingers with a simple scale-based picking exercise for the uke. If you want to get really good at playing the ukulele, it stands to reason that you'll need to practice. Happily, the Internet is awash in high-quality video lessons like this one from the folks at Ukulele Underground. For more information, including a step-by-step overview, watch this free video ukulele tutorial.

How To: Create a defined name for a dynamic range in MS Excel

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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

How To: Sum values after a deadline in Microsoft Excel 2010

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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

How To: Extract the rows in a data set to 1 column in MS Excel

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 650th installment in their series of digital spreadsheet magic tricks, you'll learn see how to take all records from a data set and place them into one column using the INDEX, INT, ROWS and MOD functions.

How To: Return only even row data in an MS Excel spreadsheet

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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.

How To: Return multiple items by array formula in MS Excel

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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).

How To: Run lookup queries with two values in Microsoft Excel

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 606th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that can look up two 2 lookup values using the INDEX & MATCH functions and concatenated (joined) columns for the lookup value and lookup table.

How To: Create a basic array table in Java programming

Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to display the index of an array in table format when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.

How To: Extract the word that occurs most frequently in Excel

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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...

How To: Make an Excel formula for a decimal stem & leaf chart

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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT functions.

How To: Extract only numbers from a text string array forumla

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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM functions.

How To: Play "This Little Light of Mine" on the ukulele

To play 'This Little Light of Mine' on the ukulele you first will need to start with the chord G progression. Start playing this at the lyric Light and then switch to the chord G7 on the verse shine. On the next line, play the chord C at the verse light and then on the word shine play the chord G. Now, while singing the same lyrics now play the G chord at light and switch to Em at the word shine. Now on the ending verse at, 'Shine, Shine, Shine' play the chords G, D7 and C-G! You can take a G...

How To: Make a popper out of a sheet of paper

This video shows how to make a paper "popper" that you can use to make a loud popping noise. Start with piece of paper. first fold it in half the skinny way, then fold it in half again the other way. Set the paper down on a table or flat surface so that the flaps of the paper make an "M" shape. Now take the paper in your hands and grab the outer sheets of the "M" with the index finger and thumb of your right hand. Pull the inner sheets out with your other hand. Take the popper in your right h...

How To: Throw a cast net whlie sitting, from a kayak

In this how-to video, you will learn how to throw a cast net while sitting down. Take your index finger, middle finger, ring finger, and pinky in order to throw. This counts for about a third of the lid. Take the other end with your weaker hand. Once this is done, you just simply toss it. If you are sitting down, grab the net by the horn and half of two thirds of the way down. Make sure that a lot of net is hanging down, as it will make throwing harder and it may catch on the kayak. Viewing t...

How To: Extract data to a new Excel workbook by array formula

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 308th installment in their series of digital spreadsheet video tutorials, you'll learn how to extract data to a new workbook by array formula. Functions used include IF, ROWS, INDEX, TEXT, ROW and SUMPRODUCT.

How To: Use the BINOMDIST & NORMSDIST functions in Excel

New to 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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...

How To: Extract part of a table from a larger table in Excel

New to 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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Tie a perfection loop knot

This is a video demonstrating how to tie a perfection loop. This is a loop that is necessary for fishing. It can be using for sinkers and fly fishing. It is good for any purpose where a loop is needed. A loop is made first. The loop is held between the left thumb and index finger. The end of the line is taken and put over the loop. Then switch hands and take the end of the line below the main line, making two loops. Then the end of the line is placed between the two loops. Take the top loop n...

How To: Hack Jungle Magic with Cheat Engine (09/20/09)

Open Jungle Magic and then open up Cheat Engine, click Browse and find the process that is running Jungle Magic (ex. firefox.exe). Click Open and in Value Type change to Array of Bytes, copy the cheat code in Hex box and press First Scan. Select the value from the left area, now in the bottom area change the value to the cheat value. Go to the game and start to play, you will see that now you have unlimited time. Go back to Cheat Engine and click New Scan, change the value type to 4 bytes, un...

How To: Play a Turkish double dumbek with Raquy Danziger

Drum artist Raquy Danziger teaches the basics of playing a Turkish double dumbek. Raquy demonstrates how the index and ring fingers of the drumming hand should move in counter-harmony to each other, as the first step. Next she shows how to accent every third beat while drumming. Then, the other hand is used to add a third sound to the two being produced by the first hand in the up-down movement. The next step involves producing two different sounds with the second hand, by alternately hitting...

How To: Scan Any QR Code in Seconds with Your iPhone

A QR code is a fun and convenient way to link people to a website or app. On iOS, you have a few ways to scan these codes. You can download a QR scanner to get the job done, but Apple has one built into iOS. Or you can add the QR Code Reader tile in Control Center, but that's not even necessary. There's a better way, one that requires basically no effort to pull off.