linking-techniques-in-depth-on-ms-excel

Linking Techniques In-Depth on MS Excel

Pre Recorded

  • 75 minutes

Understand and apply thepower of linking techniques within Excel and other key MS Office applicationsto boost productivity and efficiency for you and your organization. 

ObjectLinking and Embedding (OLE) makescontent that is created in one location or program available in anotherprogram. Using MS Excel you can link or reference to other cells in aworksheet or other worksheets, external workbooks, external files, and pages onthe internet or your intranet, a valuable and marketable skill. Dynamic linksensure 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. 

Joinus for this informative and value-packed 75 minute webinar with your teamto boost efficiency and maximize your ‘return on investment’ in MSOffice.

Session Highlights:

  • 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 otherprograms 

  • Hyperlinkto other workbook cells, external files, and web pages

What's Included:

  • Comprehensive step-by-step Learner Guide

  • Exercise files

  • Demonstrations

  • Practice exercises

  • Productivity techniques, tips, and shortcuts

Why You Should Attend: 

  • 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

Who SHould Attend:

Any person or organizationseeking to significantly boost efficiency, productivity, job satisfaction andeffective use of their technology investment. Particularly personnel in thefollowing fields:

  • Accounting

  • Banking

  • Business Analysis

  • Economics

  • Finance

  • Insurance

  • Investment

  • Management

  • Statistics

  • Valuation



Roman Kondratiuk

Roman Kondratiuk

Roman has qualifications in Management, Accounting, Training and Assessment and has delivered training to over 15,000 students, consistently receiving outstanding evaluations from his clients who include multi-national corporations and large government organisations.

With over 20 years of experience in Learning Development and Adult Training, Roman has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio and Publisher. 

Roman’s professional and relaxed training style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, online webinar and workshop services and development of customized instructional materials and online courses.

His achievements focused on formal risk management processes, eliminating waste, prioritization and implementation of major property management projects and formal engagement and induction of Colliers International as Building Managers.

No Reviews Found

Want to attend in a Group? Call 844-810-1151 and Save upto 50%

  • $99.00

  • $164.00

  • $164.00

  • $259.00

  • Total : $00.00

Share this course with a friend
           

We Also Recommend

Technology

Mastering Effective Presentations In MS Powerpoint 2010 to 2016

Free Webinar
ROMAN KONDRATIUK
(Speaker)
Duration:
90 minutes

Newsletter

Get Notified about News, Webinars, Community & More