Home > Articles

📄 Contents

  1. Office Reference Guide
  2. Table of Contents
  3. Surrealty: An Organic Case Study
  4. Working with Microsoft Word
  5. Branding Yourself with Microsoft Word
  6. Revising Your Document
  7. Saving and Using Document Templates
  8. Formatting with Styles
  9. Secrets of AutoText and AutoCorrect
  10. Trying To Remain Normal
  11. Customing Word with Macros, Menus, and Toolbars
  12. Document Management: Scanning into Word
  13. Using the Clip Organizer
  14. Backing Up Your Office System
  15. A Testimonial To Tables
  16. Navigating with Bookmarks
  17. Using a Document Map
  18. Creating a User Form
  19. Introduction to Word 2007
  20. Blogging with Word 2007
  21. Using Word 2007 Quick Parts and Building Blocks
  22. Mail Merge in Word 2007
  23. Word 2007: Open and Repair
  24. Styling: Using the New QuickStyles in Word 2007
  25. Compare and Combine Document Versions in Word 2007
  26. Accelerating Your Knowledge of Excel
  27. Getting Started with Excel Worksheets
  28. Creating and Autofitting Cell Content
  29. Populating the Worksheet with Data
  30. Using AutoSum To Create Automatic Calculations
  31. Using Formulas
  32. Making Your Worksheet Look Nicer
  33. Charting the Data
  34. Completing the Financial Picture
  35. Getting Fancy With Xcelsius
  36. Say It With Charts!
  37. The Effect of Text Entries and Blank Cells on Calculations
  38. Filtering Your Outlook Contacts
  39. New Charting and Productivity Tools
  40. Cataloging Your Backups in Excel
  41. Using Excel as a Simple Database
  42. Painless Pivot Tables
  43. Creating Interactive Spreadsheets Online
  44. Moving an Excel Macro
  45. Working with Scenarios and Goals
  46. Using Excel's Solver
  47. Emphasizing Sales Data in Excel
  48. XspandXL for Spreadsheet Analysis
  49. New Crystal Xcelsius Light (Free)
  50. Excel Business Analysis Books
  51. Excel 2007 Sorting, Filtering and Table Enhancements
  52. Creating an Entrepreneurial Marketing Plan in Excel 2007
  53. Named Ranges in Excel 2007
  54. Maintaining a Positive Outlook
  55. Using Word for Email
  56. Creating an Email Signature
  57. Handling Email Efficiently
  58. Creating an Anti-Spam Filter
  59. Working with Contacts
  60. Adding a Contact from Email
  61. Saving a Contact as a vCard
  62. Using the Calendar
  63. Appointments, Events, and Meetings
  64. Setting Tasks and Making Notes
  65. Protecting and Exporting Outlook Information
  66. Creating a Distribution List, and Other Outlook Tips
  67. Mail-Merge E-mail
  68. Creating an Outlook Form
  69. Completing the Outlook Form Solution
  70. Using Search Folders and Anti-Spam Tips
  71. Creating an E-Mail Template
  72. Using Outlook with a Cell Phone
  73. Stupid Outlook Tricks
  74. Using Multiple Outlook Calendars
  75. Using NewsGator for RSS in Outlook
  76. Review: <em>Conquer Email Overload with Better Habits, Etiquette, and Outlook 2003</em>
  77. Using Anagram's Artificial Intelligence
  78. MeetingSense for Enhanced Outlook Productivity
  79. Introduction to Outlook 2007 and Predictions
  80. Trying Business Contact Manager
  81. Outlook 2007 Organization Features
  82. Taking Your Outlook 2007 Calendar Online
  83. Going Mobile with My New SmartPhone
  84. Synching Outlook with Facebook
  85. Workaround: Create a Private Distribution List in Outlook
  86. Microsoft Office Outlook Connector
  87. "Where Are My Socks?" Accessing Your Important Information
  88. Exploring the Northwind Application
  89. Access Basics
  90. Creating Tables
  91. Using Forms for Data Entry
  92. Creating a Report
  93. Querying Your Database
  94. Creating Relationships
  95. Using Access for Business Documents
  96. Customizing an Access Template
  97. Using Macros and Switchboards in Access
  98. Creating an Online Data Access Page
  99. What's New in Access 2007
  100. Making Your Access 2007 Forms and Reports Look Professional
  101. Use the Access Label Wizard
  102. Presenting Professionally with PowerPoint
  103. Introduction to PowerPoint
  104. Creating Cool Diagrams
  105. Using the Diagram Object
  106. Beginning the Org Chart
  107. Using the Org Chart Toolbar
  108. Changing the Org Chart Layout
  109. Selecting Portions of the Org Chart
  110. Moving and Formatting the Selection
  111. Applying Styles to the Org Chart
  112. Using the Other Conceptual Diagrams
  113. Adding Our Concepts
  114. Moving Shapes with the Diagram Toolbar
  115. Moving or Resizing the Diagram
  116. Using the Diagram Styles
  117. Changing Your Concept Diagram
  118. Turning Off AutoFormat
  119. Adding a Caption or Title
  120. Summary
  121. Q&A
  122. Customizing Your Presentation
  123. The Concept of Customization
  124. Accessing the Master Views
  125. Understanding the Master Views
  126. The Power of the Master Views
  127. Adding Our Logo
  128. Changing Other Elements
  129. Slide Master Rules
  130. Using the Title Master
  131. Using the New Slide Master Template
  132. Adding Date and Time to a Footer
  133. Using Headers and Footers
  134. The Master View Toolbar
  135. Using the Handout Master
  136. Using the Notes Master
  137. Using Page Setup to Change the Presentation Type
  138. Summary
  139. Q&A
  140. Accessorizing for Presentations
  141. The Potential Of Photo Album
  142. Using Broadcast Quality Effects
  143. The Latest Presentation Gear
  144. Using PowerPoint, Video and DVD
  145. Microsoft Producer for PowerPoint
  146. Expanding PowerPoint with Plug-Ins
  147. Using Presenter View with a Projector
  148. Getting Into Your Presentation -- Literally
  149. The View from PowerPoint LIVE
  150. Making a PowerPoint Movie (not just for the Mac anymore)
  151. Making a Self-Running Animated Holiday Card
  152. Reporting on Databases in PowerPoint
  153. HD or Not HD, That Is The Question
  154. Taking On Tufte
  155. What the Heck Do I Say?
  156. Broadcasting PowerPoint Video with Serious Magic
  157. Video Blogging as a Presentation Value-Add
  158. This Just In: PowerPoint Secedes from MS Office!
  159. Two New PowerPoint Add-Ins
  160. Podcasting our PowerPoint
  161. What We Can Learn from InfoComm 2005
  162. Putting Yourself in the Show
  163. What You Can Learn from SIGGRAPH
  164. Using DVD Video in PowerPoint
  165. Animating Individual Chart Elements
  166. The Magic of PowerPoint LIVE 2005
  167. Making Sure Your Video Plays
  168. Creating a Timeline Template in PowerPoint
  169. Creating Transparent Animation and Backgrounds
  170. Using Advanced Animation Techniques
  171. Advanced Animation Part 2: Reusing Motion Paths
  172. Advanced Animation Part 3: Masked Backgrounds and Triggers
  173. Getting an Ovation with PowerPoint
  174. Video that Plays For Certain
  175. Using an Animated PowerPoint Chart on DVD
  176. Packaging Music Files with PowerPoint
  177. Say It With Presentations
  178. Keep Saying It With RSS
  179. PowerPoint LIVE 2006
  180. Total Solution: Using Propaganda for a PowerPoint Podcast for iTunes
  181. Wildform Wild Presenter for Interactive PowerPoint Online
  182. PowerFrameworks to Stimulate Your Creative PowerPoint Juices
  183. Distributing Video for iPods and Other Devices
  184. Converting Bullets to SmartArt Graphics in PowerPoint 2007
  185. Editing Video in PowerPoint (And a Lot More)
  186. Enhancing PowerPoint with Stock Photos
  187. Creating Sticky Documents and Presentations
  188. Review: Why Most PowerPoint Presentations Suck
  189. Using PowerPoint 2003 and 2007 Together: Preparing for InfoComm 2007
  190. Converting Flash to PowerPoint Video
  191. Animated Artwork for PowerPoint: PointClips and Vox Proxy
  192. Cutting Edge Graphics at SIGGRAPH 2007
  193. The Insert Object Animation Trick in PowerPoint
  194. Using YouTube Video in PowerPoint
  195. Using PowerPoint 2007 with Video Online
  196. PowerPoint LIVE 2007: Presentation Paradise in the Big Easy
  197. Camatasia 5.0: An Upgrade Worth the Effort
  198. Solving Video Playback in PowerPoint for Vista
  199. Review: Microsoft Office PowerPoint 2007 Complete Makeover Kit
  200. Graphic Novels in PowerPoint
  201. The Ultimate Presentation
  202. Opazity: PowerPoint for Lazy People
  203. Using SlideShare for Online PowerPoint with Narration
  204. Mastering Themes in Office 2007 (and Specifically PowerPoint 2007)
  205. VIDITalk's New Online Presenter Program
  206. Using and Converting YouTube Video for PowerPoint
  207. SlideRocket: Documents in the "Cloud"
  208. PFC Pro: Use YouTube Directly in PowerPoint and Maybe Get Your Web Cam into a Web Conference
  209. AuthorSTREAM: PowerPoint with Narration Made Easier Online
  210. Slide:ology: Nancy Duarte’s Design Secrets and Her New PowerPoint Book
  211. Mastering the New Slide Masters (and Layouts) in PowerPoint 2007
  212. Using PowerPoint 2007 to Create Slides That Don't Look Like PowerPoint (Video Update)
  213. A Treasure Trove of PowerPoint Templates
  214. Posting a Web Site with FrontPage
  215. Getting a Web Site
  216. Creating a FrontPage Web
  217. Where's My Web?
  218. Adding Navigation
  219. Applying a Theme
  220. Publishing Your Site
  221. The Old MHT Trick
  222. Taking Over A FrontPage Web
  223. Expression Studio 2.0: A Worthy Successor to FrontPage
  224. Publish or Perish
  225. Creating Publications for Print
  226. Publisher Web Sites
  227. Creating an E-Mail Newsletter
  228. E-mailing Holiday Cards
  229. Publisher 2007
  230. Get Visual with Visio
  231. Creating a Visio Flowchart
  232. Connecting Shapes
  233. Examining the Shapesheet
  234. Creating a Report
  235. Moving In With Visio
  236. Expanding Visio with Third-Party Stencils
  237. Playing Well with Others Using Visio
  238. Creating Interactive Diagrams with Visio's Layers
  239. Creating a "Virtual Database"
  240. Creating a Visio Dynamic Solution Template
  241. Visio 2007
  242. Visio 2007 Professional IT Toolbox
  243. Project Management with Visio 2007 Gantt and Pert Charts
  244. Review: Using Microsoft Office Visio 2007
  245. Tools That Integrate Your Office Applications
  246. Creating Video E-Mail with MovieMaker
  247. Managing Pictures with Microsoft Office Picture Manager
  248. New Year's Predictions: 2005
  249. Office Predictions for 2006
  250. Favorite Books List
  251. Using Excel as a Database Conversion Tool for Outlook
  252. Oh, Brother, I Love Labels (and other Office Tips)
  253. Planning for Disaster
  254. Using OneNote with Outlook
  255. Web Resources for Microsoft Office
  256. Simple 3D in Microsoft Office
  257. Creating Dynamic Database Links
  258. Using an Access Query for Mail Merge
  259. Displaying Database Links with Xcelsius Enterprise
  260. An Office 12 Sneak Preview from PDC
  261. My Big Fat Office Vacation
  262. What CES 2006 Means to Office Users
  263. Using &quot;Send To&quot; Between Office Applications: Word and
  264. Running (and Surviving) a Web-based Conference
  265. Running an Online Office with HyperOffice and Writely
  266. Preparing with Index Cards
  267. Creating Meeting Agendas
  268. Collecting Data with New Technologies: ARS, SMS and RFID
  269. Using Application Sharing in a Web Conference
  270. Running an Online Notes or Windows Media Session
  271. Trying Out Live Meeting
  272. Creating a SharePoint Team Website
  273. Using and Customizing a SharePoint Team Website
  274. Creating a Trip Planner in Excel and Outlook
  275. Crystal Graphics’ Excel and Solutions and Chart
  276. GoToMeeting Instant Webinar Tool
  277. Checking Out Office Live
  278. Using Quindi Meeting Capture
  279. Using Excel to Link to Other Databases
  280. Trying Out Mind Manager Pro to Brainstorm with Office Programs
  281. The 13th Thing I Hate About Office
  282. Introduction to Office 2007
  283. What's New in Excel and PowerPoint 2007
  284. Take a Look at InfoPath 2007
  285. Office's Groovy New Collaboration Program
  286. Using Office Accounting Express
  287. Printing to PDF or XPS in Office 2007
  288. Getting Adjusted to Office 2007 Changes
  289. Using SnagIt for IT Training
  290. Providing Help with Go To My PC
  291. Vista Meeting Space and People Near Me from Microsoft
  292. Trying Expression Web
  293. Migration Issues to Word and Outlook 2007
  294. Vista – Are You Kidding Me?
  295. Making Office 2007 (and Vista) Work Properly
  296. Office and the Enterprise
  297. Survey Says – Use Web Surveys with Excel and Access
  298. Uninstalling Office 2007 in Windows XP Pro
  299. Using Excel for Tables in Office 2007
  300. VIDITalk – Video in SharePoint and Beyond
  301. Career Advancement for Office Professionals
  302. Online Database that Rivals Access?
  303. Web 2.0 2008 in San Francisco
  304. Going Virtual for MS Office
  305. Going Virtual Using Mobile Apps
  306. Managing Your Contacts Across the Office Suite
  307. Charts in PowerPoint and Excel 2007 (Video Update)
  308. Outline View: The Document Planning Bridge between Word and PowerPoint
  309. Using Document Inspector in Office 2007
  310. SmartDraw: A Powerful Communications Tool to Supplement MS Office
  311. Visio 2007's New Pivot Diagram
  312. Using the Macro Recorder in Visio 2007 (Video Update)
  313. Compatibility Pack: Challenges of Using Office 2007 Documents in Previous Versions
  314. Microsoft Office Live Small Business Beta
  315. No One Asked Me But... What I Want (and Don’t Want) in the Next Office and Windows
  316. Late New Year's Resolution: Keys to Effective IT Communication
  317. SmartDraw Extras: Healthcare and Legal Templates
  318. Interesting Upgrades: Camtasia 6 and SnagIt 9
  319. Addressing the Office 2007 Read-Only Runaround
  320. Getting Organized with OneNote
  321. Flagging OneNote Information
  322. Recording and Organizing with OneNote
  323. Recording and Organizing Video in OneNote
  324. OneNote 2007
  325. Using OneNote 2007 Efficiently with Other Office 2007 Apps
  326. Using OneNote as a Voice Recorder
  327. Video Tutorials
  328. Charts in PowerPoint and Excel 2007
  329. Using PowerPoint 2007 to Create Slides That Don't Look Like PowerPoint
  330. Using the Macro Recorder in Visio 2007
  331. Playing a CD Audio in a Self Running Presentation
  332. Textboxes, QuickParts and Building Blocks in Word 2007
  333. Working Between PowerPoint and PDF
  334. Additional Resources
  335. Exploring Twine and the New Semantic Web
  336. A Tale of Two Tech Supports &#8212; OfficeLive and Zoho
  337. Digital Hollywood 2008
  338. Infocomm 2006
  339. InfoComm 2007
  340. Judging a Disc By Its Cover
  341. Surviving the Office 2007 Beta
  342. The Latest Word from CES 2007

Paul Vlahos is Chairman and CEO of iMatte, an offshoot of Ultimatte, the company that revolutionized drop out backgrounds special effects for movies, and won an Academy Award for its technology. You may remember Ultimatte best as the technique for putting two officers on the foredeck of the Titanic when they were actually in a movie studio, thousands of miles away.

Paul's current pet project is iSkia, which is a piece of hardware that sits on top of any conventional presentation projector (and actually resembles a second projector).

Figure 364Figure 364

The hardware is set up between the presentation laptop and the projector using the standard VGA connectors.

The first significant thing that iSkia achieves is creating a mask or matte out of the presenter (by having her stand in front of the device and screen, and calibrate various coordinates). Then, by projecting this mask (or matte) in real time during the presentation, the presenter can move inside the presentation image without the image being projected over her body, and without the light from the projector blinding the presenter.

Figure 365Figure 365

The device uses a conventional Gyro Presenter to set up the mask.

In effect, this puts the presenter inside the show. With the various levels of light and shadow controlled by the remote, it also enables the presenter to maintain eye contact and to engage the audience, while moving around inside the presentation area. The light levels can be refined and controlled. A 30% level is generally optimal in terms of enabling eye contact between the presenter and audience, and blending the image and shadow effectively.

So, this removes the inevitable disconnect between the audience and the presenter (who is standing off to one side while his visuals are projected elsewhere). As Vlahos says, in this scenario the brain of the viewer doesn't know where to focus its attention, and eventually zones out.

But this is just the tip of the iceberg with respect to iSkia (pardon the Titanic connection).

With the presenter free to move and point within the presentation screen area, iSkia also makes it possible to connect the remote mouse directly to the presenter's hand movement. Wherever she points, that's where the mouse goes.

It doesn't take a brain surgeon to realize that, with a synchronized click on the remote, it appears to the audience that the events on screen (the appearance of a bullet or image, the play of a movie, or the transition of a slide) are triggered by the presenter's movements, walking and pointing.

Another dramatic effect is the presenter's ability to physically control drawing tools, and to use a spotlight to highlight areas of the screen from within the performance – again, without detracting from the effect by standing outside the presentation area.

Vlahos calls this "controlling the eye-lines." The overall effect is to make the presentation one cohesive story, without a narrator disconnected from the visuals.

Again, there is no disengagement in the audience's attention between the presenter and the presentation. They are now one cohesive, organic delivery system.

Now, let's take this a step further. With iSkia properly configured, the presenter can put down the remote mouse, and his physical body becomes the pointing device itself.

It accomplishes this by using an ingeniously designed PowerPoint template. Hot zones on the screen trigger events like bullets, animation, transitions, and links to other slides and files. The movement of the presenter becomes visually woven into the presentation theme.

For example, it is no longer a disembodied mouse click from across the room that makes the curtain open, the car move, the chart data grow. It is the waving of the hand, the walk across the screen, or some other gesture or movement by the presenter.

With a motion of the hand, the mouse can be tossed across the screen, items grabbed and moved. Everything appears to be within the manual control of the presenter within the image itself.

This is beyond interactivity; I call it kinesthetic presentation. And it needs to be experienced to be properly appreciated.

The PowerPoint templates, authored and programmed by Zbig Rybczynski, really push the PowerPoint envelope through some ingenious tricks. iSkia overcomes the potential for erratic, unanticipated results by creating not one hot spot for a trigger, but rather a series of four contiguous invisible zones that are activated by the sweep of a hand or the walk across the stage.

In this way, some PowerPoint limitations are stretched to their limits with some very cool VBA programming. But the real power of iSkia is unleashed by using PowerPoint as a media platform and linking to a Macromedia Director file.

That's because Director allows for much more versatile control of the movement of screen elements and effects than does PowerPoint. By controlling the background and stage with body movement, the following types of effects are empowered:

  • Layers can be physically tossed aside, revealing the interior of a car or engine.

  • Data can be pulled up into a chart or graph (this can also be done in PowerPoint).

  • By walking across the screen with the properly created background, listeners will experience the presenter as though she's walking through an environment and interacting with it. She can enter rooms and trigger events, as though they were inside a QuickTime VR or similar environment.

I want to emphasize that this is far more than a parlor trick that will get old quickly as audiences adjust, as they might to a new set of backgrounds. Instead, the level of visual and emotional engagement is heightened between presenter and the audience, as the disconnect between the visual and personal is overcome by its complete cohesion.

Finally, looking ahead, two developments bode well for this technology. First, the implementation will be greatly simplified and reduced in cost as the iSkia technology is integrated directly into another generation of presentation projectors.

More dramatically, the Ultimatte "drop-out" technology is available to iMatte. This is the award winning real time masking capability, so that for the creators of iSkia presentations far more (photo)realistic backgrounds, stages and sets will be available for the kinesthetic presentation experience in real time. The presenter will not be limited to a conventional PowerPoint or Director background; instead, they will be free to roam and point over any image that a creative mind can devise.

So far, the main adopters of this technology have been academic institutions, but it seems inevitable that those with the most at stake in terms of reaching their audiences will adopt and adapt to this technology.

Particularly those accomplished presenters who are accustomed to using their body effectively to convey their message, and may even have been threatened by the imposition of distracting visuals, will be stimulated and inspired to be able to greatly explode the impact of their movement in harmony with the visuals which up til now have sometimes been a distraction.

This technology is obviously not for the lazy, unprepared presenter – but for those willing to embrace this technology, it will probably signal the end of "death by PowerPoint." Instead, Vlahos hopes that iSkia developers will comprise a set of the presentation elite, specializing in the ability to completely integrate the presenter and the presentation into a cohesive production – or performance – keeping an audience engaged, entertained and informed.

This will usher in the era of the kinesthetic presentation, and I believe that creative minds will take it to levels which we can barely imagine at this time.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.