Latest Trending Tech & Gadgets Lifestyle Apple Android
iOS 18 Tips, Tricks, How-Tos, News

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: 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: Convert an mp3 file to wav format with Audacity

Want to convert an MP3 to a WAV? With Audacity, it's easy! And this clip will show you just how it's done. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.

How To: Use ReDrum to load a .wav sample into Reason 4

So, you've got a copy of Reason 4 now huh? Congratulations, you own one of the most powerful music-making tools on Earth. It is infinitely complicated though, and getting started can be tough. Watch this video to learn how to load a .wav sample into Reason 4 using ReDrum, something you're going to be doing a lot of as you produce your tracks.

How To: Create and mount ISO image files using UltraISO

In this video the instructor shows how to create and mount ISO's using Ultra ISO. You can user daemon tools to work with ISOs but this video shows you an alternative to it. Download the Ultra ISO software and install it. After installing it run the program. In the tool bar select the Tools button and in the drop down box you can select the various option like create a new image, mount an image to a drive or convert images between formats. Select the mount option and it prompts for the file. B...

How To: Age photos in Photoshop

In this Adobe Photoshop tutorial you will learn how to age a photo. Learn to take a new modern photo and make it looked like it was taken in the 20's or 30's. You don't need a time machine to age your photos, just Photoshop!

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: Use the FileMaker Pro 11 graphical user interface

Meet FileMaker Pro 11's user interface! Whether you're new to the FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a frequency polygon line chart 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 655th installment in their series of digital spreadsheet magic tricks, you'll learn see how to create a statistical frequency polygon using a line chart. Also see how Excel mistakenly interprets number category label data as Number Series data.

How To: Create a crystal effect look in Photoshop

The video opens up with an introduction from the video sponsor, "Godly Tutorials. It then goes to a screen displaying the basic Photoshop screen. Once there, he opens up an image that is completely black. After that he opens up an image editing window that displays the color scale and also displays various effects. He then picks one of the crystal like effects displayed in the window as well as a color described as baby blue. Once the he changes the layer and adds another crystal effect to th...

How To: Add multimedia to PDFs in Adobe Acrobat 9 Pro

In this Adobe video the tutor shows how multimedia can be added to your PDF document to make it richer and more appealing. She shows the basics of the software taking you around the tools available to place multimedia content in the PDF. Now she opens a blank page where she intends to put the multimedia content. She shows how to mark the area of the document so that you can insert multimedia content there. She says that in this latest version you do not need Quick time or Windows media player...

How To: Create a Tangent Line with Excel

Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.

How To: Open & edit Dolby Digital AC3 audio with Audacity

A great number of audio editors don't support importing/exporting AC3 files, luckily the awesome—and, of course, free–Audacity does. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this free video software tutorial, which presents a complete overview of how to open and edit Dolby Digital AC3 audio when working in Audacity.

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: Create glass material in 3ds Max

Dave shows you how to produce a glass three different ways in 3ds Max in the video tutorial. Put two panels away, then concentrating on sensor one press m on the keyboard to bring up the materials editor. On the material editor go to the first sphere, choosing a slight blue color, bring up the specter level, bring up the glossy level, click on two sided and bring down the last two to about four. Look to see it is fairly transparent, in a test window. This is glass one, put on hide. Go to glas...

How To: Make an image strip using FastStone Image Viewer

In this tutorial, we learn how to make an image strip using FastStone Image Viewer. First, open up the images that you want to have inside the strip. Then, open up Fastone Image viewer and find the location of the images. From here, go to "create", then "image strip builder". This will bring up the builder window where you can add in the images you want to see on the strip. When finished, click on the "create" button. Now, the strip will come up on your computer in a new image and you will be...

How To: Create a basic hand rig within MAXON Cinema 4D

This tutorial covers the C4D rigging system, applying it a model of a hand. It goes from start to finish covering all the different aspects of the technique. 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.

How To: Calculate bonuses based on years worked 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.

How To: Turn a photo into a drawing with Photoshop

In this how to video, you will learn how to turn a photo into a line drawing in Photoshop. First, open your image in Photoshop. Create three layers of the same photo. The top two layers will be worked with. The bottom layer will remain the same. Take the top layer and change it to color dodge. Select control and I on the keyboard to invert it. Go to filter and blur to choose Gaussian blur. If you have dark lines, use a small amount of blur. You can use a lot of blur to get a unique look. Clic...

How To: Make a CD cover in Photoshop

This video is about how to make a CD cover. First, open up the image that you have. Then, you need an action script. Click on the action's palette and pick which CD cover you want to do. Then you click step one which will run a template for you to set everything up and place your graphic in. The next thing to do is to slide the graphic image on to the template through the select tool. Then, click free transform found on the edit toolbar and just double click the image. The next step is to edi...

How To: Create a multiuser login system in Microsoft Access

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 creating a multi-user login form to password protect different areas of your database.

How To: Set AutoCorrect and AutoReplace settings in Microsoft Excel 2011

Need a hand figuring out how to adjust AutoCorrect and AutoReplace settings in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoCorrect and AutoReplace in your own MS Excel '11 projects, watch the...

How To: Configure the Ribbon UI in Autodesk 3ds Max 2011

In this video tutorial, we learn how to configure the Ribbon UI within Autodesk 3ds Max 2010. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the 3ds Max 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the lessons imparted by this free video software tutorial yourself, watch this free video guide. Configure the Ribbon UI in Autodesk 3ds Max 2011.

How To: Auto-tune your vocals in Audacity for free

T-Pain, Cher, heck, most of the new artists these days use auto-tune, some over use it. With technology it isn't so much of a question of, "do we need to do it?" and more of "why aren't we doing it!?" Well, if you're looking for an easy way to add auto-tune to your vocal tracks, or your voice in recordings, and are looking to spend the fantastic price of FREE then check out this video! You will learn what programs you will need to download (Audacity, Audacity VST, ect.) and then how to set yo...

Prev Page