Everything Else
How To: Create a dynamic line chart for accounting 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 647th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic line chart that will show any updates to the cash account.
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: Base a PivotChart on a PivotTable in Microsoft 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 641st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a PivotChart based on a PivotTable in one click.
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: Repeat a task with a VBA For...Next loop in MS Excel
Repeating a task using a For...Next loop : Excel: VBA in Depth from lynda.com Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube
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: 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.
How To: Create a chart with two horizontal axes 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 638th installment in their series of digital spreadsheet magic tricks, you'll learn how to add two horizontal axes to a chart.
How To: Use exact & approximate matching with VLOOKUP in Excel
New to 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 Excel tutorial from ExcelIsFun, the 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to