Microsoft Excel for Advance

Course date: Saturday 21 September 2024

Application deadline: Monday 19 August 2024, 0900

Microsoft Excel can be an excellent tool to make your work systems easier, quicker and more effective. This course is for film and television practitioners who have a basic understanding of Microsoft Excel, and would like to learn how to make further use of the software.

This advanced level, hand-on course will cover the navigation and operation of the Microsoft Excel software – participants will get to practice using these Excel features:

> Locking Worksheets

> Data Validation; Protection

> Consolidate Data

> Consolidate across Spreadsheets; Consolidate across workbooks; Group & Outline

> Customising Excel

> Customise the Quick Access Toolbar

> More Functions

> Absolute Recap; IF; Vlookup; Countif; IfAnd; Nested IF; Combo; Text Functions; Auditing Tools

Who is this course for?

This course is suitable for freelance film & TV practitioners who have a solid understanding of Microsoft Excel and would like to further develop their knowledge of the software.

Tutor:

This course will be delivered by Etopia Trianing

Eligibility:

This session is specifically for established film and television practitioners based in Scotland. Please only apply if you meet this criteria. BECTU opportunities for those in other areas of the UK can be found here: England, Wales.

> Applicants should be based and working freelance in film and television in Scotland.

> Students are not eligible for this training.

Selection:

> As this is a workshop style course, there are a limited number of spaces available to allow participants the opportunity to interact and ask questions.

> Priority for spaces will be given to eligible BECTU members.

> If more BECTU members apply than spaces available, places will be given to those who demonstrate the greatest professional need for this training.

> Places are provided free of charge but are worth a considerable amount. Please only apply if you can commit to attending the session.

> We have a travel fund to support anyone who may need help with travel costs.