Function Adviser Search Results

How To: Use Adobe Camera Raw in Photoshop

If you're thinking about venturing into the world of using Camera Raw in Photoshop, you've come to the right place. The camera raw function in Adobe Photoshop provides easy access to raw image formats produced by many digital cameras. In this video, learn all about how to get started using the Camera Raw Utility plug-in for Adobe Photoshop.

How To: Use tritone chord substitutions in jazz guitar

This free video guitar lesson discusses tritone chord substitution. In short, when a dominant 7th chord is functioning, it can be substituted by a dominant chord that is a tritone or augmented fourth away from its root. For more information, and to get started playing tritone chord substitutions on your own guitar, watch helpful jazz tutorial.

How To: Make a multitouch table computer pad

Multi-touch input has been spreading throughout a huge variety of devices, from phones to all-in-one PCs. However, most multitouch (table) displays that can function with your computer tend to be fairly expensive, so with this project we're going to make our own display, that can run on any operating system, and reuses some useless everyday materials.

How To: Make USB air conditioning

Wondering how to most effectively combine ice cubes and a simple USB-powered computer fan into a fully functioning air conditioning system? In this video tutorial, you'll learn how to hack a coffee can and USB-powered fan into a simple, but effective, air conditioning unit. For detailed instructions on hacking together your own tin-can AC unit, watch this über-short how-to.

How To: Security-Oriented C Tutorial 0x0B - User Input

Hey readers! This tutorial will be the entry point for the introduction of buffer overflows. Something like requesting user input is a very common place for vulnerabilities to pop up and we will definitely have fun while trying to make programs crash. But for now, let's start with how we can get input from a user.

How to Train Your Python: Part 4, Basic User Input

In the last iteration of how to train your python, we covered basic string manipulation and how we can use it to better evaluate user input. So, today we'll be covering how to take user input. User input is very important to scripting. How can we do what the user says if we can't tell what the user wants? There are multiple ways to take input, we can give the user a prompt and take input from them directly, or we could use flags/switches, and take their input before the script is even execute...

How To: Customize Your Mac's Top Keys to Control Either Functions or Built-in Features Without Using “Fn”

Mac keyboards are great when listening to music or watching a movie, since you can control what's playing without going back into iTunes or QuickTime Player. However, when you're using an app like Photoshop that uses the F7, F8, and F9 as shortcuts, it gets pretty annoying to have to hold down the Fn key. Why can't you just hit the back, play/pause, and skip buttons alone?

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula 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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Calculate weekly gross pay from time values in Microsoft Excel 2010

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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Use the UVW unwrap function in 3D Studio Max

In this video, we learn how to use the UVW unwrap function in 3D Studio Max. First, go to the UV modifier wrap and select all the faces. Once here, edit the parameters and then go to the mapping menu. After this, you will be able to change the object as you would like. After you are finished with this, save your object to your computer in a spot you won't forget it. You can create several different layers and change the colors as you prefer. You can completely customize your experience on thi...

How To: Add custom buttons to a Thunderbird Toolbar

In order to add additional buttons to your Thunderbird Tool Bar, you will need an add-on called "Custom Buttons". It will allow you to add additional buttons to your tool bar. You will need to give instructions for the buttons, which you will use Java Script in order to set it up. Otherwise, the button will not have a function.

How To: Use the main menu functions in Photoshop CS3

In this tutorial, we learn how to use the main menu functions in Photoshop CS3. All of your main menus are up on the top toolbar. There will be a drop down list for each different tab you select. When you create a new document, you will be prompted with a dialogue box that asks you how you want your page to be set up. Change the preferences to fit how you want your page to look. When you have changed all of your different settings, click on "ok" and you will be brought to your new document cr...

How To: Use the timer function on a Panasonic G1 or GH1 camera

Learn how to set the timer function when using aPanasonic G1 or GH1 digital camera. Learn how to set the auto mode on a Panasonic G1 or GH1 digital camera. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to take timed photographs with a G1 or GH1 camera. For more information, including detailed instructions, ...

How To: Use log to solve for an unknown variable

Thinking of an unknown exponent as a cat stuck in a tree, you will see how to bring down the exponent by using the the log function. In other words, you will be utilizing the Power Law to bring the exponent down in front of the log function. In this slightly more complicated example, a little work has to be done to first be able to take the log (i.e., get the base by itself). Then once you take the log, the unknown still isn't entirely by itself, so you divide off everything it's being multip...

How To: Use the concatenate function & ampersand 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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).

How To: Sort data with sorting functions in Microsoft Excel

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 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:

How To: Use the RANK and PERCENTRANK functions in MS 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 38th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the RANK and PERCENTRANK functions as well as the Data Analysis add-in's Rank & Percentile tools.

How To: Use names and wildcards with Excel's COUNTIF function

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.

How To: Remove duplicate entries with Excel's COUNTIF function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $30. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Link buttons to external urls in Flash CS3

This is a video tutorial showing its audience how to link a button to external urls in Flash CS3. First create a exoscript 3 document with a rectangle textbox that says youtube. Next select your rectangular box and convert it to a button. Next name your button and click okay. Next give your new button an instance name, remember this name. Now click on actions and create your actions. Start with a stop action and then put the name of the button as an action. Next name your function that you wa...

How To: Calculate probabilities with Excel's NORMDIST function

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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...

How To: Do dynamic range w/Excel's OFFSET function & top data

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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.

How To: Use an OFFSET as a dynamic range in an Excel VLOOKUP

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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.

How To: Use the AVERAGE IF function in Microsoft 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 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF (AVERAGE IF) function to create a formula that will calculate the average when you have more than 1 criterion.

How To: Antidifferentiate functions with radicals in calculus

This video demonstrates how to do anti-differentiate functions with radicals in calculus. To simply problems, try to substitute. For example, in the problem, the integral of x times the square root of x plus 2 dx. You can substitute w for everything underneath the radical: i.e. x + 2. When you simplify, it becomes: the integral of x times the square root of w dw. Now, you need to get rid of the x, which you can do with a substitution: w – 2 = x. Now, plug in the values and simplify it.

How To: Start a screen share on iChat

This video tutorial from pirateskool presents how to enable screen share function in iChat application in Leopard operating system.Firstly, you need to ensure Screen Sharing function is enabled. From menu dock on your desktop, choose System Preferences option.In the opened window select Sharing. Make sure Screen Sharing is checked.Now you can close system preferences window.To establish screen sharing you need another user, who has Leopard operating system and iChat communication application....

How To: Get the copy and move to folder function in Windows

Steps taken to get the Copy to and Move to folder function in Windows 7 are:1. Go into the description and click the download link, to download the files2. After downloading the registry file you will see a zip file, which you need to extract using the software called Win Zip.3. After extracting the zip file, you will see two registry file (copy to and move to) execute both the registry file and give Yes, so that the file gets installed successfully.4. After successful installation, it is rec...

How To: Use fit image in Photoshop

This tutorial will focus on how to use the fit image function within Adobe Photoshop. You will utilize this function when you want the pixel width to match between different sized photos in portrait and landscape. First you will select all the photos (you must create a batch action in Photoshop). Next select the fit image option in the file menu under automate. You will need to put the same number into length and width to constrain the proportions of your landscape and portrait photos have th...

How To: Use accessibility options in Windows XP

This video was made to help users with disabilities use Windows XP more efficiently in their lives. Starting with entering the control panel the and clicking on the accessibility options the user will have an array of options to help customize their settings to their needs. The demonstrator showed that sticky keys are for those who have a difficult time holding down buttons at once for functions. The filter key eliminates double strokes for certain keys so you would need to hold down a key to...

How To: Rip and burn a CD in iTunes

iTunes offers the ability to extract and copy data with its rip and burn functions. Ripping lets you import songs into your iTunes library from a variety of sources. Burning lets you write audio files on to a CD. Once you customize the audio file playlist that you wish to have on CD, simply initiate the program's burn function, and you'll have a music CD in no time.

How To: Derive a quadratic equation, given the roots

This video shows you how to get the quadratic equation for the quadratic function with roots; (5,0), (12,0) which passes through the point(8,6). It shows a man solving this problem using a black board and chalk to clearly demonstrate the method of plugging in the respective coordinates to arrive at an answer. After watching this video, any person over the age of twelve will know how to use quadratic functions to derive quadratic equations and solve mathematical problems with this particular m...

How To: Use INDIRECT, TEXT, and SUBSTITUTE in Excel

ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.