In this video, Nub shows us how to delete a user account. First, you will click "start" then "control panel". Then click on "user accounts" and then "manage another account". You must be logged in as the administrator to do this. A new window will pop up once you click on this and you will see all the user accounts on your computer. Click on the user you want to delete and a menu will show up. Click the button that says "delete this account". A message will appear asking if you want to save t...
This video teaches you to sync Google Calender with the Apple iPad Calender app. The first step involves going to 'Settings' and then to 'Mail Contacts Calenders'. Add an account to the application. For doing this, go to Microsoft Exchange. Type in your email ID in the space provided for it and skip domain. Type in your username and password. Click on 'Next' and 'Accept' in the resulting box. Then a box named 'Server' appears. For the server type 'm.google.com' and click 'Next'. Turn off the ...
In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, click conditional formatting and select new rule. From here, type in =column(A1)-row(A1)=$H$1. For the format, choose a contrasting look, such as a purple background and bold numbers. Click okay. If you type -1 or -2 in this...
Log in to your account. Go to settings, then go to Forwarding and POP. Then, check in the box for enable POP for all mail. Next, save the changes. Then go back to the settings page and check the first box (to include the mail that has already been downloaded). Save your changes again. Next, select tools>account. In the box that pops up, select POP for the account type and hit OK. Name the account and fill in your email address and POP address. For the SMTP server, put in smtp.gmail.com. Then,...
Ever had router trouble? Got router trouble? Well don,t worry the people over from quickcert.com have made this video to help! More specifically a linksys 802.11g router. All new routers come with a standard Ethernet cable, which must be plugged into one of the four ports on the router and connected to your computer as well. This is necessary to change settings, using Microsoft IE (internet explorer) when the routers IP is typed into the address bar. It is strong recommended to change the def...
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to return multiple items from one lookup value and see a formula to return just the numbers from a column containing both text and numbers.
In this how-to video, you will learn how to dismantle an 80GB Microsoft Zune and remove the hard drive. You will first remove the cap at the end. Remove the screws at the bottom. Next, unclip the sides, top, and bottom of the Zune. You can use a prying tool to help you with this. Do this slowly, as you might damage the Zune. Once you can remove the back cover, you will have access to the internal parts of the mp3 player. Remove the tape holding the components together. Next, remove the screws...
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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...
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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.
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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.
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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a date label that adds leading zeros appropriately.
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 215th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a named formula with OFFSET & COUNTIF functions that defines a print area, and then insert the formula name into the print area name.
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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a mean value as a scatter diagram data series to a box plot or box & whisker that is set up as a bar chart.
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 200th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel 2007 Table Nomenclature in formulas. See 9 examples of how to create formulas with table nomenclature in this free Excel video tutorial.
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 193rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a given total score that will automatically calculate grades.
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.
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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.
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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.
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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.
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 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
This video will show you how you can increase the speed that your Microsoft Windows Vista runs by using several different methods. You can disable the transparency function and go to a basic mode. Clearing disc space will also make your computer run faster. You can just run a disk clean up. Finally you will want to do a disk defragment your computer. If your computer is running a little slower than you’d like then try doing these three things and you should gain a little speed.
This video tutorial from pctechbytes presents how to quickly set up Homegroups in Microsoft Windows 7.This feature allows to easily share files between computers with Windows 7 operating system.Press Start button, select My Computer option. In the newly opened window select Homegroup from the list to the left. Select View Homegroup Settings link.In this window you can choose what types of documents you want to share with other Windows 7 operating system users.You can share pictures, documents...
This video provides step-by-step instructions for how to insert sounds or music into a PowerPoint presentation, using Microsoft Office 2007. The narrator uses the insert sound tool and selects an audio file that, and demonstrates how to make it play automatically when the PowerPoint slide show is played. He also shows how to customize the effect options by using the animations tab, which allows you to choose when the track starts and finishes, for how many slides, and at what volume. After wa...
This video will show you how to enable JavaScript, accept cookies, and allow pop ups in Microsoft Explorer. The first thing you will need to do is to go to tools on the menu bar, then choose options, and choose the security tab of the new window that will pop up. To enable JavaScript click custom level, scroll all the way down until you see the scripting section, make sure that all three radio buttons are set to enabled, and finally click ok. To enable cookies, go to the privacy tab and make ...
Microsoft PowerPoint can be used to create power presentations. These presentation can contain images, animations, audio and video. Open your PowerPoint presentation. Go to the insert and select the audio and video option. Now browse to the file on your hard disk and select it. You can even select a video file to make your presentation better. Now this video will be added to your slide in the presentation. You can also choose different settings to the video and customize it. You can also sele...
This video is about how to install custom fonts on XP. The first thing to do is to open your browser and type "fonts" in the search bar. Several sites will appear and just simply click on any of the websites. Once you have found the site that suits you best, just start looking for fonts that you may like. And if you already have found a font, just simply press download then save it in your computer. Once you have saved it, other files need to be extracted so just simply extract it. After extr...
This simple tutorial teaches you how to create a classic 8-bit Luigi from the Nintendo franchise Super Mario Brothers in the Microsoft paint program. To start, open Paint. Select Image-> Attributes and change the image width to 12 pixels and the height to 16 pixels. Use the zoom tool to zoom in 8x and select the paint bucket tool to make the background gray, because a large portion of Luigi is white. Then use the pencil tool (set to 1 pixel) to begin drawing Luigi starting with his black shoe...
In this video, we learn how to send an email using Outlook Express. First, click "create mail" in the Outlook program. In the "to" section, fill out the email address of the person you want to email to. You can also access your address book and choose recipients from that folder, double click them and make sure they show up in the recipient folder. After this, click "ok". In your subject line, fill in which subject the email is about. After you are done with this, move to the main body of thi...
In this video tutorial, viewers learn how to add a video into PowerPoint. This video is using Microsoft Office PowerPoint 2007. Begin by opening the program and create a new slide. Click on the Developer tab and select the More Controls icon. Scroll down the list and look for Shockwave Flash Object. Now crop the size that you want the video to be. Right-click on the crop and select Properties. In Movies, paste the link of a video that you want. Delete the "watch?" in the link and replace the ...
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...
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...
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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.
In this video tutorial, viewers learn how to get a Windows 98 theme on Microsoft Windows 7. The Windows 98 themes need to be downloaded from the link in the video description. The Windows 98 themes are: Baseball, Jungle, Mystery and Travel. When opened, the background changes to the theme. The cursor and the icons on the desktop also changes to the theme. There are sound effects when the user maximizes and minimizes a window. This video will benefit those viewers who use a Windows 7 computer ...
This video will show you how to make your essay appear longer then it actually is with just a few quick changes to your Microsoft word settings. First, you want to go to the "Edit" tab and click "Replace", from there in the replace with box put a period. Then click on format and click on font and change the size of the period from 12 pt font to 14 or 16 pt font and click replace all. The next change you want to make is with your margins and in the left and right margins change it from 1. 25 t...
In this video tutorial, viewers learn how to detach and attach a database in SQL Server 2005. Microsoft SQL Server is a relational model database server. Begin by opening the Database and show all the tables. To detach the table, right-click the database and select Detach. Make sure that the database is not opened or it will not detach. To attach a database, right-click on Database and select Attach. Click on Add and find the table. Select the table and press OK. This video will benefit those...
This video shows the viewer how to disable User Account Control within either Windows 7 or Windows Vista. This is done by clicking on the start menu and then type ‘Microsoft config’ into the search box. This opens the ‘system configuration’ menu. Select the ‘tools’ section. For Windows Vista there is simply an option to disable User Account Control. For Windows 7 click on the ‘change UAC settings’ option before clicking launch. In Windows 7 the slider should be dragged to the bottom. Both met...
This tutorial is to explain how to change the ownership and/or permissions of a folder or file on your computer. It is very simple and easy to understand. There is a step by step guide to the process. There is a verbal as well as a visual representation of the process that you need to use to be able to change the permissions and ownership of the individual files on your computer. The computer screen video is of a computer using Microsoft Windows XP. It is a great guide for beginners and compu...
The video demonstrates how to get started with MLA (Modern Language Association documentation format) for an article. One of the first things that is important to understand is how to name your paper, and add a header format that will automatically paginate your paper so that you do not have to worry about it. The entries in your Works Cited need to be alphabetized and also need to be indented. Note that there is no extra space between the entries. You do not have to know how to manually form...
This is a Computers & Programming video tutorial where you will learn how to set up your developer computer for Silverlight applications. First you need to install some tools on your developer computer. The premier developer tool from Microsoft is Visual Studio. If you don’t have a license, install Visual Web Developer Express which is free. It is installed via the web platform installer. Then you need to install the Silverlight toolkit. Go to Silverlight codeplex and you will find a complete...
