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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
This video provides tips to make great photo slideshows. Many people have found photo slideshows are a great way of celebrating memorable occasions, commemorate milestones or reminisce. First, choose your photo images carefully. Filter out irrelevant or blurry photos. Try using a photo editing program to improve your photos. Next, choose a theme for your slideshow. Then select transitions, being cautious to limit your use of transitions. Consider your use of intervals in the slideshow. Also, ...
This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook.
This is a "Southwest Yard and Garden" episode that details the proper selection of gardening tools for fighting seasonal weeds. Horticulturist and host Curtis Smith takes us to meet with Ron Jobe, an Albuquerque Master Gardener, to discuss the options available for such a task. Ron covers the various conditions a gardener is faced with, including the soil and the weeds themselves. Some suggested tools are: the Wing Hoe, Skimming Hoe, Raker, Pointed Hoe, and Stirrup Hoe. The use of each is off...
Changing the color of your eyes is very quick using Photoshop and this handy video. After using the selection tool of your choice to outline the eye (this video uses the pen tool) with a little bit of feathering, just change the hue of the eye. The video shows how to do this by pressing control + h, however it can also be selected by choosing the image menu, then adjustments, then hue/saturation. This great effect can be used as shown on close up eyes or on smaller eyes further away. Both way...
In this video tutorial, viewers learn how to import media from devices in Corel Video Studio. Begin by connecting your mobile device to the computer. It can be any device with a memory card or hard drive. Open the program and click on the Capture tab. Click on the option, Import from Mobile Device and select the device that you want. Select the file(s) that you wish to import and click OK. The program will then import the media to your selection window. This video will benefit those viewers w...
In this video tutorial, viewers learn how to use the vanishing point filter in Adobe Photoshop. Begin by selecting the image you want with rectangular marking tool. Then hold Control and C to copy it. Now go to your 3D shape. Press on Filter and select Vanishing Point. Click on one of the corners and drag to each corner. Hold Control and drag it down to create another selection. Now paste the photo by hold Control and V. Then drag the photo to the selected shape area. This video will benefit ...
This video is from HelpVids and describes how to change the axis titles on charts in Microsoft Word 2007. To access the chart tools, select the chart and the tools will appear above the ribbon. There are many different design options that you can preview on the screen to make your final selection. To change the chart title, click on the Chart Title button which is located on the Layout ribbon. You can then select where you would like the title to appear. Once you select the location you can t...
The video is about the process required to remove vinyl record noise. You should have audacity programmed software installed in your computer. First clean the records as best as possible. The noise between the songs are first visualized, then go to the selection tool and press noise removal. The portion depicting the noise is enlarged to view clearly their removal. The portion between the songs is chosen and noise removal is selected and pressed. You can put in your pre-recorded songs in this...
This video tutorial by VvCompHelpvV gives you two methods to achieve the Sin City effect in your photos using Photoshop. The Sin City effect is making the main subject of the photo appear colored while the rest of the photo looks black and white. In the first method the subject should be selected using a pen-tool using the settings mentioned. After that right click on the selected areas and make the feather radius 3, inverse the selection and go to image > adjustments and de-saturate and your...
A presenter from The Home Depot gives you several tips and professional secrets on how to hang your indoor Christmas lights making this tricky process a little bit easier. She takes you through the selection of lights, planning and the installation of lights.
Everybody is going digital these days, so everybody has a reason for software like HandBrake. You can save your entire DVD collection on your computer in digital files, and you can convert videos into different formats. Check out this video tutorial on how to rip DVDs and convert videos on Ubuntu Linux, Windows, and Mac.
Go beyond the traditional 3D workflow to an immersive creative experience with the software Modo, created by Luxology. Modo is the next evolution of 3D modeling, painting and rendering for Mac and PC. Modo includes 3D sculpting tools, animation and network rendering, and advanced features such as n-gons and edge weighting.
In this video tutorial, you'll be working in Adobe Photoshop and learning a little bit about a very specific skill that I think is important for all designers. That is, the Pen Tool and using it to hand-draw clipping vector paths. There are a variety of ways to make selections in Photoshop, but drawing a real vector path is the most tried-and-true and highest quality way to do so. Mastering this tool will make you a better designer and help unleash your creative potential.
Tutorial/demonstration showing how to use Calligraphic Brushes in Illustrator to do line drawings (inking) and then import them into Photoshop as a Smart Object to retain the vector quality of the line art. By using clipping masks, we can change the color of the line art without rasterizing.
Why waste money on color contacts when you can change your eye color on a software program called Photofiltre? Photofiltre is free and you can manipulate your eye color to whatever shade you'd like in a few easy steps.
Do you see a red door and wonder if it might be a good idea to paint it black? You could "ask Ask Sherwin-Williams," or, better yet, you could just ask the new augmented reality features in the retailer's mobile app.
This how-to article is about changing you Mac icons. It goes into detail on how to make your dock icons a different image, like your favorite sports team or just a cool looking image.
There are much better things that can go in your iPhone's status bar besides an always-on indicator displaying what carrier you're shelling out money to every month. While it would be nice to get rid of the carrier name altogether at the top of the screen, an even better option is switching it out with something else to better personalize your iPhone.
Learn to Zoom to page, drawing, selection, previous, 100% and scale by numerical factor using zoom tool in Xara Web Designer. The zoom to page option is great for when you need to see all the web design elements that are shown on your web page at once.
This tutorial will let you hack into a wide selection of web cams and online security cameras. The hack is actually quite easy, and is best done with a browser like Mozilla Firefox. Navigate to Google in your browser, and then type in "inurl:viewerframe?mode+refresh". This piece of code will open up a list of active webcams. Then just surf through your choices and watch whatever you want. You can even change the camera angle and zoom in and out of the picture!
In this video, we learn how to change hair color in Photoshop CS3 and CS4. First, open up your image and zoom in on the hair. From here, you will click on the selection tool with a circle to select your image. Now, make sure this is the perfect size for the entire image. Right click and make sure it's sized out right. Now, select the hair and a red marker will appear. Select the whole surface of the hair, and as you get to the short hair use a smaller circle tool, don't worry about the smalle...
In this tutorial we learn how to text message with the Blackberry 8330. Start on the main menu and then click on the messages icon. From here, you will click on the menu key on your keyboard. From here, scroll down and choose the "compose sms" selection. Next, you will choose who you want to send the message to from your contacts, or choose a number you want to send it to just one time. After this, you will type in your message. Once you're done typing in your message, click on the menu key a...
In this tutorial, we learn how to make stencils in GIMP. Start with heads or faces if you are new to this. Then, use the rectangle tool to select the head. Then, go to image and fir canvas to selection. Now, remove the background by using the background tool. Once finished, go to colors, then threshold. The image should turn black and white. Turn the dial to the right, then turn it to the left to make it lighter and darker. Find the spot to where it shows detail but it's not distorted, then h...
In this video we learn how to create a Facebook fan page or business page. First, log into your Facebook account and go to the bottom of the screen where you see the Ads manager. Then, click on the pages selection underneath this and find the link that says "create page". Once on here, enter in all the information for the business along with the name and everything else. When the page is create, add in a picture and then the rest of the information on the page. From here, you can find new fan...
In this tutorial, we learn how to choose the right shot in World Golf Tour. The game will automatically choose the shot for you. You can find the different shots by clicking on the current swing selection on the bottom left hand corner. A full swing is the most common type of shot that delivers the most power. A punch shot is a flatter and shorter swing that causes the ball to fly lower during high wind. A pitch shot is a controlled swing that is used around the greens. A chip shot is compact...
In this video we learn how to whiten teeth in Photoshop like a professional. Start off by opening up Photoshop and zooming in on the teeth in your photo. Start out by selecting a hollow brush and then paint the selection onto the teeth. Paint around them carefully and make sure you don't touch the gums in the middle and on the top of the teeth. Once you have selected the entire area of the teeth you will see them all covered in red. Then, go to "select" and "inverse", then press the button fo...
In this video, we learn how to add rotating banner ads to Wordpress Thesis theme. First, go to your Wordpress admin, then go to the thesis option. Now, click on custom file editor. After this, selection "custom_function.php", then go to the FTP path and open "launch.php". Now a notepad will open, copy the code inside where it says banner ad and past that into your Wordpress multimedia box. now, go to the drop down menu and click view custom code. Now you should be able to see banner ads on yo...
In this tutorial, we learn how to get free custom brushes for Adobe Photoshop CS3. Go to the website, BrushesDownload. on this site, you will see a large selection of different brushes you can download. You will be able to open the zip file that they come in, so make sure you have that software beforehand. When you find a brush you like, download it and then you will be able to use it in Photoshop. There are free software programs you can download to unload these brushes, including the websit...
In this tutorial, we learn how to watch movies and TV online for free. You can do this through the website Hulu. This is a completely legal website, and you can either sign up for an account or just browse the site. You can watch movies and television shows through here, they have a large selection. They also have a great variety of different short clips for different shows. The player on the website has dimmer switches and full screen mode as well. This is a great website if you want a legal...
In this video tutorial, viewers learn how to equip their golf bag in World Golf Tour. Begin by visiting the World Golf Tour website and enter the main menu. Then click on My Settings and select My clubs. Here, users are able to select a club that they want to play with for the next round. The upper blue section represents the clubs that are currently in your bag. The lower section represents all the clubs that you own, sorted by type. When finished editing and customize your club selection, c...
In this tutorial, you will learn how to utilise UV maps for both root colour and hair length. This guide also offers a quick look at polygon selection tags and organising a scene with hair objects as well. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cin...
In this video tutorial, viewers learn how to force cards. Card forcing is when it looks like the users has a free selection of cards, but in reality the magician has predetermined a card to be selected. The force taught in this video is the cross cut force. Take the desired card on top of the deck and place it face down on top. When you shuffle the deck, make sure that the desired card always remains on the top of the deck. This video will benefit those viewers who are interested in magic, an...
In this video tutorial, viewers learn how a DJ chooses their songs. A DJ should be creative, unique and try to manipulate music to continue the artistic for of it. Experiment with song selections. Mix all sorts of music together such as: underground music, remixes, samples and the top 40 hits. Select songs that you enjoy. Make sure not to always play the same music or only play the popular songs on the radio because it can get annoying. This video will benefit those viewers who are interested...
When you hit the grocery stores, there are so many different options to choose when it comes to snack bars. You have granola bars, protein bars, sugary bars, it's confusing. Despite all the various selections, not all have been created equally. This tutorial will show you the best way to make peanut butter protein granola bars from scratch. Not only do they taste good, but are also good for you as well. So sit back and enjoy!
The Nintendo DS Lite is quite the handheld device. It has two screens, one being a touch screen, great sound quality, and a great selection of games. It is also a great accomplishment for Nintendo comparing the original Game Boy to the tech they have now. But despite its technological advancement, things can break, especially handheld devices like the DS Lite. In this tutorial, find out how to replace the original casing to a Nintendo DS Lite. Be aware that if you open your DS Lite, you may v...
The first step is to select a photo of a black, glossy car. Using the Lasso- polygonal tool, select the outline of the car. Once the image outline is complete, the dots animate around the image. The next step is to deselect the areas on the car where the chrome paint is not required. To do this, follow the same procedure as above holding the ‘Alt’ key (a minus sign appears next to the cursor). Once the selections are done, go to ‘Image’ menu, select ‘Adjustments’ and click on ‘B...
There aren't any words in the silent instructional tutorial video, but if you watch carefully, you'll learn the exact steps necessary to create a phenomenal looking shooting star or comment with nice looking special effects that are achievable in Photoshop. First you'll select a circular region with the selection tool, then you fill it with white. Next you'll use brush settings to create a brush stroke that straight and fades over time to create the comet's tail. Then you'll use Photoshop's l...
This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...
In this video, we learn how to create a picture frame on a photo using PhotoShop. First, open up the program and open the picture that you want to change. Next, select the rectangular marquee tool from the toolbar on the side. Now, create a selection of what you want to frame. Then, click with the right key and select "inverse". Click again with the right key and choose "layer via copy". Now, click 2 times on the layer to open and the layer style menu will show up. Now put the contour to crea...
