mastering-formulas-and-key-functions-ms-excel-2010-to-2016

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 Kondratiuk has delivered expert training and consulting, through beginner to advanced levels, to over 10,000 end-users in a wide range of Microsoft applications including Excel, PowerPoint, Access, Project, Word, Outlook, Visio and Publisher. Roman’s professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his range of classroom, seminar, workshop and online delivery services and instructional materials.

Roman has qualifications in Management, Training and Accounting and consistently receives outstanding evaluations from his clients who include multi-national corporations and large government organizations. Having a strong practical focus, his proven experience extends to project management and LEAN business improvement. His recent projects have delivered over 250% return on investment in savings and efficiency gains to government.

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

Technology

Outlook On Steroids - MS Outlook 2013-2016 Tips

Pre Recorded | Best Sellers
ROMAN KONDRATIUK
(Speaker)
Duration:
90 minutes

Technology

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

Free Webinar
ROMAN KONDRATIUK
(Speaker)
Duration:
90 minutes

Newsletter

Get Notified about News, Webinars, Community & More