Q. There is too much space between the lines of my recipients’ address in a letter. How can I tighten it up?
We answer four reader questions about becoming a certified Microsoft Office wizard, how to keep the certification current, and what it can really do for you.
It is three days before the event. You are frantically trying to gather attendee lists, catering orders, room arrangements, speaker itineraries, agendas, presentation slides and meeting notes. Some are in documents on your hard drive. Other information is available on a website. Countless documents and notes are in your email in box, somewhere. Sound familiar? You may have an application already installed on your desktop that can rescue you from all that insanity. It’s called OneNote.
Q. When should I use VLookUp and when is it better to use Index and Match?
The Navigation Pane, Find/Highlight tool, and Bookmarks will have you manuevering around your text and adding polish to it in no time.
Q. My formula suddenly started giving me #REF! errors. What went wrong?
Q. Why should I consider converting to Outlook 2010? 2007 seems to do everything I want it to.
Q. When I’m looking at my list of tasks, they don’t show the Start Date, only the Due Date. How can I get Start Date into the view?
There are some powerful math features in Excel that can help you with your date data. First, let’s take a look at how Excel interprets dates …
Q. I want to send an email invitation to an event, but I want the RSVP responses sent to my assistant. Can I do this?