Latest Trending Tech & Gadgets Lifestyle Apple Android

Hot Microsoft Office How-Tos

iOS 18 Tips, Tricks, How-Tos, News

How To: Set your essay to MLA format in MS Word 2007

In order to apply MLA format in MS Word 2007, you will need to change the lines and spacings. Press Control + A. This will highlight all of your typing. Then, click on No Spacing. Scroll to Times New Roman, in the font style drop down menu. Change the font size to 12. Change the line spacing to 2.0. You will need to re-center anything that was centered before. Your headers and footers will still be in the default font style. So, you will need to change them as well. Double click on the header...

How To: Disable quick fill handle & drag-drop Excel features

In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...

How To: Create envelopes and labels in Microsoft Word 2007

Interested in designing and printing out custom envelopes within MS Office Word 2007? Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, and to get started designing your own envelopes and labels in Word 2007, take a look.

How To: Navigate and use the MS OneNote 2010 user interface

Meet the Microsoft Office OneNote graphical user interface (or GUI)! Whether you're new to Microsoft's popular notetaking application or a seasoned MS Office pressional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the OneNote UI yourself, watch this free video guide.

How To: Search a notebook in Microsoft Office OneNote 2010

This clip presents instructions on how to search notebooks within MS OneNote 2010. Whether you're new to Microsoft's popular notetaking application or a seasoned MS Office pressional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started searching your own notebooks, watch this free video guide.

How To: Create a new notebook within Microsoft OneNote 2010

Need some help figuring out how to make a new notebook within OneNote? This guide will show you how it's done. Whether you're new to Microsoft's popular notetaking application or a seasoned MS Office pressional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating notebooks yourself, watch this free video guide.

How To: Make budget summary tables that add by month in Excel

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 642nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budget summary table that adds by month and payee. See the benefits and drawbacks of the SUMIFS & EOMONTH functions method or the PivotTable method. Also learn about the Excel Table feature for adding dynamic ranges.

How To: Write a value to a cell using VBA in Microsoft Excel

See how to use VBA to write a value to a cell within a Microsoft Excel workbook. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.

How To: Run a VBA routine in a Microsoft Excel spreadsheet

This clip presents a general overview of how to execute a VBA routine within an MS EXcel spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.

How To: Use object-oriented programming in Microsoft Excel

This clip offers a general introduction to using VBA within MS Excel. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.

How To: Insert a horizontal line in Microsoft Office 2007

In this video tutorial, viewers learn how to a horizontal line in Microsoft Office 2007. Begin by clicking on the Page Layout tab and select Page Borders. Then click on Horizontal Line. Scroll through the list and select a type of horizontal line. When finished, click on OK. Users are able to drag the horizontal line around by holding down the left button on the mouse and moving it. When users highlight the line, right-click on it and select Format Horizontal Line. There users will be able to...

How To: Align & group objects & use gridlines in MS Word 2007

In this video tutorial, viewers learn how to align and group objects, and use gridlines. Begin by clicking the Insert tab and select a shape from Shapes. To align the object, go to the Format tab and select the Align menu. From there, users are able to align the selected object in any direction. In the Align menu, users are also able to add gridlines by selecting View Gridlines. To configure the grid-line options, click on gridlines Settings. This video will benefit those viewers who use Micr...

How To: Use borders in MS Word 2007

To use borders in Microsoft Word 2007, you begin by clicking on the Page Layout tab. Next, click on Page Borders. This will open a window. Page borders will border the entire page. You are able to custom choose the width of the lines, the style of the border, or the color of the border. The color drop down menu will allow you to choose automatic colors or custom colors. You can also choose to remove one or more of the sides. You can decide which pages to add borders to, as well. There are als...

How To: Print an Excel worksheet or workbook with gridlines

In this video tutorial, viewers learn how to print the gridlines with a Microsoft Excel spreadsheet. This task is very fast, easy and simple to do. By default, Microsoft Excel will not print a spreadsheet with the gridlines. Begin by clicking on the Page Layout tab. In the Sheet Options box, under gridlines, check Print. To remove the gridlines, do the reverse of this operation. To view the page with gridlines, click on the Office button, go to Print and select Print Preview. This video will ...

How To: Insert a movie into a PowerPoint 2007 presentation

In order to insert a movie into a PowerPoint 2007 presentation, you will need to create a placeholder for the insert, in your presentation. Click on the media center. A window will pop up, which will allow you to open your movie. If you have already have your presentation, but you haven't left a placeholder, you can add your movie by going to the point where you want to add the movie, in your presentation. Then, click Insert. Go to Media Clips group. Choose an option from the drop down menu t...

How To: Make a basic bar graph in Microsoft Excel

In this Software video tutorial you will learn how to make a basic bar graph in Microsoft Excel. You will also learn how to give your chart a title and how to label the axes. First you put in all your data in to an Excel spreadsheet. Then you highlight the data you want to put in your graph, select the 'insert' tab, then' column' and choose the basic column chart. Next you select the title tab, go to option and choose new title. Now you add the title to the graph. To label the axes, go on top...

How To: Insert clip art with Microsoft Office Word 2007

This video tutorial is in the Software category which will show you how to insert clip art with Microsoft Office Word 2007. Open a word document and click on 'insert' tab on the navigation bar and then click on 'clip art'. The task pane will show up on the right side of the page. Here you type in the subject of the clip art you are looking for in the 'search for' box. For example, type in 'tiger' and then click 'Go'. A list of images is displayed. Click on the one you like and it will be disp...

How To: Setup Microsoft Outlook 2007 with email

In this video tutorial, viewers learn how to setup Microsoft Outlook 2007. Begin by opening the Outlook Express 2007 program. Then click on Tools and select Account Settings. Under the Email tab, click on New. Now type in your name, email address and password. Then click on Next. Select Internet Email and click on Next. Now type in your user information, server information and log on information. Then click on More Settings and click on the Outgoing Server tab. Check the first box and then cl...

How To: Create tables in MS Word 2007

In this video tutorial, viewers learn how to create tables in Microsoft Word 2007. Begin by clicking on the Insert tab and select Table. Then users are able to create a table by dragging the mouse across the squares to determine he amount of columns and rows. Make the final selection by simply clicking. Another option is to click on Tables and select Insert Table. Then users are able to input the number of columns or rows. This video will benefit those viewers who use Microsoft Office 2007, a...

How To: Insert WordArt with Microsoft Office Word 2007

In order to insert Word Art, into your document, using Microsoft Word 2007, you will need to begin by opening your document. Next, find "Insert", at the top of your screen. Click on it. This will take you to the Insert Tool Bar. Find Word Art. Choose the style that you would like to use, from any of the styles in the style gallery. When the window opens, you can choose your font style at the top, if you want to change from the default setting. You can also change the font size. Write the word...

How To: Insert or delete a comment in MS Word 2007

This video tutorial is in the Software category which will show you how to insert or delete a comment in MS Word 2007. This video shows how to insert both text and audio comments in to your word document. Click on the 'review' tab on top, highlight a part of the text that you want add comment to and click on 'new comment' tab. Then you can insert the comment in the comment box. You can continue adding comments throughout the document in the same way. You can view the comments by selecting 'ne...

How To: Convert between DOC and PDF file formats with doPDF

In this video tutorial, viewers learn how to convert word documents to PDF format. This task is very easy, simple and fast to do. Users will need to download a program from this site: DoPDF. Once downloaded and installed, open the program and open the file that you want to convert. Then click on File and select Print. Choose the printer name as "doPDF" and click OK. When a window pops up, select the location where you want to save the file. This video will benefit those viewers who have a tex...

How To: Insert or delete footnotes & endnotes in MS Word 2007

In this video tutorial, viewers learn how to insert or delete footnotes or end-notes in Microsoft Word 2007. A footnote is a little reference which will place a small number in subscript and link it to a comment. A end-note is similar except it links the comment to the end of the document, rather than the end of the page. Begin by highlighting the text. Then click on the Reference tab and select Insert Footnote/End-note. Then just add a comment to the subscript. This video will benefit those ...

How To: Flag and categorize messages in Microsoft Outlook 2010

See how to organize your email by creating categories and flagging individual messages within Microsoft Office Outlook 2010. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.

How To: Use out-of-the-box workflows in MS SharePoint 2010

This guide will show you how to use a number of less conventional SharePoint workflows. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Create an Enterprise Wiki with MS SharePoint 2010

Want to create your very own Enterprise Wiki page? This guide will show you how it's done. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Create site collections in Microsoft SharePoint 2010

Interested in creating a site collection within Microsoft SharePoint 2010? This guide will show you how it's done. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Set and work with permissions in MS SharePoint 2010

Need some help figuring out how to use permissions in Microsoft SharePoint 2010? This guide will show you how it's done. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Create and use document workspaces in SharePoint 2010

Learn how to create and work with document workspaces in SharePoint 2010. This guide will show you how it's done. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Edit your SharePoint 2010 home page

Need some help figuring out how to edit your homepage within SharePoint 2010? This guide will show you how it's done. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using SharePoint yourself, watch this free video guide.

How To: Create a Team Site within SharePoint 2010

Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Use the Microsoft Office Ribbon UI in PowerPoint 2010

In this clip, you'll learn how to utilize the MS Office Ribbon interface when working within PowerPoint 2010. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the PowerPoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating and using the Ribbon interface in your own PowerPoint projects, watch this free video guide.

How To: Use the Backstage view in Microsoft PowerPoint 2010

Learn how to use the new Backstage view feature in Microsoft PowerPoint 2010 to better manage your slideshows. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the PowerPoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating and using the Backstage view in your own PowerPoint projects, watch this free video guide.

How To: Create a dynamic frequency table & chart in MS Excel

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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....

How To: Run a chart lookup with defined names in MS Excel

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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.

How To: Find approximate matches in unsorted columns in Excel

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 639th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will do an approximate match lookup with an unsorted lookup table that can be copied across multiple columns and do lookup from multiple columns.