Microsoft® Excel – Intermediate

QUICK PAY

Debit Card/Credit Card

SEND AN INQUIRY

Talk to our team!

Overview

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

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
  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Tags:

Date

09 Jun 2021 - 10 Jun 2021

Time

9:00 am - 3:00 pm

Cost

AED3,600.00
Abu Dhabi

Location

Abu Dhabi
QR Code

Select Training and Management Consultancy L.L.C. copyright 2020

 

Setup Menus in Admin Panel

en_USEnglish
X