Hot Microsoft Office Posts
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: 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: 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...
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 ...
How To: Insert special characters in MS Word 2007
A video from Helpvids.com that shows how to insert special characters in MS Word 2007. A seldom used function in MS Word is the Insert Symbol function. Symbols like the copyright, infinity, registered trademark, Yen, Pound, Euro etc can be of use in some documents. Word provides an easy way to insert these and many other such symbols into your documents without much hassle (For example, using the Character Map utility provided with Windows).
How To: Create bulleted or numbered lists in MS Word 2007
This video explains how to add a bulleted or numbered list in Microsoft Word 2007. The shortcut to create a bullet-list is simple holding Shift and pressing the "A" key. After you hit the space bar or type a character the bullet will appear, and when you hit the Enter key it will continue the bulleted list. For numbering you just need to type the number you want and a dot after it and it should begin a numbered list. The list will continue if you press enter just like a bullet-list will. If y...
How To: Format tables in MS Word 2007
In this video the instructor shows how to format tables in Microsoft Word 2007. To know how to format tables in Word, you will first have to know how to create them. This video assumes that you already know how to create tables. When you click inside a table in Word, a new tab label, Table Tools, appears above the Design tab in the tool bar. In the Design tab there are a lot of options available that can change the look of your table with just a click. To the extreme left there are three chec...
How To: Calculate variance and standard deviation using Excel
This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are put in it by selecting the appropriate cell. The median is made an absolute constant by pressing the F4 key. This is squared by using '^2'. This is multiplied to the frequency using '*'. The result is found for all the dat...
How To: Use general printing options in MS Word 2007
In this video the instructor shows how to user printer options in Microsoft Word 2007. To do this go to the Microsoft button and click it. Form the drop down menu select the print option. Now you are presented with the three options of Print, Quick Print and Print Preview. Print is used to directly send documents to the printer by selecting the necessary settings. Quick Print is used to quickly send the documents to the printer using the default settings. Print preview is a useful way of seei...
How To: Insert and edit text in MS Word 2007
A video from Helpvids.com that shows how to Insert and edit text in Microsoft Word 2007. There are many ways to do document editing tasks in any of today's advanced word processing programs and MS Word 2007 is no exception to it. There are many ways to do the same task in word (For Ex. from the menu, using mouse gestures, using shortcuts etc).
How To: Add title labels & set data labels in MS Word 2007
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...
How To: Open/copy/save files & create folders in MS Word 2007
When you're using MS Word you should be able to see a large Microsoft office icon in the top-left icon. Clicking it opens up a menu where you should be able to see the save button. Pressing this button will save your work or overwrite a previous copy. If you press 'save as' instead, you will have the option to change what format the file is saved as and what name it is saved under so as not to overwrite the existing copy. When you've decided on the name and format and where to save, just pres...
How To: Use navigation & selection techniques in MS Word 2007
User mel_bone teaches you how to use navigation and selection techniques in Microsoft Word 2007. You will notice in the bottom right corner of the main window a slider. This controls the zoom. You can thus increase the page size or decrease it, as you need. When you have a document that has more than one page, you can go to the end of the document by pressing ctrl+end. Ctrl+home brings you to the start of the document. Clicking and holding the mouse button pressed on the navigation bar lets y...
How To: Make a checklist form in MS Word 2007
This video will go over how to insert a check box in Microsoft Word for printing or for electronic distribution. With just a few clicks you can get a check box. You can even add different symbols or styles for your check box.
How To: Save files in MS Word 2007 as Word file types
This video tells you how to save files in Microsoft Word using different file types. If you are trying to save a file as the old Microsoft Word 97-03, the process is easy. This video takes you through a visual tutorial on how to save files under different documents. If you click the circle in the upper left corner and scroll down to save as, it will give you several different options to save under. Then, you can choose which document you want to save it under, and save the file under a new na...
How To: Use drag & drop in MS Word 2007
In this video the instructor shows how to use the drag-and-drop feature in Microsoft Word 2007. You can use drag-and-drop to copy and move information within the Word document. This is particularly useful when you want to move and copy information within one page. However, if you want to move information between different pages, use the normal copy-paste feature. If you want to move any information, first highlight and select the data. Now click and hold down the mouse button in the middle of...
How To: Create a watermark or background in MS Word 2007
This video shows you how to change the background color and watermark in your Word 2007 document. Both settings are found on the Page Layout tab. The background color can be chosen from a wide palette. The most frequently used colors are immediately applied to the current page as a preview. You can also choose to add a fill effect, like a color gradient, by clicking the Fill Effects item in the Page Color list. The watermark feature allows you to add either a predefined notice, an image or a ...
How To: Insert a picture or clip art in MS Word 2007
For inserting a picture, from the INSERT Tab click picture. Then the insert dialog box gets opened. From there you can locate the desired picture. Locate the picture to be inserted and double click it. We can also replace the picture selected. For replacing any one of the following can be done: Under PICTURE tools, on the FORMAT tab, in the ADJUST group, click Change picture OR right click the picture to be replaced and click CHANGE PICTURE. Locate a new picture, and double click it.
How To: Create a flow chart in MS Word 2007
This video will show you how to create a flow chart in MS Word 2007. First click on the Insert tab. You can see the smart art option, click on it. A "Smart Art Graphic" window will appear.
How To: Use Outlook Express in Windows XP
In this video, the instructor shows how to use Outlook Express in Windows XP. This software comes bundled with Microsoft Windows XP, which is a part of Microsoft Office package. Outlook is an e-mail client that allows you to view your e-mails on your computer without the help of any web interface to your mail host. To use Outlook Express, you need to configure it first. Open the Outlook Express program. Outlook will then take you through a wizard to help you to configure your email host. Ente...
How To: Insert and remove page numbers in MS Word 2007
This video will demonstrate the process to implement page numbers in your Microsoft Word 2007 documents. The video starts out by showing the Insert Tab on the Microsoft Word 2007 Ribbon. On the Insert Ribbon, you will see an icon titled Page Number. All of the Page Number options are available when you click the down arrow directly beside the icon. The are many different position options such top of page, bottom of page, page margins, or current position. The customization options are as endl...
How To: Create data in a chart to graph in MS Word 2007
In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart templates. There are various categories of charts like Line, Pie, Bar in the left hand side. In the right hand side you can see the sample charts available and you can select any of them that you want. Now it transfers you...
How To: Use Excel data analysis functions (max, min, average)
Create a table with sales data with this video.
How To: Apply conditional formatting within MS Access 2010
lyndapodcast teaches you how to apply conditional formatting withing Microsoft Access 2010. You click View - Design View. Click the Total tab and you'll notice some highlighted options above. Click Format and then Conditional Formatting. This where you will create rules. Click the new rule button. Now you will see the conditions with drop-down menus. Type in the numbers you want and then select the formatting you want when the rule is true. The preview below will show you how the numbers will...