Excel Intermediate: Master Formulas, Data & Charts

Overview

Choose the Training Option That Works Best for You
Weoffer two convenient delivery methods to suit your needs:

In-House Training:Perfect for organisations with
four or more participants
offering acost-effective and flexible option. Training is delivered at your location and tailored to your needs.

Contact us today to learn more or request a quote.

Public Training:Ideal for individuals or smaller teams (typically
one or two learners
)our public training sessions are scheduled regularly and open for registration. Register online today to secure your place!

Develop skills to make use of MS Excel’s more sophisticated and complex features

For any organisation to progress and expand, its employees should be equipped with the necessary skills to maximise their productivity in the workplace. This course enables users to manage, manipulate and analyse date quickly and easily.

This highly practical one-day course builds on the basic MS Excel skills and explores ways in which data can be more effectively analysed and manipulated. It examines more advanced functions and formula, and explores how data can be managed for maximum efficiency and presentational impact

High level content

By the end of the courseyou will have an understanding of the following topic areas

More Functions

• COUNTIF / SUMIF
• IF
• TODAY

Managing Datasets

• Sorts, Multiple Sorts
• Filters, Data Validation

Linking

• Linking Data in Worksheets
• Linking Cells Between Worksheets
• Updating, Locking and Breaking Links

Charts

• Chart Types
• Chart Elements
• Modify Chart Design

Is it for me?

If you wish to develop your basic skills in order to make use of MS Excels more sophisticated and complex features, then this course is for you. Those wishing to progress to learn the more advanced functions of Excel should look at the Excel Advanced training course.

We can deliver this (and all our) course(s) exclusively for your organisation either in-person at your premises, at a venueof your choiceor virtually. In-house training offers a cost-effective and flexible way to upskill your team with content tailored to your organisation’s specific goals and challenges.

Whether you're looking to develop a single team or roll out training organisation-widewe’ll work with you to ensure the programme/course(s) deliver maximum impact.

Interested?Contact us today to discuss in-house options.

Location: The Mount Business & Conference Centre