Excel For The Screen Sector

Excel For The Screen Sector

Course Name: Excel for the Screen Sector

Date the courses commences: Beginners May 5th & 6th / Intermediate May 18th & 19th

Duration: 2 evenings (3 hours each), 6:30pm- 9:30pm.

Cost: Free

Venue Location: Online

Tutor(s): Carmel Murray

Course Profile:

These courses will run over two evenings

This online course run by the National Talent Academies: Film & TV Crew Academy East will aid the user in getting 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 Software Skills Series, but may also be done as a standalone.

We will run this course at 2 levels, each applicant must pick just one level to apply for depending on your skill level as outlined below.

Film & TV Crew Academy East is managed by Clermont Screen Hub CLG.

Course Descriptions:

Beginners

To be eligible for the Beginners course, you do not need any previous knowledge of Excel, but should have basic Windows, keyboard and mouse skills.

Course Content:

  • Excel Overview
  • Navigating in Excel
  • Understanding workbooks, worksheets, rows, columns, cells
  • Toolbars/Ribbons
  • Entering data
  • Understanding the various mouse cursors
  • Moving and Copying between cells
  • Learning about calculations (Add, Subtract, Multiply, Divide)
  • Copying Formulae
  • Using AutoSum
  • Use the Fill Handle to copy data
  • Formatting text – fonts, colour, alignment
  • Adding borders and shading
  • Column width and row height
  • Merging cells
  • Using the format painter
  • Applying number formats
  • Using Auto format
  • Inserting and Hiding Columns and Rows
  • Insert, Delete and Hiding Rows & Columns
  • Insert, Delete and Move Cells
  • Formatting of Cells with Number formats, Font formats, Alignment, Borders, colours
  • Headers and Footers
  • Page Margins& Orientation
  • Print ranges
  • Creating Charts using the wizard
  • Using Multiple sheets

Intermediate

To be eligible for the Intermediate course learners must be able to do the following:

  • Create simple formulas such as add, subtract, multiply, and divide.
  • Copy formulas.
  • Be comfortable in the Excel environment (moving between sheets, inserting rows and columns).

Course Content:

  • Review of basic formulas
  • Copying formulas
  • Format Painter
  • Conditional formatting
  • Charts
  • Fixing cells
  • Basic If statements
  • Sum/Average/Max/Min
  • Multiple sheets
  • Multiple Files
  • Validation
  • Database feature- Filtering, Subtotalling, Basic Pivot Tables
  • Hyperlinks
  • Example will be included and we will cover Budget exercises to allow the participant to ask questions and revise.
Participant Profile:

This course is aimed at crew working in the live-action Film & TV industry who need to create and maintain Excel spreadsheets for their departments.  

Each course is limited to 10 participants

Application Procedure:

Please apply online at this LINK by 12pm, Monday 13th April.

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 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