From the beginning when dynamic linking libraries (DLL) were new, all the applications in the Microsoft Office Suite were designed and meant to be used together, not just stand-alone. Learn how to leverage the linkage to dramatically expand what you can accomplish in Office.
Where do I begin?
Far from just the opening lyrics to the movie theme for “Love Story,” this is a question that many Microsoft Office users frequently ask themselves as they approach a new project.
- You’re preparing a report that includes a table of figures that are totaled at the bottom. Do you produce the whole thing in Microsoft Word? If you produce the table in Excel, how does it become part of your report?
- You’ve written out an idea for a presentation you want to give. You’re given the green light and need to produce a PowerPoint deck. Do you start by re-typing the outline you wrote in Word into PowerPoint?
- You have thousands of contacts in Outlook and you just signed up to use an email engine to send out messages without hazard to your own online reputation. How do you break down the contact database into the different groups you want to send to?
Underlying Technology Magic
All of the Microsoft Office applications work well together thanks to the Dynamic Linking Libraries. You’ve seen these on your computer as files with the .DLL type extension.
Perhaps the most popular way in which the DLLs are manifested is in simple Cut & Paste capabilities.
- To integrate an Excel table into a Word report, simply highlight the area to be transferred, cut or copy it, switch to Word and paste it. Done. Format as you please.
- Similarly, copy your Word outline for your presentation and paste it into the outline window in PowerPoint. Insert your slide breaks as they make sense to you. You may find yourself taking longer sections, copying and pasting the slide multiple times and then cutting away previous and subsequent bulletpoints to create multiple slides to describe the sequence. There are plenty of creative cuts and pastes to help you keep your presentation lively.
- Export your contacts to Excel. Each field becomes a column. Sort as needed. Segment as you see fit. Export to your email engine. You’re ready to publish your emails.
Think Office – Not Apps
Microsoft Office was designed with DLLs to make it all work well together. The less you think about Word, Excel, PowerPoint and the others, and the more you think of Office as one unified environment, the more powerful it becomes. Don’t think pens and pencils. Think pencil cup. Don’t think ingredients, think recipe.
When you think about the best, most effective presentations you’ve seen, and the most beautiful, impactful documents you’ve read, know that the authors were thinking this way and used all the tools at their disposal. You can too.
Talk to New Horizons
The course catalog at New Horizons is all about using many tools together. We often encourage you to engage in cross-training between applications, servers, storage, and networking technologies. We also encourage cross-training between the components of Microsoft Office. Talk to your New Horizons counselor today about …. Where Do I Begin?