Excel Training Bundle

All-in-one Excel Training Bundle

Improve job satisfaction, team performance, and professionalism. Outperform your peers and competition as you impress your management, peers, and clients with the effective and handy Excel training provided in these 4 exclusive webinars.

This bundle includes expert Roman Kondratiuk's Excel webinars:

Mastering Formulas And Key Functions: MS Excel 2010 To 2016 (90 Mins)
Working with Charts & Graphs in MS Excel (2010 to 2016) (90 Mins)
Linking Techniques In-Depth on MS Excel (75 Mins)
Working with Pivot Tables in MS Excel (2010 - 2016) (90 Mins)

Learning benefits include:

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
Correct data setup for charting
Create a new chart from scratch
Chart sheet Vs embedded chart
Chart types, layouts, and styles
Professional chart formatting
Resize, reposition and delete a chart
Add and manage chart elements
Adjust axis scale and elements
Change layoutsSwitch row and column orientation
Add a data table with legend
Stack pictures in column graphs
Create Sparkline charts
Add chart annotations and graphics
Link a chart heading to your table
Link a chart into Word or PowerPointPrint charts
Quick Analysis feature
Link between Excel worksheets and external files
Relative Vs absolute references
Complex formulas linked to external data
Formula auditingUpdate 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
Data table design essentials
Understand PivotTables
Create your own PivotTable
Define PivotTable structure
Switch & Delete PivotTable fields
PivotTable Tools – Analyze and Design
Summary Value Calculations and Format
Column and Row Filters
PivotCharts
PivotTable Slicers to Filter Data and Charts

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.

Write a review

No Reviews Found