Vessel Function Search Results

How To: Use the groove function in Ableton Live 8

In this tutorial, we learn how to use the groove function in Ableton Live 8. A group settings consists on points along the timeline where hits sit. If you have something with no groove applied, it will sound robotic. By adding a groove, you will shuffle around the midi from the hard quantized parts. This will add more human element to the audio. There is a button on the left with two lines that show the library with options you can use. You can also apply this to other clips, scroll through t...

How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions

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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Sum values after a deadline 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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

How To: Add yearly totals from monthly data in MS 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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.

How To: Extract records with 1 criterion via Excel's AGGREGATE

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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...

How To: Use Boolean logic for AND & OR formulas in MS 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 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. Also see how to create array formulas in two different ways: the SUMPRODUCT function (DON'T have to use Ctrl + Shift + ...

How To: Use the COUNT and COUNTA functions 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 658th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells.

How To: Access all Windows 7 settings at once

In this video tutorial, viewers learn how to access every Windows 7 setting at once. Users will need to download the Windows 7 in a Box program provided in the video. Once downloaded, simply click on one of the functions (Functions, Folders, Internet Settings, Programs, Tools and Settings) on top of the window and select the option that you wish to use. This program will organize all the Windows 7 settings into an easy to comprehend layout. This video will benefit those viewers who use a Wind...

How To: Use the sine, cosine & tangent trigonometric functions

New to trigonometry? Learn how to calculate cosine, sine and tangent with this 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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how t...

How To: Fill in missing column values with Excel's IF 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 605th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function to fill in column with missing values then use Paste Special Values to create the final column with correct values. Also see three methods for Paste Special Values.

How To: Fix a DGET #NUM! error 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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.

How To: Use VLOOKUP queries inside of an MS Excel IF 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 588th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine whether an employee is exempt from a tax using a VLOOKUP in an IF function, and if not use a second VLOOKUP lookup query to look in tax tables to look up and calculate the tax

How To: Look up a time value with Excel's VLOOKUP function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Force text formulas to wrap with Excel's CHAR 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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.

How To: Use the BINOMDIST & NORMSDIST functions 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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...

How To: Use the PERCENTILE & QUARTILE functions in MS 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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.

How To: Use the COUNTIF function in Microsoft 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 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...

How To: Extract part of a table from a larger table 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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Use the audio effects rack in Ableton

This video is a tutorial for a music producing software program called Ableton Live 8. In this tutorial he shows you how to apply effects to effects to audio using the audio effect rack function. The way this function works is by being dragged into the bottom of the program and being applied as a place to hold various effects. Using the effect rack you can modulate and manipulate the sound waves in the effect. This is a very convenient tool to have in Ableton because it allows you to have mor...

How To: Use the Finder buttons in Mac OS X

This video instructs you how to use the "Finder" Button if you own a Mac on OS X. The "Finder" window shows the Mac user the contents of the hard drive. It describes functions of the Finder folder: i.e., adding an untitled new folder in the Finder file. It also discusses how you can view the "Finder" in a variety of layouts: grids, lists, etc. The video shows you how to use the buttons on the upper left hand corner of the "Finder" screen to maximize, minimize, or close the window. It also dis...

How To: Batch automate in Photoshop

This how-to video produced by Photoshop Universe gives step-by-step instructions on how to batch automate a process in Adobe Photoshop. With this tutorial you'll be able to learn to correct white balance, enhance colors, resize, and save for the web whole folders' worth of images in one go. The first step to doing this is to open up one of the images in your folder and correct the white balance, enhance the colors, resize the photo and save. The next thing you want to do is to record all of t...

How To: A Hacker's Guide to Programming Microcontrollers

While hackers know and love the Raspberry Pi, many don't know of its cheaper cousin, the microcontroller. Unlike a Pi, which can be used more or less like a regular computer, microcontrollers like the Wi-Fi connected ESP8266 require some necessary programming skill to master. In this guide, we'll build an Arduino program from scratch and explain the code structure in a way anyone can understand.

SPLOIT: How To Build a Peer to Peer Chat Application in Python ( GUI - Linux )

Developing GUI apps in python is really cool. I ask those who understand the language to help convert some of the command-line or console programs or apps ( I mean programs that are useful to a hacker ) to GUI. I know GUI makes us lazy and not wanna learn but we should all know its fast. Today's tutorial is on p2p chat app I developed last week and decided to share it with the community since its kinda cool.

Food Tool Friday: Meet the Big Green Egg—The Ultimate Cookout Machine

At first glance, the Big Green Egg looks like it was created by Dr. Seuss or some other whimsy-driven being, like Zooey Deschanel. And while this earthenware cooker may look cute, it produces serious results that can rival the best barbecue or grill. In fact, it's got quite a large cult following. Entrepreneur and former Navy serviceman Ed Fisher fell in love with the taste of food cooked in kamodos (traditional domed, covered earthenware vessels in Japan) and began to import them for sale in...

How To: TAP Card Dissolved! How to Use Acetone to Transfer an RFID Tag to Your Phone

RFID cards are becoming a fairly common way to purchase goods, but they're already widely used to pay fares on buses, trains, subways, and trolleys across various cities. TAP cards are quick and reliable, but it can be a real pain to remember to bring them with you, especially if you weren't planning on using public transportation that day. Luckily, an intrepid tinkerer at Adafruit has managed to find a way to embed an RFID card into her phone, something you're far less likely to leave at home.