OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE
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.
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.
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.
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.
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.
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.
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.