Function Search Results

How To: Slice up images for HTML image maps in GIMP

See how to use GIMP to generate a HTML image map in minutes. This mimics the slice function from Photoshop. 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 chopping up digital images yourself, take a look.

How To: Look up a picture 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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.

How To: Fix other people's Microsoft Excel spreadsheets

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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:

How To: Round to the penny or dollar 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 9th installment in his "Excel Business Math" series of free video lessons, you'll learn about when you must use the ROUND function in Excel. Round to the penny or dollar with this free video lesson.

How To: Find confidence intervals without the sigma in 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 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...

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: Validate data & look up values 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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.

How To: Make a gradebook based on percentage scores in Excel

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 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...

How To: Check if a cell is empty using macros in Excel

Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this func...

How To: Make an Excel dynamic named range across multiple rows

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...

How To: Use an array formula to filter data in Excel

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...

How To: Use optimization methods in calculus

This video shows how to use optimization methods in calculus. Optimization means finding the maximum or minimum values of a quantity or finding when the maximum or minimum occurs.What quantities are optimized in economics?we want to minimize costs or maximize revenue.First steps in any optimization problem1.Identify the quantity to be optimized i.e., read the problem exactly what is exactly maximized or minimized.2.Identified the feasible domain. This is important because the math we can opti...

How To: Use differential equations to solve for velocity

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...

How To: Use an XLR mic with a camcorder

How to Make Anything demonstrates how to use a three prong XLR mic with your camcorder. The XLR plug on the mic is not going to fit into the 1/8 inch plug on your camcorder so you will need an adapter. You can find an XLR to 1/8 inch adapter for about 10 dollars. Try to get an adapter with as short of a cord as possible to reduce noise and radio interference. You can also get an XLR box which is an interface which goes between your camera and the microphone. The XLR box will be about 180 doll...

How To: Manage email with Conversation view in MS Outlook 2010

In this video David Rivers shows that the conversation look of Excel 2010 has greatly improved. Tracking and managing related emails, saves your inbox space to enable you to manage large number of emails effectively. By default, the conversations are arranged by date. Email interactions will have an arrow displayed. You can easily expand and collapse the conversation. The major improvement is the function of ignoring or clearing up conversation with just a few clicks. The future conversations...

How To: Draw storyboards

Gus Russel explains how storyboarding can be used to illustrate what a movie might be like. He has been given the task of drawing a frame for each page of a 130 page movie script. Story boarding gives the author a general idea of how the movie will come together, how the characters will look, etc. Russel shows the audience how to quickly draw a quality sketch, and how to shade it properly. The sketches do not function to show exactly what will happen in each scene, but rather what "might" hap...

How To: Create a paper scroll in Illustrator

If you aren't familiar with Illustrator software it is very similar to the photo-editing software Photo Shop. This video is a guide on how you can make a paper scroll by using Illustrator. You can follow along with the video and make the basic shapes and then re-size the pieces to look almost exactly like an ancient paper scroll. This would be something really neat to make if you needed a background for an old-timey looking photo or if you needed to make up invitations for a church function.

How To: Tie a Pagoda knot

TyingItAllTogether explains that, "Pagoda is the English language term for a tiered tower with multiple eaves. Common throughout eastern Asia, most pagodas were built to serve a religious function. The Pagoda Knot was created in admiration of this sacred architecture." In this video, learn how to tie a decorative pagoda knot. Working with a single piece of string, follow along as the string is transformed into a work of art. Begin by making a series of four loops. Cross the tails, then weave ...

How To: Use the replace color command in Photoshop

The replace color command is a nifty tool in Photoshop that enables you to change a color in an imagine very quickly and effectively. The tool requires that you make a copy of the original layer, as the replace color command is a destructive function. It requires parts that you want replacing to be selected first, to change the color of the desired areas. The result is a very realistically edited image, that is extremely fast and easy to accomplish.

How To: Create an animation using a motion guide in Flash

This tutorial video, from tasktutorial demonstrates how to create animation using the motion guide function in Flash. You will learn how to create an object, in this case, a ball, and create an animation that makes it appear to bounce. The guide shows you, how to add a motion guide by selecting a key frame and drawing it in. Then you will learn how to snap the object to your guide line, and add motion to it by selecting another key frame between the first and last frames, and snapping the obj...

How To: Do basic lighting corrections in Photoshop

In this video tutorial the instructor shows how to perform basic lighting corrections in Adobe Photoshop. The levels tool is the Photoshop's most used command which has many features to it. Its most basic function is as a lighting correction tool. In this video open an image and work on its adjustment layer so that you do not damage the original picture. Now choose the levels option by right clicking and it shows a pop up window which contains a histogram which shows the population of the col...

How To: Use Excel keyboard shortcuts

This video is all about the keyboard shortcuts that are used in Microsoft Excel of the latest version. If you really need speed and efficiency then watch this video for its shortcut keyboard buttons. After typing all the data, if you need to see the page setup with the help of the mouse than it will take a pretty long time. By opting for keyboard shortcuts you can save much of your time and can invest it in another work. If you press 'alt' button then it will show keyboard shortcuts on the sc...

How To: Use Beginner Python to Build a Brute-Force Tool for SHA-1 Hashes

Developers creating login systems know better than to store passwords in plain text, usually storing hashes of a password to prevent storing the credentials in a way a hacker could steal. Due to the way hashes work, not all are created equal. Some are more vulnerable than others, and a little Python could be used to brute-force any weak hashes to get the passwords they were created from.

How To: Create a new account, add and edit in Blogger

In this Computers & Programming video tutorial you will learn how to create a new account, add and edit in Blogger. First go to Blogger. On the home page click on ‘create a blog’. You will be taken to the account setting up page. Feed in all the details including our email. Then open your email and click on the confirmation link. You will then be taken to your dashboard or your home page. On this page you can click on ‘new post’ button and start writing your blog. When you do this a word proc...

How To: Use & understand compression when digital recording

This tutorial video will show you what the purpose of compression is and how compression works through its parameters. Your instructor illustrates a drum beat and a plucked guitar line. Beginning with how to compress the drum beat, take (download) a drum sound pack without compression and to add compression using the software right click on the drum machine, choose create, and then choose combo on compressor. The virtual compressor has all the dials and adjusters found on any basic compressor...

How To: Get around a broken HOME button on your iPhone

Looking to fix your iPhone home button? Do you have a broken HOME button on your iPhone? In this video, learn how to get around it with an application called "mquickdo", formerly known as iHome for jailbroken iPhones. This also works for iPhone 1G or 2G and iPod 1G or 2G. Mquickdo allows you to use a series of finger swipes to function as the home button. This includes putting your iPod to sleep, going back to the home page, the double tap music menu, exiting an application, and more.

How To: Build your K'NEX Starburst Spinner Thrill Ride

K'NEX is one of the most popular construction toys on the market, right next to Lincoln Logs and LEGOs, but what makes K'NEX stand out is the fact that children can build mechanically derived toys. Instead of blocks or little logs, kids use interconnecting plastic rods and connectors, which give them tons of contraptions to build and play with. Today, K NEX has even more possibilities with wheels, pulleys, panels and flexi-rods to make amusement park roller coasters, airplanes, animals, bikes...

How To: Approximate the area under a curve using rectangles

The idea of finding the area under a curve is an important fundamental concept in calculus. Consider a function y = f(x). Now the area under the curve is to be calculated. The area under a curve problem is stated as 'Let f(x) be non negative on [a, b]. Find the area of the region lying beneath the curve y = f(x) and above the x-axes, from x = a to x = b. Note that finding the area under a curve will imply that you are dealing with a non negative function. The way to approach is to divide the ...