Learning & Development

Home / Learning & Development / Intermediate Excel Training- 30th May 2019- Dublin
Intermediate Excel Training- 30th May 2019- Dublin

Intermediate Excel Training- 30th May 2019- Dublin

Aim

The aim of this course is to develop a good working knowledge of Excel to include features such as functions and formulae, sorting and filtering data, working with charts and pivot tables. This course is aimed at users who have basic experience with Excel and want to build on their current knowledge to set up their own spreadsheets and manipulate existing ones.

Course Content

  • Review Concepts
  • New Features
  • Naming Cell Ranges
  • Linking Sheets and Files
  • Logical Functions
  • Applying and Managing Conditional Formatting
  • Lookup Functions
  • Database \ List Management
  • Formula Auditing Formula View
  • Charts/Graphs Advanced Techniques
  • Pivot Tables
  • Protection
  • For in-depth course outline, contact skillnet@isme.ie

Learning Objectives

  • After completing the workshop, each participant will be able to:
    • Gain knowledge of new Excel features
    • Learn how to name cell ranges
    • Learn to link sheets and files
    • Understand how to use logical functions
    • Apply and manage conditional formatting
    • Learn how to use lookup functions
    • Understand different database\ list management features
    • Understand/learn how to use formula auditing and formula view
    • Be able to use charts\graphs and other advanced Excel techniques
    • Understand how to use create\use pivot tables
    • Learn to use IRM for file protection

Methodology

  • The course will be presented as a workshop with interactive individual exercises throughout
  • Course attendees will be required to bring along their laptops
  • A pre-course questionnaire will also be provided to determine attendee’s competency level with Microsoft Applications

Target Audience

This course is aimed at users who have basic experience with Excel and want to build on their current knowledge to set up their own spreadsheets and manipulate existing ones.

Dates and Venues

  • 30th May 2019; 9:30am – 5:00pm. ISME, Dublin 2.

Fee

One day course: €230 ISME Members, €325 Non Members

Booking Essential

Members please log in to avail of your discount

230

ISME Skillnet