Favorite List Search Results

How To: Avoid double-counting duplicates within a list 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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.

How To: Create and use friend lists on Facebook

Interested in making friend lists on Facebook? This clip will show you how it's done. Whether you're completely new to the Facebook's popular social networking site or simply require a small amount of clarification on how to perform a particular task on Facebook, you're sure to benefit from this helpful video guide. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a list a links on a WordPress blog

This video tutorial will show you how to create a list of links on a WordPress website. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.

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!

How To: Use Websploit to Scan Websites for Hidden Directories

Websites are often misconfigured in ways that allow an attacker to view directories that are not ordinarily meant to be seen. These directories can contain sensitive information such as private credentials or configuration files that can be used to devise an attack against the server. With a tool called Websploit, hackers can scan targets for these hidden directories without difficulty.

How To: Edit Android's Share Menu — No Root Needed

Android's share intents system is great in theory, but the execution can sometimes be frustrating. When you tap the "Share" button next to a link, app, or file, you see a list of apps you can share that item with. But it seems like every time you use this function, the list of apps is in a different order — especially when it comes to the Direct Share targets at the top.

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.

Kodi 101: How to Get Free Live TV Legally

When most people first become aware of Kodi (formerly known as XBMC), they hear about its ability to stream illegal content. But the real Kodi community knows that it's much more than just a haven for pirated material — it's an all-in-one media player that addresses the majority of home theater needs, particularly for those that decided to cut the cord.

Xposed 101: How to Install Unofficial Modules

The Xposed Framework has an official repository for downloading modules which can be easily accessed by searching the Download section in your Xposed Installer app. But not every module is available on the Xposed repo — in fact, many unique and interesting modules are only hosted on third-party servers.

How To: Security-Oriented C Tutorial 0x21 - Linked Lists

Welcome to the final tutorial of the series on standard C. This article will cover the linked list abstract data type (ADT). There will be a lot of abstraction to try to deliver the understanding in the most basic way for easiest interpretation of what they are and how they work, then we will get into the guts of it and learn the technical code underneath. For those who have yet to grasp the concept of pointers, it's advisable that you do that first before approaching this. Having learned thi...

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.