Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Save effort by defining names for Excel 2007 formulas
- Simplify things for your Excel users: Name the formulas they'll need to use. That way, they won't have to create the formulas for themselves. by Mary Ann Richardson
- Tags: Formula, Microsoft Excel 2007, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-08-04
- Let Word address your letters for you
- Inserting addresses in a Word document doesn't have to be a chore. Using Smart Tags, you can automatically pull in the address of anyone in your Outlook contact list. by Mary Ann Richardson
- Tags: Microsoft Word, Word Processors, Microsoft Office, Microsoft Outlook, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-08-04
- Fine-tune your Access queries to remove duplicate entries from your mailing lists
- If you query your Access database to generate a mailing list, but the list contains duplicate names and addresses, this helpful trick will save you some time. See how tweaking the query properties can ensure a list with unique entries. by Mary Ann Richardson
- Tags: Microsoft Access, Query, Mailing List, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-08-04
- Export holidays from your Outlook 2007 Calendar to an Excel worksheet
- Bringing your holiday list into Excel enables you to work with various date functions, such as Workday. Here's a trick for quickly getting company holidays from Outlook 2007 to Excel. by Mary Ann Richardson
- Tags: Microsoft Excel, Microsoft Office, Microsoft Outlook, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-29
- Visually group Access data with lines, rectangles, and back color
- With a few simple formatting tweaks, you can make your Access reports far easier to read and interpret. by Mary Ann Richardson
- Tags: Microsoft Access, Rectangle, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-07-29
- Wrap text around text in Word 2007
- Word 2007 expands your wrapping options in a text box. Here's a look at how to wrap around text rather than around the text box boundaries. by Mary Ann Richardson
- Tags: Box, Microsoft Word 2007, Figure D Word 2007, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-29
- Use Excel's Workday function to determine delivery dates
- Your customers will appreciate knowing exactly when they can expect their orders to arrive -- and Excel makes it easy to set up a calculation that can tell them. by Mary Ann Richardson
- Tags: Workday, Delivery Date, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-22
- Use Access table validation rules to protect data integrity
- When the validity of data in one field depends on what's entered in another field, you'll want to build a validation rule. Here's a step-by-step look at the process. by Mary Ann Richardson
- Tags: Microsoft Access, Field, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-07-22
- What to do when styles don't seem to match
- Sometimes, there may be variations in the appearance of your text, even if it carries the same style. As Mary Ann Richardson explains, Word's Reveal Formatting feature can help you ferret out any discrepancies. by Mary Ann Richardson
- Tags: Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-22
- Build related tables with the Access 2007 Lookup Wizard
- The Access 2007 Lookup Wizard makes it easy to create a related table. This walk-through demonstrates how it works. by Mary Ann Richardson
- Tags: Job, Microsoft Access, Job Title, Table, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-07-15
- When Excel's AVERAGE function doesn't give true results, try AVERAGEA
- If your data includes text values, Excel's AVERAGE function won't give you an accurate picture. See how AVERAGEA can solve this problem. by Mary Ann Richardson
- Tags: AVERAGEA, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-15
- Change all instances of a style at once with Word's Formatting And Styles pane
- Here's a lightning-fast way to globally replace styles in a Word document. by Mary Ann Richardson
- Tags: Style, Section Heading, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-15
- Fix numbers that deviate from your numbered list format
- If one of your list numbers appears in a different format from the rest, the problem isn't the number format -- it's paragraph formatting. Here's how you can eliminate the formatting to make the number match the others. by Mary Ann Richardson
- Tags: Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-08
- Navigating the Access 2007 Navigation Pane
- Access 2007's Navigation Pane displays only tables unless you tell it otherwise. Find out how to set it so that other objects show up there, too. by Mary Ann Richardson
- Tags: Microsoft Access, Access 2007, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-07-08
- Use Excel to calculate the number of working days you have to complete your projects
- When you're trying to determine how many days you have left before reaching a project deadline, try this handy Excel technique. by Mary Ann Richardson
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-08
- Calculating Access fields with Null values
- Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes. by Mary Ann Richardson
- Tags: Microsoft Access, Formula, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-07-01
- Five Word borders you can apply as you type
- Word offers a variety of border styles you can use to separate or set off areas in a document -- and you can apply them automatically with these keyboard tricks. by Mary Ann Richardson
- Tags: Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-01
- Set a print area to keep Excel from printing what you don't want
- When you need to prevent Excel from printing certain cells, you can define a print area that excludes them. Here are the steps you need to follow. by Mary Ann Richardson
- Tags: Cell, Printing, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-01
- Save time and keystrokes with a Save Record button
- Changes to an Access record aren't saved until the user moves to the next record -- which can sometimes mean tabbing through a bunch of controls just to execute the save. See how to add a Save Record button that lets the user save a record immediately after a change....
- Tags: Microsoft Access, Command Button, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-06-24
- Use VBA to bring in the range
- When you want to locate the last cell containing data in a worksheet, you can press Ctrl + End -- but that may take you beyond the range of data you're using. Here's a trick for resetting the used range so that Excel will take you to the right spot....
- Tags: Microsoft VBA, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-06-24
Introducing SmartPlanet
-
-
Find thought-provoking progressive ideas on topics that intersect with technology, business and life.
Visit Today
-
-
Technology, perspective, and insights shaping the world
-
Learn innovative and practical skills for your business and your life. SmartPlanet offers 360 degree coverage that you need to feel connected to the information that matters to the world at large.
Go to SmartPlanet
