- Location: Acist Skillnet, Grand View House, Ennistymon Road, Lahinch, Co. Clare.
- Duration: 2 Days
Course details
This course is designed to give users more advance commands and functions and how to apply these in their own working environments.
Course Content:
- Functions
- countifs/sumifs/averageifs/choose/match/index
- Advanced data validation
- Custom lists
- Subtotals
- Data clean up tools
- Pivot Tables
- More Macros
Learning Outcomes:
- Have an advance knowledge of excel.
- Know how to use Macros.
- Learn how to do pivot table
- Learn how to use the following functions - countifs/sumifs/averageifs/choose/match/index
Course Requirements:
- Intermediate level of excel
Course Location
About ACIST Skillnet
ACIST Skillnet provides subsidised training to private sector companies based mainly but not limited to the Mid-Theyst Region of Ireland. This Skillnets network was founded in 2006 and has trained over 5000 people in a range of disciplines but particularly focussing on the Tourism sector. They provide off the shelf courses to companies and also develop training specifically designed for business needs. Training is provided for all levels of employees.
ACIST Skillnet is funded by member companies and the Training Networks Programme, an initiative of Skillnets Ltd. Funded from the National Training Fund through the Department of Education, Training and Skills. Skillnets funds and facilitates training through over 80 networks of private sector companies, in a range of sectors and regions.
See all ACIST Skillnet courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Certificate in Microsoft Office 2016 Essential Global EdulinkEUR 57Duration: Upto 25 Months
- EUR 105Duration: Upto 80 Hours
