Largest Library Search Results

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Boost volume on your iPhone/iPod

In this video tutorial, viewers learn how to boost the volume on an iPod Touch or iPhone. Begin by opening the iTunes program and select all the songs in your library. To select all the songs, simply press the Control and A keys. Then right-click and select Get Info. When a window pops up, click on Yes. Now click on the Options tab and set the Volume Adjustment to 100%. Finish by click OK. This video will benefit those viewers who have an iPod device, and would like to learn how to boost the ...

How To: Burn a CD from a playlist in iTunes

This video teaches the secrets of burning a CD from a playlist in iTunes in simple steps. First open the iTunes, click 'File' and select 'new playlist'. Now click 'music' and go to your library to select the songs to add to your playlist. Now click and drag the songs of your wish to your playlist. Insert the empty disc, right-click on your playlist and select 'burn to disc'. Change the options if necessary, click 'burn' and then press 'OK' to start burning your disc.

How To: Change the Snow Leopard dock

Change your Snow Leopard dock on Mac OS X with this video tutorial. Go to Leopard Hard drive -> System folder -> Library folder -> CoreServices folder -> Dock App (right click) -> Show package contents -> Contents folder -> Resources folder -> Scroll down until you get to Scurve-1.png, Scruve-m.png, Scurve-sm.png, Scurve-xl.png -> Highlight them all and delete them -> Select the dock you want to change it to -> Paste the files into the place that you deleted the others -> Search for "Terminal...

How To: Get a copy of a birth certificate

Loose your birth certificate? Or, need to get a copy of someone else's, like your daughter or son? Don't fear. In this how-to video learn the steps needed to be taken in order to obtain an additional or duplicate copy of your birth certificate. Before you get started you will need basic information on the person and Internet or library access. Good luck!

How to Do the Ragtime Dance: The Maxixe (1st Step)

An American Ballroom Companion presents this social dance demonstration from the Library of Congress. Watch this demonstration traditional dance video on the Ragtime Dance: The Maxixe (1st Step). Not for beginners - this is not an instructional, step by step video. It is an authentic, professional demonstration of the Ragtime Dance: The Maxixe (1st Step). The Maxixe is an Africanized polka or two-step dance, an Afro-Brazilian styling of the polka which was brought to Brazil by European immigr...

How to Do the Ragtime Dance: The Maxixe

An American Ballroom Companion presents this social dance demonstration from the Library of Congress. Watch this demonstration traditional dance video on the Ragtime Dance: The Maxixe. Not for beginners - this is not an instructional, step by step video. It is an authentic, professional demonstration of the Ragtime Dance: The Maxixe. The Maxixe is an Africanized polka or two-step dance, an Afro-Brazilian styling of the polka which was brought to Brazil by European immigrants.

How to Do the Ragtime Dance: Argentine Tango

An American Ballroom Companion presents this social dance demonstration from the Library of Congress. Watch this demonstration traditional dance video on the Ragtime Dance: Argentine Tango. Not for beginners - this is not an instructional, step by step video. It is an authentic, professional demonstration of the Ragtime Dance: Argentine Tango. Argentine Tango is a dance which originated in Argentina and then move to Uruguay. In the US it is known as Ballroom Tango.

How To: Do the Ragtime Argentine Tango (1st figure-feet only)

An American Ballroom Companion presents this social dance demonstration from the Library of Congress. Watch this demonstration traditional dance video on the Ragtime Dance: Argentine Tango (1st figure-feet only). Not for beginners - this is not an instructional, step by step video. It is an authentic, professional demonstration of the Ragtime Dance: Argentine Tango (1st figure-feet only). Argentine Tango is a dance which originated in Argentina and then move to Uruguay. In the US it is known ...

How To: Manage panoramas and HDR photos in Lightroom

Managing Panoramas (henceforth known as panos) and HDR photos in Lightroom is an important step in making your life a lot easier if you like that type of photography. What happens after shooting a lot of either type of photography is that your library becomes really cluttered. As if the clutter wasn’t bad enough, it just becomes flat-out difficult to start processing these types of photos. So instead of ditching Lightroom when you shoot at pano or HDR set, check out this week’s video and give...

How To: Read a Book Faster Than You Can Eat Lunch with 12min's Massive 'Microbook' Library

Reading is as gratifying as it is time-consuming, the more you put it off, the bigger your to-be-read stack gets. Eventually, that stack will become a shelf, then a case, and then even if you want to read, who has the emotional fortitude to pick just one from all those unread books. With 12min Micro Book Library: Lifetime Premium Subscription you can read an entire book from start to finish in 12 minutes without losing any of the meaning, and it's on sale now for $39.

How To: Save Your UltraViolet Movies Before They Shut Down in July

At one point, UltraViolet was the go-to way to maintain a collection of digital movies. Fast-forward to 2019, and things are different. The service is shutting down on July 31, largely due to the massive competition in the digital movie marketplace. If you're an UltraViolet user, don't worry too much, because you can save your movie library — as long as you act before UltraViolet closes its doors.

How To: This Shortcut Lets You Download YouTube Videos on Your iPhone Straight from the Source, No Shady Services Needed

If you've ever wanted to download YouTube videos directly to your iPhone, there's an easy solution — just update to iOS 12 and install Apple's new Shortcuts app. With the Workflow-replacement app, you can add a shortcut that lets you download any YouTube video you want, without needing to jailbreak or use shady third-party tools.

How to Train Your Python: Part 1, Introduction

Recently I've been looking around our wonderful community and I've seen some absolutely hands-down fantastic python scripting articles. But, in the end, these series weren't very extensive. I've been wanting to do a series on teaching python for a while now, and I don't mean just the basics, I mean to make an extensive series that takes it all the way from "Hello, World!" to popular third party modules, and everything in between!

How To: 7 Great Music Apps for Windows 8

Everyone listens to music. I've got over 3,000 songs in my iTunes library, but am always looking for more, and I'm sure you are too. You can never have enough tunes to rock out to, right? If you're using Windows 8 like I currently am, these are some of the best apps in the Windows Store right now that will help you find new jams for your collection.

How To: Organize a home library

How much time have you wasted, wandering around your home trying to find one particular book? Without a good system of organization, finding the book you're looking for can become a hopeless task. Organize your book collection at home by following this tutorial.

How To: Use basic functions in Excel (AVERAGE, COUNT, MIN/MAX)

This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact sa...

How To: Make a quick bow in the wilderness

John Campbell, from azbushman, demonstrates how to make a quick bow and arrow in the wilderness by collecting natural materials and constructing them with cord. He starts by finding seep willow (also called coyote willow) that grows in clumps near rivers. He cuts ten willow sticks and ranges their lengths from about five feet down to about one foot, each a couple of inches shorter than the next.

Walkthrough Assassin's Creed 2: Mission 42

Cleaning House: This mission just might be the best one of all. Talk to Antonio, the head of the thieves guild and you'll at first get a cut scene and a memory sync, without having to do anything. Talk to him again, however, and you'll get a mission to identify and kill some traitors. The nearest traitor is in an area just north of you, so head toward the green area on your map.