With the release of a stable new operating system, Windows 7, many organizations are making the leap to the newer versions of Microsoft® Office. There are five “must have” tips that will get you over the hurdles of the revolutionary new interface and back to work.
5 tips to get from perplexed to productive in Office 2007 and Office 2010
I had a great question last week on our Outlook® webinar. Could Outlook® be used to replace a CRM function when it came to generating tasks with predefined date dependencies. For example, a real estate closing. Earnest money (or binder) is due a certain number of days from the contract date. Loan docs are due a certain number of days after the appraisal, and so on. I answered, No.
After thinking about it for awhile, I came up with a possible workaround using a combination of Excel® and Outlook®.
Create project “templates” using Outlook Tasks and import/export files in Excel.
If someone asked you what a table was (in data speak), you would likely respond with something like a set of data presented in columns in rows. When Excel® 2007 says tables it means a very specific way of formatting data that not only visually arranges into a tabular format, but gives you tools that let you work with that data easily.
From filtering to automatic totals that grow with your data, Excel Tables enable you to accurately process tabular data fast.
Missing important emails? Taking too long to check for those critical messages? Try using automatic color formatting.
If you’ve ever spent anytime copying and pasting text data into Word tables or trying to get data out of tables and into a simple list in a document, these tips might make you grumble a little. The good news is you’ll never have to do that again!
Tricks with tables to save you some cutting and pasting when your data doesn’t come in the way you expect it. Data to tables, tables to text and sorting data NOT in a table!
For most of us Office 2010 became available on June 15, 2010. While it had been released to some groups of customers back in April, the majority of us couldn’t avail ourselves of it until June. It seems to be a shocker for many because so many of us just got our hands on Office 2007 or are at least contemplating a near term migration to the new Office suite.