Data Analysis with Excel

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:  
Dublin, Professional Training, Dublin
Start date & time:  
28 November 2019 09:30
End date & time:  
28 November 2019 17:00
Price: €468.75  (€375.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
12.00
CPD hours:  
7.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend

This course is aimed at accountants 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 CAI 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

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