Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If the...
In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...
This video tutorial is in the Education category which will show you how to subtract basic fractions in simple mathematics. You can do basic subtraction of fractions if the denominators are the same. If they are not, then find the lowest common multiple of the denominators and convert the denominators to their lowest common multiple. For example, to subtract 1/2 from 3/4 find the common multiple of 2 and 4, which is 4. So, the problem 3/4 - 1/2 can now be written as 3/4 - 2/4. Since, the deno...
If you're ever done a big race before, then you've probably had to deal with attaching a paper number to your chest with safety pins. In a triathlon, where you are going to have to change clothes multiple times, having to keep unpinning and repinning that number can cost you valuable time and effort. This video will show you how a race belt can simplify the process, making switching your numbers location a breeze, even across multiple outfits.
In this economy any job is better than none at all, right? Of course, but if you know you are worth more than you're making, follow this tutorial for tips on how to ask your boss for a raise. You'll never know if you don't ask! Good luck!
This Windows XP video tutorial offers an explanation of how to use a little-utilized and known trick that gives you the power to rename multiple files both quickly and with ease. For more, or to get started batch renaming files yourself, take a look!
You can have as many iPhone e-mail accounts as you have addresses. Watch this iPhone tutorial video to learn how to add multiple email accounts to your iPhone. This how-to video is intended for new iPhone owners.
When evaluating multiple job offers it is helpful if you take the time to go over your options and determine what factors are most important to you in your career search. This how to video teaches you what to look for when deciding between several job offers.
You can make almost any website your homepage but what if you have more than one favorite? How do you choose? With FireFox you don't have to because you can set multiple homepages.
You know those big walls of televisions you see at the electronics store? Have you ever wanted to create an effect like that? Maybe for a commercial or cool project? Well this tutorial will show you how to make a wall of televisions projecting different shows using After Effects.
Learn how to use weights for working multiple joints through multiple exercises. This video gives some great combo weight training exercises.
This video will provide an idea how to untag yourself from unrelated or inappropriate images in Facebook. From this video you will learn to untag yourself from multiple images at once.
Hey all, in this video tutorial I explain 3ds Max Network Rendering, and queuing multiple scenes for rendering.
This kid has great instincts for teaching magic or card tricks as he instructs with multiple camera angles the best methods for shooting cards in the air. He also has different finger and grip techniques for multiple cards and different spins.
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 639th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will do an approximate match lookup with an unsorted lookup table that can be copied across multiple columns and do lookup from multiple columns.
This quick Blender 2.5 video tip tutorial demonstrates how to use multiple background images. This feature is very useful and allows for layering images in the viewport and assigning separate images to specific viewing angles. Without the need for multiple viewports. 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 ...
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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).
Need to know how to figure out the least common multiple or LCM of two given numbers? From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to...
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 to create a multiple selection list when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
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 use multiple constructors within a single class when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
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 TheNewBostonian will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to store multiple objects in an array when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
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 TheNewBostonian will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to multiple methods and also instance variables inside a class when writing in Java. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
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 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.
Britney, our host, shows how to create a multiple strand twist. Start with a high ponytail with a section of the hair twisted around to cover the rubber band. Take small sections of hair, about half an inch, and start twisting it. Keep twisting until it starts to coil up. Secure it with a bobby pin. Continue twisting sections of hair and pinning them to the head. Start pinning the sections to one side, and work your way around to the other side. Once you have worked your way all the way aroun...
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
If you work with MobileMe Calendar, you can create individual calendars to help you keep track of what's going on in your life. Let's say you've just started a new book club and you want to create a new calendar for it: just click on the plus sign in the lower-left corner, then click "New Calendar"; next, give it a new title such as "Book Club." Now, with your new calendar selected, when you enter the kickoff meeting for Sunday afternoon, that event will be added to the book club calendar. To...
Check out this puzzle video tutorial on how to solve a 4x4 Rubik's Cube by advanced edge pairing. This video goes over how to match up multiple edges at a time, allowing you to eventually become faster with practice. This will also allow you to understand the technique necessary for multiple edge pairing in bigger cubes as well, where it really becomes necessary in solving quickly.
In this video tutorial, Chris Pels will show how to extend a standard ASP.NET server control and customize it for a specific purpose. Specialized controls provide an convenient way to implement standardized user interface elements for multiple web sites for individuals or teams of developers. In this example, see how to extend the DropDownList control to create a special purpose year selection control. Learn how to add properties for custom attributes that control the behavior of the range of...
Well, you've got your friends & family email account, your email account for buying junk and that little secret email you keep for all other reasons. If you've been looking for a way to get them all onto your AT&T BlackBerry, here's a clear & concise tutorial teaching you how to do just that.
If you have an iPhone 3G or iPod Touch 2G, you're probably having problems with iOS 4 of multiple kinds. If you have just jailbroken one of those Apple devices and want to activate some of the sexy new options available to you, watch this video. It will show you how to enable multitasking and homescreen wallpaper on your jailbroken iPhone 3G or iPod Touch 2G with iOS 4 using winterboard.
The Contacts application on Android-powered cell phones provides a powerful way to manage your address books and keep in touch with friends and family. You can even add and manage multiple accounts from various sources. Watch these tips from Google to learn who to get the most of the Contacts Android app.
Expert bartender Jason Griffin from quickstrain.com has tons of helpful tips for all you aspiring bartender out there. Jason will show how a pro does the little things that separate the good ones from great ones. Watch this video to learn how to pour multiple drinks, upsell to customers and so much more!
This video is about showing you how to use feng shui in repairing your dysfunctional family and getting rid of the bad vibes that may be in your home, re-energizing the foundation of love. The family center is located on the left center of your home. The element for the family is wood and you wouldn't want to have dead or plants with sharp leaves because they start arguments. Too much red is considered the fire element and can also lead to your family having arguments. If you have metal in yo...
Do you want a unique way to display your vacation photos or present your holiday newsletter? Try making an instant book. This video, you will guide through the simple process. The presenter starts by referencing Esther K. Smiths book: How to Make Books. You do not need a lot of materials, just scissors, paper, and some pictures. After showing examples of different types of paper you can use, she demonstrates the step-by-step process of folding and cutting the paper. She even shows a slow moti...
Watch this video to learn something short and simple just for you to mix it in to your other salsa dancing moves. Remember, it is not about having multiple long combos, but about putting smaller salsa moves together in different orders that will make you a versatile dancer. That will keep your salsa moves fresh and keep the ladies guessing what you will do next.
In this video tutorial you will learn about the basics of using Smart Objects in Photoshop. Smart objects can consist of pixel-based content or vector-based content. These smart objects also remember their original size and can be transformed multiple times without loss.
Don't put up with another winter of discontent. There are simple things you can do to lift yourself out of the doldrums.
If you fear you're off to summer school, ease the stress of uncertainty with some simple math and know when to seek help with your grades.
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to homebrew and hack the PSP.
Beat the snack attacks with this healthy banana and peanut butter favorite. You'll love how simple and quick this fruit smoothie is to prepare. This cooking how-to video is part of Healthy Appetite with Ellie Krieger show hosted by Ellie Krieger. Cooking healthy food can be quick, easy, but most of all, delicious. Nutritionist and author Ellie Krieger has created fast and simple healthy recipes for the real world. She'll show you how simple it can be to stay on the healthy track no matter how...
