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

One of the more eclectic trade shows to hit Los Angeles every year (now twice a year) is Digital Hollywood. While ostensibly a pow wow for entertainment industry moguls to do deals with technology folks, it always features stuff of interest to ordinary geeks and those looking for cutting edge products.

This year, coming on the heels of Web 2.0, the focus at Digital Hollywood was once again "community," social networking, and widgets, but from an entertainment perspective.

For example, while you might expect that a company like Slide.com hosts PowerPoint presentations, it actually is one of a multitude of sites that enable mostly kids to put up pictures and make them into slideshows.

But if you look closely at this site and many others in the Web 2.0 space, you will once again see that API's allow developers to leverage content from one site in another. For instance, the Slide.com content can be made available in a Facebook "wall;" while this is not that exciting for the mainstream technology/business world yet — it may be soon.

Facebook already has many platform alliances with other types of content — some of them business. Its Slideshare link doesn't work yet (I keep trying) but eventually real PowerPoint will also be shared in apps like Facebook.

It's also quite possible that your higher ups are clamoring for tie ins to Facebook right now. One source you can go to right now, which may surprise you, is that AOL developer network. Instead of having your own developers come up with a social network to integrate with your own intranet or extranet, you could use Userplane. To begin to work with the newly buzzing semantic web you might check out AOL's sphere application to connect your content to textually relevant information from blogs, press releases, video, photos and ads, as well as your own archives.

AOL is bursting at the seams with apps you might be able to buy or subscribe to easily — even Mapquest is part of their developer network. They were at the show selling to entertainment web site but a business web site could take advantage of this trend equally well and stay ahead of the curve competitively.

Speaking of video, it's always a big part of this show and I am interested usually from a PowerPoint perspective. At this show Microsoft's Silverlight platform followed the Web 2.0 caravan down from the bay area. What is Silverlight? It's Microsoft's latest answer to Flash as a plug in platform to play multimedia in the browser.

For Microsoft multimedia mainly means the WMV file format, but Silverlight is gaining in the entertainment world for its cross browser and platform capabilities and it has a who's who of entertainment partners already. It doesn't tie into the business part of Microsoft (yet) as much as it does the consumer area buttressed by MSN, but eventually even Microsoft Office Live, the web based product, will interface with the "real" Microsoft Office, and PowerPoint will interface with Silverlight.

At this point unfortunately Microsoft's web entertainment/consumer presence and business presence are still somewhat disconnected.

The holy grail in my opinion of web video — which Silverlight may enable eventually — is video search. At this point only a few third party Flash developers have video search per se — where the actual visual content is searchable; most video needs to be tagged to be searchable.

An interesting application at the show pushing that envelope, however, is blinkx.com.

The first thing you notice on their site is the video wall — it does tend to grab your attention. The second thing is the word "search."

Searching in blinkx content brings up a host of hits based on its speech to text engine that indexes the content. Blinkx also has an entirely brandable extra-browser application called bbtv.

This is another trend — we covered a brandable video app called VIDITalk that works in Sharepoint a while back. Blinkx is doing this for entertainment on a bit of a grander scale, although it doesn't have the user access features of VIDI or YouTube.

Other large video applications were also at the show. Working alongside Silverlight (and incorporating its technology) was Move Media Player.

Interesting that Move uses the Silverlight plug in since it apparently competes with Microsoft Media Player; but it works with major media companies like ABC to deliver online versions of shows like Lost and Gray's Anatomy.

The long awaited convergence of the computer and TV is here thanks to the web. Lots of folks use Media Center to watch broadcast TV but one company makes a cool little gizmo that broadcasts web content around the house or conference room to one or more HD monitors. The ZvBox was at the show to be sold to entertainment companies but like many new products at Digital Hollywood, it might well turn up at InfoComm geared to corporate communications users.

While many of us already connect a PC to a TV monitor one way or another (many plasmas come with DVI or VGA connectors) the ZvBox has a terrific resolution and literally creates an internal broadcast channel in your local environment; best of many features, its universal remote (great for presentations) makes the computer interface unnecessary (no mouse) and lets you navigate the device like a home remote control.

There were some other interesting businesses at the show. Sybase, formerly a Microsoft competitor in large scale databases, was there to show off various messaging and mobile offerings that would connect, presumably, to databases.

Take a Long Look @ LinkedIn

Among the hoopla concerning social networking was pioneer Linked In. Like many users I have grown tired of receiving birthday announcements about people I don't even know, but the Linked In rep took me on a tour that opened my eyes to its business potential as a communications, search and research tool.

One neat trick is that you can locate contacts in Outlook who you correspond with frequently on Linked In, and import part or all of your Contact list from MS Outlook into the social networking environment.

I speculated on this in a previous update as a feature and today's news had rumors of Microsoft interest in Facebook.

Linked In will use an Active X control to scour your Outlook contacts for other members, whom you can import and/or invite.

I was amazed to find within minutes that about a third of my Outlook contacts were also members of Linked In, many of whom I had not annoyed with an invitation to my own network.

You can also download a Linked In Outlook Toolbar to:

  • Build your network from frequent contacts
  • Manage your LinkedIn contacts in Outlook
  • Stay connected to your network

The other terrific aspect of Linked In is its ability to take advantage of SEO (search engine optimization) capabilities for finding members and doing research.

Their rep took me through a process of changing the URL of my public profile to match my name, so that Googlers and other searchers would be able to find my several web sites (including InformIT) through my Linked In profile.

Adding keywords to my Summary and Experience fields make them meta data for searches as well, so that those who might be looking for help with video, presentations or PowerPoint might locate my Linked In profile and thereby — perhaps — hire me.

The Advanced Search window for People allows you to modify a search for those at a specific company, whether they are currently there or not. This is a good way to get the low down on working conditions from former employees and to locate individuals by drilling down by a host of useful parameters.

Another amazing resource is the Ask a Question feature — or actually the Answers section of Linked In.

You can send a question out to your network or select specific connections for potential responses. As you frame your question similar questions (already answered) will pop up, and you can get guidance on the sort of issues you may want to address.

A sample of questions from the network enable you to see the benefit of reaching out with queries — one netted 97 responses — thereby widening the scope of the questioner's actual network, getting him/her useful information and literally connecting him/her to other Linked In users. Browsing Q&A can stimulate your own work efforts and get you similar results.

Just recently I wrote an update about Career Advancement for Office Professionals; whether you are IT or elsewhere in a professional field it would seem that taking advantage of the potential of a powerful social network like Linked In would be very beneficial.

Here, finally, is an example of one of four answers to an IT related question. Couple that with the relationship opened up with those who responded, and you can see its obvious value.

This year Digital Hollywood proved very stimulating — if the Fall event is as fertile as the one I just attended, I will keep you posted.

InformIT Articles and Sample Chapters

How Meeting People Online Becomes Science with Social Networks

The Future of Identity

Books and eBooks

The Truth About Profiting from Social Networking

Web 2.0: A Strategy Guide

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.