Hassle Free Search Results

How To: Generate realistic clouds with the GIMP image editor

In need of a sunny, blue sky? Generate one in GIMP! Whether you're new to the GNU Image Manipulation Program, GNU's popular free graphics editor, or a seasoned designer just looking to pick up a few new tips and tricks, you're certain to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started making realistic clouds in GIMP yourself, take a look.

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: Utilize iPhone "freemium" strategies to profit

With the spread of smartphones and free online games, the "Freemium" model of product distribution and monetization has become prevalent over the last several years. At it's essence, it is handing out software products for free and then allowing customers to pay for in-software services using microtransactions. This video features some businessmen who do business in iPhone apps discussing how they use "Freemium" systems in their apps to make the most money possible while providing great servi...

How To: Move files to and from an Apple iPad

The iPad has many apps that can be used to create and view documents and those documents can be moved to and from the iPad using several different methods. This free video tutorial from MacMost presents an overview of a great number of those methods. For specifics, and to start moving files to and from your Apple iPad with ease, watch this free video guide.

How To: Track your Internet bandwidth use for free

Looking for an easy way to meter of your Internet bandwidth usage? This free video tutorial from the folks at CNET TV has got you covered. It details two freeware applications — one for Microsoft Windows, one for Mac OS X — that will help you keep track of your bandwidth usage. For the specifics, and to get started monitoring your own Internet usage, watch this helpful how-to.

How To: Make scones the Scottish way

Looking for an easy Scottish-style scone recipe? Look no further. In this free video cooking lesson, you'll learn how to do just that. For more information, including a full recipe and step-by-step preparation instructions, and to get started making Scottish scones yourself, watch this free culinary guide.

How To: Protect your Gmail account from unauthorized access

Protect your email account from would-be hackers and crackers with this free video tutorial from the folks at MacMost. If you have a Gmail, HotMail, Yahoo! Mail or other web-based email account, this video is much recommended. For more information, and to secure your own online free email account, watch this helpful guide.

How To: Work around the 1-rule data validation limit in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 144th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to work around data validation's one-rule limit by creating a second shrinking list that looses values as they are used in the data validation area.

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: Use the UPPER & EXACT functions 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 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.

How To: Extract records with an advanced filter in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Clean up a bad data set for a pivot table in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate variable commission totals in MS Exce

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...

How To: Convert a text formula/function to a number in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 44th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use 4 different tricks to convert a text formula or function to a number. Also see how to convert text to numbers. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Extract the top 5 values from a given list in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Hide columns and select only visible cells in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Organize your life in Microsoft Access

Brand new to Microsoft Office Access? This seven-minute free video lessson, which presents a general orientation to using the popular database program, will see that that you're well versed in all of the fundamentals. Learn how to create databases and forms, how to run queries and more. For the specifics, watch this free MS Access video tutorial.

How To: Do a goddess-pose breathing exercise

Wind down with the simple yoga relaxation exercise outlined in this free video lesson. As an added bonus, unlike most yoga exercises, which require some bare minimum of athleticism, the "goddess pose" demonstrated in this tutorial is as simple as reclining. Find out how to do the goddess pose with help from a yoga instructor in this free video on yoga relaxation exercises.

How To: Find a percent of a number

Having trouble figuring out percentages? If so, you'd be well served to give this free math lesson 100% of your attention. After watching it, you'll be able to answer questions like, "What's 25% of 38?" or "What's 38% of 25?" For more information on calculating percentages with simple arithmetic, watch this free video guide.

How To: Install any app for free using Installous on an iPhone

In this video tutorial, viewers learn how to install the Installous application for the iPhone or iPod Touch. Users will need to have their iPod device jailbroken before installing. Begin by opening Cydia and select manage. Click sources and select edit. Add this source: Select your new source (Hackulo.us) and install AppSync for your device's firmware, Then install Installous. Return to your home screen and run your new application (Installous. Now users are able ...

How To: Do a driven free kick

This video instructs the viewer on how to do a powerful Driven Free kick for soccer. First, you will need to come on to the ball and strike it with your in-step. Your in step is the inner part of your foot that is right next to the laces. The most important tip is that when you do strike the ball, come through the ball and not around it! Finish with a hop at the end which will create more power! You'll want to kick the ball just under the center for proper height and maximum power. Kick the b...

How To: Do a Trivela free kick

This video shows the viewer how to take a ‘Trivela’ free kick. This is where the player kicks the ball with the outside of their foot. This makes the ball curve towards the foot that the player kicked the ball with – a right footed shot will curve to the right and vice versus. The main point the video makes seems to be to make good contact with the ball. This is very crucial. The video also contains other tips and tricks as well as some footage of successful ‘Trivela’ free kicks taken by the ...

How To: Easily open a pomegranate mess free

Use these steps and you will be able to open up a pomegranate, mess-free! *Select pomegranates by weight not color!* Remember the heavier they are the more juice they contain! Here is how to open a pomegranate: mess free! Cut the crown of the pomegranate off - (the top of it). Take your knife and cut through the membrane of the pomegranate (the middle). Get a bowl of water and separate the seeds from the membrane inside the bowl. The seeds will sink to the bottom, and scoop out the membrane w...

How To: Understand velocity, acceleration, and free fall

In this video the author explains the various concepts like speed, velocity, free fall speed etc., Speed tells you how fast you are going, i.e. it is distance divided by time taken to travel it. Velocity is nothing but speed along with direction. Now she tells that acceleration is used to measure the rate of change in velocity. So she says that acceleration is difference in velocity divided by the time. She also explains that there can be acceleration with out change is speed as there can be ...