Excel: Drop-Down Menus, aka, Data Validation

Years ago, I worked at a university, and I was hiring student workers to help with data entry. The highest … More

Excel Absolute and Relative Cell References: Multiplication Table

How to explain the difference between using a relative and absolute cell reference in a basic Excel formula? I know … More

Excel Dates: Birthdays and Ages Spreadsheet

You are rushing to get your niece a birthday card before her birthday, and you cannot remember how old she … More

Publisher’s Master Page – Putting Something on Every Page

Let’s say you are creating a four-page newsletter or booklet.  You want a little bar of color across the top … More

Publisher – Creating an Avery Template

Avery makes printable cards, postcards, business cards, and labels, right? But how do you get your images and words onto … More

Publisher Templates – Less Work, More Play – Create Greeting Cards, Labels, Postcards, and More

Publisher was created for Desktop Publisher.  Microsoft pays their designers to create samples just for you, their subscriber.  Do you … More

Publisher Lessons

One of my students asked about Publisher, so I created a few lessons covering the basics. Once you have these … More

Publisher Layers – Bring Forward and Send Backward

For this lesson, open a one-page Publisher document with three items:  an image, a Text Box with some words, and … More

Publisher – Add a Page and Use the Pasteboard to Move Objects

Open a Publisher document you have been working on or create a new one.  It should have one image and … More

Publisher – Using Guides to Line It Up

One of the thrills of Desktop Publishing is making your document look like a professional designed it, right?  Lining up … More