EOI - Excel For The Screen Sector - Advanced

EXPRESSION OF INTEREST

Please note by registering your interest you are NOT applying for a course. This is to gauge the interest of crew in attending this type of course. We would also like to hear what elements you would like to see on the course so that we know the training is meeting crew needs as directly expressed by the crew.

Proposed Course: Excel for the Screen Sector - Advanced

Proposed month of delivery: June/July

Duration:  1 Day (6 hours) or 2 Evenings (3 hours each)

Cost: Free

Venue: Online

Tutor: Carmel Murray

Proposed Course Content:

This course would run over one day on a weekday or over two weekday evenings.

Functions

• Conditional Formatting using Absolute Cell References
• If statement (IF  and/or, - -     Nested ifs)      
• Using Named ranges in formulae
• Build the Vertical Lookup (Vlookup) function
• Build the Horizontal Lookup (Hlookup) function
• Error function ISError
• Text Functions –text manipulation

Database Features

• Creating Filers
• Extracting data

Database Functions

• Sumif
• Countif
• Averageif
• Pivot Tables

• Creating Advanced Pivot tables
• Slicers
• Creating Dashboards
• Protecting Spreadsheets

Data Validation

• Entering validation rules in cells
• Creating drop down lists
• Combining Data validation with Vlookup command

Creating Hyperlinks

Participant Profile:

These courses will be aimed at crew working in the live-action Film & TV industry who use Excel in their departments as a tool.  Participants should have an intermediate knowledge of Excel and hands-on experience.  Access to a computer/laptop, with Excel pre-loaded, with a camera, microphone/speakers and good broadband will be required. 

Expression of Interest Procedure:

Please register your interest online at this LINK by 12pm on Friday the 10th of May, 2024.

For technical difficulties with the online system please email crew.east@nationaltalentacademies.ie.

Film & TV Crew Academy East courses are open to all regardless of gender, race, religion, sexual orientation or disability.

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 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’s courses are practical and are exercise led so the student gets hands on experience with Excel.

Carmel also develops solutions for clients in Microsoft Excel and Microsoft Access