Lists Coupons Search Results

How To: Determine whether a given item in a list 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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function formula.

How To: Use partial text matching 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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER functions.

How To: Extract a unique list from a huge data set 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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.

How To: Uninstall Internet Explorer 8 from Microsoft Windows 7

If Internet Explorer 8 is being a nuisance in Windows 7 watch this video to learn how to uninstall it! Start by clicking your Start Menu, then to Control Panel and then to Programs. From there click Uninstall Programs. It will bring you to a list of all the programs that are currently on your hard drive. Next click Turn Windows features on or off. From there another list of programs will appear, but these programs are all Windows programs that come with Windows 7 Operating system. Watch the r...

How To: Pack your luggage efficiently

Rafael and Zappos How To demonstrates how to pack your luggage efficiently. First, make a packing list to determine what you will need to bring on your trip. Go through your day in your mind and add things to the list accordingly. Don't forget your toiletries. Ideally bring one pair of shoes and coordinate your wardrobe accordingly. Lay out everything you will be packing and group them by like items. Don't put piles in your suitcase. Instead, roll your garment to prevent wrinkles and save spa...

How To: Speed up your Internet connection

This video takes us through a process of speeding up our internet connection using OpenDNS.com. Open the webpage and go to solutions and click on the icon open the DNS page and it lists computer or router, she selects computer and list of operating system is listed, she selects vista. She goes to start and selects control panel, click on view network status and connection, in that select view status and then click on properties and on the networking page, go to internet protocol version 4 and...

How To: Build a compost pile for dummies

The video starts out with the narrator explaining the benefits and uses of a compost pile. He then begins to demonstrate the steps to start a compost pile. He lists the ingredients and demonstrates how to mix it up with a pitchfork and shovel. He advises to put brown organic matter such as wood chips, leaves, sawdust, etc. as the first layer in the pile. Then add a layer of green organic matter such as grass clippings. A layer of kitchen scraps or manure can be added. He then shows how and wh...

How to Use Logic Pro: Arrange Window

Get to know how to use Logic Pro's arrange page in this short tutorial. Use the arrange area to work with the audio of your song. Change the timeline by choosing a time and beat. Use the toolbar area to do some functions. Use the icons to easily open up media and list areas. Use the bin to store your audio. Use the browser to look for your audio songs. Use the event list editor to edit your MIDI information. Use the inspector to view the channel strips of your track. Use the editors in the bo...

How To: These 11 New Reminders Features in iOS 14 Give You Way More Power Over Your Tasks

The iPhone's built-in Reminders app got an overhaul last year with iOS 13, giving us a more modern design and plenty of new features, and iOS 14 doesn't mess with a good thing. Instead, iOS 14 brings lots of small tweaks all over the app to smooth out the experience and make Reminders more powerful and more customizable than ever.

How To: Open Previous Drafts Faster in Your iPhone's Mail App — From Any Mailbox or Folder

All of your partially written, unsent emails live in your "Drafts" folders, in limbo until the day they are sent off or deleted. In Apple's Mail for iPhone, you can access all drafts from all accounts in a combined "All Drafts" folder from the app's main Mailboxes list — but only if you added it manually. But there's an even better way to access all of your drafts in Apple Mail in iOS; it's just not obvious.

News: 15 Awesome 'Reminders' Features in iOS 13 That'll Make You Actually Want to Use the App

While the Reminders app has been largely ignored by Apple for years, iOS 13 finally makes it a force to be reckoned with. The app has been completely redesigned with easier navigation and more useful features that can compete with other task managers. After giving the new Reminders a shot, you may want to ditch that third-party to-do app you've been using.

How To: Tag People in Reminders to Get Alerts When Chatting with Them in iOS 13's Messages App

While iOS 13 might have made waves for some of its more prominent features — most notably system-wide Dark Mode — some of the more interesting tools lie with its smaller, unannounced updates. One of those updates is a new Reminders setting to tag contacts in a to-do task so that iOS pings you when texting that person in Messages.

News: Thinking of Ditching MoviePass? Directly Compare Movie Ticket Subscriptions with This Chart

It's no secret that MoviePass is a shell of the service it once was. The primary $9.95/month plan for three movies each month is inconsistent and can change drastically depending on your location. Thankfully, MoviePass isn't the only movie ticket subscription service available. We've compared all the best plans on the market to help you find the one that's right for you.

How To: Create Custom Wordlists for Password Cracking Using the Mentalist

Beginners learning brute-forcing attacks against WPA handshakes are often let down by the limitations of default wordlists like RockYou based on stolen passwords. The science of brute-forcing goes beyond using these default lists, allowing us to be more efficient by making customized wordlists. Using the Mentalist, we can generate millions of likely passwords based on details about the target.

News: Always-Updated List of Phones With No Headphone Jack Built-In

The past year brought about a number of trends in the smartphone space. More immersive displays, better processors, and portrait mode for cameras come to mind as big steps forward. One of the most polarizing trends that continued in 2017 is the removal of the 3.5 mm headphone jack from flagship phones. The number of manufacturers that have completely dispensed with wired audio is staggering, so let's run down the full list!

NR50: Welcome to Next Reality's 50 People to Watch in Augmented & Mixed Reality

Those of us that work with or around augmented and mixed reality have seen a powerful shift in the last year as the popularity and interest have grown in the field. With Microsoft's HoloLens release, the popularity of Pokémon GO, and the constant rumor mill known as Magic Leap, the terms augmented reality and mixed reality have started to become a part of the modern vernacular more and more each passing day.

Hack Like a Pro: Python Scripting for the Aspiring Hacker, Part 2

Welcome back, my fledgling hackers! In an earlier tutorial, I introduced you to probably the most popular scripting language for hackers, Python. To become a professional hacker, you need to have some scripting skills and Python is a good choice if you want to master just one. In this latest guide, I will expand your background in Python and offer you a tidbit of Python code to whet your appetite for all of the hacking to come.

How To: Shut Down Your PC and Send Other Commands Remotely Through Twitter Using TweetMyPC

Ever been halfway to work or school and suddenly remembered you forgot to log off your computer? A lot of people are constantly logged in to email and social media accounts, so if you have a mischievous roommate or sibling, this situation could be disastrous. That's where TweetMyPC comes in—it's a free Windows application that lets you send commands to your computer just by tweeting. Image by Twittermania

How To: Block someone from calling or texting you on your iPhone

If there are people you just don't want to talk to, or texts you want to stop recieving, you can use the MCleaner app for iPhone. This app has a white list of approved numbers and a black list of disallowed numbers. You can even choose to let in phone calls from one number while letting in their text messages, or vice versa. MCleaner will also log your blocked calls, so you can see who has been trying to get through.

How To: Set up distribution lists for mass emails on your iPhone

If your iPhone is a business tool for you, you'll want ways to send out mass e-mails, either to your customers or employees and coworkers. You can use the iEDL, or Email Distribution App, published by MerckTech, to set up a distribution list that will let you send out mass emails as often as you need. This video shows you all the ins and outs of this awesome little app. Expand your productivity and marketing reach for your business and personal projects!

How To: Access and use the MIDI event list in Pro Tools 9

In need of a quick guide on how to use and make edits with the MIDI event list within Pro Tools 9? This free video software tutorial from Lynda presents a complete and thorough overview of the process. Whether you're new to Pro Tools or just new to Pro Tools 9, Avid's first native, software-only version of their popular Pro Tools DAW, you're sure to find much of value in this brief view.

How To: Create a data validation drop-down list from a table with duplicates 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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.

How To: Add a photo to a contact profile on an Android phone

After a short time of having an Android phone, you'll notice that your contact list can bulk up quite a bit. Not only that but all that text can make your favorite and preferred contacts fade into the list. In this clip, you'll learn how to take control of your contacts. It's easy! So easy, that this video tutorial can present a complete, step-by-step overview of the process in about three minutes. For more information, including detailed, step-by-step instructions, watch this video guide.

How To: Write a landing page that converts

Starting up a website can be daunting if you know nothing about web design or setup, but there are some tips to get the right people finding, looking, and returning to your site. A good landing page gives visitors exactly what they are looking for, and converts them from browsers to customers.

How To: Create drop-down menus in Microsoft Excel 2007

This video is a tutorial on how to create drop-down menus in Excel 2007. Select a cell on your spreadsheet and click on the “Data” tab. Go to the “Data Tools” section and select “Data Validation”. In the window that opens select "Allow" and choose "List". You will create a list of the values you want to allow. Type in the values, separated by commas, and click OK. Now you will see your selected cell has an icon to right that indicates there is a drop-down menu containing the value...

How To: Install Windows 7 on your PC from a USB drive

Some computers might now have a working DVD drive and in such cases you can use a USB pen drive to install Windows 7 on it. To do this first connect the USB drive to your computer. Now go to the command prompt and run the 'diskpart' command to find the details of the hard drive. Use the 'List Disk' command to list all the drives on you computer. You can also find the USB drive in the list. Now use the Select disk command to select the disk. Perform a clean command of the disk. Next create a p...