Event

So you’ve just attended our Excel Introduction course or have used Excel before and want to gain a bit more knowledge and confidence to create your own spreadsheets and adapt those created by others. The course starts with a revision exercise to get into the swing of calculations and provides a great opportunity to ask questions and fill in any gaps in your knowledge of the basics. We will then cover everything you need to know in order to manage lists of information, expand your knowledge of functions to produce summary calculations and visualise these with conditional formatting and charts. Tips, tricks and shortcuts are covered throughout the course to keep your Excel working day as efficient as possible.   You will learn:

• How to work with dates and times – Calculate age or stock date expiry warnings
• ​Build in logic with the IF function – Monitoring stock levels to display re-order information
• Conditional formatting – Automatically highlight relevant information, e.g. stock that needs re-ordering
• ​Absolute cell addressing – Lock cell references with dollar signs and learn why you would use this
• Database features – Sort, filter and sub-total lists of stock by category
• Calculations across multiple sheets – ​Store data with a sheet per month and create an annual summary
• ​Charting – Create a graphical representation of summary data for use in meetings

Would you like to know how to use Twitter effectively for your business and gain ideas for content?

Make sure you and your business is up to speed by attending our nextinteractive, half-day Twitter workshop onThursday 24th Septemberand discover how Twitter canboostyour profile in 2015.

Designed for a maximum of five people, the morning will bepacked full of usefultipsfor increasing your audience andcreatingengaging content.

With the training tailoredfor the businesses attending, there will be lots ofopportunitiesto shareideasand test out Twitter for yourself – leaving you ready and raring to go!

What will our workshop cover?

• Getting started: How to use Twitter – practical tips and the ‘lingo!’
• Creating your brand personality.
• Join in with the conversation. But with who?
• What do I post? Lots of handy content suggestions.
• How your competitors are using Twitter.
• Top tips to get the most from this tool.
• Five ways to build your following.
• Twitter etiquette: Do’s and Don’ts.

And of course we will supply mandatory tea, coffee and biscuits!

We’vehad some great feedback from past delegates.

“The interaction around the table is relaxed and it’s a friendly environment,”Barnham Broom.

“Really enjoyed feedback on current practice and research into competitors,”R A Brown.

“Friendly. Learnt lots,”The Cottage Hair and Beauty Salon.

Our next half-day workshop is being held onThursday September 24th 2015.

Arrive:09:15am for training to take place between 09:30am – 12:30pm.

Where: Suite 3, The Old Church, St Matthews Road, Norwich, NR1 1SP.

Cost: £75 + VAT per person.

For more information or to bookemail daniella@reflectionpr.co.uk or call 01603 219191.

We are specialists in business and individual wellbeing. We provide onsite consultancy, training and development, counselling and employee assistance.

Courses in mental health and wellbeing are available throughout the year.

Our training is delivered by qualified trainers and experts in mental health.

All courses take place at Sale Road in Norwich, and include refreshments and lunch.

All our courses are one-day courses, run from 09.30 until 15.30 and include a certificate for each attendee. Our one-day courses cost £115 per candidate.

For full descriptions of training course content and information about who should attend, see our website www.norwichmind.org.uk

If you want us to run a group training session at our site or at yours, get in touch for preferential rates.

WellBusiness Team

01603 432457

The APM Project Fundamentals Qualification (PFQ) course is based on the APMP Body of Knowledge 6th edition – a concise and structured guide to the knowledge required in managing projects. It provides a solid introduction to the key issues involved in managing projects and explores core project management tools, techniques and terminology.  This course is also suitable for anyone looking to achieve a nationally recognised, entry – level qualification in the discipline of project management. All our courses are delivered by highly experienced and approved trainers with many years experience in the delivery of APM courses and the implementation of the methodology into organisations.  Around 10 hours preparation is required prior to attending the course. The pre-read material will be sent to you after your booking has been confirmed.  This course will also require evening study (approx 1-2 hours per evening).

Location: Carrowbreck House, 7 Carrowbreck Road, Norwich, NR6 5FA. Are you struggling with Linkedin? Not quite sure what the fuss is about? Wondering whether you should spend even more time on yet another networking platform? It’s ok, you’re one of many, you may even be one of the many who set up an account but then didn’t go back to it. Linkedin is a business tool which helps you to do even more business. Having just hit 200million users, 1 million groups, 40 million visits a week and a total of 5.3billion searches during 2012, you can’t ignore it. Did you know that half of the users on Linkedin are the main decision makers? Did you know that Linkedin drives the most customers for B2B organisations – even more than Blogs? Tapping properly into Linkedin will enable you to drive valuable customers to your website. Tapping properly into Linkedin will position yourself as a leader in your niche and gain you new clients. Stop missing out on opportunities now! This course is for you if you are a SME, Business Development Manager, Sales manager, Marketing Manager, whichever industry you’re in, and you are keen to utilise LinkedIn for your business to drive traffic and get results. Duration: Half-day course (9.30am – 12.30pm) Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available. Lunch provided: Light refreshments will be provided. Lunch only provided on full-day courses. Course Content: How to achieve maximum exposure and connect with main decision makers The power of groups and company pages How LinkedIn works with or without a budget How LinkedIn is the perfect marketing tool & discover the ways to use it in your business Course price: From £38.50 – £49.50 For more details or any enquiries, please do contact us on 01603 788950, or email carrowbreck@broadland.gov.uk

What will I learn?

Our MHFA ArmedForces Communitycourse is split up into 4 manageable chunks. These are:

• What is mental health, andwhymhfa for armed forces community?
• Suicide and depression
• Psychosis
• Anxiety and post traumatic stress disorder

In each sectionyou willlearn how to:

• Spot the early signs of a mental health problem
• Feel confident helping someone experiencing a mental health problem
• Provide help on a first aid basis
• Help prevent someone from hurting themselves or others
• Help stop a mental illness from getting worse
• Help someone recover faster
• Guide someone towards the right support
• Reduce the stigma of mental health problems

These topics have been specifically tailored to the armed forces community and their culture.

How will I learn?

The MHFA for the Armed Forces Community courseusually takes place over2 full days.

The sessions will be a mix of presentation, group discussions and group work activities.Our instructors provide a very safe learning environment and are trained to support you throughout the whole course. If you don’t feel comfortable joining in certain bits, then don’t, we won’t make you do something you aren’t comfortable with.

You’ll receive a MHFAArmed Forces Communitymanual that you can take away with you at the end of the courseandalso an attendance certificate from MHFA England to say you are now Armed Forces Community Mental Health First Aider.

Who canattendthe course?

Places on the MHFA for the Armed Forces Community courses areonly open to specific groups of people.Places are restricted to members of the following target groups:

• Veterans
• Serving personnel
• Family member of Serving or ex-Service personnel
• Health and Social Care working with the Armed Forces Community
• Charitable organisation working with the Armed Forces Community

How do I book on a course and what is the cost?

It costs £50per candidate.

If you wish tobook onto the course please emailwelladmin@norwichmind.org.ukor phone 01603 432457

This half day course is for all employees in the Food and Hospitality sector and is aimed at any current holders of the Level 2 Award in Food Safety to refresh & update their knowledge on the subject.

*Take personal responsibility for food safety procedures *Keep themselves clean and hygienic *Receive and store food safely * Prepare, cook and hold food safely *Assessing and evaluating the learning

The subjects covered are:

1. Food safety hazards; what can harm the consumer? 2. Safe food storage; food handling & cross contamination 3. Temperature control; refrigeration and chilling 4. Cooking, hot holding and reheating 5. Cleaning and disinfection 6. Pest control 7. Food premises and equipment 8. Legislation

Prerequisites: None-just enthusiasm (but basic spoken English/ literacy does help)

Duration: Half day training programme (09:00-13:00)

Cost: £55 +VAT includes examination fees.

Course Tutor: Course Tutors: Sarah Daniels & Richard Mills are both Chartered Environmental Health Practitioners, having spent over 25 years each in the profession.

The RedCat Partnership has been providing food safety training & consultancy in Norfolk, East Anglia & nationally for over 20 years.

For more information about this course please contact us on 01603 473732 or reception@redcatpartnership.co.uk

Location: Carrowbreck House, 7 Carrowbreck Road, Norwich, NR6 5FA This course is designed for users to enable them to become competent database-developers. As a result of this course, users can expect to be able to design and create tables to store their data and to specify what data is appropriate, as well as choosing how each table should be linked to the others in the database. As well as the basics, it will look in more depth at relationships, and focus on more advanced queries, allowing the user to create a more complete business or personal database. Additionally, they will have learnt how to extract the required data using a combination of queries and filtering. We will also look at Access Forms and Reports to enable users to print, read and enter their data in a user-friendly format. Delegates should have sufficient Windows experience beforehand and by the end of the course you will be more comfortable in designing and implementing a finished relational database. Duration: One-day course (9:30am – 4:00pm approximately) 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 Introduction to database concepts Tables Forms Querying data Relationships overviews Creating reports Course price: From £77.00 – £99.00 For more details or any enquiries, please do contact us on 01603 788950, or email carrowbreck@broadland.gov.uk

Join us this month on our IOSH Managing Safely course and bring great health and safety practices to your business. Aimed at supervisors and managers, the three-day course will give you the confidence to manage health and safety in your workplace. Our experienced advisers will deliver a course that is relevant to all industries, focusing on the core principles of risk management.

Topics covered include:

• Introducing managing safely
• Understanding your responsibilities
• Identifying hazards
• Assessing risks
• Controlling risks
• Investigating accidents and incidents
• Measuring performance.

On completion, you will receive an accredited IOSH Managing Safely certificate, an internationally recognised qualification that shows your staff and customers that your business is committed to good health and safety practices.  Our next IOSH Managing Safely course is running on the 26th to 28th November at our Norwich office. The course fee is £450.00+VAT. Parking, lunch, refreshments, course materials and certificates are all included.  Call our risk management team on 01603 967900 or email them at RiskManagement@alanboswell.com to book your place.

An Introduction to Getting it Right for Your Business

Customers receive information from a range of marketing channels. The Marketing Channels workshop will help delegates define who their customers are, develop clear marketing messages and identify the most effective marketing channels to reach them.

This will include highlighting key points to help develop these channels successfully and a clear plan of action for delegates to develop.

Aimed at business leaders from established companies who wish to define, or re-define their marketing plans, the workshop will be rich in content, informative, interactive and practical.

• Key Outcomes Delegates will develop a clear understanding of: ·
• The definition of marketing – what it is ·
• Customer demographics ·
• How to establish a niche/unique selling point ·
• How to develop marketing messages ·
• A range of marketing channels and how to develop them effectively including: – website and SEO – social media (Linkedin, Facebook and Twitter) – PR – leaflets – face-to-face marketing including public speaking, attending exhibitions and meetings ·
• The key elements of an Action Plan
• Sources of further information

Who is it for?

This course, as with all the Scale-Up New Anglia and New Anglia Growth Hub events, is suited and intended for businesses already running and established. Ideally, those businesses who are looking to grow their customers and increase sales and loyalty.

Please refer to courses by NWES and MENTA for courses more suited for those businesses who are pre-start or have been trading for less than 12 months.

We have a fantastic Level 2 Award in Food Safety in Catering or Manufacturing course taking place this month at The Business Rooms at No.8 Thorpe Road in Norwich.

This qualification provides basic food safety and hygiene, why these are necessary and how to put these basic precautions in to place. This is the benchmark, entry level qualification for all food handlers.

Objectives;

*Understand the main Food safety hazards (what can harm the consumer?)

*How to safely store and handle food, to prevent contamination

*Understand the different chill temperature controls

*Understand the basic concepts of cooking, hot holding and reheating

*Define cleaning and disinfection, why it is such an important issue and how it is achieved.

*How to identify, prevent and control pests

*Understand the basic principles of the design and construction of food premises and equipment

*State key legal requirements

Organisation

Duration; This course is delivered over 1 day. It is a classroom session.

Exam/Assessment; 30 mark multiple choice exam: This is an Ofqual Accredited course.

Cost; £88+VAT includes, notes, refreshments, lunch and the assessment & certification fees.

Awarding Body; Chartered Institute of Environmental Health (CIEH) or Highfield Awarding Body for Compliance (HABC)

Tutor; Mitchell Vale

Differentiation; None-just enthusiasm

Audience; Anyone working in a catering, manufacturing or retail setting where food is prepared cooked or handled.

Customer Feedback; “Many thanks for presenting the Food Hygiene course on Tuesday. It was well received by all my staff; you put us all at ease & made it a really pleasant informative day. As predicted a few of us sang when washing hands & all were checking for things we had discussed.” Phil Bush, Catering Manager

For more information on this course click here

Scottow Enterprise Park