0
Not the spacebar!

Become familiar with Microsoft Word’s ruler, tabs, tables and basic spacing techniques and you’ll find it easy to produce any type of document, from a résumé to a report.

Continue Reading

0
Auto-fill context menu

What makes a good spreadsheet? Two things: good design and good data.

Continue Reading

2
The formatted budget

Creating a budget is of one the simplest and most useful tasks you can do using a spreadsheet. Here’s a step-by-step guide to simple budget creation in Excel.

Continue Reading

4
Running a parameter query

Interactive, on-the-fly parameter queries add a huge amount of flexibility and power to run-of-the-mill static queries. Learn how to create your own using Microsoft Access.

Continue Reading

7
A select query

Learn how to start building more complex database queries, such as comparative and action queries, using Microsoft Access.

Continue Reading

2

Not sure which series of database tutorials on Geekgirl’s Plain English Computing is right for you, Databasics or Databases from Scratch? Here’s a quick description of their contents.

Continue Reading

20
Eliminating recurring fields

This third article in the Databases from Scratch series delves into the database heartland by exploring relational database design.

Continue Reading

4

The second in a series of articles on choosing, designing and using a database program. This one covers simple table design.

Continue Reading

13
A simple relational database

The first in a series of articles on choosing, designing and using a database program.

Continue Reading

0
Lovely Charts

Here are five useful tools and services to ease your work tasks, from handling PDFs to creating charts to replacing Microsoft Office in its entirety.

Continue Reading

0
Word’s Format Painter

When you need to apply the same formatting to multiple parts of a Microsoft Word document, there’s no need to go through the same motions repeatedly. Word provides a smogasbord of techniques for formatting a bunch of elements in a document quickly and efficiently.

Continue Reading

8
Side-by-side view in Microsoft Word

If you have a document open in Word 2007 or Word 2010 and you open another document, that second document is displayed in the same window as the first. To view the now-hidden first document, you can’t, as you might expect, swap between the two documents by pressing Alt+Tab…

Continue Reading

2

The latest version of Microsoft Office comes in 32-bit and 64-bit flavours. It’d be natural to assume that if you have a 64-bit computer running a 64-bit version of Windows then you should install the 64-bit version of Office 2010. Not so. You’re almost certainly better off using the 32-bit version.

That’s because Microsoft has included little in the 64-bit version that you won’t find in the 32-bit version, with two exceptions…

Continue Reading

7

In the previous tutorial I discussed some guidelines for creating data entry screens that are easy to use. In this tutorial, we’ll put those guidelines into action by refining the membership database we introduced in part two of this series. I’ll step through the process in Microsoft Access 2000 and Microsoft Access 2010. If you’re […]

Continue Reading

9

It’s a trivial task to sort your Outlook contacts: simply display them in List view and click any of the column headers. So, to sort by category, click the Category column header; to sort by name, click the Full Name column header. It’s an equally trivial task to sort your contacts by multiple criteria. Trivial, […]

Continue Reading

0

While word processing programs are the most commonly used office application and browsers are probably the most commonly used application of all, much of the success of personal computers is due to spreadsheets. In 1979, two blokes – Dan Bricklin and Bob Frankston – developed the first spreadsheet. Their creation was called VisiCalc and it […]

Continue Reading