Webinar: Integrating Excel with Word and PowerPoint

WK270  |  Partner Virtual Events  |  Intermediate  |  Scheduled

Description

Excel is the accountants' tool of choice for analyzing data, but their analyses often find their way into formal reports and presentations. Most accountants and business professionals use simple cut-and-paste processes or re-key their analyses to integrate them into Word and PowerPoint, but these Microsoft Office products offer a full range of options for integrating data among and between them. Tables and text in Word documents and PowerPoint presentations can be linked and updated as analyses in Excel is updated or changed. This session contains all of the tips, tricks, and techniques necessary to ease the process of integrating Excel with Word and PowerPoint.

Credits

Number of Credits Type of Credits
2 Other

Prerequisites

Good working knowledge of Excel, Word, and PowerPoint.

Highlights

Using the Camera to link or embed formatted Excel tables or reports into Word or PowerPoint Linking individual data cells from Excel into Word text Pasting and linking report text from Word into Excel Embedding Excel analysis in Word documents or PowerPoint presentations Using hyperlinks to link text in Word or PowerPoint to underlying analysis in Excel Embedding PivotTables into PowerPoint presentations

Objectives

Upon completing this course, you should be able to:

  • Use linked or embedded Excel analysis to automate the process of updating reports or presentations
  • List the five ways in which Excel data can be pasted into Word
  • Describe the process of linking or embedding multi-page Excel objects into Word
  • Explain how to modify the Quick Access Toolbar to facilitate working with hyperlinked documents

Preparation

None

Notes

This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.

Prices

Member (Early Bird)
$79.00
Non-Member (Early Bird)
$79.00
Member
$79.00
Non-Member
$79.00
Your Price: $79.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations. Early Bird rates will be applied to all registrations made prior to December 20, 2017.

Facilitators

Lawrence McClelland, MBA, JD

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Back to Facilitators