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 […]
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.