maryannrichardson

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here’s how.

Does your Access report contain so much data that it’s difficult to read? Then make your report easier on the eyes by breaking it up with group headers and footers. Mary Ann Richardson explains how.

Looking to track positive or negative changes in your Excel data? Mary Ann Richardson explains how you can use conditional formatting to find out this information automatically.

Who’s high? Who’s low? Who’s average? If you’re working in Excel, conditional formatting can help you determine who falls within the ranges you set.

Trying to predict the future based on past experiences, but you’re lacking the right formula? If you’ve forgotten high school algebra, fear not. With trendlines, Excel can project future figures based on previous history. Mary Ann Richardson points the way.

One of the best ways to gauge user responses and collect data is with a survey. In this Word tip, Mary Ann Richardson explains how to create a customized survey form, step by step.

When you use Excel’s Chart Wizard to create a chart, by default the chart takes on the number formats used in the worksheet that includes the charted data. Mary Ann Richardson shows you a way to change the number formats in the chart—without having to change the worksheet formats.

When entering text into Word columns, it can be a battle trying to get the text to balance. Mary Ann Richardson explains how to let Word fight the battle for you and keep your columns in line.

Are you constantly changing your Excel chart’s data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of data to your spreadsheet.

When you want to total the amount of sales from your top 10 performers, you usually would have to sort the data first, then use the SUM function to add up the first 10 values in the sorted range. With Excel’s Array function, you can get the same results in a single step.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It’s not, as Mary Ann Richardson shows us.

With Microsoft Excel’s custom views, you can readily access whatever worksheet areas you need, which will help your presentations to flow. Here’s how to get started.