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 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.