Manitoba Named Search Results

How To: Do dynamic range w/Excel's OFFSET function & top data

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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.

How To: Sew a buttonhole pattern

This video will show you how to use your sewing machine to create a buttonhole stitch. The buttonhole patter is very useful when making clothing because it does exactly what it’s name implies. It is the stitching used to sew a hole for your button. The pattern is not as hard as it looks. You follow an ABC sewing pattern to create the four sides of your buttonhole and if you go slowly and follow the pattern with appropriate height adjustments your will be butting stuff up in no time. To finish...

How To: Draw a panting cartoon dog

First you draw a triangle then you attach lips to the triangle then you go up and over to make his head. make two half circles to make two eyes. Draw two ears on the top of the little dogs head. Then from the head you draw down to proceed to make his body. You can make him a little fatter if you like fat dogs. Draw his tail. And for a little extra look you can add a spot over his eye. You can also draw a collar on him and if you draw a circle at the center of the collar you can even name him ...

How To: Set up a business card at home for a printer

If you’re an entrepreneur or in need of a little more professional marketing then you will need a business card. This video will show you how to create your own business card using Adobe Illustrator. You will need to make sure you are keeping your work with in the standard card size. You can make your own logo or a name title. You will see tips and helpful advice for how to have the best results for your card. You will see an example card which is print ready. Once you get this process down i...

How To: Use layers in Photoshop like a pro

Layers are very important component of Photoshop. Without knowing how to use the layers correctly, one can not utilize the maximum what Photoshop offers to designers and digital artists. For a beginner, this video provides a good basic knowledge about Photoshop layers. Layers enable you to arrange different parts of a picture and manipulate them without effecting the content of other layers. Layers are added by using layers panel. Each layer is named accordingly. We can change the order of la...

How To: Take screenshots in Windows XP with Print Screen

In this video, the instructor shows us how to take a screen shot off of Windows XP. First, you will want to pull up the screen that you want to take a screen shot of. After you have this up, you will hit the "Alt" and "Prnt Scrn" button at the same time. Nothing will show up on your computer, but it will have saved the image. Next, open up the program "Paint" and click "edit" on the top toolbar, then click "paste". The image will then show up on your screen. To save, click "File -> Save As", ...

How To: Write a resume in the table format

In this video tutorial, viewers learn how write a resume in the table format. A table formatted resume is one of the most effective formats. It highlights metrics in a particular field that potential employers are looking for in a presentable quick overview. At the top of the table, provide your name, contact information and location. In the table, list your skill, experience, role and products from each of your previous jobs and experiences. This video will benefit those viewers who are sear...

How To: Sew elastic (polybraid & Lastin)

This video is a tutorial on sewing both polybraid elastic and lastin elastic. Polybraid is a very sturdy fabric elastic, while lastin is a thin, clear, very stretchy elastic, good for use in diapers. It is important to buy name brand lastin elastic to ensure good quality.

How To: Make a clay Christmas stocking for the holidays

To make a Clay Christmas stocking you need to slice a slab from a block of wedged clay using a wire and two rulers. After you slice the slab trace the shape using a needle and a template. If you want you can add the child's name using stamps. Add decorative stamping. Using a clay extruder, squirt out a clay rope to accent the opening of the stocking. Glue down with slip. Punch out two holes with a straw for hanging. Now you are almost done with your Clay Christmas stocking. You can vary the p...

How To: Configure Windows Netmeeting

In this Computers & Programming video tutorial you are going to learn how to configure Windows Netmeeting. It is very easy to do. This video is from Fix PC Freeze. Go to start > all programs > accessories > windows explorer. Now click on SA(C:) > program files > Hewlett-Packard > Netmeeting > conf. On the NetMeeting installation dialog box click next and type in your name, email and other details and click ‘next’ twice. On the following box, select ‘local area network’ and click ‘next’ thrice...

How To: Draw 8-bit Toad from Mario Brothers

Drawing an 8 bit toad seems very easy from the video of Mario brothers, first you draw two short standing lines which are the eyes and are black in color using freehand draw option. Then you draw a somewhat oval shape using the same option around the eyes which would look like a face using the color light yellow then you provide darker shades on each side to give the face a 3d effect. Then the cap is drawn after which you draw the rest of the parts the body, dress, hand, shoes etc and finally...

How To: Block certain users from seeing your Facebook account

In this video tutorial, viewers learn how to block certain users from seeing their Facebook account. Begin by logging into your account and go to your home page. Click on the Setting tab and select Privacy Settings. At the bottom of the page, under Block List, there will be a space for users to type in a persons name to block and click Block. Select the person from the list of people and click Block. This video will benefit those viewers who use Facebook, and would like to learn how to block ...

How To: Convert movie files to DVD player-playable video

In this video from Act2Scene5 we learn how to convert movie files to DVD player playable video using ConvertXtoDVD. All you have to do is take a movie file and drag it into the interface. The program will import it into the program. Once it's in the application, you have several options you can do. You can change the name of the DVD so you can name it. You can also set the DVD to auto start. You can use loop playback where the video will restart after watching it through. Another option is to...

How To: Make web browser bookmarks with Visual Basic 2008

This video is about making a bookmark for your web browser in Visual Basic 2008.The videos begins with a simple web browser which consists of simple web components, a textbox and a go button. Pull the sides of the browser to stretch it and put in a listbox. Enlarge the listbox and use two buttons below the listbox. Enter the text for the buttons as "Enter current page" and "clear". Now go to selection explorer, double click "my project" and go to settings. Add a new setting called "Bookmarks"...

How To: Make animated GIFs with GIMP

First we have to do is to create a new file with the size we want. Then we go to the layer tab in the left and duplicate the existing layer how many times we want (how many frames we want to have the GIF). After this we deselect all the layers by clicking on the eyes on left. Now we click again on one eye to select the layer we want to work with. Be sure to have only one layer selected. Then we can start "playing" with the images and create shapes, faces and so on with all the layers we had c...

How To: Tag a picture with a friend's name on Facebook

In this tutorial, Mike Montgomery shows up how to tag a friend in a picture on Facebook. First, log into Facebook and click your photos and upload your photo to the desired photo album, or create a new one. Once it's uploaded you can add a caption to the picture as you wish, then click on "publish now". If you would like to involve your friends in the picture that have Facebook, click on the "tag this photo" button. You can click on their faces in the photo, then a drop down menu of your frie...

How To: Manipulate eye color in Adobe Photoshop CS3 or CS4

This video guides you through a process you can use in Adobe Photoshop CS3 or CS4 in order to change a persons eye color. The computer user shows how to first select only the iris of the eye by guiding you through which tool bar buttons to use. You should then zoom in close to the eye in order to very accurately select just the iris. Once the iris is selected you will go to the select menu then click "New Fill Layer" then "Solid Color..." When the dialogue opens up you will change the Mode to...

How To: Draw Luigi on a snowboard

The video demonstrates how to sketch the cartoon character of Luigi on a snow board. First the character is drawn with a soft pencil using faint lines. The action of the character on the snow board are detailed ,even the minute details like the hand ,legs, eyes and its expression are slowly etched out. Once the faint sketch is complete the features are highlighted with a dark pencil or sketch pen. A depth to the sketch is given by shading the parts and giving it third dimensional feeling. A d...

How To: Stop a friend from seeing your Facebook updates

Elijah from 360 Degree Social gives a tutorial on how to block specific people from seeing your Facebook posts. When someone you don't have in your inner circle, sometimes you don't want them to see everything that you do on Facebook. You go into the upper right hand corner and click on Account, then click on Profile Information. It used to say Status updates, but now says Posts by Me. After choosing the Custom options, you can type in a "friend's" name and they won't see any of those status ...

How To: Unzip a file with WinRAR file management software

You should use the file Winrar to unzip your file, it's the easiest. You're going to open up an internet browser and go to: Zybomen. Click on download, then click on Winrar. Click on the one that says 32bit, unless you've got a 64bit system which is the second one. Click run, then wait for it to download. Close your internet browser. Click install, go through the process. Right click on the file you would like to unzip, and then click on extract to and then the file name. Double click on the ...

How To: Do a system restore in Windows Vista

In this video, we learn how to perform a system restore on an HP Touchsmart PC. A system restore will return your computer to a previous point in time. This will not change anything you've currently downloaded or any files you have. First, go to the main desktop then click on "start", then "all programs" then "pc help and tools" then click on "recovery manager". A page will pop up and click on "advanced options". You will now be presented will several options, choose the one that says "restor...

How To: Burn a video_ts folder to a DVD

In this Software video tutorial you will learn how to burn a video to folder to a DVD. For this you will need the Nero program. Open up Nero and click on ‘rip and burn’. Then click on ‘burn a video disc’. This will load up Nero express. Now click ‘DVD video files’ and on the next page click ‘add’. On the next window click on ‘VIDEO_TS’ and click ‘add’ and click ‘close’. Click ‘next’ on the window that pops up. Then a disc label program loads where you can make a label for the disc. Then you g...

How To: Watch YouTube videos on your PSP with Ultimate PSPTube

If you like YouTube and own an PSP , then this tutorial is the perfect tool for you today. You will learn how to watch YouTube videos on your PSP. You only need your PSP and one program named Ultimate PSPtube 2.0. You can download that from the link in the description of the video. You have to unzip it after you download it . After that you must extract the ultimate PSP tube folder from the zip and then go to your my computer, click your PSP folder, go to the Game folder and then copy the ult...

How To: Draw a wintery snowflake with Mr. G

In this video, Mr. G demonstrates how to draw a wintery snowflake. You will need a plain pencil, or a blue and black colored pencil for this drawing. Start by writing your name and the date on a white sheet of paper. Then, begin lightly drawing the base of your snowflake. After you have drawn your base, Mr. G will show you how to make the lines darker to form the shape of your snowflake. Then, you will learn how to detail your snowflake by drawing small triangles inside the basic shape that y...

How To: Register Visual Basics 2008 for free

Registering Visual Basics 2008 express edition is quite simple. It is a free registration. First open visual basic then go to the help option. Register the product and click on register now. It will ask you to sign into Microsoft email using your Hotmail account or if you do not have one you can create one and use it there. Use your user name and password where it asks to verify. Fill out all the form information, it may be real or fake, it does not matter. Then you will come to a registratio...

How To: Add audio into PowerPoint

This video tutorial from hottyqingwa shows how to add audio files into PowerPoint projects.In this tutorial was used Power Point 2007 Professional edition.To start, create a folder with a random name. Then drag your audio file and power point project into this folder.Open PowerPoint project, click Insert from top menu, then select Sound-Sound from file. Double click audio file in your folder.Dialogue box will appear asking if you want the sound to start automatically or when clicked.After, cl...

How To: Convert a Word document to PDF

In this how-to video, you will learn how to change a .doc file into a .PDF file. Open the document in Microsoft Office. Go to file and select print. Change the printing device to the CutePDF Writer. Click okay and save the file as whatever name you want. Once this is done, navigate to the location where you have saved the new .PDF file. Open the new .PDF file by double clicking it. You cannot change any of the text in this new file. By viewing this video, you will learn how to quickly convert...

How To: Extract the top five records from a table in 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 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.

How To: Create a glass text effect in Photoshop CS3/CS4

This Software video tutorial shows how to create a glass text effect in Photoshop CS3/CS4. Download a free trial version of Photoshop CS4 from Adobe. Open Photoshop, go to ‘file’ and click ‘open’. In the next box, give it a name, select width and height at 90 pixels, background contents to ‘transparent’ and click OK. Select the color palette and choose the background color and click OK. Now open ‘paint bucket tool’ and fill in the color. Then go to ‘text tool’, select the font, size and posit...

How To: Play kick the can

Here's a classic throw-back to times past with a timeless game of kick the can. Just because you don't need expensive equipment doesn't mean you can't have tons of fun. You can play this game just about anywhere.

How To: Retweet on the web with Twitter

This video shows the method on how to Retweet web sites using Twitter. The website used on this video is Dream Systems Media. First, choose an interesting topic to tweet. Highlight and copy the entire tweet. Second, using either of the following codes: RT, rt, R/T or retweet, and the ‘@’ symbol; paste the tweet previously copied. Check if the tweet contains the name of the site and the URL. Third, place your comment inside the parenthesis following the tweet. Last, click the update button and...

How To: Make a fake & funny virus

Karn demonstrates how to make a fake and funny harmless virus that will shut down only your computer. First, go to your desktop and right click to access the right click menu. Then, choose new from the menu options and select the shortcut option. A window should open. In it type -s -t. The -t will represent the number of seconds you want the virus to activate. Also type -c. Create a message like, "This is a virus, your system is being shutdown." Name the shortcut anything that you'd like. The...

How To: Read palms for intuitiveness and psychic ability

This video provides a diagram and explanation of the some of the more common mysteries in palm reading. Although the video does not provide much instruction for the actual act of palm reading, the diagrams are very helpful in determining which lines on the palm of the hand would be used to conduct a reading. The diagram shows the names and locations of each line that can be read on the palm. The life line, line of affection and line of intuition are explained in detail. The psychic cross is a...

How To: Take a picture off your PCs screen

You don't need a camera to take a screen shot of your computer. In fact, a camera would probably give you an extremely blurry picture! There is a special button on your keyboard called Prnt Scrn. All you need to do is press that button. The screen shot of your desktop is then stored onto your clipboard. To get it off the clipboard, you need to paste it in paint. Open it up, go to edit and click paste. Then go to file and click save as to save your file. Choose where you want it to be saved, n...

How To: Use Windows Movie Maker to cut simple videos

Windows Movie Maker is a basic program that comes with windows, but it actually performs quite well. You can capture video with your webcam and import it into WMM or you can capture it in the program itself. Make sure your webcam is connected and click "Capture from video device". Click next and name the file, click next. Click best quality, then next. The start capture tab will start the recording and stop capture will cease it. Select finish when you are done. The video is then saved to the...

How To: Convert your Microsoft word files into pdf files

Steve Hicks from Screen Cast Central demonstrates how to convert your Microsoft Word files into PDF files using the Easy PDF Creator. First, download and install the PDF Creator. Then, open Microsoft Word and open the file that you would like to convert. Choose the file option from the top tool bar. Next, click the print option from the drop down menu. The print menu will now open. Under the printer name field select the PDF Creator option. Click the OK button. The PDF Creator summary window ...