-
Excel Advanced Level
The purpose of this two half-day course is the teach delegates some of the advanced features of Excel.Working with Pivot Tables, Using What If Analysis Tools, Auditing tools and Writing Macros are all covered in this module. Extensive hands-on classroom training is provided throughout. Pre-Requisites Delegates should be proficient in essential excel skills before starting this module- See Excel Introduction & Intermediate. Versions ; This course is available for Excel 2010, 2013,2016, & 365 Contents · Create a PivotTable · Create a PivotChart · Create a Macro · Use Goal Seek · Use Scenarios · Use Solver · Audit Worksheets · Protect Worksheets and Workbooks · Use Consolidation · Apply Conditional Formatting · Apply Data Validation · Import and Export information
Customs Clearance Upskilling Programme
Over the past number of months we have noted the interest of our member companies in a Customs Clearance upskilling programme. This programme is for all employees, those who have recently joined, or have been internally promoted to the role of Customs Clearance personnel. We aim to give the participants an overview of current arrangements plus to assist them through our Q&A sessions to address particular obstacles that may have appeared. Course Profile: On the 1st of January 2021 the UK exited the Brexit transition period and left the EU Customs Union and Single Market. For companies importing or exporting goods on the Island of Ireland this meant the introduction of a new set of rules for business to contend with in order to get goods across border. The first few months have been a baptism of fire for many business trading goods with and through the UK with many experiencing difficulties.
Introduction to Excel
The purpose of this one day is course is the teach delegates the essential features of Excel . Accessing worksheets, entering data, core functions Referencing cells, formatting worksheets, headers & footers and printing are all covered. Extensive hands-on classroom training is provided throughout. Versions ; This course is available for Excel 2010, 2013, 2016, 365
Skillnet: How to "Present like a Pro"
This one-day interactive workshop looks at presentation as primarily a performance activity. The workshop is very practical and provides participants with a toolkit of skills and practices to enhance the effectiveness of any presentation. The workshop draws on the knowledge and experiences of performers, actors, writers and successful presenters in a bid to show that anyone can be a compelling presenter with the right preparation and attitude.
Excel - Intermediate Level
Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and functions, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs and small lists. The Intermediate Excel 2013 / 2016 training course is ideal for those with a working knowledge of Microsoft Excel and demonstrates how to work more efficiently with workbooks and enhance the appearance of the data in the spreadsheets.
Time Management and Personal Effectiveness
The course aims to enable learners to better manage time in the context of personal effectiveness, making participants more aware of where they need to spend their time in order to be more effective, both in their working lives and in their personal lives. It also explores what inhibits good time management and personal effectiveness and what behaviors and competencies are required to improve.
Excel Advanced Level
The purpose of this two half-day course is the teach delegates some of the advanced features of Excel.Working with Pivot Tables, Using What If Analysis Tools, Auditing tools and Writing Macros are all covered in this module. Extensive hands-on classroom training is provided throughout. Pre-Requisites Delegates should be proficient in essential excel skills before starting this module- See Excel Introduction & Intermediate. Versions ; This course is available for Excel 2010, 2013,2016, & 365 Contents · Create a PivotTable · Create a PivotChart · Create a Macro · Use Goal Seek · Use Scenarios · Use Solver · Audit Worksheets · Protect Worksheets and Workbooks · Use Consolidation · Apply Conditional Formatting · Apply Data Validation · Import and Export information
Digital Marketing & Content Creation Training Programme
This training programme is for every individual or company who struggles to come up with frequent, interesting and engaging content for their social media channels. Its for those who sit down on a Monday morning to come up with posts and wait for inspiration to hit. Not only does this course provide great ideas for social media posting, it provides a step by step guide to a content creation process that is easy, stressfree and that works! The programme also covers step by step guidance on using Canva to design professional and engaging visual posts, and Vimeo for cost effective and impacful video development. Participants will also receive a number of useful interactive templates, including a social media planner that manages ongoing and consistent communication across all relevant platforms. Breakdown of Content per Workshop Workshop 1: Understanding the Context of Digital Communication ? Introduction to concepts and templates ? Introduction to what good and bad communication looks like ? Understanding the context of social media content ? Demonstration of how mind mapping delivers content ideas and longevity ? Step by step guidance on the content creating process ? Demonstration on how to analysis metrics on a monthly basis, thus providing an understand of which content works best for engagement levels Workshop 2: Creating Impactful Visual & Engaging Posts ? Guidance on the development of professional and creative posts ? A detailed overview of Canva with a step by step guide on graphic development ? Understanding of all elements of the Canva interface ? Guidance of using online image/video libraries ? Guidance on how to export Canva projects correctly ? Guidance on how to publish Canva projects on all relevant social media platforms ? A review of how to maximise exposure through boosting posts Workshop 3: Developing Professional Video Content ? An overview of the technical process of creating professional business videos ? All technical aspects of developing a corporate or marketing video ? The basics of how to capture sound and lighting for a professional look ? How to create, edit and distribute videos across all platforms One to One Mentoring Each participant will receive 3 hrs one to one mentoring. The primary focus of these sessions will be to help each participant understand content creation in the context of their own business and persona groups. A further goal of the mentoring will be to assist each company with the development of a usable and easy to manage weekly content plan. Finally, each participant will be given step by step support to enable them to design and develop their own visual and video content for all future posts.
Introduction to Excel
The purpose of this one day is course is the teach delegates the essential features of Excel . Accessing worksheets, entering data, core functions Referencing cells, formatting worksheets, headers & footers and printing are all covered. Extensive hands-on classroom training is provided throughout. Versions ; This course is available for Excel 2010, 2013, 2016, 365
Excel - Intermediate Level
Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and functions, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs and small lists. The Intermediate Excel 2013 / 2016 training course is ideal for those with a working knowledge of Microsoft Excel and demonstrates how to work more efficiently with workbooks and enhance the appearance of the data in the spreadsheets.
