Dialog Box
402 Stories
Open multiple Word 2003 documents in one window
Techguide Consolidate and streamline your Word document display to avoid the clutter of individual application windows.
Tags: Microsoft Office, Microsoft Corp., Data, List, Cell, Item, Record, Microsoft Word 2003, Chances, AutoComplete
Use an Excel array function to create an AverageIf function
Techguide Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally.
Tags: Microsoft Office, Microsoft Corp., Database, Tool, Database Table, clip art, Mouse, Microsoft Excel, Microsoft Access, dialog box
Add a looping introduction to a PowerPoint presentation
Techguide You can set up your slide shows to include a little preview presentation that will help prime your audience for the main event. Susan Harkins shows this simple but highly effective technique.
Tags: Microsoft Office, Presentation, Slide, Template, Button, Invoice, PowerPoint Presentation, Microsoft Excel 2007, sales tax, Figure
BlackBerry smartphones open to SMS attack
News Certificate notification issue means BlackBerry users could be tricked into visiting malicious Web sites, Research In Motion has warned.
Tags: Viruses and worms, Network security, BlackBerry, Research In Motion Ltd., Smart Phone, E-mail, dialog box, Web Site, RIM BlackBerry, software
Compress pictures to reduce the size of your PowerPoint presentation
Techguide While pictures improve the Powerpoint presentation's appeal, they increase the file's size.
Tags: Microsoft Office, Name, Presentation, PowerPoint 2007, Microsoft Corp., software, Cell, File, Tool, Mouse
10+ keyboard shortcuts for entering special characters in a Word document
Techguide If you prefer to enter special characters yourself on a case-by-case basis, it's handy to know a few keyboard shortcuts.
Tags: Microsoft Office, keyboard shortcut, keyboard, Microsoft Excel, Microsoft Access, dialog box, technique, window, Microsoft Office, Microsoft Word
Microsoft tweaks antipiracy tech for Windows 7
News The software maker is making a couple of changes to the activation process for the operating system as it works to find the balance between preventing piracy and limiting annoyance.
Tags: Piracy, Microsoft Windows, Microsoft Corp., Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows Genuine Advantage, antipiracy, software, Microsoft Windows XP, Microsoft Windows
A quick method for counting Access records in a form
Techguide There are several ways to count the records in a form's recordset. In fact, Access forms display the record count by default.
Tags: Microsoft Office, Method, File, Tool, Tools Menu, Microsoft Excel 2007, File Menu, Microsoft Excel, Microsoft Access, dialog box
Spot invalid imported data with help of custom Excel function
Techguide Anytime you have to manually review worksheet data to look for errors, something can slip through. Here's a handy safety net: a user-defined function that will flag one type of invalid data.
Tags: Microsoft Office, Animation, ALT, Microsoft PowerPoint, Microsoft Excel, dialog box, Microsoft Office, Microsoft Word
Use an Excel command to quickly separate first and last names
Techguide If you need to split a list of names into two columns, you don't have to do it manually. See how this Excel wizard can quickly knock out the task for you.
Tags: Microsoft Office, Microsoft Corp., Column, Dirty Property, check box, Microsoft VBA, Microsoft Excel 2007, Figure F, Microsoft Excel, Microsoft Word 2007
Make your Access forms run faster
Techguide By giving a form less data to digest, you can make it run more efficiently. These two tricks can help.
Tags: Microsoft Office, Microsoft Corp., Form, data entry, Mail Merge, performance, Microsoft Excel, Microsoft Word 2007, Microsoft Access, Illinois
Print selected pages from different sections of a Word document
Techguide Choosing which pages to print is a straightforward process, thanks to Word's Page Range options. But if those pages belong to different document sections, you'll need to give Word a little extra guidance.
Tags: Microsoft Office, Microsoft Corp., Section, Chapter, Parameter Query, data entry, Microsoft Excel 2007, Figure, Microsoft Excel, Microsoft Access
Using Microsoft Excel with SharePoint 2007
Techguide Excel and SharePoint 2007 offer interactive features that simplify many collaborative tasks. Here's a look at what's in store.
Tags: Microsoft Office, Microsoft Corp., Data, Table, List, Workspace, SharePoint List, Datasheet, Refresh, Microsoft Excel
Add sounds to your Access form events
Techguide Access lets you play a sound for any form event. Find out how to do it in this step-by-step guide.
Tags: Microsoft Office, keyboard shortcut, shortcut menu, Mouse, Microsoft Excel, toolbar, Microsoft Access, dialog box, window, Microsoft Office
Use Wingdings to add graphics to Access forms and reports
Techguide You can insert a symbol or picture into a form or report, but embedded graphics consume a lot of resources.
Tags: Microsoft Office, Error, Microsoft Corp., Code, MsgBox, keyboard shortcut, Graphics, vbOKOnly, Alan Wood, Insert
