Primary Key Search Results

How To: Create a Pareto chart for categorical data in MS Excel

If you want to create a Pareto Chart for categorical data in MS Excel you should first have your data input into Excel already. From your data, you should highlight the cells that you want to count the frequency for and in the frequency box you should type in =COUNTIF and highlight the data you want the frequency for and put in F4 and then press , click on cell to the left and click enter. Now this will work all the way down. If you have not sorted it, you can right click and then click sort....

How To: Apply four styles of lighting

This video tutorial will show you how to apply four styles of lighting. This video teaches you how to apply four styles of lighting, namely Rembrandt, Beauty, Cameo and filling in from the Key Side. You will learn about high contrast lighting schemes, dealing with the amount of contrast used to highlight a person's face, as well as spotlight effects, and how these tend to draw the viewer into the scene. You will be shown how the Rembrandt Lighting setup contains three steps, namely taking a K...

How To: Use the F shortcut key in Photoshop

Do you even know what the F key does? or what it stands for? We'll give you a hint - it helps you toggle between the different screen modes like full screen, standard screen, and maximized screen. So check out this Photoshop tutorial and see how to use the F shortcut key.

How To: Use the smart key for the 2010 Toyota Prius

In this video, we learn how to use the smart key for the 2010 Prius. You can use this just like any other keyless entry system. Press the lock button to lock the doors and the unlock button to unlock the doors. When you press unlock once it unlocks the drivers door, if you press it twice within 3 seconds, it unlocks all the door. After 60 seconds, the Prius will automatically lock itself. Press the red alarm key if you need to draw attention to yourself in an emergency situation. Make sure yo...

How To: Figure out the key signature of a piece of music

Knowing music theory never hurt anyone—not Bach, not Chopin, not Schoenberg. Even if you fancy yourself a musical iconoclast, the better you know the rules of music, the better equipped you'll be to break them down the line. In this free video music theory lesson, you'll learn how to determine the root or "home" key of a song. For more information, including a very thorough overview, watch this helpful musician's guide.

How To: Create and use custom shortcut keys in Photoshop CS4

Assign custom shortcut keys to your most commonly used Adobe Photoshop CS4 functions to help speed up your workflow. Whether you're new to Adobe's popular graphic editing program or a seasoned design professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.

How To: Set key frames in the Nuke 5 node compositor

Learn how to use set key frames (or keyframes) working in Nuke 5. Whether you're new to the Foundry's popular node-based compositing application or a seasoned post-production professional just looking to better acquaint yourself with Nuke 5's new features, you're sure to be well served by this video tutorial. For more information, including a detailed overview, watch this free video guide.

How To: Operate the Blackberry 8330

Learn how to operate the latest Blackberry 8330 in simple steps. Follow the steps below to overview the Blackberry 8330: 1. First switch on your Blackberry by pressing the power button on its top. 2. Use the 'Trackball' to navigate around the menu options and press it to select an option. 3. The 'Send' can be used to call a contact, the 'Menu' key opens a list of options, then the 'Escape' key is used to end an application and the 'End' key is used to end a call. 4. You can find on the left s...

How To: Upgrade the Pioneer MEP-7000 Firmware 2.02

Go to DJTUTOR computer where you can download the latest firmware for free. Once downloaded you need to either burn it to a CD-R or use a USB key. Unzip the file and download it to a fat formatted USB key with nothing else on it. The firmware upgrade consists of two files. Eject any disks from the MEP and remove any USBs and make sure the unit is turned off. Next insert your USB key and push and hold USB 1 and USB 2 and turn on your unit. The MEP will then tell you when the firmware is comple...

How To: Adjust the neck on an electric guitar

Step by step tutorial video on adjusting the neck of your guitar. First you need to remove the truss rod cover to gain access to the truss rod. Make sure you have the correct Allen key when adjusting your truss rod. If your guitar came with it's own Allen key make sure you use that one. Put a capo on the first fret. To increase the tension on the truss rod turn the Allen key to the right. To decrease the tension turn it to the left. Always check the gap between the frets and the strings.

How To: Create a jumping letters animation in Flash

This video describes how to create a jumping letters in Flash, first create the text for example "JUMP" and using Break the letters each and then make the layer and now convert the letters into "Movie clips" and now we should add the key frames to our "time line”. Then moves the letters up by using the up arrow now copy the key frames from font end and paste on the back again for go up and come down the letters again and add the "motion between" for each letters and now skip the key frames by...

How To: Create a cool image animation using mask in Flash

This tutorial will show you how to create a cool image animation using mask in Flash. First lets import image file and now lets create a new layer. Choose oval tools and now lets draw a shape just outside our scene. Then go to frame 30, and add the key frame and select transform tool. Now lets re-size our shape and go to 50 frame and add the key frame. Then go to frame 80 and add the key frame, re-size our shape and use free transform tools. Now lets create shaped in frame over 30, 50,and 80 ...

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: Create a black & white mask animation in Flash

In this flash tutorial the instructor shows how to make a black and white mask animation. To do this, first start by importing your image into the flash tool and bring it on to the scene. The image should be wider than the scene. Now select and distribute the layers. Now convert those images into movie clips. Now go to frame 80 and add all frames. Get back to the first layer and create a shape that is the your mask. Now go to frame 40, select key layer and add free transform tool. Now, mask t...

How To: Spring bump locks

This is a great spring bumping demo from UK Bump Keys. Spring bumping involves inserting a spring over a bump key to disledge the mechanisms in a lock. This is a locksmith and lockpick demonstration.

How To: Increase and decrease application font size in OS X

Wouldn't it be handy if, while running Mac OS X, you could enlarge some of the fonts and applications like Mail or Safari? Some of those fonts can be relatively small. All you need to do to increase font size in an OS X application is to press the command, shift and plus keys. To make a font smaller, in turn, all you need do is press the command, shift and minus keys. For more on using these key commands to obviate the need for squinting, watch this Apple tutorial.

How To: The Simple Way to Enable Caps Lock on Your iPhone

When you need to type in all caps on a computer, you just press the "caps lock" key. But no such key seems to exist on iOS. The "shift" key appears to work at first but will deactivate once you type one capital letter. Holding down the shift key while you type gets the job done, but it's a pain. While it might not be obvious, enabling caps lock is actually really simple.

How To: Fix the 'Number Changed to Primary' Bug on Your iPhone

The iPhone XS, XS Max, and XR aren't the newest devices from Apple Inc., but all three have a serious problem in Messages. When sending a friend an SMS/MMS text rather than an iMessage, the phrase "Number changed to Primary" appears in front of every message. What gives? If this issue is driving you mad, there are a few tricks that may exterminate the bug until Apple gets around to issuing a patch.

How To: Use U2F Security Keys on Your Smartphone to Access Your Google Account with Advanced Protection

Security-minded users can reduce the risk of phishing by enabling Advanced Protection on important Google accounts, requiring a U2F security token to log in. Using these keys isn't intuitive on most popular smartphone platforms, and you can find yourself locked out if you don't plan ahead. You'll need to learn and practice using U2F keys on your device before enabling this layer of security.

Hack Like a Pro: Cryptography Basics for the Aspiring Hacker

Welcome back, my rookie hackers! As hackers, we are often faced with the hurdle of cryptography and encryption. In some cases, we use it to hide our actions and messages. Many applications and protocols use encryption to maintain confidentiality and integrity of data. To be able to crack passwords and encrypted protocols such as SSL and wireless, you need to at least be familiar with the concepts and terminology of cryptography and encryption.

How To: Clean your Mac computer keyboard

In this video, we learn how to clean your Mac computer keyboard. You will need to have iKlear and iClean to do this, along with a microfiber cloth. To start, you will take off the tops to each of the keys one by one. After you remove one, you will place the cloth over the top of it and then spray it. From here, you will clean the key off and then replace it back on the keyboard. After this, repeat for each of the keys until you have cleaned the entire keyboard. Give it one final wipe and then...

How To: Play the harmonica in the key of G

In this video from pazzmanmusic we learn how to play the harmonica in the key of G. Draw on the 1, blow on the 2 and blow on the 3. Then draw on the 3. A bit of a bend draw. Then walk it down by drawing on the 2 and then drawing on the 1. Then he goes on to play a riff where he blows on the 1 and 4 holes and covers the 2 and 3 with his tongue.

How To: Text message with the Blackberry 8330

In this tutorial we learn how to text message with the Blackberry 8330. Start on the main menu and then click on the messages icon. From here, you will click on the menu key on your keyboard. From here, scroll down and choose the "compose sms" selection. Next, you will choose who you want to send the message to from your contacts, or choose a number you want to send it to just one time. After this, you will type in your message. Once you're done typing in your message, click on the menu key a...

How To: Make a call on the Samsung Galaxy I7500

In this video, we earn how to make a call on the Samsung Galaxy I7500. From the home screen, tap on the dialer screen, then tap on the dialer tab. From here, enter in the phone number you want to call. Then, press the dial key after the number has been entered. To end the call, press the menu key and then press the end call button. If you wish to call a contact, tap the dialer key and then tap on contacts on the top menu. Tap on your contact that you want to call, then tap on call mobile to c...