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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...
In this video tutorial, viewers learn how to hand-write on an HP Touch Smart computer. The HP Touch Smart is a touchscreen all-in-one desktop computer. The input panel allows users to hand-write or type text right on the screen. There are 3 different writing modes in the input screen. The modes are: writing pad, character pad and on-screen keyboard. It can be used in many HP programs such as the calendar and notes. This video will benefit those viewers who have an HP Touch Smart computer and ...
In this video tutorial, viewers learn how to convert VHS tapes to DVD. Users will need a computer with an analog input or an external converter. If the computer has an analog converter, simply connect the RCA cord from the VCR to the computer. If the computer does not have an analog input, connect it to the converter with the USB/fire wire cable. Then connect the RCA cable to the VCR and external converter. Now open a video editing software and capture the video from the VCR by pressing play....
This video tutorial will teach you how to use the onscreen keyboard on the HP touch smart. Very informative video that goes through several steps including teaching you how to add an event to your calendar. It starts by showing you how to add the event and then takes you through the keyboard and teaches you how to capitalize your words using the shift key as well as caps key. It demonstrates the input panel tab and how to move your panel as well, teaching you all the techniques for good use o...
Even today, smartphone text input leaves a lot to be desired. It's difficult to select specific words, the cut/copy/paste menu isn't always accessible in every app, and we're lacking undo and redo options, even though it's as simple as pressing Ctrl + Z on computers.
In the last iteration of how to train your python, we covered the concept of control flow and covered the booleans associated with it. Today, we'll be putting those to use as we discuss how to use if, else, and how to make conditional statements. So, Let's get started!
In this video tutorial, viewers learn how to type in special characters. Begin by opening System Preferences and select International under Personal. Then click on the Input Menu tab and check Character Palette and Keyboard Viewer. Now check "Show input menu in menu bar" and click OK. Then click on the flag icon on the top of the screen and select Show Keyboard Viewer. This will allow users to type or mimic the actions of the keyboard. Users are also able to change the character by selecting ...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this how-to video, you will learn how to hook up your TB X41 Headset to your Xbox 360. First, hook up the HDMI cable. From there, you must have a fiber optic cable and an Xbox 360 audio adapter. All you have to do is plug it in right above the HDMI connector. The black input is where the digital audio input goes. This is where you install the fiber optic cable. Run that into the transmitter. The transmitter sends the signal to your headset. By viewing this video, you will learn how to easi...
This video presents you the character input methods and the messaging options that can be found on LG Chocolate Touch. When sending a text message, you get to choose from the following input methods: Text (abc, Abc, ABC), numbers, pen (handwriting) and symbols. The phone features a normal mobile phone keyboard and a QWERTY one, making text messages easier. The QWERTY keyboard pops up when you rotate your mobile phone horizontally, using the built-in accelerometer. Also, you can create a "Favo...
This video tutorial will show you how to take an old computer keyboard and use its circuitry as a physical computing input device. Once you have this device, you can then use it to interface with programs that you write using software such as pure data processing, MAX/MSP, and Ableton Live to name a few. What you are doing is replacing the switches within your keyboards with others for input devices. Make sure the interface is plugged in when you are testing but it's probably a good idea to u...
Included in Logic Pro is a vocoder called the EVOC 20 PS (PolySynth), a very hand tool when it comes to audio editing. The EVOC 20 PS is a combination of a vocoder and polyphonic synthesizer, which can be played with an external controller keyboard. But let's concentrate on this video tutorial, where you'll learn how to use and record the vocoder synth in Logic Pro. See the steps below:
Ready to rock and roll? You don't have to listen to music through those teeny tiny computer speakers anymore! Check out this cool tutorial, and learn how to connect stereo speakers to your laptop or PC and get the most out of your music.
This video in the Software category will show you how to use multitrack live recording in Logic Pro 9 . This video is from Lynda. Say you are going to record a 4 piece band; drummer, base, guitarist and a singer. Use separate mikes for all four. First you make 8 different mono audio tracks. Go to track menu and click new. Type in 8 for number, select audio, format will be mono. Now you click the ascending box, order the inputs from one to eight and click create. Now you have 8 audio racks. Cl...
This video shows a quick and easy way to create a drum loop using "MIDI MERGE". A stereo instrument track with expand 2 is used here. First, select a track, expand 2, and select session drums (you can take any other track) for the patch and also create a "click track" which will be available in the track menu. Open the transport window and select "loop playback". In order to create a looped playback, right click on the "play" button and select "loop". This is a loop, so make sure that you do ...
One of the main goals of Google Wifi (and Nest Wifi after it) is to make managing your internet connections as simple as possible. A great example of this is how easy it is to prioritize one device and allot it more bandwidth when your network is bogged down with other traffic.
If you utilize strong passwords—which you absolutely should be—you've probably had to go back and forth between keyboard screens multiple times to input various letters, numbers, and symbols.
"Enter your email address. Confirm your email address." I absolutely hate seeing those two sentences when I'm signing up for something online, especially on my Samsung Galaxy S3. The less keyboard work I have to do on my mobile the better. Luckily, there is a way to enter your email address without having to type it all out, and I'm going to show you how it's done.
Here's a quick tutorial on how to set up a connection which will let your computer talk to a PS3 controller, so you can use it as an input device to play games on! All you need is to download the software and then update the driver!
Need to adjust your microphone's input volume using the Realtek Sound Manager but aren't sure how? The 20db mic boost gain appears to be in a buried spot in the Realtek HD sound cards software, but it's there! In this video tutorial you'll see how to get to it.
In this episode we show you how to import pictures off of your Bluetooth capable cellphone and onto an iMac. Should you buy a digital camera or camcorder? What features should you look for? The techies give their input on what to look for in making those decisions. Along the same theme, the techies offer some suggestions on where to buy electronics including digital cameras and camcorders. (31min 59sec)
How to speed up your internet connection
The following are the steps to be followed to know the internet speed using CNET. 1. Go to google.com
It is a great time to be a mobile gamer. Not only are there millions of mobile games on the Play Store and App Store, but thanks to some recent developments, we can also even play PC games. AMD recently released an app, which, among other things, lets you play your favorite PC games on your phone.
In recent years, wave after wave of technological advancement has led us down roads that are beginning to look more and more like science fiction stories. In their efforts to bring us from science fiction to science fact, Microsoft Research showed us a new communication medium called Holoportation earlier this year—and now they have found a way to make this highly complex holographic system far more mobile.
Hello everybody Joe here. Today I will be demonstrating how you can find XSS vulnerabilities in a website and what you can do with them
Like a car, your Mac needs to be monitored and cared for to keep it running as smoothly as possible. While your vehicle comes with a ton of gauges to keep track of your oil, temperature, and in some cases, even tire pressure, your Mac has no easy way to watch for low memory or high disk usage. Normally you would have to open up Activity Monitor to take a look at your usage stats, but now there is something better.
Swype is a function for the Android phones which lets you input words by dragging your fingers across the keyboard instead of tapping. While newer phones have this feature, some older phones may not. This tutorial shows you how to equip your Android phone with Swype.
Aimed at Flash developers who like making games or other applications, this tutorial shows you how to use keyboard mapping so users can control the game using specific keys. This is also useful for photo galleries or slide shows, so users can navigate using their keyboard.
Looking for a primer on how to get started recording audio using your home computer (without shelling out the money for an expensive USB or FireWire interface)? This home-computing how-to from the folks at CNET TV is here to help. For specifics, and to get started recording audio using the built-in inputs on your own Windows PC or Mac, watch this free video guide.
In this Photoshop video tutorial, hosted by photoshopuniverse, from Free Photoshop Video Tutorials, you will learn how to create an effect that makes it appear as though text you input into your image has been embossed on a glass surface. As you follow along with the host in this video, you will learn how to insert text, and align it to a plane, so that it will appear to be aligned to the surface you want to place the text on, as well as how to achieve the embossed look when you're finished.
See how to build a pulse motor with just one transistor and one diode.
Watch this video to learn an easy and inexpensive way to make an iPhone headphone adaptor. Once you make the adaptor, you can use any set of headphones or even a car input jack.
You can connect your Nintendo Wii Wiimote to your PC using GlovePie input emulation software and a bluetooth connection. Learn how to program your PC to calculate distance using the Wiimote's infra-red (IR) sensor.
In this tutorial, we learn how to add iTunes songs to Movie Maker without a CD. First, open up Windows Movie Maker, then click on the narrate timeline icon. After this, change the audio input source to "wave out mix". Make sure the input level is set at its lowest. Then, leave Windows Movie Maker open and open up iTunes. Find the song you want to import, then create a playlist if you would like. From here, drag your songs onto Movie Maker and then press play. Once you do this, you will be abl...
It's easy to record an audio track with Pro Tools! This tutorial walks you through everything you need to know to set an input channel, establish a level for your instrument and setting up record. You're also shown how you set up loops and cycles when recording.
You can instantly get audio onto your iPad using a few extra hardware accessories to plug in a USB microphone, which allows you record audio input. Then you can use several apps directly on the iPad to start editing and creating your own audio content.
Send text messages, conduct Google searches, play music, get directions and even send emails (complete with emoticons!) using the voice actions function available on your Android phone. This tutorial demonstrates this awesome new voice input functionality for your Google Phone.
This clip demonstrates how to get video and images into the node-based compositor in Blender using the RenderLayer and the Image input nodes. 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!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 37th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a table of formulas and labels based on formula inputs in an assumption area.