Shift Resources Search Results

How To: Disable the True Tone Display on Your iPhone 8, iPhone 8 Plus, or iPhone X

The new iPhone 8 and 8 Plus models come with a gorgeous Retina HD display with Apple's True Tone technology, which automatically adjusts the white balance on the screen to match the ambient light around you. The iPhone X also has True Tone built into its Super Retina HD display. However, if you're coming over from any previous model iPhone, it may look a little strange in some situations.

How To: Adjust the front derailleur on a bicycle

If you bike is shifting poorly, you may need to adjust your front derailleur. That's not good, because the front derailleur is not the easiest part of the bike to adjust. Fortunately, this video is here to help. It will show you how to adjust your front derailleur, restoring the smooth functionality of your transmission and ensuring that you continue to have good rides.

How To: Create a basic array formula in Microsoft Excel

Looking for a primer on how to create and work with arrays 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 very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel.

How To: Multiply matrices with the MMULT function in MS Excel

Looking for a primer on how to create and work with array formulas 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 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Do time calculations with Microsoft Excel's MOD

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 286th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate hours worked for a night shift where workers start at 9 PM and end at 5 AM.

How To: Begin drawing human poses

Watch this instructional video to begin drawing figures in realistic poses. Ask yourself, what are these people doing? Human figures are constantly shifting balance. For instance, an elbow should relate to a knee. The human expressions do not have to be anatomically perfect as long as they relate to the other objects within the space.

How To: Close your golf stance to cure a golf pull shot

In this video tutorial, viewers learn how to close the gold stance to cure a golf pull shot. When starting the swing, do not turn your body before you shift. This may be called spinning out. This will make the club go outside, before going down to the ball. Therefore it creates a left swing that will curve around the pole. When swinging, move the weight from your left heel to your right toe. This will cause the user to shift forward straight swing. This video will benefit those viewers who en...

How To: Recover deleted podcasts on iTunes

Veronica Belmont from Tekzilla shares a tip for finding lost podcasts without unsubscribing and resubscribing to the feed. To do this by a simple keyboard combo fist close the disclosure triangle so that the individual episodes are hidden, then hold down the 'Option key' in Mac or 'Shift' in Windows and toggle the disclosure triangle as shown. The iTunes feed will refresh and all the past episodes will reappear. Combine this with the "Get All" button to find lost podcasts.

How To: Fix a bicycle tire innertube

Lear how to replace your bike's inner tube! Remove wheel from bike. Quick release on front is easier. If you have wheel nuts you'll need some tools. Shift derailler to slack chain, then it's easy. Use a tire lever to take the outer tire. Feel along the tire to locate the puncture site.

How To: Create a material resource in Microsoft Project 2010

In this clip, you'll learn how to create a new material resource when using MS Project 2010. Whether you're new to Microsoft's popular project management application or are just looking to better acquaint yourself with the Project 2010 workflow, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.

How To: Pitch underhanded

Sometimes you will have to pitch underhand - whether you are playing softball, baseball or with little kids - sometimes a lighter throw is necessary. It may seem odd and unnatural to pitch this way at first, but check out this tutorial for tips on how to toss that ball over the plate with the same force as upperhand pitching.

How To: Do an arm roll dance with Tabitha Lupien

Watch this video to learn how to do the arm roll dance with Tabitha Lupien. 1. Put your arms bent at a 90 degree angle and as fists. 2. Next pop your right shoulder out. Then shift your left shoulder out, but as you shift the left out dip your knees to lower. After doing so, you pop your right shoulder back out. 3. Now when you rise, you shift your left shoulder back to the left and pop your right shoulder to the right and the end. 4. Next your arm rolls back behind your head, then rolls back...

How To: Install a front derailleur on a bike

If you've ever installed a rear derailleur, you know how hard that is. You probably also know how relatively easy it is to install a front derailleur. If you don't, watch this video. It explains how to quickly and easily install a front derailleur on your bike, keeping your chain straight and ensuring good shifting performance for you bike.

How To: Adjust the front derailleur on a mountain bike

Unlike rear derailleurs, which are very complicated and come in at least two very different styles, front derailleurs are pretty standard across manufacturers. That means you only have to watch this one video to learn how to adjust them! It features a professional mountain bike mechanic walking you through the adjustment process. This ensures proper shifting and chain flow, which will keep you on the bike and riding smoothly.

How To: Put together a tool kit for your home

The most important items in a tool kit, are the protection and safety equipment, like a breathing mask, ear muffs, and eye goggles. Other than that, tools vary on your needs. Some basics are a handsaw, a hacksaw, a level, a hammer, screwdrivers, a measuring tape, a shifting wrench, a chisel, pliers, a combination square, a utility knife, and a clamp. Watch this video home improvement tutorial and learn how to select tools for a basic tool kit.

How To: Change a flat tire when cycling

Flat tires are inevitable, so it's important to be prepared. Learn some tricks that will simplify the process and save you time. Check out this instructional cycling video that demonstrates how to change a flat tire when cycling. Just follow these simple tips: shift into smallest gears, check for sharp object in tire, use sandpaper to roughen rubber, let glue dry 2-3 minutes before applying patch, make sure tire doesn't pinch tube.

How To: Use the section tool in Google SketchUp

Take a look at this instructional video and learn how to use the section tool in Google SketchUp. This tutorial covers how to create cut-away views of your model in any direction, the context options for the section plane, and how to move and rotate the section plane. You can lock the section orientation by holding the "Shift" key.