excel-training-bundle

Excel Training Bundle

Pre Recorded | Combo Offers

  • 340 minutes

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:

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

No Reviews Found

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

  • $249.00

  • $399.00

  • $399.00

  • Total : $00.00

Share this course with a friend
           

We Also Recommend

Technology

Mastering Effective Presentations In MS Powerpoint 2010 to 2016

Free Webinar
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