Multiple Ranges Search Results

How To: Build objects for multiple constructors for Java

Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBostonian will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to build objects for multiple constructors when writing code in Java. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.

How To: Retrieve multiple values from a horizontal Excel table

hether 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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the HLOOKUP and ROWS function to retrieve multiple values from a horizontal table.

How To: Create an average with multiple criteria 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 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Add extreme contrast in Photoshop

Oftentimes, a photo may not capture the true vibrancy of color in real life, but Photoshop can fix that. Photos with lots of color can be given even greater hue saturation by adding extreme contrast in Photoshop. By using multiple effects, including overlay blend modes and noise across multiple layers, a picture's color intensity can be made more bold with these techniques. By following the steps in this video, colors can be made more vibrant using extreme contrast with Photoshop software.

How To: Use multiple monitors with your Mac

Sometimes just one computer monitor is not enough. Whether you are working on a detailed art project, multiple files at once, or simple wish to open more windows, you may need to connect multiple monitors to your Mac. In this video, Gary Rosenzweig from MacMost.com shows you how to hook up another screen to your computer and make the most out of your desktop space. It is actually very easy to hook up a second monitor to most Macs. Once you get a monitor and the proper cables you are good to g...

How To: Host multiple websites on your Mac Mini server

How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.

How To: Add fractions with unlike denominators

In order to add fractions that are not alike, you will need to find the lowest common denominator. This is the least common multiple of the fractions. To add 2/3 plus 1/5, you will need to find the lowest common denominator. Here, it is best to think of all of the multiples of the denominators. If it helps, make a list. For 3, it is 3, 6, 9, 12, 15, etc. For five, the multiples are 5, 15, 20, 25, etc.

How To: Manage multiple Finder windows with tab browsing

In this video tutorial, viewers learn how to get tabs in Finder. This can only be done on the Mac OS X computers. Users will need to download the Total Finder application from the site provided in the video. Once downloaded and installed, this program will allow users to manage multiple Finder windows in a series of tabs in a single window. In the Finder Preferences, users are able to configure the sidebar, label color, file name and trash options. This video will benefit those viewers who us...

How To: Create multiple inboxes in Gmail using filters

See how to set up multiple inboxes within Gmail and use filters and labels to have mail sent to different addresses automatically sorted (and mail sorted using other criteria too, like subject, or containing certain words). It's easy! So easy, in fact, that this Gmail user's guide can present a complete overview of the process in just over four minutes time. For details, and to get started using Gmail's useful filtering feature yourself, take a look.

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: Add rational numbers

Learn how to add rational, or fractional, numbers by following the tutorial in this video. In the case of fractions where the denominators are the same, the addition is simple: you simply add the numerators and keep the denominator the same. When the denominators are not the same, you need to find the least common denominator (or multiple). Take a look at your denominators and test different numbers to find the smallest multiple of the two. Then, convert the two original fractions so that the...

How To: Summarize data from multiple sheets in Microsoft 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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.

How To: Find range and interquartile range in Microsoft Excel

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 40th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate range & interquartile range for variability using the MAX, MIN, QUARTILE functions.

How To: Use multiple start-up pages in your web browser

If you visit the same pages over and over, you may want to consider setting multiple start pages. While you may not have even known such a thing was possible, the set-up procedure is simple in both Mozilla Firefox and Windows Internet Explorer 7. Learn how to use browser tabs to open up multiple websites when you launch your browser with this how-to.

How To: Create a comp from multiple takes in Propellerhead Record 1.5

Learn how to create a perfect track from multiple takes with the Record comp editor. This official video guide from James Bernard of Propellerhead will teach you everything you'll need to know. Whether you're new to Propellerhead's virtual music studio application, Reason, or their newer DAW app, Record, you're sure to find much to take away from this brief video software tutorial.

How To: Calculate future & present value for multiple cash flows in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the future and present values for multiple cash flows in Excel.

How To: Sync iTunes on multiple computers with Home Sharing

In this video tutorial, we learn how to share content from an iTunes library with multiple computers with the Home Sharing feature. It's easy. So easy, in fact, that this home-computing how-to from the folks at CNET can present a complete overview of the process in just over two minutes. For more information, including a complete demonstration detailed, step-by-step instructions, take a look.

How To: Display the results of a MySQL query over multiple pages

In this clip, you'll learn how to use pagination—that is, to view the results of a MySQL query over multiple pages. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look

How To: Add a single effect to multiple clips in Sony Vegas

Learn how to apply a single effect across multiple video clips in Sony Vegas Movie Studio or Sony Vegas Pro. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Add unlike fractions using basic math

In order to add unlike fraction, using basic math, you will need to find the lowest common multiples of the denominators. In order to add 5/12 and 1/6, you will need to make the denominators the same. The lowest common multiple, for these fractions is 12.

How To: Work with multiple objects at once in Blender 2.5

This clip presents a general introduction on how to work with multiple objects simultaneously within Blender 2.5 and discusses the topics of loading and saving. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look.

How To: Find the lowest common multiple/LCM with a factor tree

This video lesson demonstrates how to find the lowest common multiple/lowest common denominator (LCM/LCD) using factor trees. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).

How To: Find the lowest common multiple with the ladder method

Looking for an easy way to find the lowest common multiple (LCM) of a pair of numbers in simple arithmetic? Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).