Hot Microsoft Office How-Tos
How To: Create a graph or chart in Excel 2007
This video demonstrates how to create a graph or chart in Excel 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create a graph or chart in Excel 2007, For Dummies.
How To: Add hyperlinks to a PowerPoint presentation
This video demonstrates how to add hyperlinks to a PowerPoint presentation. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to add hyperlinks to a PowerPoint presentation, For Dummies.
How To: Record narration for a PowerPoint presentation
Need to record narration for a PowerPoint presentation. Watch this video to learn how. Adding narration to PowerPoint presentations is easier than it sounds. You can record your voice to narrate your slide show and then link to or embed the sound file to your presentation. This video shows you the steps. Record narration for a PowerPoint presentation.
How To: Add video to a PowerPoint presentation
Check out this lesson from Dummies.com on how to add videos to your PowerPoint presentations. This is easy and greatly enhances your slideshow. Make your presentation extra engaging and professional by integrating video.
How To: Create tables in Word 2007
This video demonstrates how to create tables in Word 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create tables in Word 2007, For Dummies.
How To: Convert text to table in Word 2007
This video demonstrates how to convert text to table in Word 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to convert text to table in Word 2007, For Dummies.
How To: Create and apply PowerPoint templates
This video demonstrates how to create and apply PowerPoint templates. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create and apply PowerPoint templates, For Dummies.
How To: Make handouts to accompany a PowerPoint presentation
This video demonstrates how to make handouts to accompany a PowerPoint presentation. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to make handouts to accompany a PowerPoint presentation, For Dummies.
How To: Add images to a Word 2007 document
This video demonstrates how to add images to a Word 2007 document. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to add images to a Word 2007 document, For Dummies.
How To: Animate text in a PowerPoint presentation
This video demonstrates how to animate text in a PowerPoint presentation. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to animate text in a PowerPoint presentation, For Dummies.
How To: Import and export in Microsoft OneNote 2007
Microsoft Office OneNote 2007 is an incredibly versatile way to capture your thoughts and organize your work. It's far more than a sketchpad: its powerful import and export tools will create a central idea forum for you and your team. For detailed instructions on using the import and export features in Microsoft Office OneNote 2007, watch this video guide.
How To: Use Microsoft Office OneNote 2007
Do you ever wish you had a way to jot down an idea, and then illustrate it with a page from a document, a photo and a sound clip, all without opening multiple applications? Microsoft Office OneNote 2007 note-taking program is that advanced notepad, and is better than ever with new additions to the interface that make it even easier to organize yourself. For more on using MS Office OneNote, watch this video tutorial.
How To: Use templates in Microsoft Office PowerPoint 2007
Building a presentation can be time consuming. You need to make sure the layout is consistent from slide to slide, and make sure important graphic or text elements make it to every slide. Fortunately, in Microsoft Office PowerPoint 2007, you can create a template to speed the process. For detailed instructions on using templates in Microsoft Office Power Point 2007, watch this video tutorial.
How To: Use the auto-complete feature in MS Office Excel 2007
Microsoft Office Excel 2007 Tip - Using Formula Auto-Complete - Microsoft® Office Excel® 2007 is truly at its best when it's working hard behind the scenes to execute complex calculations, working with any of a number of standard formulas. When we're creating spreadsheets, formulas should be easy to replicate again and again, but human error can sometimes get in the way.
How To: Find data with Instant Search in MS Outlook 2007
Microsoft Windows Vista Tips - Finding Information with Instant Search in Microsoft Office Outlook 2007 - Somewhere in the hundreds, or perhaps thousands of messages in your Microsoft Office Outlook 2003 mailbox is the one that has the information you need about that client meeting on Thursday. So how do you find it without reading through every one of your messages? The new Instant Search feature in Microsoft Office Outlook 2007 allows you to find the information you need instantly. For more...
How To: Secure MS Word documents with Digital Signatures
Securing Microsoft Office Word 2007 documents with Digital Signatures - When you receive a document that has been signed by someone you know, you are more likely to trust the contents than those of a document that has not been signed, or has been signed with an unfamiliar signature. Signing a document validates it to someone who recognizes your signature, now add the same degree of integrity to your documents in Microsoft Office Word 2007 thanks to the new Digital Signatures feature. For more...
How To: Set up signatures for multiple Outlook accounts
Microsoft Outlook 2007 Tip - Setup Signatures for Multiple Email Accounts - One of the difficulties with using multiple mail accounts is making sure your messages have the correct signature, or sig, attached to them. The new Signatures feature in Microsoft® Office Outlook® 2007 takes the hassle out of creating and applying signatures to your email.
How To: Use update queries in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about updating records in Access using update queries.
How To: Use full-screen reading in Microsoft Office Word 2007
If you've ever found yourself printing a copy of a document in Microsoft Office Word just to be able to read it, you'll appreciate the new Full Screen Reading feature in Microsoft Office Word 2007. For more on utilizing this handy new feature of Word, watch this MS Office how-to.
How To: Use the QUOTIENT and MOD functions in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about the QUOTIENT and MOD functions. Note that, in urder to use these functions, you'll need to install the analysis ToolPak. For more information, watch this Excel how-to.
How To: Count word length with the LEN function in MS Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using LEN to count word length. To get started using the LEN function for yourself, watch this how-to.
How To: Summarize data with pivot tables in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using a pivot table to summarize data.
How To: Add comments to cells in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about adding hidden comments (and metadata more generally) to data cells. For more information on commenting, watch this Microsoft Office Excel how-to.
How To: Use COUNTIF in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about Using COUNTIF function to count the number of As, Bs and Cs. For more on using the Microsoft Excel COUNTIF fucntion, watch this how-to.
How To: Use HLOOKUP across two worksheets in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using the HLOOKUP function to generate adaptable grades from marks. For more on using HLOOKUP across multiple documents, watch this Microsoft Office how-to.
How To: Use the LEFT and RIGHT functions in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about concatenation using LEFT and RIGHT functions. For more information, watch this Microsoft Office how-to.
How To: Concatenate in Microsoft Excel using cell references
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about concatenation using cell references only. For more on textless concatenation, watch this MS Office how-to.
How To: Concatenate in Microsoft Office Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about stringing text and data together by using an ampersand (&) concatenation. To learn more, watch this MS Office how-to.
How To: Use conditional formatting in Microsoft Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using conditional formatting in Excel to change background color. To get started learning about conditional formatting, watch this MS Office how-to.
How To: Use VLOOKUP across worksheets in MS Excel 2007
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS Office how-to.
How To: Use VLOOKUP in Microsoft Office Excel 2007
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP to look up values located in a table. To learn more about VLOOKUP, watch this MS Office Excel how-to.
How To: Use nested IF statements in Microsoft Office Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.
How To: Use absolute ($) cell referencing in Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.
How To: Calculate averages in Microsoft Office Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.
How To: Use simple formulae in Microsoft Office Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about simple addition, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.
How To: Format spreadsheets in Microsoft Office Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.
How To: Get started using Microsoft Office Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. This Microsoft Office video tutorial presents an extremely introduction to Excel. In it, you'll learn about names of bits and really simple formatting. To get started using Excel for yourself, take a look.
How To: Create a simple table in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about basic table setup in MS Access. Several different fields used and lookup wizard used are used in this tutorial. For more information, and to get started creating your own tables in Access, watch this how-to.
How To: Create relationships in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating relationships between tables. For more on creating and managing relationships in MS Access, watch this how-to.
How To: Mail merge with Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a letter to multiple recipients using one form letter and a table to populate it. For more on using mail merging in Microsoft Access, watch this how-to.