If you’ve never created a Macro before, this one will be an easy starting place. A macro can be a simple recording of keystrokes that can be played back over and over again. The purpose of this macro is to set the column widths and row heights to the right size to accommodate the data […]
Are your PowerPoint presentations essentially a script, chock full of every single detail you intend to present? Or, at the other end of the spectrum, is your “deck” just a set of discussion prompts meant to guide the session, not inform it? Before creating a PowerPoint presentation you need to make two decisions:
Q. I want to set up some monthly dashboard reports where I have a template of multiple graphs and tables on one page. Can this be done with Pivot Tables?
In PowerPoint 2010, you can now create a video file called a Windows Media Video file or .wmv. This format is playable on many video players and can be converted with a separate piece of software to another format if needed. Last year, here in Office Tech Pro, we introduced the basics for creating videos […]
Q. Quick Parts are very useful in Word. Is there something like that in Outlook?
Many people are presenting problems to IT and being told their solution is SharePoint. While there is a whole lot of “geek speak going around, there’s not enough plain talk. Here’s a primer: What SharePoint is NOT SharePoint is not an application. So we while we open Word and create a .docx or open Excel and […]
Q. How do I find all my files in Windows 7?
Q. How do I set up a simple time sheet in Excel?
As business professionals one of the goals we should have is to find new and better ways to repeat success, not re-invent it. Here’s what I’m doing today to make my life easier next year. Word This year I started writing proposals on 2 different types of work. I plan to do more next year. […]
Q. How can I create a drop-down list in Excel?