A non-CPU lens is one which does not have contacts on the rear mount, meaning it communicates with the rest of the camera solely through the aperture. This tutorial shows you how to set up the lens data for your camera, so you can get the most out of your non-CPU lens.
You are typing along and you notice one of they keys on your keyboard isn't responding like it should. It is common to get a stuck key and you won't need to take your keyboard to fix this problem. You can do it right at home.
This video demonstrates how to reformat a hard drive and perform a clean installation of Windows XP operating system. The tutor first advises to make a back up of everything, including the drivers and my folders. He explains various methods by which one can take the backup of the data in a system. Now he shows how to format the C drive where you can now install Windows. He also shows software that is used to take the backup of important data before formatting. This video shows how to reformat...
Learn how to set up Internet on iPhone clones with this video. *First thing you need to do is to make an AT&T GPRS data account.
In this 15-part video guide, you'll learn how to retrieve keys locked inside a car, use tools to unlock a car without a key, and prevent car theft, taught by an expert locksmith.
In this Silverlight web application tutorial you will learn how to create a basic stock quote application that updates in Realtime. You can apply this ASP.Net backend application to any realtime data update application you need to make. All you need is Silverlight to get you started.
If you've ever entered a lot of data into an Excel spreadsheet before, then you know that putting together even one spreadsheet is a pain in the butt. So if you are required to place all the data on one spreadsheet onto another spreadsheet, don't slave away for hours copying and pasting.
This screencast tutorial from Matthew MacDonald, author of Access 2007: The Missing Manual, shows you how to use pivot tables to analyze data in Microsoft Access 2007.
Are you 100% sure that all of your data is gone? Use Darik's Boot and Nuke to completely wipe a hard disk of all data.
This video shows you how to use Windows Task Manager to restart your computer without losing any data.
The greenscreen has allowed filmmakers to take us to worlds they never could have otherwise, but they can ruin a movie when used poorly. Watch this video for a guide to picking a screen, lighting it, and getting a good key for it using Final Cut Pro or After Effects.
In this video, we learn how to play "Here Comes the Sun" by The Beatles. Start out with your hands across the piano with your fingers around the A, E, and C keys. Start off by playing the melody so your fingers can get a feel of how the different keys are played. Go slowly doing different sections of the song, then put it all together. There will be D and F# keys being played, but those will come towards the end of the melody in the song. Once you learn to put all the key together, you can pl...
Want to add location data to posts on a self-hosted WordPress blog or website? This clip will show you the way. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
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 650th installment in their series of digital spreadsheet magic tricks, you'll learn see how to take all records from a data set and place them into one column using the INDEX, INT, ROWS and MOD 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 655th installment in their series of digital spreadsheet magic tricks, you'll learn see how to create a statistical frequency polygon using a line chart. Also see how Excel mistakenly interprets number category label data as Number Series data.
In this video tutorial, viewers learn how to find hidden task-bar shortcuts in Windows 7. Begin by pressing the Windows and T keys on the keyboard. The will focus on the task-bar, allowing the user to navigate through using the arrow keys. Users will be able to move between different icons. If the application has a window open, it will show the thumbnail. Then press the up arrow key to sort through the thumbnails. Press the down key to focus back onto the task-bar. This video will benefit tho...
You might be confused when using Swype and need to use punctuation marks. Have no fear! It is actually quite easy. Swype is a revolutionary new app that is available for lots of newer smartphones that allows you to type messages without ever lifting your finger from the keypad. You literally "swype" from letter to letter. Check out this clip for info on how to include proper punctuation marks in your texts.
Swype is a cool new app that you can use on tons of phones to improve your texting and e-mailing speed. In this tutorial, learn what to do when you hit a word that requires an apostrophe so that you don't slow down your typing!
Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to write data to an external file when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
You know that moment of slow motion when you realize your keys are still in the ignition while the car door is closing? If you've accidentally locked yourself out of your car, check out this tutorial.
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 36th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate a trimmed mean, which is used when there are extreme values in the data set that might skew the mean.
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 39th installment in his "Excel Statistics" series of free video lessons, you'll learn about variability (or dispersion or spread). Create an X-Y Scatter Diagram chart showing data points and the mean.
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 25th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data percent & relative frequency distributions with pivot tables. Also see how to create a histo...
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 22nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a percent (%) cumulative frequency distribution with formulas, a histogram and an ogive chart. See how to add ...
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 15th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use create a frequency distribution, relative frequency distribution, percent frequency distribution and pie chart wi...
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 351st installment in their series of digital spreadsheet magic tricks, you'll learn how to create an area chart for x and f(x) data as well as how to use the IF function to show a second data set plotted to show a specific area section.
Tinkernut demonstrates how to hook up your exercise bike to Google Maps. Using a stationary bike can be good for your health but it can also be boring. You can spice up your exercise regiment by using Google Maps. You will need a USB keypad with arrow keys, a magnetic contact alarm with wires, soldering equipment, an exercise bike and a laptop computer. Connect the contact alarm to the up arrow key on the keypad by opening up the keypad and connecting the wires to the up arrow key by solderin...
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 183rd installment in their series of digital spreadsheet magic tricks, you'll learn how to sum revenue from a table of data by year and month using the SUMPRODUCT, TEXT, SUM, IF & LEFT functions in an array formula.
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. With this video tutorial from ExcelIsFun, the 308th installment in their series of digital spreadsheet video tutorials, you'll learn how to extract data to a new workbook by array formula. Functions used include IF, ROWS, INDEX, TEXT, ROW and SUMPRODUCT.
Want to learn how you can make some awesome YouTube videos of your own? Maybe your own Internet show or maybe even a short indie film... well, one way to make things easy is a green screen. This two-part video tutorial will show you how to make your own green screen studio and key it out. With a green screen, a YouTube show with special effects is easy!
Have you ever locked your keys inside of your car before? I net you have, you've felt the frustration, you've felt the pain, but don't pull out that cell phone just yet... you don't need a locksmith.
In this video tutorial, Chris Pels shows how to create a custom profile provider to store and retrieve data associated with a user profile in SQL Server tables separate from the standard ASP.NET membership provider’s aspnet_Profile table. The principles covered in this video will apply to creating profile providers for other databases like Access and Oracle. After learning how to create the custom profile provider we learn how to install the provider in a web site and see a demonstration of l...
Given how glued we are to our computers these days, we're surprised we're not replacing PC and laptop keys on a monthly basis from all the wear and tear. If you've got a key/button that has kicked the bucket, it's best to replace it with a new one.
If you're reading this, you're likely a tech-savvy coding pro whose analytical talents are mostly applied to designing apps, cracking passwords, and infiltrating networks — all of which are admirable activities for both aspiring and seasoned white hat hackers. But there are other profitable ways that you can put these types of skills to use, namely in the world of investment and trading.
Many popular apps automatically share your personal data. While I have accepted a certain amount of data collection from Google, to know companies such as Facebook perform this without my consent bothers me. After some researching, I've found a great solution, and it doesn't require root.
While keeping your iPhone out of the bedroom might help to avoid unnecessary distractions before bedtime, it could be better served right by your side to help diagnose sleeping issues you may be experiencing each night.
Before you can dive into customizing your OnePlus 6T, you must take the initial step of unlocking the bootloader to gain the ability to install TWRP, Magisk, custom ROMs, and other mods.
Encrypting payloads and encoding stagers are more effective against macOS than one might think. It's very easy to evade VirusTotal and macOS antivirus software using a few simple tricks.
While many of the latest content partnerships announced by Magic Leap appear to lean towards entertainment and gaming, a new partnership with medical technology provider Brainlab has Magic Leap getting down to more serious business.
Project Fi, Google's MVNO, is running a new promotion on the latest and greatest from LG. From July 16 until the 29th, whenever you order and activate the LG G7 ThinQ or LG V35 ThinQ, you will receive a $300 service credit. When you do the numbers, that equals a minimum of three free months of service.
