Mastering Formulas And Key Functions: MS Excel 2010 To 2016

Free Webinar

  • 90 minutes

Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at introductory to intermediate level.

To work efficiently with formulas and functions you must start with clear understanding, good habits, and application of correct structure and syntax. This presentation effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you need to understand the depth and scope of these Excel features. Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government and business administration.

Promote and attend this informative and value-packed 90-minute webinar with your team to boost efficiency and maximize your ‘return on investment’ in MS Office.

Session Highlights:

  • Concatenation – combine text and numbers in 2 or more cells

  • AND and OR used with the IF function

  • VLOOKUP – lookup and match data efficiently

  • PMT – calculate loan repayments with ease

  • Key text functions – cleanse data from external sources

  • Link between worksheets and workbooks

  • Key Date functions – use dates in calculations

  • Formula auditing – manage, trace and correct formulas

What's Included:

  • Comprehensive step-by-step Learner Guide

  • Exercise files

  • Demonstrations

  • Practice exercises

  • Productivity techniques, tips and shortcuts

  • Q&A session

Why You Should Attend:

  • Use formulas and key functions with improved confidence and consistency

  • Improve job satisfaction, team performance and professionalism

  • Outperform your peers and competition

  • 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 in practice and business

  • Tax professionals

  • Financial analysts, planners, advisors and directors

  • Benefits Specialists and Managers

  • Bookkeepers

  • Business analysts

  • IT Professionals

  • Administrative personnel 

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.

Good webinar on ms excel


the speaker covered good tips on using formulas in excel and the learning guide is also simple.

by Farrah Chitsaz

Good information covered


I like the option of being able to watch at a later time.

by Lavonda Brown

Webinar on Excel


learning excel functions is easy by attending this webinar.

by Gregory Effinger

Working with Pivot Tables in MS Excel (2010-2016)


I would highly recommend this introductory course. The instructor was very knowledgeable, professional and had a very clear, personable teaching style.

by Terry Prewitt

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

Share this course with a friend

We Also Recommend


Working with Charts & Graphs in MS Excel (2010 to 2016)

Free Webinar
90 minutes


Get Notified about News, Webinars, Community & More