Named Puma Search Results

How To: Create a dynamic frequency table & chart in MS Excel

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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....

How To: Look up a picture in Microsoft Excel

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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.

How To: Use and work with tables in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:

How To: Use the Advanced Filter tool to extract data in Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:

How To: Set the wallpaper on an Android cell phone

Want to give your new Android enable mobile device a personal touch? Well, your phone comes preloaded with wallpapers that you can use, and you just have to find the right one that fits your personality. Adding the wallpaper to your phone is easy. Go to gallery, flip through the stock wallpapers, and select the one you want by clicking "select" — Best Buy has answers. The Best Buy Mobile team explains how simple it is to set the wallpaper on an Android cell phone.

How To: Format a hard drive to boot a second operating system

In this Computers & Programming video tutorial you will learn how to format a hard drive to boot a second operating system. First, do a Google search for EASEUS partition master, download and install it. Launch the program. Right click on the unallocated space on your hard drive and then click ‘create’. Now create a new partition for the new OS. Name it Vista, select ‘primary’ in the ‘create as’ window, choose ‘NTFS’ in the ‘file system’ window, select drive letter as ‘V...

How To: Format a secondary hard drive in Windows Vista or 7

In this how-to video, you will learn how to format one of your hard drives in Windows 7. First, go to start and right click my computer. Select manage and a new window will pop up. Go to storage and select disc management. Now, right click the drive you want to format. Type in the name you want for the label and check quick format. Once this is done, press okay. Click okay to continue. This does not take too long. You have now formatted a hard drive. This video shows you the basic steps it ta...

How To: Tie a Prusik friction knot

In this Outdoor Recreation video tutorial you will learn how to tie a Prusik friction knot. In case someone has fallen into a crevasse or you want to get back on a rope, Pruisk knot is required. It is used to tie two ropes of different diameters. It basically puts a loop of cord around another rope. It is named after the Austrian mountaineer, Karl Prusik. For making the knot, take the fixed loop made on one rope and pass it around the other rope and back through the fixed loop itself. Then lo...

How To: Tether a laptop to a Droid smartphone for free WiFi

In this Electronics video tutorial you will learn how to tether a laptop to a Droid Smartphone for free Wi-Fi. For this you will need the android wifi tether application. Download the version for your device from here and install it. Then launch the app and press the icon to start tethering. In your laptop, go to settings and then to wi-fi. You will see a new network called android tether. Connect to the network and you will see that it works. As with any other network, you can change the nam...

How To: Partition an external hard drive on a Macintosh

In this video tutorial, viewers learn how to partition an external hard drive on a Mac computer. Begin by open Macintosh HD. Scroll down the list on the left and click on Applications. Double-click on Utilities and select Disk Utility. Under Volume Schemes, select 2 Partitions. Select the name of the partition and choose the format that you want for the drive. Select the second partition and do the same. Now click on Apply and click on Partition. This video will benefit those viewers who use ...

How To: Validate data & look up values in Microsoft Excel

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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.

How To: Use LinkedIn as a college graduate

This is a video tutorial that is showing its audience how to utilize the website LinkedIn after you graduate from college. The first step is to go online to the website. Then you should make a profile. Make your profile polished and professional so that you future boss can easily search for your name and look at your wonderful profile. The next step is to include at least three past positions in your profile, a photo, and what schools that you have attended. You should also be aware of your p...

How To: Select numbers from a set without repeats in MS Excel

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 373rd installment in their series of digital spreadsheet magic tricks, you'll learn how to select 3 numbers from 50 with no repeats. Also see how to select 3 names from a list of 10 with no repeats.

How To: Chemiluminescence, oxidation of luminol

In this how to video, you will learn about Chemiluminescence and the oxidation of Luminol. The first solution is Luminol and NaOH. The second is K3 and H202. Luminol is used to detect blood in crime scenes. It reacts with Iron in Hemoglobin. As you can see in the example, it illuminates the chemicals in the dark. This is why it is very useful for crime scenes. It can be used even if the blood is not visible with day light. Thus, it is an invaluable chemical in the name of science and justice....

How To: Set an iPhone alarm using the clock application

This HelpVids.com tutorial shows the basic options for setting an alarm on an iPhone. To begin, open the "clock" app. There are four sub-menus in the the "clock" app. Choose the "alarm" sub-menu. To create a new alarm, touch the "+" in the upper right corner of the screen. A new screen appears and the user has different options. A repeat time for the alarm can be chosen. The user can choose the sound that plays when the alarm goes off. The "snooze" option can be toggled on or off, and the ala...

How To: Dynamically count unique words in a column in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...

How To: Do sand writing as a children's sensory activity

Shelley Lovett from Childcareland demonstrates sand writing as an early childhood learning activity. All you need for this activity is a baking sheet that is approx one inch deep and some sand. Colored sand makes it more fun for the kids. Shelley says the cheapest place she has found colored sand is at Wal-Mart, but it is also available at craft stores and perhaps even at Home Depot or Lowes. You spread a thin layer of the sand onto the baking sheet and try to make it pretty even. For very yo...

How To: Create a virtual machine for free

In this Computers & Programming video tutorial you will learn how to create a virtual machine for free using the virtual box in Mac. Open the virtual box and click on new. Click next, put in a name for the virtual machine and click next. In the next window, it gives a recommended memory, increase it slightly with the slider and click next. Click next in the subsequent 4 windows that come up and finally click ‘finish’ and click ‘finish’ again on the next window. In the next window click CD/DVD...

How To: Make free calls with Skype on the iPhone

In this video Mike Callahan walks you through using Skype on the iPhone. To start, download it from the Apple App Store. Next, launch the application on your iPhone. It will immediately prompt you to enter your name and password. If you don't have one you can use this screen to create one. Once you've logged into your account you'll see your list of contacts. Touch one of your contacts to place a call to them. There is a call option at the bottom of the screen that will launch your dial pad. ...

How To: Hide and lock folders in Windows

In this Computers & Programming video tutorial you will learn how to hide and lock folders in Windows. When you want a private folder that you don’t want any one else to open and see. You will need this feature. For this open a new folder. Open the folder, right click on it and go to ‘customize’. Then select ‘change icon, click on a blank icon, click OK and ‘apply. Now you will see that your folder icon on the desk top will disappear; only the name will be visible. Now rename it with a small ...

How To: Completely hide the Ribbon menu in Excel

The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...

How To: Change the font size in Word 2007

In this how-to video, you will learn how to change the font size with Microsoft Word 2007. First, open the program and type in a sentence or two. Now, move your cursor to where the font name is. To the right of this should be a drop down menu with numbers. These are the sizes of the font. Highlight the text. Now, click and change the number to change the size of the text. The larger the number, the bigger the font will become. This video shows you just how easy it is to change the font with t...

How To: Check your site's Google indexing

This video tutorial from MatthewNeer presents how to check your site's or blog's Google indexing.Type in Google word Site, press Space and then enter your site's or blog's URL address.Then press Enter or click Search button.Newly opened Google page will show all the pages from your site or blog which are already indexed in Google search engine.From search Results to the right you can see how many pages from your site are already indexed.According to the results you can reoptimize those pages ...

How To: Summarize data from multiple sheets in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.

How To: Install Installous on your iPhone and iPod Touch

This video shows the method to install 'Installous' on your iPhone and iPod Touch. The first step involves opening up 'Cydia' on the iPhone or iPod Touch. After opening Cydia go to manage and then go to the option of 'Sources'. The resultant window will show an option named hackulo.us. Add this cydia.hackulo.us to the source. The resultant window which opens shows various sections. Find the section of Hackulous in the window. Go to the Hackulous section and find the option of 'Installous'. In...

How To: Recycle an aluminum can into an indoor mini planter

This video shows how to make a eco friendly plant holder. The first thing you do is trace a fabric around the tin can this is to give it a better look. Then stamp the letters on the fabric of what you want to name your plant. After that poke about ten holes at the bottom of the can. Then glue the back of the fabric to place it on the can. Now wrap the fabric around the can on the sticky side. Lastly tie twine around the can for extra protection to hold up the fabric. Then put in the plants an...

How To: Mask a domain with GoDaddy.com

Ken Appleby demonstrates how to mask a domain with GoDaddy. Masking a domain enables the domain owner to customize what appears in the viewer's address bar. First, log in to your GoDaddy account. Then, click on the domain manager function located on the left hand side of the page. Next, choose the domain that you would like to work with in the domain name list. Click the forwarding option. In the next window, click on the masking tab. Tick the enable masking function. Choose a masking title. ...

How To: Make a book cover in Photoshop

In this Software video tutorial you will learn how to make a book cover in Photoshop. Go to file -> new. Give it a name, set width 900, height 1200 and resolution 300 and click OK. You can change these settings if you like. Go to your paint bucket tool and paint the background black. Then go to layer -> new ->new layer -> OK. Now select the elliptical marquee tool and holding ‘shift’ drag from the top left hand corner and make a circle. Go to your paint bucket tool and paint the circle with a...

How To: Cite a cereal box in MLA format

In this video tutorial, viewers learn how to cite a cereal box in MLA 2009. citation is a reference to a published or unpublished source. In general, a citation requires the author's name, publication information and medium type. Start by examining the entire cereal box for the information. Look on the front, back, sides, top, bottom and even inside. Usually, users will only be able to find title, medium, corporate sponsor and place of publication. This video will benefit those viewers who ar...

How To: Remove friends and acquaintances from Facebook

In this video you will learn how to remove your friends and acquaintances from Facebook. To do that just follow these simple and quick steps and instructions: The first thing that you need to do is to open your browser and go to Facebook. After you login to your account click the Friend List tab and select All Friends. To remove a friend in Facebook, click the X button located on the right of his/her name. A warning will pop-up and to complete the process just click the Yes button. Now you ar...

How To: Make a mini Christmas log cake for a dollhouse

Here is another video by a woman named Angela on how to make a miniature Christmas log cake for a dollhouse. The first thing she does is roll out a sheet of brown clay with a pasta maker on a setting of 4. Then she rolls out a white sheet with smaller setting of 6. Use a razor blade and cut some straight edges. She layers the brown and white layer and rolls them together. Cutting off the ends she has now created a log cake. Use these ends for slices of the cake for dolls. She then uses a pepp...

How To: Link your Hotmail email account & Mac mail

The video shows you how to link your hotmail account to your Mac. The person first asks you to open the mail and write down your full name, hotmail id and the password in the boxes given there. Then click on continue, and in the next option box, leave the account type as POP and then give a description as hotmail in the space provided. Then you have to type pop3. live.com in the box given for incoming mail server. Once done, click on continue and it will ask you for description of outgoing ma...

How To: Host multiple sites & domains on one GoDaddy account

This video shows how to get more value on your GoDaddy account. You have to have a deluxe account to share domains. You have to pay an extra $2 a month to get this account. Once you sign in go to "hosting" then my "hosting account". To add another domain you move it over to a new folder then put the site files in there. To do this, click add domain then go to bulk. Then create a folder and name it what you desire. Sometimes the file folder doesn't always appear immediately, but it is there, i...

How To: Add a theme to your Google Form

Classroomnext describes how to create a Google form with your own custom colors and designs to give it a personal touch. Once you are logged into the Google Docs main screen, click on the button that says "New" and choose the option "Form" from the dropdown menu. Once your new form appears onscreen, type in a simple test name in the title field and a placeholder question. Save the document. Click on the button that says "Theme" and you will be shown a variety of styles to choose from. Save th...

How To: Sort table contents in MS Word 2007

This is another HelpVids.com technology video. This video will teach us how to sort table contents in Microsoft Word 2007. The video starts out with a Word 2007 document with a sample table. When you click on the table, you will see the Table Tools tab appear above the ribbon. Click the Table Tools button, then click Layout and finally the Sort Button. The sort dialog box allows you to choose which column to sort by, which direction you would like to sort, and any secondary sorting you would ...