- Office Reference Guide
- Table of Contents
- Surrealty: An Organic Case Study
- Working with Microsoft Word
- Branding Yourself with Microsoft Word
- Revising Your Document
- Saving and Using Document Templates
- Formatting with Styles
- Secrets of AutoText and AutoCorrect
- Trying To Remain Normal
- Customing Word with Macros, Menus, and Toolbars
- Document Management: Scanning into Word
- Using the Clip Organizer
- Backing Up Your Office System
- A Testimonial To Tables
- Navigating with Bookmarks
- Using a Document Map
- Creating a User Form
- Introduction to Word 2007
- Blogging with Word 2007
- Using Word 2007 Quick Parts and Building Blocks
- Mail Merge in Word 2007
- Word 2007: Open and Repair
- Styling: Using the New QuickStyles in Word 2007
- Compare and Combine Document Versions in Word 2007
- Accelerating Your Knowledge of Excel
- Getting Started with Excel Worksheets
- Creating and Autofitting Cell Content
- Populating the Worksheet with Data
- Using AutoSum To Create Automatic Calculations
- Using Formulas
- Making Your Worksheet Look Nicer
- Charting the Data
- Completing the Financial Picture
- Getting Fancy With Xcelsius
- Say It With Charts!
- The Effect of Text Entries and Blank Cells on Calculations
- Filtering Your Outlook Contacts
- New Charting and Productivity Tools
- Cataloging Your Backups in Excel
- Using Excel as a Simple Database
- Painless Pivot Tables
- Creating Interactive Spreadsheets Online
- Moving an Excel Macro
- Working with Scenarios and Goals
- Using Excel's Solver
- Emphasizing Sales Data in Excel
- XspandXL for Spreadsheet Analysis
- New Crystal Xcelsius Light (Free)
- Excel Business Analysis Books
- Excel 2007 Sorting, Filtering and Table Enhancements
- Creating an Entrepreneurial Marketing Plan in Excel 2007
- Named Ranges in Excel 2007
- Maintaining a Positive Outlook
- Using Word for Email
- Creating an Email Signature
- Handling Email Efficiently
- Creating an Anti-Spam Filter
- Working with Contacts
- Adding a Contact from Email
- Saving a Contact as a vCard
- Using the Calendar
- Appointments, Events, and Meetings
- Setting Tasks and Making Notes
- Protecting and Exporting Outlook Information
- Creating a Distribution List, and Other Outlook Tips
- Mail-Merge E-mail
- Creating an Outlook Form
- Completing the Outlook Form Solution
- Using Search Folders and Anti-Spam Tips
- Creating an E-Mail Template
- Using Outlook with a Cell Phone
- Stupid Outlook Tricks
- Using Multiple Outlook Calendars
- Using NewsGator for RSS in Outlook
- Review: <em>Conquer Email Overload with Better Habits, Etiquette, and Outlook 2003</em>
- Using Anagram's Artificial Intelligence
- MeetingSense for Enhanced Outlook Productivity
- Introduction to Outlook 2007 and Predictions
- Trying Business Contact Manager
- Outlook 2007 Organization Features
- Taking Your Outlook 2007 Calendar Online
- Going Mobile with My New SmartPhone
- Synching Outlook with Facebook
- Workaround: Create a Private Distribution List in Outlook
- Microsoft Office Outlook Connector
- "Where Are My Socks?" Accessing Your Important Information
- Exploring the Northwind Application
- Access Basics
- Creating Tables
- Using Forms for Data Entry
- Creating a Report
- Querying Your Database
- Creating Relationships
- Using Access for Business Documents
- Customizing an Access Template
- Using Macros and Switchboards in Access
- Creating an Online Data Access Page
- What's New in Access 2007
- Making Your Access 2007 Forms and Reports Look Professional
- Use the Access Label Wizard
- Presenting Professionally with PowerPoint
- Introduction to PowerPoint
- Creating Cool Diagrams
- Using the Diagram Object
- Beginning the Org Chart
- Using the Org Chart Toolbar
- Changing the Org Chart Layout
- Selecting Portions of the Org Chart
- Moving and Formatting the Selection
- Applying Styles to the Org Chart
- Using the Other Conceptual Diagrams
- Adding Our Concepts
- Moving Shapes with the Diagram Toolbar
- Moving or Resizing the Diagram
- Using the Diagram Styles
- Changing Your Concept Diagram
- Turning Off AutoFormat
- Adding a Caption or Title
- Summary
- Q&A
- Customizing Your Presentation
- The Concept of Customization
- Accessing the Master Views
- Understanding the Master Views
- The Power of the Master Views
- Adding Our Logo
- Changing Other Elements
- Slide Master Rules
- Using the Title Master
- Using the New Slide Master Template
- Adding Date and Time to a Footer
- Using Headers and Footers
- The Master View Toolbar
- Using the Handout Master
- Using the Notes Master
- Using Page Setup to Change the Presentation Type
- Summary
- Q&A
- Accessorizing for Presentations
- The Potential Of Photo Album
- Using Broadcast Quality Effects
- The Latest Presentation Gear
- Using PowerPoint, Video and DVD
- Microsoft Producer for PowerPoint
- Expanding PowerPoint with Plug-Ins
- Using Presenter View with a Projector
- Getting Into Your Presentation -- Literally
- The View from PowerPoint LIVE
- Making a PowerPoint Movie (not just for the Mac anymore)
- Making a Self-Running Animated Holiday Card
- Reporting on Databases in PowerPoint
- HD or Not HD, That Is The Question
- Taking On Tufte
- What the Heck Do I Say?
- Broadcasting PowerPoint Video with Serious Magic
- Video Blogging as a Presentation Value-Add
- This Just In: PowerPoint Secedes from MS Office!
- Two New PowerPoint Add-Ins
- Podcasting our PowerPoint
- What We Can Learn from InfoComm 2005
- Putting Yourself in the Show
- What You Can Learn from SIGGRAPH
- Using DVD Video in PowerPoint
- Animating Individual Chart Elements
- The Magic of PowerPoint LIVE 2005
- Making Sure Your Video Plays
- Creating a Timeline Template in PowerPoint
- Creating Transparent Animation and Backgrounds
- Using Advanced Animation Techniques
- Advanced Animation Part 2: Reusing Motion Paths
- Advanced Animation Part 3: Masked Backgrounds and Triggers
- Getting an Ovation with PowerPoint
- Video that Plays For Certain
- Using an Animated PowerPoint Chart on DVD
- Packaging Music Files with PowerPoint
- Say It With Presentations
- Keep Saying It With RSS
- PowerPoint LIVE 2006
- Total Solution: Using Propaganda for a PowerPoint Podcast for iTunes
- Wildform Wild Presenter for Interactive PowerPoint Online
- PowerFrameworks to Stimulate Your Creative PowerPoint Juices
- Distributing Video for iPods and Other Devices
- Converting Bullets to SmartArt Graphics in PowerPoint 2007
- Editing Video in PowerPoint (And a Lot More)
- Enhancing PowerPoint with Stock Photos
- Creating Sticky Documents and Presentations
- Review: Why Most PowerPoint Presentations Suck
- Using PowerPoint 2003 and 2007 Together: Preparing for InfoComm 2007
- Converting Flash to PowerPoint Video
- Animated Artwork for PowerPoint: PointClips and Vox Proxy
- Cutting Edge Graphics at SIGGRAPH 2007
- The Insert Object Animation Trick in PowerPoint
- Using YouTube Video in PowerPoint
- Using PowerPoint 2007 with Video Online
- PowerPoint LIVE 2007: Presentation Paradise in the Big Easy
- Camatasia 5.0: An Upgrade Worth the Effort
- Solving Video Playback in PowerPoint for Vista
- Review: Microsoft Office PowerPoint 2007 Complete Makeover Kit
- Graphic Novels in PowerPoint
- The Ultimate Presentation
- Opazity: PowerPoint for Lazy People
- Using SlideShare for Online PowerPoint with Narration
- Mastering Themes in Office 2007 (and Specifically PowerPoint 2007)
- VIDITalk's New Online Presenter Program
- Using and Converting YouTube Video for PowerPoint
- SlideRocket: Documents in the "Cloud"
- PFC Pro: Use YouTube Directly in PowerPoint and Maybe Get Your Web Cam into a Web Conference
- AuthorSTREAM: PowerPoint with Narration Made Easier Online
- Slide:ology: Nancy Duarte’s Design Secrets and Her New PowerPoint Book
- Mastering the New Slide Masters (and Layouts) in PowerPoint 2007
- Using PowerPoint 2007 to Create Slides That Don't Look Like PowerPoint (Video Update)
- A Treasure Trove of PowerPoint Templates
- Posting a Web Site with FrontPage
- Getting a Web Site
- Creating a FrontPage Web
- Where's My Web?
- Adding Navigation
- Applying a Theme
- Publishing Your Site
- The Old MHT Trick
- Taking Over A FrontPage Web
- Expression Studio 2.0: A Worthy Successor to FrontPage
- Publish or Perish
- Creating Publications for Print
- Publisher Web Sites
- Creating an E-Mail Newsletter
- E-mailing Holiday Cards
- Publisher 2007
- Get Visual with Visio
- Creating a Visio Flowchart
- Connecting Shapes
- Examining the Shapesheet
- Creating a Report
- Moving In With Visio
- Expanding Visio with Third-Party Stencils
- Playing Well with Others Using Visio
- Creating Interactive Diagrams with Visio's Layers
- Creating a "Virtual Database"
- Creating a Visio Dynamic Solution Template
- Visio 2007
- Visio 2007 Professional IT Toolbox
- Project Management with Visio 2007 Gantt and Pert Charts
- Review: Using Microsoft Office Visio 2007
- Tools That Integrate Your Office Applications
- Creating Video E-Mail with MovieMaker
- Managing Pictures with Microsoft Office Picture Manager
- New Year's Predictions: 2005
- Office Predictions for 2006
- Favorite Books List
- Using Excel as a Database Conversion Tool for Outlook
- Oh, Brother, I Love Labels (and other Office Tips)
- Planning for Disaster
- Using OneNote with Outlook
- Web Resources for Microsoft Office
- Simple 3D in Microsoft Office
- Creating Dynamic Database Links
- Using an Access Query for Mail Merge
- Displaying Database Links with Xcelsius Enterprise
- An Office 12 Sneak Preview from PDC
- My Big Fat Office Vacation
- What CES 2006 Means to Office Users
- Using "Send To" Between Office Applications: Word and
- Running (and Surviving) a Web-based Conference
- Running an Online Office with HyperOffice and Writely
- Preparing with Index Cards
- Creating Meeting Agendas
- Collecting Data with New Technologies: ARS, SMS and RFID
- Using Application Sharing in a Web Conference
- Running an Online Notes or Windows Media Session
- Trying Out Live Meeting
- Creating a SharePoint Team Website
- Using and Customizing a SharePoint Team Website
- Creating a Trip Planner in Excel and Outlook
- Crystal Graphics’ Excel and Solutions and Chart
- GoToMeeting Instant Webinar Tool
- Checking Out Office Live
- Using Quindi Meeting Capture
- Using Excel to Link to Other Databases
- Trying Out Mind Manager Pro to Brainstorm with Office Programs
- The 13th Thing I Hate About Office
- Introduction to Office 2007
- What's New in Excel and PowerPoint 2007
- Take a Look at InfoPath 2007
- Office's Groovy New Collaboration Program
- Using Office Accounting Express
- Printing to PDF or XPS in Office 2007
- Getting Adjusted to Office 2007 Changes
- Using SnagIt for IT Training
- Providing Help with Go To My PC
- Vista Meeting Space and People Near Me from Microsoft
- Trying Expression Web
- Migration Issues to Word and Outlook 2007
- Vista – Are You Kidding Me?
- Making Office 2007 (and Vista) Work Properly
- Office and the Enterprise
- Survey Says – Use Web Surveys with Excel and Access
- Uninstalling Office 2007 in Windows XP Pro
- Using Excel for Tables in Office 2007
- VIDITalk – Video in SharePoint and Beyond
- Career Advancement for Office Professionals
- Online Database that Rivals Access?
- Web 2.0 2008 in San Francisco
- Going Virtual for MS Office
- Going Virtual Using Mobile Apps
- Managing Your Contacts Across the Office Suite
- Charts in PowerPoint and Excel 2007 (Video Update)
- Outline View: The Document Planning Bridge between Word and PowerPoint
- Using Document Inspector in Office 2007
- SmartDraw: A Powerful Communications Tool to Supplement MS Office
- Visio 2007's New Pivot Diagram
- Using the Macro Recorder in Visio 2007 (Video Update)
- Compatibility Pack: Challenges of Using Office 2007 Documents in Previous Versions
- Microsoft Office Live Small Business Beta
- No One Asked Me But... What I Want (and Don’t Want) in the Next Office and Windows
- Late New Year's Resolution: Keys to Effective IT Communication
- SmartDraw Extras: Healthcare and Legal Templates
- Interesting Upgrades: Camtasia 6 and SnagIt 9
- Addressing the Office 2007 Read-Only Runaround
- Getting Organized with OneNote
- Flagging OneNote Information
- Recording and Organizing with OneNote
- Recording and Organizing Video in OneNote
- OneNote 2007
- Using OneNote 2007 Efficiently with Other Office 2007 Apps
- Using OneNote as a Voice Recorder
- Video Tutorials
- Charts in PowerPoint and Excel 2007
- Using PowerPoint 2007 to Create Slides That Don't Look Like PowerPoint
- Using the Macro Recorder in Visio 2007
- Playing a CD Audio in a Self Running Presentation
- Textboxes, QuickParts and Building Blocks in Word 2007
- Working Between PowerPoint and PDF
- Additional Resources
- Exploring Twine and the New Semantic Web
- A Tale of Two Tech Supports — OfficeLive and Zoho
- Digital Hollywood 2008
- Infocomm 2006
- InfoComm 2007
- Judging a Disc By Its Cover
- Surviving the Office 2007 Beta
- The Latest Word from CES 2007
In past years the Reference Guides have been asked to write what they see in the year ahead. This year no one really asked me, least of all Microsoft, but with all of the reaction to the current version of Office, and also to Vista (much of it negative) I thought I might add my two cents.
Interestingly, the current issue of Wired Magazine has an in depth profile of Ray Ozzie, who came over with Groove and developed Lotus Notes to be the current Chief Software Architect, now responsible for future releases. The man who Bill Gates calls “one of the top five programmers in the universe” seems refreshingly candid and aware of the perceptions of the current versions of Office and Vista.
If you read between the lines of the article and Ozzie’s own quotes you may agree with me that he is painfully aware of the limitations of desktop shrink-wrapped software which have only been exacerbated by the need to release new versions — with features that are less necessary to end users than they are to the company releasing the software — and to their bottom line.
What this has resulted in, for example, in Office 2007 is the Ribbon, which while making some excellent new features (conditional formats, effects, galleries) “transparent” also resulted in a massive need for users to reorient their ways of working, sometimes for days and sometimes for months.
For example, a feature I seldom use (Replace Fonts) is nowhere to be found near Fonts, and exists elsewhere on the Ribbon. So when I finally need to use it (months after installing Office) I need to locate it and wonder whether it still exists (see below). Worse, pressing F1 for Help does not seem to provide a quick reminder of where the feature actually is and how to implement it. (I found the answer on Google).
Other features were simply removed, like the Macro Recorder in PowerPoint, or moved to the “Quick Access Toolbar” to be manually installed for presumably quicker access, like the Data Form in Excel. In each case users had to figure this out for themselves, generally while working on an important project.
Similarly in Vista, even after disabling User Account Controls (since I’m the only user I feel entitled), it still may take a multitude of keystrokes just to move a folder from one desktop to a flash drive or another location on the network. There are questions about “File Properties” for example that would take hours of research to answer, but if you click Yes to acknowledge they won’t be moved, you remain mystified as the task finally ends.
Going back to Ozzie, all of this points to his clear understanding that as he aims Office and Windows at the “Cloud”, hosting services online as well as on the desktop, the challenge will not be to change interfaces or add features and complexity, but rather to make everything simpler and easier to use.
Microsoft is not benevolently coming to this realization. The Mac attacks and Google obviously are motivating factors.
The Wired article lists a four prong technological plan from Ray Ozzie which includes an online version of Windows and Office.
But while technologists wonder or anticipate whether the full features set can be accommodated to the “cloud”, and new value added features included as well, the average user and IT professional is surely wondering about the two real gorillas lurking behind the new software: usability and compatibility.
For Office 14 to succeed, in my opinion, it will need to build, of necessity, on the Ribbon. Translating these features to the web will be a daunting task for programmers, particularly since not everyone will want to use only the web services version, but will want to stick with Office 2007 and 2003 on the desktop.
But before we get into compatibility — in terms of usability, will just moving Office into Office Live be enough to make users pay for the service (especially if they own desktop versions)?
Unfortunately the marketing folks may not be convinced, and they may well attempt to add new “features” that confuse rather than streamline work flow. Even the current feature set of Office has made many users opt for Open Source Open Office, Google Apps and Zoho, just for the simplicity, finding the only capability a pleasant value add if not a necessity.
The fact that SlideRocket lets you collaborate and present online is cool, but the fact that you can incorporate web resources seamlessly and create a decent slide show in an hour without opening a gazillion dialog boxes is a major plus as well. (I think that also accounts for the popularity of Keynote and SmartDraw — simplicity and transparency).
In terms of compatibility both Office 2007 and Vista have been a nightmare. Having created digital video for years, the problems I have encountered just in this arena have been enough to make we want to scream. I have had to tout an Add-In — Plays for Certain which of necessity re-encodes my video before I can play it PowerPoint.
The apparent reason is a difference in playback capability between Media Player and the MCI playback in PowerPoint — but who cares?
And, PowerPoint still doesn’t accept Flash video and most of QuickTime, and neither does Media Player.
And that’s just one potential compatibility issue facing Office and Windows when they go fully online. (Where does YouTube not play?)
Accommodating users of previous versions is the other major rub. The “Compatibility Pack” aside, even users of Office 2003 (never mind previous versions) run up against major roadblocks when they try to move their files to 2007, and God help them, back again. I’ve used the PowerPoint masters as an example, but until you really need to do this, you don’t know the iceberg is waiting for the Titanic, so it hits you at the worst possible time – usually when you want to deliver a project.
A great example of this happened to a friend of mine who recently bought a Vista laptop. He was telling me that all of the sudden, for no apparent reason, his audio would be muted. I speculated that it was probably the result of a Vista update; on several of my updates my dual monitors were abruptly disabled and my desktop appeared only on the small low resolution monitor, not on both.
What made my friend’s story poignant was the comment by his girlfriend — “I thought you knew a lot about computers.” We all did — when we learned the vagaries of Windows XP and Office 2002/XP and later 2003. Now we need to unlearn much and figure out more just to do what we always did without any problem.
If the payoff in new features really added value, that would be one thing — but I really don’t see it and in both Vista and Office several features I was used to have simply been eliminated.
Ironically help for these issues is usually found in Google from other users on forums, or in the Microsoft forums — and not in the programs themselves (Help?)
So in a nutshell what do I want from the next web-bound version of Office?
Simplicity, transparency and usability.
I want items to be where I expect them to be, and to work the way I have been conditioned to work for a decade or more. I certainly don’t want new web-related problems to suddenly emerge at critical junctures of my workflow, and if they do, I want them to be anticipated and explained clearly in online documentation.
When I begin a Word document I want to start typing, saving and sending, and not realigning margins, figuring out fonts or why my text is suddenly double spaced. I don’t want to learn a new version of online styles either. I just want to do my work.
More on the Vista side — but it affects Office as well (and in the web version this could be done with cookies, I suppose) — I’d like Explorer to remember where I last saved files and be able to simply (that is the key) set a default for how I view files in Explorer. I prefer Details as my default with Date Modified as one of the categories and after a number of attempts, I’ve given up trying to have Vista remember those preferences, either universally or for folders I have already used and designated.
One more thing — I don’t want any squiggly circles or sliders that never end, popup dialog boxes that have language I don’t understand or a lot of other hurdles or impediments to simple tasks like moving files or burning a disk.
That’s about it. Microsoft can take it from there.
InformIT Articles and Sample Chapters
Compatibility Pack: Challenges of Using Office 2007 Documents in Previous Versions
Books and eBooks
Office 2007: The Missing Manual(Safari Books Online)
Windows Vista Annoyances (Safari Books Online)