- 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
I spent the ride back to Los Angeles from San Diego trying to figure out just exactly why I think this trade show is so special.
While many of you work for large companies, a fair number are probably solo practitioners like me, and that can make you feel pretty lonely in the technology universe.
(Violins please.)
Then again, even if you're in a big company, your skills may not be totally appreciated. The view from your cubicle may sometimes make you feel like Dilbert.
Now, the word "community" is way-overused in our industry. But PowerPoint LIVE is such an intimate and friendly event that its sense of community is palpable. It has to be mainly the work of its host, Rick Altman, who also runs a Corel event. He extends a warm and sincere personal welcome to all who attend, present, or sponsor the show. It doesn't hurt that Rick's mom, her friend, and loyal crew of other staff members have followed the event as staff since its inception.
More to the point, the event is faithfully attended and staffed by two very significant sub-"Communities." One is probably the biggest gathering of MS Office MVPs outside of a Redmond conference. If you've been to the PowerPoint newsgroup you will recognize the names of some of the most prolific helpers with the program on the list of PowerPoint LIVE Help Center pros.
They include (and I will leave some out) Steve Rindsberg, the VBA guru, Geetesh Bajaj of Indezine, Kathy Jacobs, Echo Swinburg, Troy Collar, and a veritable "Who's Who" of mavens with the program, from programmers to graphic design experts.
Another community that attends and catalyzes interactivity of the more human kind is the Presentations Council of ICIA (International Communications Industry Association), to which I proudly belong and which shares the expertise of the A/V and presentations industry among its members and beyond.
The council also contributes heavily to Visual Being, a Webblog dedicated to presentations craft, where you can find excellent insight into PowerPoint LIVE by my colleague Rob Lindstrom.
To give you an idea, there are over 200 PowerPoint fanatics in town for a few days, and on any given night between 75 to over 100 of them went to the same restaurant for dinner to keep talking PowerPoint, drink, and interact. Margarita consumption reached unworldly proportions.
Before I forget, they/we were also joined by Ric Bretschneider, Microsoft's Product Manager for PowerPoint, and Rebecca Levine, Microsoft's PowerPoint Program Manager for the Graphics Products Unit. Needless to say, we got an in-depth look at PowerPoint 12 (which I wrote about in my update from the Professional Developers Conference).
The Immediate Close
So what else sets this conference apart, besides the warm and fuzzy stuff? Well for one, it's incredibly useful. Here's why:
Besides the obvious aspect of being able to learn from experts and dig deep into the features of the world's most popular presentation program, many of the sessions at PowerPoint LIVE, now in its third year, and the keynotes deal with a generally unappreciated aspect of computing: WHY DO YOU USE THE PROGRAM?
This is the essence of Death by PowerPoint. I've written before about the outstanding insights of Jim Endicott, a presentation consultant who specializes in thinking about this vital aspect of the craft. He says that too many presenters focus on themselves instead of what the audience wants. For a sales presentation, he talks about finding the pain that your product or service cures to hook the audience into caring about your presentation. He provides a 7-part persuasion building model that proceeds from the hook, opening through the stages he recommends for eventually closing. This year, he provided another fabulous insight: the concept of the immediate close.
Have you ever been in a presentation where the speaker has run out of time, and starts to rush through the remaining slides at warp speed? This destroys any hope of closing the deal in a sales presentation. Jim suggests that the speaker know the slide number of one or more slides that he can get to instantly by entering the slide number (and hit ENTER) to get right to the close if time draws short. You can also do this with a hyperlink and a Custom Show.
But the key is that, in a sales situation, you can go seamlessly to your strength and summary, close and ask for the order, and elegantly look like you've planned for the time allotted or the quick exit.
This technique dovetails well with an interesting presentation paradigm put forth by Bob Lane, an academic presenter from Arizona. He showed a veritable Collective Unconscious-like hyperlinked super-presentation where the presenter is totally flexible by a using Web-modeled slideshow that can go anywhere, any time, in a few mouse clicks. This model stimulated lots of discussion about potential applications and directions for the ordinary PowerPoint slide show.
Finding A Presenter's Strengths & Weaknesses
Perhaps most successful among the presenters was Korie Pelka whose in the trenches insight of her work with EFI (Electronics for Imagining) resonated with most attendees who are basically working for presenters and whose ideas are welcomes with varying degrees of enthusiasm, while they understand the medium of PowerPoint best.
Korie's slides, which will be available at the PowerPoint LIVE site for attendees, provided a really insightful view of the types of presenters strengths and weaknesses and how to best craft a story or message to make an impact for a variety of situations, including sales, technology, training, and corporate communications.
This stimulated two sessions of discussions of the psychology of dealing with audiences and with presenters themselves, from CEOs to engineers who know too much and sometimes get off on details that are better left alone.
Going beyond the bytes into thinking about the real world scenarios in which presentations are given (and revised on airplanes) gave attendees concrete ideas on how to organize and craft their message and reach desired objectives.
On a more entertaining but very useful note, we were also lucky enough to visit with Albert Einstein (aka Arden Berkowitz) who both regaled and inspired the audience with some very nuts and bolts techniques for creative thinking. Hint: don't answer the phone on the first ring; take a breath; "bookmark" where you were in your thoughts when it rang; then pick up and deal with the call.
Oh Yeah. Products, Too.
Lest we overlook the technical aspects, there was an expo filled with innovative PowerPoint products, many of which have been dealt with in previous updates. These included Camtasia Studio 3, Infommersion Xcelsius and Instant Effects' Office FX along with various Flash converters and VOX Proxy's animated characters.
For the cool factor the show featured at least four maestros of PowerPoint design and animation, including Nancy Duarte on corporate branding and identity creation, and Troy Chollar, Julie Terberg and Glen Millar, veritable Gods of PowerPoint Animation.
To see examples of the absolute crème de la crème of PowerPoint, you must look at their work. We got to see the inner workings of the Custom Animation Task Pane for some of their projects, and there were literally hundreds of effects on one slide that worked seamlessly.
I would say that Julie and Troy can do more with corporate charts and logos that you've ever imagined, and Glen is an artist with PowerPoint on a level you can't imagine if you haven't seen this Aussie's awesome work.
For those of you who use PowerPoint I have three suggestions:
- Put an image on the Slide Background. Use AutoShapes to obscure and reveal the image by filling them with the Background Image.
- Use the "With Previous Animation" setting to combine effects in a myriad of fascinating ways.
- Activate the Advanced Timeline to fine tune your animations.
I will explore these techniques in more detail in a future update (after I've grokked them myself).
Before the show even began, there were seminars, including one by Julie Marie Irvin and Todd Dunn which provided a comprehensive resource guide to the universe of products that enhance, support, and project PowerPoint presentations. In two hours, they covered conferencing, organization, and Flash import and export tools. Julie has supervised some of the most successful presentations for military funding and pharmaceutical promotion, while her colleague and friend Todd is perhaps the guru of audio visual mastery, having worked at Disney World and with the U.S. Air Force. Their handout was worth the price of admission.
If you get the sense I'm excited about this show and about my relationships with my PowerPoint colleagues, you're correct. I am not sure whether Rick will let non-attendees have any of the content, but if you're a serious PowerPoint user, I suggest you beg, borrow, or pilfer the program CD or try to access the Web site for the content.
Only 364 days til the next one.