Functioning Efficiently Search Results

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

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

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.

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