Hot Software How-Tos

How To: Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.

How To: Remove Vocals from Songs Using Audacity

Need to remove the vocals from a song? Audacity just might be the answer. It's one of the few free audio editing programs out there with many, many features, making it simple to create a track for karaoke or simply to listen to an instrumental version.

How To: Use x-ray techniques in Photoshop to show naked skin through clothing (NSFW)

Do those new naked body scanners have you freaked out at the airports? As far as the TSA is concerned, those x-ray machines are here to stay, but you might as well take comfort in knowing that airport security guards aren't the only ones looking at your private parts. Practically anyone with a computer can manage to see through your clothes, and it's all thanks to a little program called Photoshop. Thanks, Adobe.

How To: See Through Clothes with Gimp 2.6

If you can't seem to find any photos of naked people on the internet, don't fret, this how to will show you how to "see through" clothing using some simple techniques with Gimp 2.6 photo editor. Gimp is like Adobe Photoshop without the heavy price tag. Tight, white clothing works best for this trick, so keep that in mind. Watch the video and get one step closer to seeing someone naked. Right on your own computer! See through clothes with Gimp 2.6.

How To: Turn a male voice to female voice with Audacity

If you're a user of digital editing software Audacity, you already know you can do a ton of cool things. One of the cooler things you can do is changing a guy's voice to sound like a woman's. This is done with pitch control, or autotune, and will like you modify the voice by a number of octaves. I this video, rock band 30 seconds to Mars is made to sound like Avril Lavigne. Check it out! Of course, this can also be done with your own voice too!

How To: Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.

How To: Completely hide the Ribbon menu in Excel

The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...

How To: Count characters (including spaces) with LEN 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 221st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LEN function to count charters including spaces. Then see how to use the LEN, SUBSTITUTE, and TRIM function to count characters but not unwanted spaces.

How To: Create a beautifully layered 3D composition with After Effects

Using a layered photograph, chroma key footage and depth of field, prolific Italian designer Juri Ciana demonstrates precisely how to create a stunningly beautiful 3D composition with After Effects. In this informative video-only tutorial, depth of field and focus is utlized as critical elements that provide the various components of this video composition with a living vibrancy and dynamism.

How To: Create a skewed checkerboard pattern in Illustrator

Check out this simple Adobe Illustrator CS4 tutorial to learn how to create a skewed checkerboard pattern. This technique will save you the trouble of having to use the Option and Drag method multiple times. Veerle Pieters expertly takes you through this easy pattern technique. For more Adobe Illustrator tutorials, search for Illustrator on WonderHowTo.

How To: Count word length with the LEN function in MS Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using LEN to count word length. To get started using the LEN function for yourself, watch this how-to.

How To: Create an Excel inventory template with running totals

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Update inventory records by formula in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).

How To: Do bank reconciliation in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 37th installment in his "Excel Business Math" series of free video lessons, you'll learn how to do bank reconciliation when accounting in Microsoft Excel.

How To: Make a cartoon character in Flash

This video will show viewers how to use Adobe Flash and how to make a cartoon character talk in this program. This tutorial covers aspects such as recording the voice of your characters, drawing their mouths to speak, and how to sync the recorded speech to the animation. Furthermore, this video will also show how to create subtle facial expressions that display emotion in the character. In order to record the sound, the host recommends a program called Audacity which has a free downloadable v...

How To: Use Photoshop to turn a photo into a greeting card

There's nothing like a greeting card to turn a frown upside down. In this day and age of emails and text messages, making your own greeting cards for someone can mean so much. From Valentine's Day to Christmas, greeting cards are a way to thank, welcome, congratulate, and even apologize to family or friends. So in this video tutorial, find out how to make greeting cards using a photo and the program Photoshop. Enjoy!

How To: Audit remote password using THC-Hydra

THC-Hydra is a remote dictionary attack tool from The Hacker?s Choice group. It?s a well made tool that supports a lot of protocols and options. The following protocols are supported: TELNET, FTP, HTTP, HTTPS, HTTP-PROXY, SMB, SMBNT, MS-SQL, MYSQL, REXEC, RSH, RLOGIN, CVS, SNMP, SMTP-AUTH, SOCKS5, VNC, POP3, IMAP, NNTP, PCNFS, ICQ, SAP/R3, LDAP2, LDAP3, Postgres, Teamspeak, Cisco auth, Cisco enable, LDAP2, Cisco AAA. Audit remote password using THC-Hydra.

How To: Use BearShare to download music

In this video series, watch as computer, internet and software expert Matt Nichols teaches how to use BearShare to download music. Learn the basics of BearShare software, how to download BearShare, how to install BearShare, how to search for songs to download, how to download music, how to get a monthly subscription to BearShare, how to use the playlist, how to burn CD's using BearShare, and how to use BearShare for social networking. File-sharing is a great way to learn about new music and s...

How To: Generate random numbers (with decimals) in Excel

This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...

How To: Change a person's sex in an image editing program

Want to change someone's sex in Adobe Photoshop—making a boy look like a girl or a girl a boy? This clip will get you started. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.

How To: Extract records that meet certain criteria in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...

How To: Make your own passport size photo

This video instructs the watcher on how to create a passport-sized photo in Photoshop. First, open Photoshop and choose the image that you want using the "Browse" option. Then go to "image", from there "select image size" and select the image size you want (e.g. 35 mm by 43 mm). Next, under "File", go to "select new" and select the size of the paper you use in your printer. Select image and move it to the new file. Copy it as many times as you want in that file. Save, then print. Watch this v...

Prev Page