Excel Linking Techniques With Word PowerPoint Access & Web
Ray Evans
Live: One Dial-in One Attendee
Corporate Live: Any number of participants
Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Object Linking and Embedding (OLE) makes content that is created in one location or program available in another program.
Using MS Excel you can link or reference to other cells in a worksheet or other worksheets, external workbooks, external files, and pages on the internet or your intranet, a valuable and marketable skill. Dynamic links ensure changes in source data, graphics and charts etc. are reflected in all “dependent linked” files. Mastering the linking of information using MS Exceland MS Office is a valuable skill
Why you should Attend:
Join us for this informative and value-packed 75 minute webinar with your team to boost efficiency and maximize your ‘return on investment’ in MSOffice.
Use data more efficiently and effectively
Ensure improved data accuracy
Improve job satisfaction, team performance and professionalism
Impress your management, peers and clients
Advance all co-workers using MS Office to a consistent standard
Maximize your technology investment performance
Areas Covered in the Session:
- Link between Excel worksheets and external files
- Relative Vs absolute references
- Complex formulas linked to external data
- Formula auditing
- Update linked values
- Change link source
- Open a source file
- Break links
- Link information and graphics between Excel, Access and other programs
- Hyperlinkto other workbook cells, external files, and web pages
- Comprehensive step-by-step Learner Guide
- Exercise files
- Demonstrations
- Practice exercises
- Productivity techniques, tips, and shortcuts
Who Will Benefit:
- Any person or organization seeking to significantly boost efficiency, productivity, job satisfaction and effective use of their technology investment. Particularly personnel in the following fields
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher. Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 120,000 students and authored a wide range of complex reports, training, and procedural documentation, Ray has demonstrated strong ability in written communication, change management, and knowledge transfer.