Microsoft® Excel – Intermediate

SCHEDULE

No schedule at the moment

If you have three or more candidates or you would like to run this course as an in-house programme, please contact us.

Course Pre-requisites

This programme is designed for delegates who has completed our Microsoft® Excel – Basic programme, or has equivalent knowledge of using the various parts of the Microsoft Excel interface, can use absolute, relative and mixed references, use formulas and functions, manage and organise worksheets, edit and format data, print and save files and customise the Excel interface.

Overview

This intermediate level course is intended to help all users get up to speed on many of the different features found in Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyse data, organise worksheet data with tables, visualise data with charts, insert graphics, and enhance workbooks.

Objectives

  • Learn how to apply range names and use specialist functions
  • Explore the function categories, references, syntax and entry dialogue boxes
  • Learn how to use text, logical and lookup functions
  • Be able to create and modify tables and sort and filter data
  • Know how to create charts, modify and format existing charts and create a trend line
  • Learn how to create a PivotTable, filter data using slicers and analyse data using PivotCharts
  • Learn how to insert and modify graphical objects and incorporate SmartArt into workbooks
  • Customise workbooks, manage themes and create and use templates

Course content

Below is an example of the course content. The content can be ‘tailored’ to meet the exact requirements of the client.

Day One

Creating advanced formulas
  • Apply range names
  • Use specialised functions
  • Enabling interactive calculations
Analysing data with logical and lookup functions
  • Text functions
  • Logical functions
  • Lookup functions
  • Date functions
  • Financial functions
Organising worksheet with data and tables
  • Create and modify tables
  • Sort and filter data
  • Subtotal and database functions
Visualising data with charts
  • Create charts
  • Modify and format charts
  • Create trendline
  • Create advanced charts

Day Two

Analysing data with PivotTables, slicers and PivotCharts
  • Create a pivot table
  • Filter data by slicers
  • Analyse data with PivotCharts
Inserting graphics
  • Insert and modify graphic objects
  • Layer and group graphic objects
  • Incorporate SmartArt
Enhancing workbooks
  • Customise workbooks
  • Manage themes
  • Create and use template
  • Protect files
  • Preparing a workbook for multiple audiences

METHODOLOGY OF TRAINING

The foundation of our training is anchored in activity-based experiential learning. This methodology takes into consideration different learning and communication styles, and more importantly language and cultural differences. It is through active participation that the adoption and application of theory is expedited.

Our training team pays careful attention to planning and designing effective instructional methods essential for the transfer of knowledge. It is the creative skill of our management trainers and consultants that reveal untapped skills of the delegates through:

    • Practical sessions
    • Individual and syndicate activities
    • Individual and group tasks
    • Case studies
    • Role plays
    • Audio and video evaluation
    • Action planning
    • Experiential learning games
    • Presentations
    • Assessments

 

Recent Post

callback request

Your Name

Contact Number

Company

Location

Email

How did you hear about us?


Abu Dhabi

P.O. Box 44705, Abu Dhabi,
United Arab Emirates
Phone: +971 2 6740340
Fax: +971 2 6743554

Tax Registration Number:
100003031000003
for VAT purposes, only in the UAE

Dubai

P.O. Box 334058, Dubai,
United Arab Emirates
Phone: +971 4 2566414
Fax: +971 4 2566424

Tax Registration Number:
100003031000003
for VAT purposes, only in the UAE