Everything Else
How To: Create a drop down box in Excel
Learn how in this video to create a drop down box in a Microsoft Excel cell.
How To: Use the Mid and Find functions in Excel
Learn how to use text functions like mid and find to extract characters from a larger text string within a cell in Excel.
How To: Name ranges of data in Excel
Name ranges of data to make formulas a bit easier to read and write when working in Microsoft Excel.
How To: Use Outlook Express
This tutorial introduces you to the basics of using Outlook Express email program.
How To: Merge and center in Excel 2007
In this tutorial, you will learn how to use merge and center in Excel 2007.
How To: Use the Left, Mid, and find function in Excel 2007
This video demonstrates uses of the left, mid, and find function in Excel 2007 to pull out specific pieces of text from a longer text string.
How To: Add a visual indicator to a Gantt chart in Excel
Adding a visual indicator to an Excel Gantt chart of how far into the project you are.
How To: Create a 2-axis chart in Excel 2007
Create a 2-axis chart in Excel 2007 combining a column chart and line chart
How To: Use the VLOOKUP function in Excel 2007
Several examples of using the VLOOKUP function in Excel 2007.
How To: Create page backgrounds and borders in Word 2007
Creating different borders and backgrounds for pages within a single Word document.
How To: Create bullets, pages borders, and backgroudns in Word
How to create Picture Bullets, Page Borders, and Backgrounds in Microsoft Word 2007.
How To: Make a gantt chart in Excel 2007
Using Excel 2007 to create a Gantt chart--a popular project management tool.
How To: Manage mailbox size in Outlook 2007
Learn how to make sure an Outlook mailbox size is under limits.
How To: Insert video into a PowerPoint presentation
In this video, Ask the Techies explain: •How to insert video into a PowerPoint presentation on both Macs and PCs and how to avoid cross-platform snags. Using Photoshop’s extraction tool to extract a face out of one document and insert into another. •Gettings songs onto an iPod including using the iTunes music store and digital rights management.
How To: Making a Gantt Chart with Excel
This tutorial shows you how to use an Excel to create a project management Gantt chart. There is no default for this, but you can customize a stacked bar chart to do the job.
How To: Create a bar chart in Microsoft Excel
Learn how to compare numerical figures and create a simple bar chart in Microsoft Excel.
How To: Use pictures and clip art in Microsoft Word
How to format Microsoft Word documents that contain picture or clip art and how to import images into Word documents and capture images from your PC screen.
How To: Create message rules and auto-sort with Outlook
How to create message rules and do auto-sorting with Microsoft Outlook. f you ever wish every email from your Uncle Lou could be put into a folder (or the trash) automatically -- or you want to flag message from your boss -- or you want to have a sound play when an ebay outbid notice comes in, then this tutorial is for you.
How To: Optimize Microsoft Word
This Microsoft Word tutorial discusses some tips and tricks for speeding up your work and adding extra function to Microsoft Word.
How To: Work with dates in Microsoft Excel
This Microsoft Excel tutorial goes over formatting dates and using dates in formulas including how to use the "today()" and "now()" functions.
How To: Use formulas and formatting in Microsoft Excel
A beginner's Microsoft Excel tutorial that covers working with formulas, formatting, auto-formatting, dates, and more in Microsoft Excel.
How To: Use 'If' in Microsoft Excel formulas
Learn some more advanced formula uses in Microsoft Excel including the "IF" statement. For example, "IF someone earned over $200 then charge them $20... otherwise charge them $40."
How To: Create forms and charts with Microsoft Excel
Learn some useful tips to make your Microft Excel spreadsheets soar and how to use Excel to create forms and charts.
How To: Make a coordinate plane or Venn Diagram with Excel
How to use Microsoft Excel to produce a Cartesian coordinate plane and a Venn Diagram.
How To: Create charts and diagrams with Microsoft Excel
This tutorial demonstrates how to create charts and diagrams with Microsoft Excel by walking you through creating a seating chart in Excel.
How To: Begin using Microsoft Excel basics
This tutorial introduces some of the basic concepts of Microsoft Excel and then demonstrate a couple practical uses for Excel.
How To: Use advanced features in Powerpoint
Some tips for intermediate to advanced Powerpoint users including adding sounds to presentations and creating custom animations.
How To: Create an Out of Office message with Outlook
Learn how to use the "Out of Office" message feature in Microsft Outlook to automatically send email replies when you are out of town or away from your computer.
How To: Use pivot tables to view data in Access 2007
This screencast tutorial from Matthew MacDonald, author of Access 2007: The Missing Manual, shows you how to use pivot tables to analyze data in Microsoft Access 2007.
How To: Trace formulas in Excel 2007
This screencast tutorial from Matthew MacDonald, author of Excel 2007: The Missing Manual, shows you how to trace formulas in a Microsoft Excel 2007 worksheet.
How To: Use tables in Word 2007
This screencast tutorial from Chris Grover, author of Word 2007: The Missing Manual, guides you through working with tables in a Microsoft Word 2007 document.
How To: Create a combination chart in Excel 2007
This screencast from Matthew MacDonald, author of Excel 2007: The Missing Manual, guides you through creating and modifying a combination chart in Excel 2007.
How To: Create a custom switchboard in Access 2007
This screencast from Matthew MacDonald, author of Access 2007: The Missing Manual, guides you through creating a custom switchboard in a Microsoft Access database.
How To: Add custom animation in PowerPoint 2007
This screencast from E.A. Vander Veer, author of PowerPoint 2007: The Missing Manual, guides you through adding custom animation to an object in your PowerPoint 2007 presentation.
How To: Add a soundtrack in PowerPoint 2007
This screencast from E.A. Vander Veer, Author of PowerPoint 2007: The Missing Manual, guides you through adding an audio soundtrack from a CD to your Powerpoint Presentation.
How To: Use the SmartArt feature in MS Office
Learn about the New SmartArt Feature in Microsoft's Office 2007 which allows you to create interactive graphics in your documents.
How To: Import external data in Excel
Learn how to Import External Data (i.e data from web pages) dynamically into Excel in Microsoft's Office 2007.
How To: Use the formula functions in MS Office 2007
Learn about the New Formula Features in Microsoft's Office 2007 and how to use them to do calculations in MS Office and Excel documents.
How To: Track changes in Microsoft Word
Learn how to Track Changes made to documents in Microsoft's new Office 2007.
How To: Create PDF and XPS files in MS Office
Learn how to create PDF and XPS files directly from Microsoft's Office 2007.