If you find yourself looking for the most recent/best presentation from which to make a new one, or pondering the question, “Now, how did I do that last time?” it’s time to get familiar with custom PowerPoint templates. The basic steps are pretty straightforward: With the presentation from which you’d like to create a template […]
Q. Can I set up a macro to run automatically in a Word template?
I got this question in a SharePoint class this week: How can I take the email addresses out of an email with a huge “To:” line and create a list for SharePoint? Well, here’s how to do it. 1. Create a blank worksheet in Excel, then switch to the Outlook email with the addresses you […]
Q. I need to perform a calculation if specific text is found inside a cell in an Excel work sheet. It won’t always be in the same place. How would I do that?
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 […]