User: DemoTrainer |
Excel 2007: Distribute 1 cell across multiple cells See more Excel 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx. Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address, city, state/province, postal code, country/region — one for each column, you can remove those limits. Watch this demo to see how to use the Convert Text to Columns Wizard to automatically break up a single column of full addresses into multiple columns. Tags: Excel 2007 Microsoft training tutorial how-to |
User: DemoTrainer |
SharePoint Server 2007: Creating a SharePoint team site See more server demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx Microsoft Office SharePoint Server 2007 can help you get your work done more efficiently because it provides organizations with a platform for sharing information and working together in teams. A SharePoint site offers specific kinds of tools and workspaces that you can use to communicate with team members, track projects, coordinate deadlines, and collaboratively create and edit documents. Tags: Microsoft training Office 2007 SharePoint Server how to |
User: DemoTrainer |
Excel 2007 Demo: Create a formula with Function AutoComplete See more Excel 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx The Formula AutoComplete feature in Office Excel 2007 helps you avoid syntax or typing mistakes that can break your formula and display an error in the cell. Every step of the way, Formula AutoComplete guides you with ScreenTips that show you how to build your formula. Watch the demo and then try it yourself. Tags: Microsoft training Office 2007 Excel how to AutoComplete Function ScreenTips computer |
User: DemoTrainer |
Excel 2007 Demo: Hide or unhide rows and columns See more Excel 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx In Microsoft Office Excel 2007, you can hide rows and columns in several ways to change your view of the worksheet. When you finish your task, you can unhide the rows and columns to return the worksheet to its original state. This demo shows you quick ways to temporarily hide the data you don't want to see — so you can focus on what you do want. Tags: microsoft training free excel worksheet manipulate hide rows columns |
User: DemoTrainer |
Windows SharePoint Services Demo: Boost teamwork with a wiki See more server demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx You and your team members can use a wiki to add, edit, and link Web pages quickly and easily. On your wiki created with Windows SharePoint Services 3.0, your team can plan a conference, brainstorm your next product or campaign, develop a proposal, and more. With a wiki, you can collect and update information painlessly, as it changes. The demo shows you how to get started with a wiki site template in Windows SharePoint Services. Tags: wiki training sharepoint microsoft software team office 2007 how to collaborate web site intranet |
User: DemoTrainer |
Word 2007 Demo (2 of 2): Let Word manage table of contents See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx In this second of a 2-part demo, you'll see how to make last-minute changes in your table of contents as you prepare to publish your finished document. You can even change styles and formats for the headings and add heading levels. Got a document with a manually produced TOC? Learn how to easily convert it to an automatic table of contents. Tags: microsoft software training word document table of contents TOC create office 2007 how to |
User: DemoTrainer |
Word 2007 Demo (1 of 2): Let Word manage table of contents See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx Putting together a table of contents is as easy as 1, 2, 3, especially when you use built-in heading levels as you begin writing your first draft. Then let Microsoft Office Word create the TOC with your headings. Watch the demo to see how to insert a table of contents and make revisions that Word will update automatically. Tags: microsoft software training table of contents TOC word document office 2007 how to |
User: DemoTrainer |
Word 2007 Demo: Use Word Viewer to open or print documents See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx Even if you don't have Microsoft Office Word 2007, you can open Word documents with Word Viewer. In this demo, a Microsoft employee shows how you and your coworkers can download Word Viewer and the Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats. With these 2 downloads, you can open, print, or copy and paste from Word documents without having to install Word on your computer. Tags: microsoft training software word documents viewer compatibility pack legacy versions lower view read print |
User: DemoTrainer |
Word 2007 Demo: Scenarios for headers and footers in Word See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx Adding a header or footer to your document is now much easier with Microsoft Office Word 2007 building blocks. In this demo, a Microsoft employee who uses Word himself demystifies the options and shows you exactly how to do it. The demo covers some common questions from customers, such as when to use a page number design versus a header or footer design, how to set up a cover page, and how margins and headers and footers work together. Tags: training software microsoft word documents headers footers format margins |
User: DemoTrainer |
Word 2007 Demo: Remove tracked changes from Word documents See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx Leaving visible revision marks and comments in a document that you thought was "final" can be embarrassing. In this demo, a Microsoft employee demystifies what's going on with those tracked changes that you thought were gone from your Microsoft Office Word 2007 document. He also shows you two ways to banish those markings permanently and gain peace of mind. Tags: microsoft training word document strikethroughs edits revisions delete remove clean |
User: DemoTrainer |
Word 2007 Demo: Add pictures to a document from a scanner See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx If you're baffled about how to get your own photographs into your Microsoft Office Word 2007 documents, watch this demo. A Microsoft employee who uses Word himself shows you how to insert your picture or digital photo into a document and format it the way you want. He addresses questions about terms like "inline" and "floating," and explains how easy it is to set up a watermark. Tags: microsoft software training word pictures photos photographs watermark scan document insert graphics |
User: DemoTrainer |
Word 2007 Demo: Use tracked changes in documents See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx The Tracked Changes feature in Microsoft Office Word 2007 makes it easy for your team to collaborate on documents. In this demo, you'll see how to make tracked changes and comments, how to review them, and how to accept or reject changes. The demo shows several ways to do these tasks, and also shows you how to make sure all revisions are deleted from finished documents. Tags: revisions edit comments word documents software training microsoft edits office 2007 how to |
User: DemoTrainer |
Word 2007 Demo: Build a document with building blocks See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx Fear the blank page no longer. With the new building blocks feature in Word 2007, you can create sharp-looking business documents more easily than ever. You assemble your document from galleries of predesigned parts, add your business information, and save the building blocks to use again. Tags: software microsoft training word boilerplate templates documents reuse text office 2007 how to |
User: DemoTrainer |
Project 2007 Demo: Add, hide, and show columns in Project See more Microsoft Office demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx Suppose you created a project plan in Microsoft Office Project 2007, and you want to add a new column of information. You also want to be able to choose not to display the new information, but you don't want it to be lost. You can create a column, hide a column, and show a column that you previously hid Tags: project microsoft training columns plan data information spreadsheet office 2007 how to |
User: DemoTrainer |
Word 2007 Demo: Place watermarks in Word documents See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx With watermarks, you can add a new layer of information to your Microsoft Office Word 2007 documents. This demo shows you how to add a watermark to whatever section of your document you want and position it on the page where you want it. It demonstrates how to use graphics and text to create a custom watermark, such as your company logo. Tags: microsoft training word watermark logo graphics document office 2007 how to |
User: DemoTrainer |
Word 2007 Demo: Part 3, use headers and footers See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx Did you inherit a document that already contains headers and footers? In this third demo in a series of 3, you learn how to change existing headers and footers or delete them and add your own. You also learn how to save the headers and footers you create for future use and how to add a file name path to a document header. Tags: tips software training word microsoft headers footers customize documents office 2007 how to |
User: DemoTrainer |
Word 2007 Demo: Part 2, Use headers and footers See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx In this second demo in a series of 3, you create different headers and footers for odd and even pages. You learn how to customize the headers and footers in different sections or chapters of your document. You also select a cover page design and set the page numbering to start on the first page of text. Tags: microsoft software training word headers footers documents customize page numbers cover numbering office 2007 how to |
User: DemoTrainer |
Word 2007 Demo: Part 1, Use headers and footers See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx In this first demo in a 3-part series, you learn how to add page numbers to multiple-page documents, customize your document from a gallery of predesigned headers and footers, and even change the theme. Tags: microsoft training software word documents customize page numbers headers footers add themes design office 2007 how to |
User: DemoTrainer |
Word 2007 Demo: Share documents to earlier versions See more Word 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx How to share Microsoft Office Word 2007 documents with people using earlier versions of Word. Colleagues can open, read, and edit documents you create in Word 2007. You can make Word 2007 documents fully available for editing by turning on Compatibility Mode. Tags: documents word microsoft training compatibility legacy older versions old earlier convert file view how to 2007 |
User: DemoTrainer |
OneNote 2007 Demo: Set up a OneNote notebook See more OneNote 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx With Microsoft Office OneNote 2007, you can create a new notebook with a few clicks and set it up the way you want it. You can share with colleagues or not. Add sections to organize information the way you want: by client, by product, by date, by region. And you can rearrange later by just clicking and dragging. Tags: Office 2007 how to training onenote notebook software microsoft get started setup set up orientation |