Entries by Veronica Mount

Access – Collecting Data by Email

Access provides great tools for organizing, searching and analyzing data. But before you can use those great tools, you must first enter the data. In Access 2007, a wizard with the monster-name, “Collect Data Through Email Messages Wizard,” for collecting information by email was introduced.  Two aspects of this process make it particularly attractive: 1)     … Read more »

“Saving” time in Word, PowerPoint and Excel

“Just Browsing” might be considered worthwhile when we are strolling through the mall with no particular must-haves on a shopping list. But when we’re working in Microsoft Office and frequently saving files, taking time to browse for the preferred folder can be about as productive as hunting for a mall parking spot at Christmas! Your installations… Read more »

Access: Querying for “Preferred” Data Given Multiple Choices

A friend once presented a challenge with his Access database. A table called tblContacts held information about contacts and included the fields WorkEmail and HomeEmail. Some records had values in both fields, others had values in just one or the other, and some had no values in either field. The user wanted to query the… Read more »

Excel: Trimming Cell Entries

A friend recently complained to me about mail merge results she was getting from her Excel data. Her spreadsheet held lists of important donors to her organization, but the data had been entered in various ways from many different sources. As a result, cells in the data held random spaces before or after the information… Read more »

Printing Graph Paper from Excel

Graph paper can be handy for a number of purposes when you need it – art projects, numeric comparisons, floor plans, and crafts to name a few. But unless you use a lot of it, graph paper isn’t something most of us are likely to keep on hand. Excel can serve up a quick grid… Read more »

Extending STEPS with lynda.com: Office for Mac 2008

Users of Microsoft Office can take advantage of STEPS workshops on Excel, Word, PowerPoint, Outlook and Access.  However, these workshops are all taught in Office 2007 for Windows; and Office for the Macintosh (both the 2004 and 2008 versions) have a significantly different interface. Don’t worry though – users of Office 2008 for the Mac… Read more »

Numbering and Counting Records in an Access 2007 Report

Access reports provide many options for formatting the data in the report so that it is easy for readers to understand. One formatting element you may want to include is numbering of the records in the report. Adding numbers allows readers to see a rank order of the items listed or to easily reference a… Read more »

Using Pattern Fills in Excel 2007 Charts

When preparing articles for publication, you may encounter a journal requirement specifying that chart data markers be filled with different patterns such as dots, slanted lines, etc. These types of fills make data that is being displayed in black and white easier to discern than those formatted in various colors. Unfortunately, while Excel 2007 includes a plethora… Read more »

Using Excel’s Text to Speech Feature

Everyone who has used a computer for analytical purposes has at one time heard the expression “Garbage In – Garbage Out”.  It might have been stated, “The analysis is only as accurate as the data.”  In either case it emphasizes that the calculations in Excel are only as reliable as the data that was entered… Read more »

Grouping Worksheets in Excel

In a recent training session on Excel basics, one panicked participant reported that she was suddenly unable to access or use any tools on the Insert tab of the ribbon. The majority of the icons there were gray. When the workshop assistant arrived on the scene, the participant and the assistant discovered the reason for… Read more »