OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE
There are many people who live in Microsoft Outlook a good percentage of the day. You might want or need to change your email signature regularly depending upon the person you are emailing or the account you are using, and there’s a really simple way to do this that might not be obvious.
How many times have you wanted to only print out a portion of the data on an Excel spreadsheet? About a year ago I shared a tip to save ink and paper by only printing selected text from a webpage. Instead of analyzing the spreadsheet, printing it out and reanalyzing it to find the pertinent data here I will show you how to print out the specific area.
Creating new MS Office documents from scratch can be quite a time consuming process. Entering recurring data in a worksheet can be especially monotonous. By using Autofill in Excel we can speed up the process of entering in days of the week, dates, times, etc.
A cool trick I learned the other day is inserting an audio file into word documents. There are several instances where this comes in handy. Here we will take a look at a couple different ways to insert the sound files into Word 2007.
Another thing you might want to try is record a message about your document for co-workers through Sound Recorder or other audio recording program and insert that into a document as well.
Sometimes in your daily work routine you might need some extra features from the Microsoft Office Suite. One way to get extra functionality is through Office Add-Ins. Sometimes these are bundled with Office but not included with the initial installation. These are easily accessed and installed. Here I will show how to install an add-in with Excel.
This article is part of Mysticgeek’s Realm, a How-To Geek blog focused on IT geekery.
Flowcharts are a very good way to get a new idea explained in a presentation. Office 2007 has some great new tools for creating a visual appealing flowchart which can be used from Excel, Word or PowerPoint. Here we will take a look at creating a simple flowchart in Word 2007.
This article is part of Mysticgeek’s Realm, a How-To Geek blog focused on IT geekery.
Perhaps you come up a formula that actually proves the Theory of Relativity is completely wrong. Maybe you have written a best selling novel in Word 2007. You definitely want to associate a protective license on it. in our digital age there is an enormous amount of Ideas, creative writings, and music are available at our finger tips. It is very important to protect your work. The Creative Commons add-in for Office 2007 makes it easy.
This is mean as a introduction to Office Live Workspaces allowing you to get familiar with what is offered. Next week we I will go into this service a lot more in depth showing more cool functions available. Also, we will cover Office Live Small Business which can get small business owners online and working efficiently with customers and employees.
We’ve written previously about how to set the Office 2007 color scheme away from that awful default blue, but you can also set it with a quick registry hack or even via group policy on your network, so we’ll cover that here.
If you are working on a spreadsheet and want to be able to quickly see differences in numbers at a glance, you should use the new Conditional Cell Formatting in Excel 2007. With this you can change the background of a cell based on the data in the cell, almost like an inline chart.
If you are using Office 2007 in an environment where everybody else is using Office 2003, you might have already set Excel or Word to always save to 2003 format, but what about when you create new documents using the New menu? The only choices are now to create files in 2007 format, but we can add the old ones back.
For this Sunday’s Office tip we are going to look at Vista Sidebar Gadgets that can help you better manage appointments and GTD lists in Outlook 2007. When Vista first came out I was not a fan of the Sidebar or its gadgets. At the time, gadgets seemed only to be resource consuming “”eye-candy”. As this technology has progressed I am finding more useful Gadget applications.
After reading an article I wrote over at Lifehacker on how to use the Quick Parts feature in Outlook, reader Jason wrote in asking how you can transfer them to another computer once you’ve created them, and it seemed useful enough to explain for everybody’s benefit.
During a workday things can definitely seem overwhelming as the amount of data we are expected to absorb increases at such a rapid pace. In this fast paced environment it can be easy to misplace an important contact or have another do the same if you are the important contact.
If you don’t want to spend a lot of time creating your own Electronic Business Card design you can download Templates from the Microsoft Office site. This is a cool and easy way to go because you can open the template and do various customizations to it. There are also several sites on the Web that you can download them from.
One of our great readers wrote in yesterday asking how to migrate the custom Office dictionary from one computer to another, and it seemed worthy enough to write about for everybody’s benefit. Thanks Josh!
When it comes to the business world and office documents, there are tons of file formats, extensions, and associations to be considered. When Adobe came out with the PDF format it was to be the “standard” and even that can be sometimes be difficult when dealing with conversion for different tasks and software utilities.
Many times we will want to enter in symbols and character other than the standard. You might be doing business in Europe and need to enter in Euro’s or other symbology into Excel sheets. We can achieve this in easily in Excel 2007.
Have you ever wondered how many times per day you check your email? For many of us, it’s far too often… and if every single time you have to click on a little icon in the tray, or find the Outlook button in the taskbar, it can get a little annoying. Instead of that, what I do is assign a hotkey to switch to my already open Outlook window.
This article is part of Mysticgeek’s IT blog, a How-To Geek blog focused on IT geekery.
Creating a professional looking chart for Excel presentations is extremely easy in Excel 2007. Making charts is a more interesting way to present data than just going through the rows and columns on a spreadsheet.
