OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE
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.
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.
If you are using Microsoft Outlook as your email client, you’ve likely already used the instant search box… but using it can be even more “instant” if you learn how to use a couple of shortcut keys, instead of having to resort to the mouse every time.
If you are using Outlook with Gmail over IMAP, you might have noticed a really annoying problem: if you flag an email in Outlook, or use the Star feature in Gmail, you’ll often end up with duplicate items in the To-Do bar.
This should fix the issue in both Windows XP and Windows Vista! Enjoy!
Have you ever noticed that the To-Do bar in Outlook 2007 doesn’t show you what type of item is in the list? It could be a task or a flagged email, but which one is it? With a simple tweak you can add the icon column to easily differentiate them.
How many times has the Outlook reminder popped up on your screen only for you to hit the Snooze button to be reminded again in 5 minutes. How can you possibly be productive while hitting the snooze button repeatedly throughout the day?