- 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
Making Office 2007 (and Vista) Work Properly
In my previous update I detailed some severe issues that I had in setting up and using a brand new Dell laptop with Windows Vista and Office 2007, specifically Outlook 2007.
After stewing on the situation overnight I swallowed my pride and decided to call Dell Tech Support. This is akin to asking for directions while driving and has the additional problem of generally resulting in losing my temper; as a presumably advanced user I like to ask questions and get answers.
I was not looking forward to hearing, "Yes sir, I am eager to help you, can you tell me please what operating system you are using?"
Especially since Dell should have all that info already...
Amazingly that was not what happened. Instead I got a very bright young Canadian who responded directly to several specific questions. It turned out that my Outlook 2007 problem (where the taps on the keyboard showed up on my screen after several seconds of delay) was specifically related to installed software for the Dell Media Direct feature set — this allows you to play DVDs and audio CDs without booting up.
Why this would affect Outlook I had no idea, but there it was, under Add or Remove Programs, the Cyberlink Add In Manager for Outlook. Apparently this varmint slows down your Outlook in the manner I described and I was able to uninstall it.
Of course if you've used Vista you may have discovered that in Control Panel there is no longer an Add or Remove Programs options. (That would be way too easy). You now need to locate Programs and Features (in Classic View), sufficiently renamed and hidden to be almost impossible to find.
My understanding of Classic View is that is should resemble how it used to work. Why Classic View has changed that I have no idea.
But I was sufficiently excited about the results of uninstalling Cyberlink's Outlook Add In that I continued with the Canadian expert into some other areas.
He asked me about the Outlook Add Ins I might have installed myself. The only Add In I was using was Anagram, a favorite program that uses Artificial Intelligence to populate Contact fields and Appointments with information copied to the clipboard.
I had looked under Outlook Tools > Options for Add Ins to uninstall before calling Dell, but again, that was the old way of doing it.
The Canadian pointed me elsewhere — the "Trust Center" under the Tools menu.
Outlook Trust Center
For Office 2007 users the Trust Center brings up a window that closely resembles the one opened by the Office Button in Word, Excel and PowerPoint, but since there is no Office Button in Outlook (although there is a Ribbon, sort of... once you open an email message or contact item you do get a Ribbon) they hid a bunch of important stuff in the Trust Center.
When I opened the Trust Center of Outlook 2007 I could barely contain my excitement — there was an option to turn off the default in Outlook not to download images into HTML email.
I hate having to right-click to see what I am receiving in an email message.
Next I opened the Add-Ins window and lo and behold — look at all those &%$#@ Add Ins!
Of course you can't just get rid of them from here — you need to click Go and uncheck the options boxes for the Add Ins you figure you will never use.
How do you know you will never use them? Good question. I figure if I need them I can always reload them — but since I don't use Microsoft Exchange Server its add ins are a good place to start.
I might interject here that some of these will not go quietly. Others will not go at all — there is a dialog box that pops up that says you can't get rid of the sucker without going into the Registry.
Uh oh.
Of course the basis for all of this is that Microsoft has been hammered on security issues for a long time, so now they opt for high security and also high intrusiveness.
This also accounts for various Vista "features" like "are you sure you want to really really really run this program, even though you clicked it three times?"
This is apparently called User Account Controls — it is also very annoying when you want to move files (once you finally set up your network). Then you get stuff like, do you want to merge this folder. Are you sure? This file too? And this one? How about this folder.
That means you can't just drag a folder over and walk away — you need to reassure Windows you really want to overwrite the files.
So User Account Controls means Microsoft is controlling you and everything else.
Believe it or not you can disable some of this stuff — in the MsConfig program that still exists somewhere in Vista. You need to open the search panel in the Start menu, type in "msconfig" and hit return. Since this program is so useful and dangerous, it is well hidden.
In the Tools tab of MsConfig you can disable User Account Controls. Highlight the disable option and click Launch.
This opens a DOS window (hello!) and does something and then you can close the DOS window.
Unfortunately the checks and balances for moving files remain, but you can now load programs or install stuff without being asked if you really really really want to.
You can use the Startup tab of MSConfig to turn off a lot of resource sucking icons in the System Tray, and if you open Services, and click to hide all Microsoft Services, you can also remove services that are running by programs you didn't even know you had.
Now admittedly this is dangerous stuff — and it requires a reboot to apply it. But if you don't like the results you can always set a restore point before you do it and go back, or reopen MSConfig and re-enable anything that seems missing.
The fact is that most of these programs don't need to be running just because you started Windows; for example, your printer will probably load its print monitor and driver when you actually print.
(Sounds like a plan, doesn't it?)
If I seem a bit vexed and out of sorts about some of this is because I just don't get the point of creating a brand new operating system with completely different ways of doing everything.
I've gone through this now to Windows 95, Windows 98(2) and Windows XP. You would think that they would settle on a single interface and user logic and continue to build on it.
Similarly in Office 2007 in most cases clicking in the Ribbon opens a set of very familiar dialog boxes. While PowerPoint 2007 has some nice new features, for information workers who have finally learned routines in Office 2003, why do they need to search for the same commands in a brand new program?
One final example. In setting up my Outlook 2007 email, I suddenly could not send mail. It worked for a while but in typical fashion suddenly stopped working an hour later.
Only when I checked an option to log in to my receiving server first, in an Advanced options window under mail setup, did it finally start working again(?)
I check the same setup on my desktop — despite the fact that the same option was not enabled I can send mail fine (for now).
Now, this is an IT web site — so most of you readers probably are okay with figuring a lot of this stuff out or finding the answers using Google, or in my case, amazingly, tech support.
But I think about the average home business user, who just wants to type a letter, print it and go on with his or her life.
It took me nearly three days to set up my Dell with an operating system and Office suite I had already used for a while on my desktop. To me, this level of obtuseness is inexcusable.
Furthermore, after waking up to a Windows Update with my Dell rebooted, some of the settings I had entered to speed up Outlook 2007 were gone and needed to be reset!
If I buy a new model Infiniti, Acura, Mercedes or even a Honda, I don't need the owners manual to start the engine. I may need it to set up my stereo, but most of the controls build on the old versions.
The Windows in Vista are beautiful and Mac-like — they are translucent and have page folds when they open and close.
But I would much rather have ugly windows and be able to run my computer the first time just by turning it on. It's sort of like buying a phone that takes pictures and plays music but having a problem getting a dial tone.
Lastly, kudos to Dell for having tech support that really responds to the questions of users quickly and effectively.