Guide Lists Search Results

How To: Sort Excel data in custom order

This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...

How To: Merge two list tables and delete 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 381st installment in their series of digital spreadsheet magic tricks, you'll learn how to merge two lists into one list while keeping unique items from list 1 and list 2 and removing duplicates.

How To: Use the motion guide in Flash CS3

This software tutorial will show you how to work with motion guides in Flash. This lesson is great for beginning Flash users since it covers some of the basic tools in Flash, effect modes and keyframes. Learn how to use the motion guide to make a car follow a path in Flash CS3.

How To: Use a guide Awl on your tennis racket

Take a look at this instructional video and learn how to use a guide Awl to pass string through blocked grommets on your tennis racket. Wax or chapstick can help the guide Awl ease through the block grommet. When attempting this, try spinning it as it'll help reduce the friction.

How To: Check whether quantities are equal in two lists 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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.

How To: Use guides in Illustrator CS2

Naturally you're going to need to align objects from time to time while using Adobe Illustrator. One of the ways that we use to keep objects lined up is to use a visual guide so that we can see at a glance if something is lined up or not. In this video we'll also see how to turn any path into a guide as well as putting guides on layers.

How To: An Extended Guide on Runtime Crypters

Hello again, folks! I'm back with another (final) guide on runtime crypters which is an extension on my previous runtime crypter guide. If you have not read it yet, I highly recommend that you do since the fundamental theory of the PE format. Again, this will be a Windows-specific guide, so I'll repeat this: If you're a hater and cringe at the slightest sound of Microsoft's grotesque baby, feel free to close this tab, delete your history, exit your browser, pour some oil onto your machine and...

How To: 100+ Apps You Can Use 3D Touch on Right Now

3D Touch is a new feature on the iPhone 6S and 6S Plus that's reinventing the way we interact with our smartphones. With just a little bit of added pressure when tapping on the display, you can perform Quick Actions from an app's home screen icon, "Peek" at emails, stories, and photos in-app, as well as perform other app-specific gestures. Since 3D Touch is such a new concept, here are some of the apps that currently support it, along with the shortcuts you can use.

How To: Crack WPS with Wifite

Hi, dear co-apprentices and wise masters. I've been recently trying to learn the basics to hacking here, and I've read all guides on Wi-Fi hacking and noticed no word is dedicated to this awesome script that comes bundled with Kali!

How To: Show Someone a Photo on Your iPhone Without Them Swiping Through All of Your Pics

You hand your iPhone to a friend to show them a picture. What happens? They swipe. Left, right, it doesn't matter. You don't remember what lies in either direction of the photo in question, and you don't want anything compromising exposed to the unassuming viewer. Luckily, Apple includes a safety net in iOS to prevent this scenario from ever happening, so long as you set it up ahead of time.

How To: Use the M8's New Sense TV App on Your HTC One M7 & Ditch Your Remotes for Good

Let's face it, finding your remote, let alone finding something to watch, can take more time out of our days than we'd care to admit. There are remote locators and channel guides out there, but why use those when you have a perfectly good remote always on you—your HTC One. HTC put an IR blaster into their One and when it's coupled with their Sense TV app, it can make for one hell of a smart remote.

How To: Replace the SIM card in a BlackBerry smartphone

Looking for a quick guide on how to swap out the internal sim card in your BlackBerry phone? This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.

How To: Use the Software Update feature in Mac OS X

Need a primer on how to use the Software Update feature within all versions of Mac OS X? This Mac user's guide from the folks at Mac Most provides just that. For more information, including detailed, step-by-step instructions, and to get started automatically updating your software and OS with the Software Feature app, watch this video guide.

How To: Turn your Nexus One smartphone into a WiFi hotspot

Interested in tethering a WiFi device to your Google Nexus One phone? This guide will show you how it's done. Whether you're the owner of a Google Nexus One Android smartphone or just covet one, you're sure to enjoy this Nexus One owner's guide from Nexus One Hacks, which presents a complete, step-by-step walkthrough of the tethering process. For complete details, take a look!

How To: Make a reflective floor for an underwater scene in C4D

Modeling an undersea scene in Cinema 4D? This guide will show you how to create a realistic reflective floor. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.

How To: Create a new notebook within Microsoft OneNote 2010

Need some help figuring out how to make a new notebook within OneNote? This guide will show you how it's done. Whether you're new to Microsoft's popular notetaking application or a seasoned MS Office pressional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating notebooks yourself, watch this free video guide.

How To: Use camera navigation when working in MAXON Cinema 4D

This quick C4D user's guide presents a general overview of camera navigation. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.