- Exploring Excel's Functions, Part 7: Rounding with Excel
- Jun 23, 2006
- When a numerical value has more decimal places than you need or want, Excel offers a selection of functions to help you deal with it. The latest installment in Peter Aitken's series of articles takes a detailed look at some of Excel's advanced rounding capabilities.
|
- Six Slick Tricks for Long Documents in Word 2003
- May 12, 2006
- If you've ever juggled really long documents in Word, you know that they can cause problems, particularly in the last-minute run for a deadline. Laurie Rowell tells you how to manage these monsters, reduce stress, finish faster, and minimize lockups.
|
- Exploring Excel's Functions, Part 6: TTEST() Function
- Apr 14, 2006
- Are you intimidated by the very mention of statistics? There's no need to be. In this sixth in a series of articles that take a detailed look at some of Excel's advanced functions, Peter Aitken tells you why statistics are nothing to fear when you use the TTEST() function in your own work.
|
- Seven Hidden Options that Make Word Fly
- Apr 14, 2006
- Word 2003 has plenty of features hidden in plain sight. Laurie Rowell ferrets out seven that can make your work go faster.
|
- Troubleshooting Excel PivotTables
- Apr 7, 2006
- Frustrated? Excel PivotTables are a powerful data analysis tool, but they are not always easy to use. Peter Aitken divulges some troubleshooting tips that might lessen your gray hair factor.
|
- Troubleshooting Word Tables
- Mar 31, 2006
- Tearing your hair out when you use Word tables? They are very flexible and powerful, but sometimes the features you do not need get in the way those you do. Maybe this article can help. Peter Aitken provides some insight and tips for dealing with some problems you might encounter.
|
- Exploring Excel's Functions, Part 5: The Power of Choice
- Mar 24, 2006
- Want more power of choice? Excel's CHOOSE() function does just what its name implies; it chooses something based on data in the worksheet. In this fifth in a series of articles that take a detailed look at some of Excel's advanced functions, Peter Aitken explores ways the CHOOSE() function lets you select data based on values in the worksheet.
|
- The Art of Presenting to Win: You and Your Audience
- Mar 17, 2006
- Few human activities are done as often as presentations, and as poorly. One recent estimate has it that 30 million presentations using Microsoft PowerPoint slides are made every day. You’ve probably attended more than a few. How many of them were truly memorable, effective, and persuasive? Probably only a handful. This chapter will help you improve your presentations by keeping your audience in mind when crafting them.
|
- Seven Things I Hate About Word Printing
- Mar 10, 2006
- Word is a great program, but it's hardly perfect. When it comes to printing, there are at least seven problems that prematurely turn users' hair grey. Peter Aitken says, "Let the whining begin!"
|
- Exploring Excel's Functions, Part 4: Database Functions
- Feb 24, 2006
- Why on earth would Excel have database functions? After all, Excel is a spreadsheet program, and Access is the database program that is part of the Microsoft Office suite. This is true, but Excel's spreadsheet structure (that is, rows and columns) lends itself to certain kinds of simple databases, and the Excel database functions are designed specifically to work with this kind of data.
Continuing Peter Aitken's series on Excel's advanced functions, this article explores the Excel database and shows you how you can use database functions to store many kinds of useful data.
|
- Exploring Excel's Functions Part 3: CELL() Shocked
- Feb 3, 2006
- You might guess that the CELL() function has something to do with worksheet cells, but exactly what does it do? This often-overlooked function is one of Excel's information functions, so-called because their jobs are to provide information about certain aspects of the worksheet. In this third article in a series on Excel's advanced functions, Peter Aitkin shows you how to take advantage of the CELL() function's capabilities to make your workbooks stand out in terms of usability and convenience.
|
- Absolute Beginner's Guide to Quattro Pro X : Navigating in a Notebook
- Jan 27, 2006
- Navigating a new software package is like finding your way around a new town after a move—you need to learn how to move around in it efficiently. In Quattro Pro, you also need to learn how to select so that you can move and copy information as those actions become necessary. In this chapter, you'll learn how to move around a notebook, select cells, enter information into a spreadsheet, correct mistakes, and, most importantly, save a notebook so that you save the fruit of your efforts.
|
- Tracking Changes in Word 2003: Five Things People Forget To Do
- Jan 13, 2006
- The Track Changes feature in Microsoft Word is very handy for wordy folks like your Informit editors. But even ordinary mortals might come to like and use revision marks if they follow through on Laurie Rowell's suggestions in this article.
|
- Access Fear Factor I: Basics
- Dec 30, 2005
- Afraid of the dark? Spiders? Heights? If you are an experienced Word/Excel user who has Access-phobia, this article is for you. Herb Tyson shows you how to use Word and Excel to start creating what should be a simple database. When limitations become obvious, you learn how to use an Excel spreadsheet as the starting point for an Access database that ultimately will be more useful.
|
- Exploring Excel's Functions Part 2: ADDRESS() and INDIRECT()
- Dec 30, 2005
- Excel functions might seem a bit complex, but sometimes there's no avoiding a complicated formula to achieve the worksheet results you need. The ADDRESS() and INDIRECT() functions can provide you with flexibility that is not available any other way. Continuing Peter Aitken's series on Excel's advanced functions, this article explores the INDIRECT() and ADDRESS() functions and shows you how they can be used together to make your Excel life easier.
|
- Ten Things I Hate About Entourage
- Dec 30, 2005
- Owen Linzmayer is not exactly a big fan of Entourage, the personal information manager component of Microsoft Office 2004. Read his top 10 list of "features" that are turning him into a disgruntled user.
|
- Versions: Getting the Story Straight in Word 2003
- Dec 22, 2005
- How many different copies of a document can you keep around your hard drive before you accidentally delete the "real" one with the last set of changes? If you're like Laurie Rowell, that "oops" has happened once too often. Using Word's versioning, you should be able to keep better track of document changes and ensure that the final document is really final. But is the versioning feature worth the risks it poses?
|
- Exploring Excel's Functions: IF() Only!
- Dec 9, 2005
- How often will you need to calculate the prorated linear depreciation of an asset? Heck, do you even know what that means? But if you need that calculation, Excel's built-in AMORDEGRC() function can save you time and hassle. Many users do not take full advantage of Excel's functions, simply because they don't know what is available or they're not quite sure how to use them. Peter Aitken hopes to remedy this situation. This first article in a series that will explore some of Excel's less well-known functions discusses one of its most useful ones: the IF() function.
|
- I Wouldn't Touch That Task with a 10-Foot Banner: Creating Banners in MS Publisher
- Dec 1, 2005
- Want to make a banner that says "Happy Birthday," "Welcome to the Conference," or the ever-popular "Hey, Bill. We're Out of Toner!"? It's not impossible to make a banner using Microsoft Word, just as it's not impossible to open a can of beer with a screwdriver. But Microsoft Publisher has templates for every occasion and is the better tool for the job. Herb Tyson shows users of all levels how to create banners (up to 20 by 20 feet), step by step, using Microsoft Publisher 2003.
|
- Wav Surfing with E-mail Voice Alarms in Microsoft Outlook
- Nov 18, 2005
- Herb Tyson loves a good mystery, but not when it comes to the seemingly arbitrary sounds emitted by his computer. When nonspecific new mail arrives, his daughter's seven-year old voice announces, "Hey, Daddy! You've got mail!"
For users of all levels, Herb shows you, step-by-step, how to record voice alarms for use in Microsoft Outlook running under Windows XP. Whether you want a general alert that’s more informative than Windows' built-in notification, something specific for different senders, or both, this article tells you what you need to do and how to do it.
|