The mission is to raise funds for The Big C, Norwich
Bond Themed Casino Evening, come dressed as your favorite Bond character
Buffet
Music from Trumpet DJ, dance the night away until 1 a.m.
Enjoy an evening of fun packed casino games, music, food and good company, plenty of prizes to be won on the night including a Samsung LED TV. To start you off you will get £25 worth of fun casino chips absolutelyFREE.
Numbers are limited so please book early to avoid disappointment
This course develops many of the features of Microsoft Excel. We will look at the most useful elements, including formulas and functions, using Excel as a database and sharing text and data with other applications. Everything will be explained in straightforward terms. It is also an opportunity to iron out any bad habits that you may have picked up.
Delegates are expected to have a reasonable knowledge of basic Excel.
Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available. .
Lunch provided: Lunch and refreshments will be provided throughout the day.
Course Content
Review
Brief review of general Excel principles:
Arithmetic formulas
Looking at +, -, * & /
Brackets
BODMAS
Advanced AutoSum
Unusual ranges
Auto-Average/Max/Min/Count
AutoFill
Building Functions
Using the Paste Function dialog
Basic functions
Functions with one argument:
Statistical functions
Absolutes
When/how to use absolute references
Formulas and Functions between Sheets and Workbooks
For most owners, selling their business represents a once-in-a-lifetime opportunity to realise the value of a lifetime’s work.
The Government estimates* that around 100,000 otherwise viable businesses close each year simply because no-one wants to take them on. With the average age of small business owners steadily increasing succession failure is a growing issue.
Join us for a wide-ranging discussion that will include:
Who will buy my business? Building a business someone will want
Maximising sale value
Business valuation techniques
Tax efficient extraction
Funding options and deal structures
The session will be introduced byRichard Ross. We are delighted to be joined byIan NelsonfromLarking Gowen’s Corporate Finance Team andMartin SimonsfromHSBCCorporate Banking.
The Masterclass will last around two hours with questions and be of interest to business owners looking to sell or acquire another firm and their advisers.
Wednesday May 18th 2016
The Enterprise Centre, University of East Anglia, Norwich Research Park, Norwich, NR4 7TJ
8.15 for 8.30 & 12.15 for 12.30
Refeshments will be provided. There is no charge for the masterclass but you may like to consider a donation of £20 to Action for Children.
Hopefully as we approach the summer months you and your staff will be thinking about things to do with your family.
At the Zoological Society of East Anglia, we operate two Zoological Parks – Banham Zoo and Africa Alive! These two parks receive 350,000 visitors a year, we are amongst the most popular attractions in our region.
But we aren’t just top rated visitor attractions. We are also a serious charity with an international reach. In our parks and around the world we support ground breaking wildlife conservation efforts.
From breeding critically endangered animals to influencing the Mongolian parliament to create reserves for Snow Leopards, the money that we raise from charitable giving really does make all the difference.
There are many ways that local businesses can support our cause, including through corporate memberships, which start at just £250. We don’t expect something for nothing and so offer benefits depending on packages. Including discounted access for your staff to our parks, PR opportunities and networking events. Our existing partners describe this as an excellent staff benefit, building morale and adding that little extra to reward hard working staff.
Our special corporate evening will be taking place on Friday 3rd June from 5pm through to 7.30pm. This evening will include a tour of the Zoo site, as well as several talks from leading ZSEA experts. Refreshments, including a light buffet will be available for visitors. You are welcome to come along with a guest (big or small, just so long as they are human!)as company.
To book your place or to find out more about our corporate packages – please contact us by either emailing [email protected] or calling us on 01953 715371.
Please arrive 15 minutes before the session starts at 08.30am.
Venue:Norfolk Chamber of Commerce, 9 Norwich Business Park, Whiting Road, Norwich, NR4 6DJ In this session (Be Better at Change Management) Emma Bishop,Optem Limitedwill be your host.You will learn: Change is constant in business due to internal and external pressures. Successful change is about taking people with you. So why do so many change programmes fail? Research shows that up to 70% of them fail. This is down to a number of reasons, but the recurring ones from the copious amounts of research show that communication, unclear vision and under estimating emotions are fundamental areas that need to be taken into account during the planning stage, before anything is implemented.Emma Bishop of Optem Limited will take you through the steps of managing those all important changes in the right way. After all, if you fail to plan, you plan to fail. About Emma:
Emma is the Director of Optem a professional Services Organisation and the Chair of WEN.She has been a Strategic and Operational Senior Manager and Leader in both the Public and Private Sector for over 10 years. Emma has successfully delivered multi-million operations, projects and services across the oil & gas and renewables industries,leading cultural changes, transitions, tenders, client integrations,organisational restructures and substantial commercial savings.With a commercially focused and target driven approach to delivery.Emma has ensures the needs of her clients are balanced with the risks and costs of actions and that change is managed in a structured manner to ensure a smooth and effective transition for all involved.
This session forms part of The Chamber Sessions. The Chamber Sessions are open to Chamber Members only. They are free to attend but booking is required and places limited to one per company per session.
Bookings for this session are now close, forAvailability please email [email protected]. Thank you.
Course Title; Level 3 Award in Allergen Management for Caterers
Aim; This qualification provides those who work within Catering businesses with the appropriate knowledge relating to the control of food ingredients and understanding of the process for ensuring that accurate ingredient information is available.
Objectives;
– To understand the different roles in ensuring that food ingredients and allergens are effectively managed
– To understand the characteristics of food allergies and food intolerances
– To understand procedures relating to the accurate communication of ingredient information, from supplier to consumer
– To understand hygiene considerations with regard to allergen and ingredient control
– To understand procedures relating to the control of contamination and cross contamination of allergenic ingredients
Organisation
Duration; 1 day course
Exam/Assessment; There is no formal assessment for this course – A course book is completed which is marked by your tutor
Cost; £185+VAT includes, notes, refreshments, lunch & the assessment
Awarding Body; Highfield Awarding Body for Compliance (HABC)
Tutor; Sarah Daniels
Differentiation; Recommended understanding and knowledge of basic food hygiene – ideally the CIEH Level 2 Award in Food Safety taken within the last three years.
Audience; Those who are responsible for the purchase, delivery, production and serving food in the catering industry. The qualification is also suitable for Catering Business owners
For more information please do not hesitate to contact us on 01603 473732
This course has been designed to ensure that all employees are aware of their own safety and the safety of customers, contractors and the public. It is applicable in any workplace and the training can be adapted to meet specific needs.
This course enables attendees to understand the principles of Health and Safety, contribute to any Health and Safety Management system, develop an understanding of the responsibilities placed on employers and employees, develop an understanding of hazard, risk and the main causes of harm to workers, acknowledge the importance of following systems, procedures and rules and understand how individual action can reduce risks to health and safety
Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available.
Lunch provided: Lunch and refreshments will be provided throughout the day.
Please note that it is a requirement of the HABC, the awarding body, that we need to see photographic proof of identity of each candidate before they can be entered into the exam, for example, passport, driving licence, student union card or work pass.
Course Content
Legislation
Health
Safety
Welfare
The workplace and workplace equipment
Risk assessment
Manual Handling
Hazardous substances
Ergonomics and work station design
Transport and vehicles
Noise and vibration
Subject to passing a 20 question multiple choice exam paper delegates will gain the HIGHFIELD AWARDING BODY FOR COMPLIANCE Level 2 Award in Health and Safety in the Workplace. It is recommended that this qualification is refreshed every 3 years.
You will be given a HABC Health and Safety manual to take away and keep after the course for future reference.
Course costs range from £91.80 – £102.60 per person. For more details please contact us at [email protected] or on 01603 788950.
The course is designed for users new to Excel. It will provide trainees with the confidence, knowledge and practical experience to use Excel, to create and manipulate spreadsheets and produce printed reports.
Delegates should have sufficient Windows experience beforehand.
Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available. .
Lunch provided: Lunch and refreshments will be provided throughout the day.
Course Content
The Excel Screen
Ribbons, Quick Access Toolbar, Formula Bar, and Status Bar
Workbooks and Sheet Tabs
Data Entry
Types of Data
Data Entry Techniques
In Cell Editing
Selecting
Cut/Copy/Paste
Drag & Drop
Using AutoFill to fill Adjacent Cells and Extend Series, Custom Lists
Location: Carrowbreck House, 300 Drayton High Road, Norwich, NR6 5BJ.
This course develops many of the most useful aspects of Excel such as formulas and functions, list management, and more advanced features including Pivot Tables and summarising data across multiple sheets or books. Trainees will have completed the introduction course or have a similar knowledge and experience of using Excel in the workplace.
Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available.
Lunch provided: For full day training courses a lunch with sandwich or salad, crisps and cake or fruit will be provided. Refreshments will be available throughout the duration of this course.
Course Content Review Brief review of general Excel principles: Formulas, Functions, Absolutes, Formatting, AutoFill Functions Using Paste Function The IF Function Nested IF Functions The VLOOKUP Function Nesting other Functions Linking Multiple Sheets and Workbooks Summarising data from multiple sheets Working with 3D Formulae Linking workbooks Workspaces List Management (Databases) Sorting Subtotals Filtering Good Working Practice Pivot Tables Creating pivot tables with the Pivot Table Wizard Formatting pivot tables Manipulating pivot tables Graphs/Charts Creating a graph/chart Formatting a graph/chart Changing and editing your graph/chart Using the Chart Wizard Incorporating a chart into a Spreadsheet Macros Recording a simple macro Assigning a macro to toolbar buttons An explanation of different versions How to find familiar commands in the 2003 & 2007/10 interface
Course price: From £72.00
For more details or any enquiries, please do contact us on 01603 788950, or email [email protected]
You can download a factsheet from this page for course details, but here’s a summary;
Who is this qualification for?
This qualification is aimed at workers in the food industry, such as;
· supervisors, team leaders and QA staff, or
· business owners/managers of smaller businesses,
who are involved in verification of food safety through auditing and inspection.
Although contextualised in food safety, the skills are generic and can be applied to many other business sectors
Learning Outcomes:
Understanding the purpose, function and difference between of auditing and inspection, and appreciating the benefits and limitations
Understand the competencies and characteristics required of auditors
Outline the stages of, and understand the need for a planned approach to auditing
Outline a variety of methods for collecting data
Improve your ability to analysis, interpret and verify data
People skills; improve your ability to get the right information
Consider the preparation of written reports
How Is The Course Delivered?
Delegates will participate in two live “Zoom” sessions, interspersed with a series of self-directed (but supervised) “blended learning” activities and case studies. You will still engage with RedCat’s usual blend of engaging and interactive training methods.
How is the Course Assessed?
For the assessment, delegates will Delegates will need to complete a 30-question, multiple choice test on their own PC. Pass mark is 18 marks, distinction is 24 marks. Delegates require a reasonable internet connection, an isolated space with NO disruptions, a PC with webcam (the invigilator will be watching) and a Smart Phone (so you can video your surroundings and proof of identity).
How Do I Book?
We’ve uploaded a booking form for you, or you can contact us directly on 01603 473732, or through [email protected]
This course is for anyone who would like to improve their minute or note-taking skills. The different types of minutes are covered and the approach is a practical one, with participants given help and support to develop their summarising and writing skills. The workshop also aims to extend understanding of the requirements for different kinds of meetings, and to give a necessary appreciation.
Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available.
Lunch provided: For full day training courses a lunch with sandwich or salad, crisps and cake or fruit will be provided. Refreshments will be available throughout the duration of this course.
Course Content Prepare Agenda’s for meetings Understand your role before, during and after meetings Understand the role and responsibilities of the Chairperson Different Meeting styles Different Agenda styles Different Minutes styles Record notes and produce good quality minutes
Course price: From £72.00
For more information please call us on 01603 788950, or email [email protected]