Home > Articles

Microsoft Office Reference Guide

📄 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
  • Print
  • + Share This

Microsoft Office is the patriarch (or matriarch) of applications suites, and has now anointed itself as the Office System. In this Reference Guide, we cover the ins and outs of the various Microsoft Office applications, with an eye toward streamlining the end user experience by working on tangible projects and tasks. A key focus is using the programs as they were meant to be used—as a harmonious team to solve various business problems and allow companies to work more efficiently, whether Fortune 100 behemoths or single practitioners with a line of credit from mom and dad.

Why Microsoft Office?

When I moved to Los Angeles (a long time ago), I was pursuing a dream to become a writer for movies and television, so the only people who would hire me and pay me well were attorneys.

It was while working for law firms that I got my initiation into computers, both in terms of mastering word processing, and in how programs come to take over an enterprise.

Most of the companies I worked for used proprietary standalone word processors in which they had a substantial investment. Then, with the advent of personal computers, many switched to desktop programs, and WordPerfect 5 was king.

But a funny thing began to happen. Other parts of the law firm were using different types of products—Excel spreadsheets, PowerPoint presentations (although at that time the standard was Harvard Graphics). But the operating system was from Microsoft, and gradually (or perhaps not so gradually) the proclamation came down that we must be "integrated"—and that didn't involve busing kids to other neighborhoods. Instead, it was Microsoft saying that if we used their products as a unit, those products would all work together to make life easier. You could even start any document or program you wanted from this neat little toolbar, at no extra cost.

Before we knew it, Microsoft Word had devoured WordPerfect, PowerPoint elbowed aside Harvard Graphics, and Excel took over from whatchamacallit—Lotus 1-2-3.

Then Access was introduced—a powerful desktop relational database that let anyone keep track of inventory as though they were using high-end databases from IBM or Oracle.

The pièce de résistance, however, came with the Internet and the ubiquity of email, when Microsoft integrated Outlook—with its email capability, calendar, and contact list—and synchronized with some new cool toys like the Palm.

Game over.

To be employable these days, you pretty much need to know Microsoft Office, and if you run a business, you probably need to use Office to keep pace with your competitors and your customers' needs.

How do you get a handle on this enormous pack of programs? My guess is that you've already bought some books and learned some important tasks. So what we're going to do in this Reference Guide is give you the tools you need, in terms of examples and insights, to solve the most common business tasks using the various Office programs.

We're not going to try to teach you each program in depth. You've probably already laid the foundation for that. Instead, we'll try to show you the big picture and help you to "get" some key concepts that will enable you to succeed in...well, whatever you use Office for.

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.