Data Analysis with Excel

Registration is full.
Summary

This hands-on course will show experienced Excel users how to operate the package at a higher level and explore its more sophisticated analysis tools.

Venue details:  
, Professional Training, Unit 22 Westland Square, Pearse Street, Dublin
Start date & time:  
22 October 2020 09:30
End date & time:  
22 October 2020 17:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
12.00
CPD hours:  
7.00
Speaker details
First nameLast name
Damian O'Neill

Description

Product type:  
CPD course
Category:  
Technology and data

Who should attend

This course is aimed at accountants, and other business professionals, who have strong Excel skills and a good working knowledge of Powerpoint and Word. The minimum skills required would be to have attended, or have equivalent knowledge of, the Institute's CPD Intermediate and/or Advanced Excel courses. The course is not suitable for inexperienced Excel users.

Course overview

  • Data mining techniques in Excel
  • Arrays as a data splicing tool
  • Advanced Pivot Table operation in specific areas
  • Operation of Data Tables
  • Purpose and use of Standard Excel Add-ins
  • Report tools in Excel and best practice for them
  • Linking reports to other Office Media for best effect
  • Excel and Powerpoint interaction

Key learning outcomes

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

  • Use Excel to higher level of operation
  • Work more effectively with Excel's data tools
  • Produce more relevant and succinct reports