If you know what a secondary axis chart is, then you know what a challenge it can be to show disparate values on the same chart. This used to be somewhat cumbersome in older versions of Excel, but with Office 2007 and Office 2010 it’s a piece of cake! For those unfamiliar with the term, […]
Q. When I link two sheets together and a cell in the source sheet is blank, I get a 0 in the target sheet. How do I get rid of the 0’s?
Are you planning a big meeting with lots of moving pieces: Catering, handout materials, AV. Wouldn’t it be great to not have to recreate the meeting attendance data from Outlook to do that? Well here’s how you can. In a meeting where you were the meeting organizer, in the Show group on the Meeting tab, […]
Q. Can I copy someone on an email without sending them the attachments?
Q. In SharePoint, I keep getting an error when I import Excel workbooks. Why does it say it’s not a valid Excel File?
Want to set up your own desktop theme in Windows 7? If you’ve changed your desktop theme in Windows 7 to one of the available Aero Themes, you might notice that the picture used for your desktop background changes every so often. What you might not know is that you can control how often those […]
I recently heard a train-the-trainer presenter refer to all animations and transitions as unnecessary fluff and distractions. While I agree that animation beyond basic slide transitions can be distracting, I do think there is a place for well-placed advanced features in your PowerPoint. Here are my basic guidelines: Have a purpose for the pizazz – […]
Q. What is the best way to create identical worksheets? I do a lot of copying and pasting, but I’m sure there is a better way.
Q. I used to highlight emails from certain people in a particular folder. I can’t find this option in Outlook 2010.
Q. I need several versions of a PowerPoint presentation. For some audiences, I’ll need to show all the slides, for others just the topic summaries and some of the detail. Another audience needs just a section or two of the whole thing. Do I have to make multiple copies?