If you want to get really good at playing the guitar, it stands to reason that you learn how to use a capo. Happily, the Internet is awash in high-quality tutorials like this one, which presents an overview of how to shop for a guitar. For more information, including a step-by-step overview, watch this free video guitar tutorial.
In this free video language lesson, you'll learn how to say "excuse me" in perfect Japanese. With Japanese, as with any other language, a few key nouns and phrases (and knowing how to properly pronounce them) can go a long way. For more information, and to get started speaking Japanese yourself, watch this video tutorial.
Interested in keyframing (or key framing) text in Final Cut Pro or Express? This clip will show you how it's done. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
In this clip, learn how to create a camera controller using nulls and user data. This makes animating a camera in a scene much easier. 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.
In this video tutorial, viewers learn how to print the gridlines with a Microsoft Excel spreadsheet. This task is very fast, easy and simple to do. By default, Microsoft Excel will not print a spreadsheet with the gridlines. Begin by clicking on the Page Layout tab. In the Sheet Options box, under gridlines, check Print. To remove the gridlines, do the reverse of this operation. To view the page with gridlines, click on the Office button, go to Print and select Print Preview. This video will ...
Knowing music theory never hurt anyone—not Bach, not Chopin, not Schoenberg. Even if you fancy yourself a musical iconoclast, the better you know the rules of music, the better equipped you'll be to break them down the line. In this free video music theory lesson, you'll learn how to do simple major-to-major transposition. For more information, including a very thorough overview, watch this helpful musician's guide.
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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....
With any form of dance, flexibility is key to making sure you don't pull any kind of muscles. There are various ways to help improve your flexibility, and this tutorial will help show you one.
The best snack is handheld. Anything that is all in one and can be eaten with one hand (and a napkin) is key to the ultimate snack or lunch. In this tutorial, learn how to make delicious sausage rolls from scratch. These babies are quick, easy and fit perfectly in your hot little hands. Enjoy!
Changing the oil to any vehicle is one of the most important and key parts for having a functioning vehicle. For some cars, changing the oil can be super easy, but for some it can be a real challenge. So to help you out and your wallet, here's a tutorial on how to change the oil and filter to a 2008 R56 MINI Cooper S. So good luck and enjoy!
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 626th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart to show the amount of time a project takes during a day.
Want to play Train's "Hey, Soul Sister" on your ukulele? See how it's done with this free video ukulele lesson, which presents a complete breakdown of the song as played in the key of C. While this tutorial is geared toward those who already have some knowledge of the ukulele, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Hey, Soul Sister" on your own ukulele, take a look!
See a number of useful key commands that will allow you to quickly resize and adjust the relative hardness of your brushes in Adobe Photoshop CS4. Whether you're new to Adobe's popular graphic editing program or a seasoned design professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.
Addicted to keyboard shortcuts? Interested in adding a few more to your arsenal? This home computing how-to from the folks at CNET TV demonstrates a number of intermediate- and advanced-level shortcuts sure to speed up your Microsoft Windows Vista workflow. For the specifics, and to get started using these useful Windows key commands yourself, watch this handy how-to.
Speed up your MS Excel workflow with these handy formatting key commands. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
Speed up your Nuke 5 workflow with the handy key commands dmeonstrated in this clip. Whether you're new to the Foundry's popular node-based compositing application or a seasoned post-production professional just looking to better acquaint yourself with Nuke 5's new features, you're sure to be well served by this video tutorial. For more information, including a detailed overview, watch this free video guide.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and use simple charts in MS Excel as well as see how to use Excel's SUMIFS & AVERAGEIFS functions. Specifically, this video covers the following topics:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 47th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values. Compare building confidence int...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
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.
To remove the lexan paint, obtain a bottle of brake fluid. Make sure you read the Material Safety Data Sheet (MSDS) for its harmful effects, and put on a pair of gloves to avoid contact with the hands when applying the brake fluid. To remove a large area of paint, pour a little amount of brake fluid onto some paper towel, and rub the area in a circular motion until the lexan paint is completely dissolved and removed from the area. A Q-tip can also be used to remove smaller areas. Apply as muc...
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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.
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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
New to 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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...
The guy first gives the definition of differential equations. He explains that a differential equation is an equation that contains the derivatives of an unknown function. He then gives some examples of differential equation and explains what the equation's order means. After that he gives an example on how to solve a simple equation. He calculates it and gives examples of graphs. Then he explains what a general solution is and how to narrow down the number of solutions using data from the pr...
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 329th installment in their series of digital spreadsheet video tutorials, you'll learn how to create a frequency table. Then see how to calculate the midpoint of each category and make a frequency polygon with two or more lines (two or more data sets).
If you don't want to spend an extra $130 to get 3G for your iPad, you can use the app MyWi to tether your iPhone's 3G connection to your iPad. This video shows you the easy way to tether your iPhone's 3G or EDGE Data Connection to your iPad, or any other Wi-Fi enabled device. So skip paying the extra dough and get a 3G connection for free! Be careful, as this can drain your iPad's battery!
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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
When you apply cologne you want to get the ban for your buck, and you want that bang to smell perfectly. There are a couple key points that you should keep in mind when applying scents. This video will show you exactly how to apply cologne, fragrance, or perfume and love it.
This video is from HelpVids and describes how to change the axis titles on charts in Microsoft Word 2007. To access the chart tools, select the chart and the tools will appear above the ribbon. There are many different design options that you can preview on the screen to make your final selection. To change the chart title, click on the Chart Title button which is located on the Layout ribbon. You can then select where you would like the title to appear. Once you select the location you can t...
This video will show you how to send a text message with the Samsung Galaxy I7500. Just follow these simple steps to start sending text messages from your Samsung Galaxy I7500: From the home page, tap the messaging icon. Select "New Message" Tap the "To" field and enter either the name or the number of the person you wish to send a text to. Type in your message, and when you are done, tap the "Send" key.
If you are a user of FileMaker Pro then this video teaches you how to use calculation and summary fields in it while making new files. In Filemaker you can create a various kind of fields that you want your file to contain. In Filemaker a calculation is a data that gets computed depending up on the formula that is set in the Filemaker database settings. Calculations are very critical in file management. Open the Manage Database and there you can find some of the calculation fields. There in t...
