free microsoft office 2007 tips and tricks and notes

Office 2007 Notes: Office 2010 to come!

If you have Office 2003 and need to open and minimally work on Office 2007 files, please download and install this compatibility Pack I have linked to Microsoft's site.

If you want a need a free onscreen tutorial on finding where things were in 2003 vs 2007, please watch the items below. They saved me a half hour of wasted time!

The following can only be seen in Internet Explorer - but Firefox right click and save to your hard drives to view.

Excel 2003 to 2007 flash
Word 2003 to 2007 flash
PowerPoint 2003 to 2007 flash
Outlook 2003 to 2007 flash
Tom's Keyboard Shortcuts! (or .docx format)

More Notes:

Add to your Quick Access Toolbar
Save as 97-2003 .doc by default
Make Outlook Search all folders!
Excel 2007 Keyboard Shortcuts
Excel Data Cube
Excel New Numbers
Excel 2007 Tips and Notes
Excel Open in new windows
Excel Toolbars 2003 vs 2007 (2MB file)
Excel Ribbons - Landscape
Open Excel in two separate windows
Excel or Word slow to open
Univ of Manitoba - Great Excel 2007 Basics
Import Lotus Notes to Excel 2007
Slow Saving to Excel or Server 2003
Office 2007 Screenshots
Outlook 2007 Notes
PowerPoint 2007 Notes
Outlook Don't Leave Emails on Server
Reference 2003 - 2007
What is new in Excel 2007
Word 2007 Notes.doc
Office 2007 suites overview
Office 2007 system suites
Touring the new user interface
Tips tricks sheet Office 2007 final
Outlook ScreenShots
What's new with Vista
Introduction to Microsoft Vista and Office 2007
Effective Business Writing
Good Open Ended Questions
Useless facts about Excel 2007
Email one Excel 2007 sheet? Nope, use vbscript.

Office 2000 - 2003 Notes:

...the name is Tom, Tom McLaughlin ;-)

TIP JAR

Use tomax77@shaw.ca email address.

What's new in Office 2010?

- No more ORB! Yahooooo!!!
- Outlook now incorporates the Ribbon
- Orb replaced by FILE tab, albeit more confusing...

Things I'd like to see in Office:

PowerPoint incorporate BOTH a landscape and portrait setting in the same slideshow

Users rearrange the Quick Access Toolbar by dragging the icons around instead of the retarded way of going into the Options/Customize area. I mean the brain fart of having a horizontal bar being re-arranged by a vertical selection was priceless.

Simple way of opening two Excel spreadsheets in separate windows.

�C:\Program Files\Microsoft Office\Office12\EXCEL.EXE� /e �%1″ - click for steps to open excel in a separate window

Arrange Excel Tabs alpha or numerically without VBscripting.

Practice Files:

Personal Stuff:

What is an Office Application?
Sometimes people confuse the terms and idea of Application with an Operating System (like Windows XP). Simply put Applications sit on top or need an Operating System in order to run.
Examples of Application/Office Suites are: Microsoft Office 2003, 2007 or Office XP, Microsoft Office for Apple, Open Office, Star Office, whereas single Application programs are Microsoft Word, Microsoft Excel, or Microsoft Outlook Express (which comes with Windows and is like the "little brother" to the fuller version like Microsoft Outlook).

Word Processing � Letter writing. People can make changes such as spelling, margins, additions, deletions, and movement of text

Excel Spreadsheets � Budget spreadsheets. People can store numeric data, add, subtract and manipulate numbers or text that can be used in calculations, address books, or listings in a table format. Plus one can create charts and graphs using the spreadsheet application.

Access Databases - A database can sort the names, addresses, grades, classrooms for students in a school. From this, one can print professional looking reports, whereas in a Spreadsheet, it will only show the raw data.

PowerPoint, Publisher - Create a slide show presentation, or newsletter/brochure, and other similar types of publications. It is similar to word processing one can use text, graphics, lines, shapes, patterns, and borders.