On ZDNet: Why Money just wants to be free
10615 Resources for

microsoft office

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Generate a list of unique entries in an Excel column
When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick walk-through shows how it's done. by Jeff Davis
Tags: Column, List, Microsoft Excel, Microsoft Office, Office Suites, Software, Jeff Davis
Blog posts 2008-08-05
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
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
Quickly apply multiple formats in a Word document
Applying multiple formats throughout a document can be a tedious task. Bust the task with this easy-to-use keyboard shortcut. by Susan Harkins
Tags: Format, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Susan Harkins
Blog posts 2008-08-04
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
Create a custom letterhead template in Word
Printing your own stationery can save you significant bucks -- you can print on an as-needed basis and make changes whenever you want without incurring any charges. Here's what you need to know about using Word to set up a letterhead template. by Susan Harkins
Tags: Page, Margin, Template, AutoShape, Susan Sales Harkins, Document Management, Microsoft Word, Word Processors, Printers, Microsoft Office, Enterprise Software, Software, Finance, Managerial Accounting, Office Suites, Hardware, Peripherals, Susan Harkins
Blog posts 2008-07-30
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
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
How to reference an Access subform
Referencing a control on an Access form is easy. Referencing a subform and its controls is a little more complex. To Access, a subform isn't a form at all, but a control, so you must reference it as such. by Susan Harkins
Tags: Microsoft Access, Control, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
Blog posts 2008-07-28
Quick access to Excel formula bar via keyboard
A quick keyboard shortcut puts you right into the Formula bar. You don't need the mouse at all! by Susan Harkins
Tags: Mouse, Formula, Keyboards, Microsoft Excel, Mice, Microsoft Office, Hardware, Peripherals, Office Suites, Software, Susan Harkins
Blog posts 2008-07-25
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
Quickly move extra text onto its own slide in PowerPoint
Crowded slides are guaranteed to send your audience scrambling for the exits. Luckily, PowerPoint makes it easy to scoot excess text onto a new slide. by Susan Harkins
Tags: Toolbar, Slide, Microsoft PowerPoint, Microsoft Office, Office Suites, Software, Susan Harkins
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
How to get the Office spell checker to ignore Internet addresses
Internet addresses fill our correspondence and documents, and those addresses confuse the spell check feature. If you don't want the spell checker to stop at each Internet address, tell it to stop -- permanently. by Susan Harkins
Tags: Spell Checker, Microsoft Office, Internet, Office Suites, Software, Susan Harkins
Blog posts 2008-07-21
Dinosaur Sighting: Microsoft Bob
If you think Vista was Microsoft's worst product ever, you've never seen Microsoft Bob. Bob was Microsoft's attempt to make computers easier to use in the 90's. Here's a look back. by John Sheesley
Tags: Microsoft Windows Vista, Microsoft Corp., Microsoft Windows, Microsoft Windows Vista (Longhorn), Operating Systems, Microsoft Office, Software, Office Suites, John Sheesley
Blog posts 2008-07-18
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
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
Create a Strikethrough shortcut in Word
Applying the Strikethrough format to text in a Word document requires a trip to the Font dialog box -- which will get old in a hurry, if you use that format a lot. Taking a moment now to create a keyboard shortcut will provide a big efficiency payoff. by Jody...
Tags: Dialog Box, Keyboard Shortcut, Strikethrough, Word 2007 Word 2007, Microsoft Word, Keyboards, Word Processors, Microsoft Office, Office Suites, Software, Hardware, Peripherals, Jody Gilbert
Blog posts 2008-07-15
  • << Previous
  • page 1 of 531
  • Next >>


IT Help Desk Survival Guide, Third Edition
TechRepublic's IT Help Desk Survival Guide, Third Edition provides tools and recommendations to help you better manage help desk services, improve end-user support, troubleshoot frustrating hardware issues, identify quick fixes to vexing Windows problems, and help users make the most of Microsoft Office 2003.
Buy Now
500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now

Product Spotlight