Speaker Profile
ROMAN KONDRATIUK
Roman’s professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher. He also recently added Office 365, SharePoint Online, OneDrive, Outlook Web Application and Office Online to his online courses portfolio. Roman has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 15,000 students and authored a wide range of complex reports, training, and procedural documentation, Roman has demonstrated strong ability in written communication, change management, and knowledge transfer.

Lookup Function Essentials in Excel
When it comes to dynamically lookup and retrieving information from small or huge tables of data Lookup functions can elevate you to a new world of accuracy, productivity, and time savings in Excel. To work efficiently with lookup functions you must start with a clear understanding, good habits, and application of correct structure and syntax.This course effectively teaches lookup techniques and demonstrate..

Excel Fundamentals For Bankers
You can use Excel for basic tables, spreadsheets, calculations, and charts through powerful data management, PivotTables, professional graphs, and automation of repetitive tasks. Confident skills in this most popular and powerful Microsoft application are becoming an essential requirement in Banking, finance, business, government, and education sectors.Gain a solid foundation to efficiently build your knowl..

Formulas, Automatic Calculation and Key Functions In Excel
To work efficiently with formulas and functions you must start with a clear understanding, good habits, and application of correct structure and syntax. Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at an introductory level.This course effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you ..

Intermediate Functions, Lookups and Linking In Excel
To work efficiently with formulas and functions you must start with a clear understanding, good habits, and application of correct structure and syntax. Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel beyond the introductory level. This course effectively demonstrates and teaches examples of formulas and specific functions, providing the perspectiv..

Linking Techniques In Depth In Excel
Linking between spreadsheets, workbooks and applications offers huge efficiencies but needs a clear understanding to work accurately and avoid risks that linking can pose. Understand 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..

Pivot Tables Essentials For Data Analytics In Excel
PivotTables are the most powerful data analysis feature in Excel, combining the ability to sort, filter, subtotal, calculate and chart data in minutes. A PivotTable displays a summary of a selected data set in a condensed format of rows, columns, data fields, and pages. These components can be “pivoted” with your mouse allowing you to expand, isolate, calculate, and group the particular data in real-time. T..

Mail Merge Essentials In Word
Mail merge saves you significant time and effort, producing mass mailings and labels is much simplified, especially compared to the process of preparing individual letters or envelopes for many people. One standard letter can be created and sent to a huge range of recipients without having to manually add each name and address.MS Word "mail merge" creates personalized letters, emails, envelopes, or mailing ..

Mastering Chart And Graph Essentials In Excel
With 16 chart types in MS Excel including the new funnel chart, there are many choices to present information in a clear, engaging, and professional manner. Each chart type has up to 7 sub-chart variations plus a massive range of formatting options and variations. Maximize your use of this powerful Excel feature and take data analysis and interpretation to an effective and appealing level, helping your audi..

Mastering Styles, Table Of Contents and Indexing In Word
Styles can save you significant time and effort by applying consistent formatting throughout your document and instantly creating a Table of Contents which is automatically updated. A Table of Contents can include titles or descriptions and page numbers for sections or chapters and outline your content giving readers a high-level view of the structure and segments in your documents.Indexing allows you to ma..

Name Ranges, Goalseek, Linking and Formula Auditing In Excel
Understanding of Name Ranges, Goalseek, Linking and Formula Auditing provides a huge advantage in progressing to higher levels of mastering Excel. 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 a clear understanding, good habits, and applicat..

Email and Calendar Essentials With Power-User Skills In Outlook
This course effectively demonstrates and teaches the key elements of Outlook from introductory to beyond the basics, including power-user techniques, shortcuts, tips, and tricks.Microsoft Outlook is the powerhouse in managing email, appointments, tasks, and contacts.It aims to provide the knowledge you need to understand and use the outstanding capabilities of this powerful application.The expert tuition an..

Excel - Mastering Lookup Functions
"How do I look up a value in list ONE and pick up a related value from list TWO""How do I avoid my lookup formula displaying an ugly error when it can't find a match?""I've heard of VLOOKUP but what's HLOOKUP and what’s XLOOKUP?"These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mas..

Tracking Actual Project Progress in Project 2013
Tracking compares what actually happens during your project against what was planned.Protect your well-planned project from becoming a disaster!Thorough project planning is essential, however, keeping your project on track is critical and often more challenging.After planning, reality sets in, bringing likely risks, delays, and budget blow-outs. To effectively manage a project, you must regularly monitor ac..