Course Name: Excel for the Screen Sector - ADVANCED
Date the course commences: June 8th & 9th
Duration: 2 evenings (3 hours each), 6:30pm- 9:30pm.
Cost: Free
Venue Location: Online
Tutor: Carmel Murray
Course Profile:
Course Goal:
This Excel Advanced course is to aid the user get a better understanding of the capabilities of excel. It is a practical hands-on course.
Course Content:
- Absolute Cell referencing using mixed absolutes
- Conditional formatting using absolute cell references
- Named Ranges
- Data Validation
- If statements/If and or/Nested ifs
- Sumif/Countif/Averagif
- Subtotal used with databases
- Advanced Filtering
- Linking sheets
- Pivot Tables and dashboards
This course will run over two evenings
This online course run by the National Talent Academies: Film & TV Crew Academy East will aid the user get a better understanding of the capabilities of Excel and support them in setting up a departmental budget and the tools to maintain it.
This course is part of our Advanced Software Skills Program for Experienced Screen Crew but may also be done as a standalone course.
*Please note these dates are for Advanced only we are also running Beginners and Intermediate courses that are advertised separately.
Film & TV Crew Academy East is managed by Clermont Enterprise Hub CLG.
Participant Profile:
This course will be aimed at crew working in the live-action Film & TV industry who need to create and maintain Excel spreadsheets for their departments. You should have some knowledge of Excel and be seeking to improve on the knowledge you have.
The course is limited to 10 participants.
Application Procedure:
Please apply online at this LINK by 12pm May 25th.
For technical difficulties with the online system please email brian.murphy@nationaltalentacademies.ie
Selection on courses/programmes will be based on quality of application and industry experience relevant to the course and participant profile. We do not accept CVs so please make sure you outline all relevant experience in the application form.
Film & TV Crew Academy East courses are open to all regardless of gender, race, religion, sexual orientation or disability.
Reasonable accommodations: We aim to accommodate all attendees to help ensure they can successfully participate in our programmes. Reasonable accommodations are adjustments or modifications we can make to help those with disabilities participate fully in our training events.
Tutor/Company Profile:
Carmel Murray Consultancy is a privately owned company with over 20 years’ experience in developing and implementing quality solutions for our client and providing IT consulting services including project management and training
Carmel Murray Carmel’s courses are practical and are exercise led so the student gets hands on experience with Excel. Consultancy assists companies by developing and implementing software solutions which allow them to efficiently manage the information required to run their business.
Carmel Murray has 20 years’ experience in computer training in various industries.
Carmel Murray (B.A. H.Dip. Grad. Dip Computing, Microsoft Professional.) has been running IT courses for many years as a private consultant and then as a member of the Carmel Murray Consultancy. She has designed many courses to suit different industries.
Carmel also develops solutions for clients in Microsoft Excel and Microsoft Access.
Subscribe to our newsletter
This newsletter will keep you up to date with courses, activities, programmes, events, news, and resources related to the Irish screen sector from crew, film, and television to animation and VFX.
Subscribe