Everything Else
How To: Use the archive feature in MS Outlook
Is your Outlook inbox starting to seem overwhelming? No problem! In just a few minutes you can corral that growing pile of e-mail by using the 'archive' feature. Have a look at this video and learn how to use this handy option and clean up the mess in your inbox.
How To: Drill through spreadsheets 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 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
How To: Format and use the ROUND function in Microsoft Excel
Adding formatting to plain Excel spreadsheet is a wonderful way of increasing the readability and improving the overall look and feel of your data. With this software how-to from ExcelIsFun, you'll learn all about using the Microsoft Office program's formatting features. As an added bonus, you'll learn about the ROUND function, which is also useful for cleaning up charts where great precision isn't required.
How To: Copy and paste on a computer
Why type everything twice? If you don't know how to copy and paste you are missing out on an incredible time saver. Check out this tutorial and learn how to speed up your work.
How To: Customize a Watermark in Word 2007
Get to design your own watermark for your documents. Here's a video showing these easy steps to watermarking your documents. 1. Go to the "Page Layout" tab in Word 2007 and look for the "Page Background" section of the toolbar and select the "Watermark" button. 2. Click on the "Custom Watermark". 3. Click on either picture or text watermark, whichever you prefer. 4. If you select the Picture Watermark, you need to insert a picture by clicking the select picture. You can also customize the sca...
How To: Make a footnote in MS Word 2007
This video shows you how to make a footnote in MS Word 2007. 1. Click on the last letter of the word where the footnote refers to. 3. Click on the References tab. 4. Click Insert Footnote. 5. A tiny number will appear beside the word where you clicked and a footnote number with a line on top will also appear on the last part of the page. 6. Type in the words or the notes. 7. You may now continue typing your work.
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 ...
How To: Switch from PowerPoint 2003 to PowerPoint 2007
There are many new features which will make you more comfortable in doing your work in PowerPoint 2007 which will force you to switch from PowerPoint 2003 to PowerPoint 2007. There are number of new features in PowerPoint 2007.
How To: Use the IF function with letter grades in Excel
This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...
How To: Select a random name in Excel
Not sure about all the functions and abilities of Microsoft Excel? Luckily there are free video tutorials out in the world... or better said, the World Wide Web, to help you. In this video, learn how to use the RAND function and sort in Excel to select a random name from a list.
How To: Sort data in Excel
A major plus in using Microsoft Excel is its ability to sort large amounts of data. What's the use of Excel, if you don't know how to sort? In this short video clip, learn how to go about sort your data in the order needed.
How To: Add a video to a PowerPoint presentation
The video demonstrates how to add animated images and video content to your Microsoft PowerPoint presentation.
How To: Put your MS Access databases on your website
To start off the process of publishing your access database online we first look at a sample MS ACCESS database with typical formats and a online searchable application where users can search by library name or city and get details of the library. There are 3 steps to publish the database. The first step is importing data which can be done through clicking on the file menu and then click on import data through a Microsoft Access Database. Now select the file you want to import through the bro...
How To: Embed a YouTube video in PowerPoint 2007
This video shows how to embed a YouTube video in a PowerPoint presentation in Microsoft Office PowerPoint 2007. First you want to copy the URL of the YouTube video that you want to embed in your PowerPoint. Then, open PowerPoint 2007 and click the office button in the top left corner (circular button with office logo). Then click "PowerPoint options" and check "show developer tab in ribbon". Then click "OK". Click on the developer tab, and click on "more controls". Then scroll down to "Shockw...
How To: Create an Excel spreadsheet to calculate your GPA
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
How To: Embed a YouTube video into PowerPoint 2003
First thing you want to do is to find a video that you want to embed in a PowerPoint file (it might be PowerPoint 2007 also). After that you might see the video and decide of the final quality of it (dependent on your internet speed ). In the right side of the video you will see a URL link to it, copy that to your PowerPoint to have it ready for next step. On your PowerPoint file enable the Control Toolbox and follow the instruction .Be sure that you modified properly the web address . Voila,...
How To: Apply accounting & percentage formatting in Excel
This is the fifth video in the Statistics in Excel. He gives the website address where content can be downloaded. He speaks about the different types of formatting like stylistic and number formatting. He talks about the different formats like accounting and percentage, and how to use both of them. Accounting format is nice because it lines up the decimals nicely. He shows how to apply the accounting format. The percentage format displays the value in as a percentage. He shows you how to appl...
How To: Embed a YouTube video in PowerPoint w/ or w/o internet
In this Software video tutorial you will learn how to embed a YouTube video in PowerPoint with or without Internet. You will see two ways of doing this with and without internet access. When you have an internet connection, open up PowerPoint and click on the office circle button on the left hand corner. From there select ‘PowerPoint options’ and check the box that says ‘show developer tabs in the ribbon’ and click OK. Once the developer tab is in your ribbon, select that and go to the area t...
How To: Embed a YouTube video into PowerPoint w/ no internet
This genius video shows the viewers how to easily embed and add a YouTube video into a PowerPoint presentation with no internet connection! First you will need to make sure you are using Firefox. After getting Firefox, make sure you install a Firefox Add-on called Video downloader. To get this add-on, Google 'video downloader' and install the add-on. you will see a new icon at the bottom of the screen to the right. First, go to the video you would like to download on YouTube and click on the ...
How To: Change views & navigate documents in MS Word 2007
In this video the instructor shows how to change views in Microsoft word 2007 and navigate around the documents. In Microsoft word 2007 in the ribbon there is a view tab to the extreme right. Open the tab. Now in that bar the default layout selected is the Print Layout which is 'What you see is what you get' layout. Next to it the full screen reading option and clicking on it, the documents opens up as a two page book with all the other tool bars hidden. The next is web layout which is ideal ...
How To: Create an MLA works cited page in Word
To start with you have to write the author's name, with the last name entered first followed by first name and then the period. Title of the article should be in quotation marks. Do not use italic format. Title of the actual journal must be written. After this there is a series of numbers the volume number, issue, year, pages number separated by a colon. Don’t write 'p' for pages as the number itself is a standard for it. Write the period and also the dates.
How To: Get started with MLA in Word
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...
How To: Sort a range in Excel
Using Excel, sorting large or small pools of data has never been easier. In this Excel tutorial, learn how to sort a range of data in Excel and what steps to do so, from start to finish. Sort totals, percentages, or decimals in a range in descending or acsending order with help from this video.
How To: Create headers and footers in MS Word 2007
This video is part of the HelpVids.com series of technology videos. The video describes the process of adding headers and footers in Microsoft Word 2007. The easiest way to edit headers and footers is to double click in the header or foot section of the document. Once you double click it will allow you to edit the text that appears in the header and/or footer. You can also go to the Insert Ribbon and then click Header. This will display many preset styles that will apply to your header. Choos...
How To: Use Spellcheck/Thesaurus/AutoCorrect in MS Word 2007
As you type in Microsoft Word, take care to notice when the computer puts a red squiggly line underneath a word you typed. If you see a red squiggly line, the word is spelled incorrectly. If you right-click on the word, MS Word will show you a list of correctly spelled words that it guesses you were trying to spell. If you wish to check the entire document, you can click the Tools tab at the top of the page and then spell check. This will go through the document and point out every misspelled...
How To: Use the Office clipboard in MS Word 2007
This video shows you how easy and convenient it is to use the Office clipboard in MS Word 2007. Go to the "Home" tab. Then click on the little
How To: Calculate total savings in Excel
This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches functions that can be used in the Excel sheet, plus useful tweaks and formulas.
How To: Insert the current time and date in MS Word 2007
In this video you will learn how to insert the current time and date in MS Word 2007. In order to do that, just follow these easy and quick steps and instructions. The first thing you need to do is to click the Insert tab. Now, you need to select a space where your date and time will be placed. The next step is to click the Date & Time button, and select the format that you want. Click the OK button, and you are done. If you followed the simple steps correctly, then you won't have any problem...
How To: Calculate equivalent earnings in Excel
In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semi-weekly, bi-weekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you w...
How To: Create a dynamic table for VLOOKUP function in Excel
You can use the vlookup function in MS Excel to create a dynamic table in your document. Creating a new dynamic table and a new dynamic lookup area enaables you to add new data or new columns to the lookup table. You can also create dynamic named ranges by using offset, vlookup table and the match table. This function is very useful to businesses working on Excel. This video will show you to create a dynamic table for vlookup in Excel.
How To: Make read only/password protected docs in MS Word 2007
Ever have the problem of people messing with your word documents? This guy shows you the solution by telling you how to create password protected encrypted word documents. The process starts with your open file. Clicking on save as... and in the popup window clicking the tools button in the bottom left corner and clicking general options. There it shows you text entry boxes, one for setting a password to open the file, another to set a password for rights to modify the file. Enter your passwo...
How To: Change text alignment & formatting in MS Word 2007
In this video tutorial, viewers will learn how to change text alignment and formatting in Microsoft Word 2007. To format or align the text, you must high light it first. Once highlighted, users are able format the text in many ways. The formatting options are: font type, font size, bold, italics, underline, strike-through, subscript, superscript and change case. The alignment options are: right align, center, left align and line spacing. Users also learn how to add pictures and position the t...
How To: Create a table for the VLOOKUP function in Excel
In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Excel Table feature and Table Formula Nomenclature for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup tabl...
How To: Set and adjust tab stops and indents in MS Word 2007
This is a video from HelpVids.com that discusses how to set and adjust tab stops and indents in Microsoft Word 2007. The video starts off with a Word 2007 document open on the screen. First the presenter shows how to show and hide the rulers. This is accomplished by clicking on a small icon above the vertical scroll bar. Tab Stops are only applied to text that has been selected and not the entire document (unless you select the entire document). The sliders on the ruler control the amount of ...
How To: Find and replace text in MS Word 2007
This video will show you how to use the ‘find’ and ‘replace’ text buttons in Microsoft Word 2007. Microsoft Word 7 is slightly different from the Microsoft you might be used to but with these instruction you’ll have no problem finding the buttons.
How To: Record macros in Excel 2007
In this Microsoft Excel 2007 for Dummies video the instructor shows how to record a Macro. Macros let you create a shortcut to perform a sequence of commands all at once. For example you can create a macro to quickly build a sales report template that you frequently use. When ever you run that macro the Word will automatically build the template for you based on the recorded commands. To write macros you need to have the developer tab enabled. To enable it click on the office button and at th...
How To: Use SmartArt graphics in MS Word 2007
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart Art object choices. In this example we first want to click on the Text Cycle icon. Once we do that click on OK and the rough drawing will be placed on your document. After that click on design and you can format the gra...
How To: Cut, copy, and paste to the clipboard in MS Wrod 2007
HelpVids user mel_bone teaches you how to cut, copy and paste to the clipboard in Microsoft Word 2007. Select the first paragraph by either triple clicking on it or selecting it with your mouse. Click "Copy" in the top ribbon or press "ctrl + c". Then use "Paste" or "ctrl + v". To cut a paragraph, select it and click "Cut" or press "ctrl + x". Using the paste options, you can only paste the text, without its formatting. By clicking the small icon next to the Clipboard tab, you will open the p...
How To: Add or delete fill effects in MS Word 2007
For that, first, click insert, select any shape from the given options. Take drawing tools from format option. In that, we can choose from the most used colors , like, black, blue and red. Also we have options like, fill color. In that, theme color can be used for different type of colors. Also there are options for gradient colors, color effects. We can make 3D effects of the shape we inserted 3D options in format option. In text wrapping option, we have edit wrap points.
How To: Change margins & show/hide the ruler in MS Word 2007
This video demonstrates how to show and hide the ruler in Microsoft Word 2007, along with working with page margins. The presenter indicates that if you click the small button above the vertical scroll bar, Microsoft Word will then display Rulers. To work with margins you'll need to click on the Page Layout tab to display the Page Layout ribbon. The video shows the different options located on the Margins menu. There are several built in settings for wide, narrow, normal, moderate, and mirror...