Content

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

Managing safely is aimed at managers and supervisors in any sector, and any organisation. It’s designed to get managers up to speed on the practical actions they need to take to handle health and safety in their teams. Importantly, Managing Safely makes a powerful case for health and safety being an integral part of day-to-day management and business This course:

• Is a nationally recognised and respected certificate training for managers and supervisors
• Is designed and quality-controlled by IOSH, the Chartered body for health and safety
• Covers two key areas – health and safety plus environmental basics

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

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 [email protected] or call 01603 219191.

Aims to provide delegates with the required level of training, skills and knowledge in First Aid, and comply with the requirements of the Health and Safety (First Aid) Regulations 1981.

Suitable For

Successful delegates will be awarded a certificate of competence accredited by Qualsafe Awards who are recognised by Ofqual. It is valid for three years.

Course Venue

Open courses are held regularly at our training venues in Norwich, Norfolk and Cambridge, Cambridgeshire. Alternatively, courses can be arranged at your own site anywhere in the UK (subject to suitability).

Syllabus

• Introduction to first aid
• Incident management and safety
• The unconscious patient
• Major illness: diabetes, heart attack, stroke
• Fractures and dislocations
• Head Injuries
• Eye Injuries
• Simple record keeping & first aid equipment
• The legal framework for first and in the workplace
• Basic life support
• Use of AED
• Control of bleeding and shock
• Major Illness: epilepsy, allergic reactions
• Burns and scolds
• Poisons and harmful substances
• Basic casualty handling
• Knowledge and skills assessments

“Good course with refreshing content. Great value for money.”

“The use of video clips really helped. The course was a good pace and the content was made interesting. It’s the most enjoyable First Aid course I have attended in 20 years.”

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 [email protected]

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 [email protected]

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 email[email protected]or phone 01603 432457

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 [email protected] to book your place.

Scottow Enterprise Park

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 [email protected]

Location: Carrowbreck House, 7 Carrowbreck House, Norwich, NR6 5FA. The day is split into 2 half-day sessions. Part 1: Get introduced to the many ways your website can climb the search ranks & learn the fundamental principles of ‘search’ along the way in this half-day course. We’ll explain the importance of ‘keywords’; describe what your ‘quality score’ is, how it’s calculated and ways you can improve it. We’ll take a look at what you can do on your website to improve its visibility to the search engines. This half-day course gives an overview of the key techniques to help move your site up the search ranks, explains the major search ranking factors, the principles behind the search engine and the steps that you can take on your website to make it more visible by the search engine. Duration: Half-day course (9:30am – 12:30pm approximately) Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available. Course Content • The principles behind the Search Engine • How search works – understanding the search results and how to get seen there. • Understanding the difference – natural search / paid search. • Explanation to the major Search Ranking Factors; keywords, link building, quality score • Key techniques to help your site move up the Search Engine Results (SERPS) pages • Introducing other tools of the online trade; Online PR, Display Advertising (including on the Social Networks), Affiliate Marketing. Part 2: Google gives a whole host of free and paid-for tools to help every business, large and small, be found in the search engine results pages: Google My Business, Adwords Express, Adwords, Google Shopper and Google Analytics. This half-day course allows you to create, edit & update your Google My Business page and gives you an overview of the other Google products – more than enough to get you started with your online marketing. You’ll walk away with a good understanding of how you can get your business seen in the Google search results pages and know what areas of your website & advertising that you need to focus on. Duration: Half-day course (1:30pm – 4:30pm approximately) Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available. Course Content • Google My Business – what is it and why is it so important? • Create, edit & update your Google My Business page. • Google Adwords Express & Adwords – how a small marketing budget can go a very long way and jump you to the top of the search pages. • Google Shopper – for those businesses that are selling products online. • Google Analytics – what is it saying about your website and what can you do about it. • Introducing other tools of the online trade; Online PR, Display Advertising (including on the Social Networks), Affiliate Marketing. Course price: Parts 1 & 2 – FREE for Small Broadland and South Norfolk based businesses with less than 15 full-time equivalent employees, otherwise £49.50 per part. For more information or to book any free spaces please call us on 01603 788950, or email [email protected]