Excel Intermediate

Summary

This course focuses on the core skills that members need to be effective in using MS Excel.  The concentration is on real-time reporting, Charts,  Pivot tables, Data Tools and key Functions to make Excel work productively for you.

Venue details:  
Dublin, Professional Training, Unit 22 Westland Square, Pearse Street, Dublin
Start date & time:  
03 December 2019 09:30
End date & time:  
03 December 2019 17:00
Price: €300.00  (€240.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
9.00
CPD hours:  
7.00
Speaker details
First nameLast name
Damien O'Neill

Description

Product type:  
CPD course
Category:  
Information technology

Who Should Attend?

This course is for experienced MS Excel users who have completed a foundation course or have a similar level of knowledge.

Course Overview

This course will cover the following topics:

  • New features - Flash fill, Quick Analysis & Tell me About
  • Working with Charts
  • Working with Functions and Formulas
  • New functions - Ifs, Switch, TextJoin, ConCat
  • Advanced Formatting - Conditional Formatting & Data Validation
  • Pivot Tables – Manipulating Data, Pivot Charts & Slicers
  • Get and Transform Data
  • Power Query basics

Key Outcomes

By the end of this course, participants will be able to:

  • Identify new charts to communicate the key message
  • Use a variety of functions to analyse business data
  • Sort and Filter Data in predefined Tables
  • Use data validation to control data entry
  • Use the key functions of Pivot tables
  • Use Get and Transform Data to clean and prepare data

Speaker Bio

Professional Training is a group of experienced specialists providing focused training in IT and Management skills. Our trainers use a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation by our course participants. We have delivered a range of CPD programmes with Chartered Accountants Ireland since 1997. Website: www.professional.ie