Reference Listing Search Results

How To: Match two lists 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 382nd installment in their series of digital spreadsheet magic tricks, you'll learn how to match values in lists and, where there are matches, take the second column from each table and put it in new table.

How To: Set up POP3 settings for Outlook 2003/Outlook Express

POP3 stands for Post Office Protocol, a way in which you receive mail on the internet, paralleling how mail is received in your mailbox. To set up your POP3 for Outlook, go to tools, click “view or change existing e-mail accounts’ and press next. You’ll be able to see a list of your current email accounts that you can change or remove. When you select an email and press change, you’ll be able to see the account in detail: the email address, the POP3 and SMTP server information, and th...

How To: Install fonts in Photoshop

In this how to video, you will learn how to install fonts on to a computer running Windows. First, go to the start menu and go to control panel. From here, double click on fonts. Next, select install new font. From here, browse your folders to the folder you have saved your downloaded fonts. Once it is selected, press okay to add the font to your current list of fonts. You can check if the font can be used by opening up Photoshop. Create a new file and then press the text icon. From here, you...

How To: Download a torrent for the first time

This video tutorial from JdudeTutorials presents how to download a torrent for the first time.To start, open your Internet browser. Browse to utorrent web page.Download and install uTorrent client version, suitable for your operating system (MacOS or Windows).Once you've installed application, browse to The Pirate Bay.This is the largest torrent source in the world.Check Video option under the search bar and type family guy (as an example).Click Enter. A list of torrents connected to family g...

How To: Remove a friend you shouldn't have asked on Facebook

Is there anyone on your list of Facebook friends that you no longer wish to have access to your profile? This concise video shows how to remove "friend" statuses from unwanted Facebook friends. First, you must log into your Facebook profile. Near the top of the opening page you will see a tab called "friends". Click on it, then click on "all connections". This page will list all of the people that you are currently friends with. On the left is each person's profile picture and name, and on th...

How To: Use Microsoft Excel to determine statistical values

Follow this video to learn how to formulate calculations in Microsoft Excel. First type in a list of numbers in the cells. In order to calculate the median click on the cell where you want the answer to be shown. Then type equals, average, open bracket and insert the cell code where the first number is, colon, and then type in the cell where the last number in the list lies, and close brackets. In practice this is an example where the numbers are in a list from cell A1 to cell A11: =AVEARAGE(...

How To: Repeat a list of names 7 times in Excel

The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.

How To: Select profitable books to sell on Amazon

Have an Amazon store for yourself? Sell books? Well, you may be wasting your time listing certain books when they'll never sell, but there are some ways to make sure you're listing only the most sellable and profitable books on Amazon.com. Watch this video tutorial to learn how to select profitable books to sell on Amazon, and how to know which books aren't worth it and to avoid.

How To: Remember a list of random words

In this video, US Memory Champion Chester Santos teaches you how to expand and improve your memory by using a few simple techniques. Word visualizing allows you to create associations which help to remember individual words. Memory can be increased in a fun and easy way by taking advantage of Santos' cool and unique method of associative thinking. You will hopefully never forget your shopping list again!

Instagram 101: How to Share Posts & Stories to All Your Close Friends' Feeds Only

Instagram is a great platform to share photos and videos with the world, but sharing with smaller groups is near impossible. You can directly message pictures, stories, or post links to friends, but that only works for one person at a time or in group chats you create. To share your content with a small group of people you care about the most, you'll want to use the "Close Friends" list.

News: Galaxy S8 Oreo Beta Update Coming to US in November

With all of the Pixel 2 excitement the past few weeks, many Samsung fans are feeling left out on that new software hotness. If you're anxiously awaiting the Android Oreo update on your Galaxy S8 or S8+, that wait may come to an end this week. Users over on Reddit decompiled the APK for the Samsung+ app to reveal multiple mentions of the upcoming Oreo Beta Program for the Galaxy S8 and S8+.

How To: Using BASH for Computer Forensics

Greetings to all geeks, hackers, nerds, and explorers of Null Byte. Welcome to my brand new tutorial, "Using BASH for Computer Forensics". This tutorial will give you a look at how the computer programming language, Bash, can be used to find out details on apple devices for later use.

How To: Customize Your Android's “Share via” & “Open with” List for Less App Clutter

When opening a link or sharing a photo, your Android device will bring up a list of possible applications that you can complete the action with. However, some of the apps included you never use or didn't even know existed, and this leads to unnecessary clutter. Fortunately, if you're rooted, there's an easy way to remove apps from the "Open with" and "Share via" lists.

How To: Fully Customize Your Samsung Galaxy S3's Dictionary Using Old Tweets, Statuses, Emails, & Texts

My standard text greeting to friends is something along the lines of "Wazzup biznitch?"—but apparently the auto-correct function on my Samsung Galaxy S3 has a problem with that. Time after time I have to retype it or just add all my made-up words to the word list—and I use a lot of made-up words, because that's what bosses do. But texting isn't the only way I communicate. I also use email, chat, and social media on a daily basis—and I don't always use my phone. So, wouldn't it be awesome if m...

How To: Find Out If the FBI Is Keeping Tabs on Your Apple Device (UPDATED)

It's no secret that there's a lot of surveillance going on these days. It's easier than ever to end up in a database, and even former government agents are speaking out about the atrocious amount of spying being done against our own citizens. They've targeted our laptops, cars, IP addresses, and now they're coming for our iPhones. AntiSec hackers managed to get their hands on a list of over 12 million Apple UDIDs (Universal Device IDs) from an FBI computer, and they published 1,000,001 of the...

How To: Delete game history on your Xbox 360 (Xbox 101)

Learn how to delete the game history on your Xbox 360 from Ryan Treit in simple steps. You can get rid of the nasty unused game history from your Xbox 360 by following the steps below: 1. First go to your profile, press the guide button and then slide to the left one tab to Games and choose 'Achievements'. 2. Now a list of all the games you used will be displayed in order. 3. Select the game you wish to delete and press the X button and select 'Yes' to delete the game history. 4. Delete all t...

How To: Animate a bully splashing a water bottle in Adobe Flash

This tutorial shows you start to finish how to draw an image of a bully with a water bottle in hand and then fling that water bottle onto someone else using FL Studio. This a useful reference piece for trying to animate splashing water or similar water physics. It's not precisely hard to do, but you'll want to pay attention to some of the detail in each piece. Also make sure that you have the most current version of FL Studio installed!