linking-techniques-in-depth-in-excel-2013-2016

Linking Techniques in Depth in Excel 2013-2016

certification logo13006       

Live Webinar

  • 60 minutes

1Understand and apply the power of linking techniques within Excel and other key MS Office applications to boost productivity and efficiency for you and your organization.

Object Linking and Embedding (OLE) makes content that is created in one location or program available in another program. As examples, in 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. Dynamic links ensure changes in source data, graphics and charts etc. are reflected in all “dependent linked” files.

Mastering Outlook is a fundamental, highly regarded and marketable skill set, vital in business, government, and academic environments. Promote and attend this informative and value-packed 60-minute webinar with your team to boost efficiency and maximize your ‘return on investment’ in Microsoft Office.

Session Highlights:

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

  • Hyperlink to other workbook cells, external files, and web pages

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: 

  • Accountants 

  • CPAs 

  • CFOs 

  • Financial Managers/Staff 

  • Financial Analysts 

  • Budget Directors Staff 

  • Auditors

  • Administrators

  •  Managers

  •  HR 

  • Sales Professionals (Who prepare report using excel)

  •  Controllers

  •  Banking 

  • Insurance

  •  Education

  •  IT Professionals (Who want CPA/Financial Analysts point of view on Analytical Reporting)


Advanced Preparation: None

Program Level: Intermediate

Prerequisites: Basic knowledge of Excel

Field of Study: Computer Software & Application


*You may ask your Question directly to our expert during the Q&A session.

** You can buy On-Demand and view it as per your convenience.

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

Edupliance is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.

Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaint and refund, please contact our offices at 844- 810-1151.

PLEASE NOTE: To receive credit through the NASBA for this program you MUST attend the Live program in its entirety and complete the required progress checks.

Number of CPE Credits Awarded for This Course: 1.0 (Computer Software & Application - 1.0)

Delivery Method: Group Internet Based

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

Share this course with a friend
           

Newsletter

Get Notified about News, Webinars, Community & More