How To: Sort & find duplicates in Excel
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
Sort 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: Perform the instant sort card trick with ease
This trick is great for beginning magicians! A very simple concept: You mix up the deck, mixing face up and face down cards, and then you sort them instantly with just a little bit of magic. In this video you'll see a demonstration for the trick and then a great, step-by-step, tutorial on how to perform the trick and some techniques to get you going.
How To: Sort data with queries in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about sorting data using queries. For detailed instructions, and to get started using queries to sort data for yourself, watch this how-to.
How To: Sort incoming email with GMail
If you're a heavy gmail user here's a handy way to sort your incoming emails from spam with a little known trick from Tekzilla.
How To: Use Excel to sort data & present data in a line chart
This video introduces how to use Excel to sort data, perform the Frequency function, and present data in line chart. See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating your own li...
How To: Sort numbers with a formula 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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.
How To: Create message rules and auto-sort with Outlook
How to create message rules and do auto-sorting with Microsoft Outlook. f you ever wish every email from your Uncle Lou could be put into a folder (or the trash) automatically -- or you want to flag message from your boss -- or you want to have a sound play when an ebay outbid notice comes in, then this tutorial is for you.
How To: Return a sorted list based on row values in MS Excel
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
How To: Sort and filter information in Numbers '08
Sorting and filtering information in spreadsheets is a vital function. In this tutorial you will see how they work in Numbers '08 and how to apply them to your projects.
How To: Use the Cloner Sort option in MoGraph for Cinema 4D
This clip presents an introduction to the Cloner Sort tool and the Random Effector Sorted mode of MoGraph for Cinema4D. 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. Use the Cloner Sort option in MoGraph ...
Stock Photo Challenge: Tiger Eating a Zebra (SFW... sort of)
Nom nom nom They have a whole series of these photos... 0_0
News: Interesting Radio Interview -Validity and description .. sort of ,
Well the Picture is great ... ! This video/Radio interview has some interesting points .. Im always on the lookout for more scientific studies etc...
HowTo: Brew Your Own Bathtub Gin (Well, Sorta)
Here's another slightly under-the-table D.I.Y. project for you (though much less gritty than today's earlier example).
News: Automatically Manage and Sort Files Using Hazel [Mac]
In many of my articles, I will refer to applications designed to empower Mac users to automate various tasks on their computer. One such application is called Hazel. Like smart folders, smart playlists, and smart albums found in Mac OS X and iPhoto, Hazel can automate the task of moving, copying, or deleting files in folders on your Mac. I recommend Hazel as one of the most essential applications for any Mac user. Let's explore how it works.
How To: Alphabetize in Excel
Need to sort a ton of data in Excel? Why waste time cutting and copying cells? In this tutorial, learn how make Microsoft Excel automatically sort columns or rows alphabetically.
How To: Set up your Gmail account in Mozilla Thunderbird
In this video from MegaByteTV we learn how to set up a Gmail account in Mozilla Thunderbird. First go to your browser and download Thunderbird from the Internet. Once downloaded, go to the Thunderbird application. Go to New and Account. Click on Gmail and enter your name and email address. Click Next and check off download messages now and click Finish. Your messages should now appear there. The first time you do this, all of your messages will look new but you can change that. If you'd like ...
How To: Budget w/ ledger sheets in Microsoft Excel: Mac 2008
Don't want to shell out the big bucks for some fancy, expensive budgeting software? Well, if you have Excel 2008 for Mac installed, you can manage your budget right there. Personal financing doesn't get easier than this— even business finances are easy to keep track of. The Microsoft Office for Mac team shows you just how to manage your finances with pre-formatted Ledger Sheets in this how-to video.
How To: Regift Unwanted Christmas Presents: The 10 Rules to Regifting
It's been done for ages, but for most of us, "regift" entered our vocabulary after the 98th episode of Seinfeld—"The Label Maker." In this episode, Elaine calls Dr. Whatley (played by Bryan Cranston) a "regifter" after he gives Jerry a label maker—the same label maker that Elaine gave Whatley.
How To: Fight as Iron Man in Marvel vs. Capcom 3: the basics
Iron Man is riding high on the success of his two recent awesome films, and now is making an appearance in Marvel vs. Capcom 3. Show Robert Downey Jr. how it's done (sort of like Charlie Sheen has done) and watch this video to learn all the basics of fighting with Iron Man.
How To: Get the Doll Hobbyist achievement in the Train Station stage in Stacking
Stacking is not the sort of game that really emphasizes achievements, but if you want to make sure you find all the hidden dolls chasing the achievements is a good way to do it. This video will show you where to find all 19 dolls in the Train Station level and get the Doll Hobbyist achievement / trophy.
How To: Create a reflective glass button in Adobe Illustrator
Whether you're a web developer or a blogger trying to get your name out there in the vast world of fashion design, creating an aesthetically pleasing website is indispensible these days - sort of like making your virtual resume. While fabricating a nice site may seem time-consuming, with a few easy Photoshop tricks you can have it up and looking sexy as hell.
How To: Turn an LCD screen into a simple EL (electroluminescent) display
Electroluminescent (EL) materials light up when electricity passes through them, as opposed to more common incandescent lights that respond to heat. EL displays are becoming very popular in advertising and art,but getting them or the materials to make them can be expensive. Watch this video to learn how to turn an LCD into a simple EL display, and also how superglue can be used as a cheap dielectric in this sort of project.
How To: Make basic, simple sounds with the Moog analog synthesizer
The Moog synthesizer is the most intimidating instrument ever made from a playing standpoint. Sitting down at one, it is possible that without prior knowledge you would be unable to make any sort of sound with one. Fortunately, this video for analog synth beginners will show you how the basics of making sounds using a Moog. Many of these techniques work on other old analog synths as well.
How To: Do basic krump moves, including stomps, arm swings, and buck ups
Krump is one of the most unconventional hip-hop dances, and there is a special emphasis on achieving a nasty sort of style while you're doing it. This video will teach you the basics of krumping, including stomps, arm swings, and buck ups. It also offers tips on achieving that nasty attitude you're going for when you krump.
How To: Render a video to AVI format using 3ds Max
If you want to demonstrate your 3D model on a turntable or create some other sort of short animation with your models without having to use more specialized software, you can render an AVI video inside 3D Studio MAX. This video will show you how to do this quickly and easily, assuming that you already know how to animate your character. Now, let the world see your beautiful 3D work!
How To: Create a random frame using Flash and Actionscript 3
Flash and Actionscript can be used together to create damn near any sort of animation or website feature that you could want. This video will teach you how to do just one thing: generate a random frame using Flash CS4 and Actionscript 3. This is handy if you want to create a button that will link to several different objects randomly. Fun if you want to add the zest of unpredictability to your user's website experience.
How To: How to make your own longboarding slide gloves
Sliding gloves are a great tool to help you add a new surface to your longboard sliding. Sort of like the combination of longboarding and street luge, this adrenaline junkie sport is fast. Check out this video to learn how to make the gloves.
How To: Draw manga mouths in four different ways
Characters in Japanese manga tend to have very expressive mouths, ranging from a smirky little line on one page to a giant "O" mouth on the next page. In this video, "Miki Falls" manga creator Mark Crilley shows how to draw mouths the manga way. And we won't just learn to draw one sort of mouth, we'll learn four different styles.
How To: Find your perfect red lipstick
We're experiencing a Lipstick Renaissance. Rich, defined lips ruled the fall runways, cementing the return to old school glamour and the ladylike lipstick that comes with it. Here, Sephora Pro Beauty Team member Vanessa Dunn helps you sort through the new crop of creamies. Learn a trick for finding your undertone, instantly!
How To: Solo over Jazz changes using melodies and focusing on key centers on guitar
Jazz is a complicated style of music that takes a completely different style of thinking and playing to even do it somewhat decently. Soloing in its own right is the toughest, but there's a great way of getting started, and thanks to Jeff Richman from Musician's Institute, you will learn how! In this amazing video lesson, he goes through showing you the various ways of using melodies and key centers to really bring out your solo over any sort of Jazz Changes.
How To: Create Lady Gaga's "Let's Make a Sandwich" makeup look from "Telephone"
After watching Lady Gaga's music video for "Telephone," most of us probably wouldn't want Lady Gaga to mix us up any sort of drink or sandwich. But makeupwise, there is certainly something to be coveted about Lady Gaga's dramatic electric blue, gray, and black abstract eye, dark brows, and plush pink lips.
How To: Use and get the right materials for making a fursuit or other costume
Cosplay-friendly conventions are going through a sort of renaissance right now. AnimeExpo, ComiCon, A-Kon, PAX. All over the country people are dressing up as anime characters and furry animals and filling exhibition halls to mingle. If you want to have a really badass costume, you're going to need the right materials. In this video, a semi-professional costume-maker will walk you through the materials you need to make a great fursuit or other elaborate costume and where to get them.
How To: Conform Canon 5dmk2 footage from 30p to 24p in Final Cut Studio 2
A tutorial using Final Cut Studio 2 on how to convert footage shot in 30p to perfect 24p. Used in the short Sofia's People. Can't quite figure out why you have two of the same filters in FCP? This quick clip will sort you out. Whether you're new to Apple's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more...
How To: Get Angelina Jolie's sultry "SALT" makeup look
Angelina Jolie is our hero. After all, she is a humanitarian, a loving mother of six, an Oscar-winning actress, and as of yet the only female actress out there who can play a usually male-centric spy role and be an action movie star without any sort of gender bias. Oh yeah, and she's the most gorgeous woman in the world.
How To: Use Swype to text message on a Windows Mobile phone
In this clip, learn all about Swype. Swype is a cool new app that allows you to type at super fast speeds. If your phone has this capability and you are just in too much of a hurry to actually type a word - check it out. You don't even have to remove your finger from the screen! Just swipe your digits over the letters and the phone will magically know what you were trying to say. It's sort of like T9 updated for 2010.
How To: Make an egg drop and learn the physics behind it
The egg drop has become a sort of rite of passage for gangly fourth graders as they embark on their first journey into physics and math before they approach these subjects again later on in middle school and high school.
How To: Solve a 4 colored Mastermorphix
A Mastermorphix is sort of like a more intense version of a Rubik's Cube. This tutorial will show you how to solve this triangular puzzle. Basically, once you know how to solve a normal Rubik's Cube, you will be able to master this in no time.
How To: Achieve the perfect nude lips for your skin tone
Nude lips are tricky to get right. If you make them too light, you will look like you have toothpaste or powdered donut stuck to your mouth. If you make them too dark, you look bizarre and if you make them too similar to your actual skin tone, you can look like a zombie. If you are having trouble figuring out how to apply the right type of nude to your pout, follow along with Petrilude as he shows you exactly how to select and apply this sort of look. So, what are you waiting for? It's time t...
How To: Restart Windows OS without rebooting your computer
This how to video shows you how to restart Windows without rebooting the computer. Press control, alt, and delete on the keyboard at the same time. Your task manager program will open. Select processes and click image name to sort it. Select explorer.exe and press end process. Click yes in the warning dialog. Your start menu will disappear. This is usually bad considering you cannot do anything when this happens. Go to file and select new task. Click browse and click on any folder and right c...