Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
3D Touch is only available on the 6s and 7 series iPhones right now, and likely future models, so those with older devices are missing out on all the cool "Quick Actions" available for app and settings icons. But the new iOS 11 is finally bringing some of those helpful shortcuts to iPhones without 3D Touch built in.
Check out this flute lesson on breathing techniques by Nina Perlove who teaches at Northern Kentucky University. This unconventional breathing method was taught by Alain Marion in Paris. The end goal is to allow your lungs and chest cavity to expand. You will have more breath control when playing the flute with the technique shown in this video.
To keep your city in CityVille thriving, you will need to make sure it is constantly expanding. This tutorial shows you the best and most efficient ways to expand your city. Expansions can be expensive, but they are worth the investment in the long run.
In this video director David Lynch (Mulholland Drive, Twin Peaks, Inland Empire) explains his method for focusing and expanding his consciousness in order to go deeper into the creative process. He explains that consciousness needs to be expanded in order to capture ideas 'deep down' in order to catch what he calls the 'deeper fish' of consciousness. A fascinating video, David Lynch certainly has some unique ideas about how to expand your mind!
How is it even possible to expand your shoe collection without actually buying new shoes? Well, it's not so much expanding as redoing your old, plain shoes. If you've got some uniformly colored black, brown, or even red heels that need some new life, check out this video for tips on how to add small DIY touches.
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to use Protoss Warp Gates and Warp Prisms to control massive section...
This Blender tutorial discusses how to set up action contraints, where you can use a bone to control things like finger curl/expand, or something more advanced, like facial expressions. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including ste...
For the majority of phones, Android's volume rocker is wrong. A large vocal part of the Android community wishes the volume buttons' default control was the media volume, not the ringer. Although the Galaxy Note 9 is in the "wrong" camp, Samsung has included multiple ways to change it.
Ever-shrinking bezels and disappearing hardware buttons make for good looking phones, but they also increase the need for gesture controls. Android Pie comes with seven new swipe gestures, but if you don't have the update yet (or find its default gesture options to be lacking), you should take a look at the Microsoft Launcher.
Jeff Schell walks you through, step by step, how to create a handful of different track mattes in Premiere Pro CS3. Schell discusses where you can apply a track matte, how to expand it, how to apply and expand a blur, and what track you want to borrow the shape from. He also shows us how to apply a track matte with a title, and details the effects of a luma matte.
AirDrop is an underrated feature that lets you to quickly transfer files like songs and photos via Bluetooth and Wi-Fi from your iPhone to Macs and other iOS devices. It's been a staple in the Control Center ever since iOS 7, prominently displayed for easy access. However, with iOS 11, that quick access to AirDrop has seemingly disappeared.
Back when 4.1 Jelly Bean came out (boy, how time flies), Android introduced expandable notifications. Depending on the notification, a simple swipe down with your finger could expand it and show extra content, like Delete and Reply buttons for Gmail messages.
This is an educational video from The Free Math Tutor which explains how and why should we expand fractions. This video is basically for kids who have just been introduced to fractions in mathematics.
This is a cheat-free tutorial that shows you how to expand your land for your city in the Facebook game CityVille. It's quite easy - now you have more room to build business and houses to keep your city running!
In this clip, you'll learn how to browse, read and expands tweets on the new version of Twitter. It's easy. So easy, in fact, that this video tutorial can present a complete, step-by-step overview of the process in just under two minutes. For more information, including detailed, step-by-step instructions, take a look.
This how to video shows you how to do a live trace in Adobe Illustrator. First, open the image you want to use. From here, zoom out. Go to the corner of the image and hold shift and drag to shrink it. Zoom back in and then click the arrow beside Live Trace. Go to tracing options and click okay. Check ignore white so that you will not get a box. Click trace and then select expand. Click out of the image and click control y on your keyboard to show the outline of your file. If you did not check...
ArabicPod101.com presents Video Vocabulary, a video and audio tool to assist you in improving your understanding of the Arabic language. This video will help expand your Arabic vocabulary. Follow along with the language lessons in these videos and you'll be speaking Arabic in no time.
With the economy looking more sour than Lindsay Lohan at her latest party, finding a job means exploring every avenue possible. This means thinking about doing job training to both expand what you know and to possibly work in a field you never considered before.
This quick video guide will show you how to expand your virtual memory. Do the following steps to expand your virtual memory: Go to Start, select My Computer, then Properties. Click the Advanced tab, and under Performance hit Settings. Go to Advanced Settings, and under Virtual Memory hit Change. Change your Virtual Memory size here. Hit Set, OK. Restart computer for the new settings to take effect.
Back when we took chemistry, most of what we read and learn went in one ear and out the other. If only we had a cool experiment like this one to perk up our pubescent ADD.
Microsoft recently made it possible to use a USB memory stick to expand your storage capacity. You'll want to watch this video to check out how it's done. Basically, you're going to need an Xbox 360 game system, and a USB flash drive with at LEAST 1G storage capacity. Under that and it won't work. The system will format the memory stick first, so make sure it doesn't have anything important on it. Go for it gamer! Oh yeah, this is also a cheap way to expand your storage too.
As you test out the new Quick Settings media controls in Android 11 and form an opinion, you'll notice one of the changes they made to the player besides the new location. For example, when you swipe away the mini version of these controls, the music keeps playing and the player still appears in the expanded view.
To create glossy or reflective vector image, you will need to know how to use the offset options in Adobe Illustrator and the basics for pathfinder. You will be creating a vector image that can be resized without hurting its quality. To start select you text style, which be glossy for this. You will have first a white layer, a shadow, a radiant layer, a white outline and a shadow going underneath. In this video the Oh Gizmo Logo! is being used as the template. Right click create outlines. You...
If you want to know how to use the web browser on your Nokia N97, you should watch this video. On the home screen, tap the Web icon. Bookmarks screen appears. On the right side of the screen there are icons present namely: Exit, Add Bookmark, Go to Web Address, Delete, and Options. Type in your desired URL and tap Go To after tapping the Go to Web Address icon and a URL textbox appears at the bottom. Wait for the webpage to load. If you want to display some options, tap the Expand Sidebar ico...
This video shows you how to expand your RAM in an Asus EEE PC in less than 3 minutes to 2 GByte RAM using 1 Kingston KVR667D2S5/2G Modules, which costs about 50 bucks ..
This 4 part video series is a gift from me to all the other singers out there who have shown me such great love and support. It contains a full vocal warmup that will improve tone, expand range, and increase control. This is pretty much the kind of warmup that I might do with a private client, but it's for you guys - free of charge.
This video will show you how to insulate an exterior door or window frame using Great Stuff expanding foam insulation. Easy to use, works great for sealing out the elements.
Learn how to create a drop shadow that runs along your site, and, if your site expands, expands with it! Start in Photoshop to create a nice little drop shadow graphic and then head to Dreamweaver for some fun with CSS and divs. Looking for an easy way to create 3D shapes? Have Photoshop CS3 or later? Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from TutVids.
Posture plays a huge role in your entire respiratory system. Enabling your body to have good psture can increase breathing and really help expand your lungs. This video will demonstrate exactly how to improve lung capacity with a posture breath excersise.
It was extremely simple in iOS 10 to switch your iPhone's display to warmer colors at night, but iOS 11 buried the "Night Shift" toggle for some reason. So don't beat yourself up if you couldn't find the setting right away.
If there's one gripe I have with Android Lollipop, it's the new volume menu. When Priority mode was introduced, the stock volume panel was revamped to accommodate it, and somewhere along the way a bit of functionality was lost.
iOS 5 introduces an incredible feature that isn't very well known called "Shortcuts." It allows you to use automatic text expansion for whatever abbreviations you want. This is a great way to type several letters into your iPhone, iPad, or iPod touch and have them immediately expand into whatever phrase you want. Find out how to configure text expansion in this guide.
LittleBigPlanet 2 has expanded the prodigious level editor from the first game into a powerful and complex new form, and you probably need some tutorials to learn about it's many features. This video will teach you about some of the game's advanced logic features, including toggle, counters, timers, random, direction splitter, direction combiner, selector, sequencer, and controllinator.
This video shows how to softmod your slim, PS2. You'll need to crack open your case and be comfortable with the insides of your machine. Take your time and follow the instrutions to soft mod your Sony slim PS2 and enjoy the expanded goodness. This will let you unlock your PS2 to play games if you copy them from somewhere else.
Get wide-angle and fish-eye effect for about $5 with this DIY lens attachment. Expands your camera's viewing angle up to 200 degrees. Great for tight-quarters indoor shots, stunning landscapes, and funny fish-eye photos. Amazing results. For use on photo and video cameras.
This how-to video will help you expand your iPod library. Rockbox turns your iPod into a FLAC- and OGG-playing, open-source monster. Learn how to install this custom firmware on your iPod to enable it to play all sorts of audio file types and even games. Watch this video tutorial and learn how to free your iPod with Rockbox.
Here they are used to find anime episodes and movies, but you can use advanced Google commands to perform more dynamic searches on Youtube. Learn how to narrow or expand your searches and search for multiple items simultaneously.
Mikey shows you how to use the cyclic controls on a 6-channel helicopter radio controller. Cyclic controls move a helicopter forwards and back, as well as side-to-side. If you're comfortable with using the rudder controls, you're ready to move on to the cyclic control, usually found opposite of the rudder controls on the radio controller. The control is easiest to use while the helicopter is in the regular orientation, with the tail pointed towards you. Mikey also demonstrates how to use the ...
In this video tutorial, viewers learn how to do a liquid nitrogen experiment. The materials required for this experiment are liquid nitrogen and film canisters. This task is very easy, fast and simple to do. Begin by pouring the liquid nitrogen into the film canisters. Then quickly place the film canister lids on. The liquid nitrogen will eventually become a boiling gas and expand about 700 times. Because of the expanding, the pressure will build in the canisters and result in popping lids. T...