MS EXCEL EXPERT

Become a data expert with our Excel courses

You have used Excel to perform tasks such as running calculations on data, sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel, by automating some common tasks, applying advanced analysis techniques to more complex data sets such as Pivot Tables, collaborating on worksheets with others, importing and exporting data using Power Views.

Request a Meeting

WHY IS IT CRUCIAL TO TRAIN YOUR EMPLOYEES?

Increase in Productivity
Performance Management
Product Quality
Employee Retention

COURSE PREREQUISITES

  • Delegates should already have a good working knowledge of Excel (one way to achieve this would be to attend our one-day Excel Core course).

LEARNING OUTCOMES

  • Manage multiple workbooks
  • Modifying workbook templates
  • Managing workbook versions
  • Copying macros between workbooks
  • Connecting to external data
  • Tracking changes
  • Protecting workbooks for sharing
  • Displaying & Reviewing changes
  • Merging workbooks
  • Identifying errors & Tracing formulas in separate worksheets
  • Creating custom formats
  • Using advanced Fill Series
  • Apply advanced conditional formatting and filtering
  • Managing conditional formatting rules
  • Creating and modifying cell styles
  • Creating form fields
  • Prepare workbooks for internationalization and accessibility
  • Create advanced chart elements
  • Adding trendlines to charts
  • Creating dual-axis charts
  • Create and manage PivotTables
  • Creating Slicers
  • Using PowerPivot
  • Manipulating options in existing Pivot Charts
DOWNLOAD SYLLABI

PUBLIC COURSE SCHEDULE

Venue: Holistic Technologies Ltd, Fgura

Training Date Time Price
Thursday 30th November ’17 09:00 – 16:00 €200.00 (including Training by an Excel Professional, Courseware, x2 Coffee Breaks and a light lunch)
PAY NOW
Thursday 15th February ’18 09:00 – 16:00 €200.00 (including Training by an Excel Professional, Courseware, x2 Coffee Breaks and a light lunch)
PAY NOW

ON-SITE TRAINING

Holistic Technologies On-site Training is a flexible, cost-effective option that allows you to train as many or as few employees as you need—from a single team or department to everyone in your organization.

On-site Training courses can be delivered “off-the-shelf,” slightly modified or completely customized for your learning needs. They’re designed to meet your most important goals and produce immediate, measurable results.

Your employees and your business benefit because:

  • Courses are planned around the individual’s and department schedules, and delivered in any format
  • Teams will learn with real-world, mission specific examples to ensure your project’s success
  • You maintain productivity with flexible course scheduling
  • You can train groups of employees to significantly reduce expenses
  • You can tailor the course material to fulfill corporate needs and expectations.
Request a quote