If you’re looking for a good starting point with Excel, this is it. The mystery of calculations will dissolve and getting everything to fit on the right number of pages will become a few seconds work. You will have a spreadsheet up and running with calculations within an hour and by lunchtime you’ll be happy duplicating a number of different calculations across the spreadsheet. Formatting columns, text and numbers will ensure the spreadsheet looks good on the screen, and will still look good when fitted to a page with headers and footers for printing. Tips, tricks and shortcuts abound and we can’t resist squeezing in a quick chart at the end of the day, just to show how easy it is. You will learn:
The Excel screen – The proper names for components of the screen and how to use them
Spreadsheet basics – Entering and editing information along with saving as various file types
AutoFill – Filling calculations, dates and text based lists such as months of the year
Calculations – Add, subtract, multiply, divide and percentages
Functions – Sum, Average, Min and Max
Formatting – Column & row, numbers, date and time as well as text
Printing – Scaling up and down to fit a page along with headers and footers
Working with larger spreadsheets – Freezing and splitting the screen
Designed for business professionals who are expected to perform effectively in a time poor environment, this one-day workshop will help delegates improve their productivity and performance by changing their understanding of and approach to time management.
Benefits of attending this workshop
Understand the benefits of planning and managing time
Recognise your barriers and challenges to effectively managing your time
How you currently use your time and planning to improve
Understand when you are at your most effective and how to make use of this
Understand your workload and how to prioritise effectively
Know how to use a variety of time management techniques to improve efficiency, reduce stress and improve performance
Use techniques to ‘create time’
Manage technology better so it works for us
Workshop Content
Welcome, introduction & review personal objectives
Key benefits and reasons for planning and managing time
Does your time control you? To recognise the key barriers and how to overcome these to improve your own self-management
‘Time Efficiency’. Recognise when you are at your most productive and how to make best use especially with complex tasks
Analysing our Time Log. Recognise prime areas of efficiency and inefficiency in your day to day and actions to improve
Understanding our Priorities. To understand the methodology and practice for prioritising work
Creating Time. To recognise how you can influence and gain time in your working week and create actions to achieve this
Time Management Tools and Techniques. Key techniques of:
Diary planning
Lists
80/20 rule
Clustering
Delegation
Action planning
Making email and social work for you To recognise the major impact that technology has on our lives and what we need to do to make it work for us
Key Tips of Self-Management. To enable you to consider a series of small techniques which have been proven by others to improve the management of their time
Summary, review objectives and close
IMPORTANT NOTE ON PRE-COURSE WORK: You will be asked to complete a time log in preparation for the training. A template will be provided upon booking.
This course is a one day open programme, running 9:30am – 4:30pm on February 27th 2020 and 9:30am – 4:30pm on March 16th 2020
Welcome to the Nuclear Safety Culture and Behaviours programme.
This practical course is designed for Supply Chain supervisors and other persons who are, or are about to be, responsible for planning, organising, monitoring, controlling and supervising teams on a nuclear construction project.
It is about getting ready to work on a nuclear construction project. The course will look at the behavioural aspects of work and provide you with a head start on understanding what nuclear safety culture is.
The course focuses on behaviours which positively impact safety, quality and productivity in supply and construction. In particular we will discuss how to implement the behaviours required to build a nuclear safety culture both today and for tomorrow.
It highlights the need for effective leadership, teamwork, performance management and the importance of adequate communication to sustain a health and safety culture within the whole workforce. It promotes a culture that accepts that mistakes can be made, admitted to and rectified, so that lessons learnt can be implemented, leading to a positive culture for safety from design through build and on to production and operation.
Programme Aims – leaders must:
• Keeps themselves, their team and the environment safe • Look out for others and report safety issues • Work to quality plans and understand why ‘right first time’ is essential • Do the right thing when no-one is watching • Take ownership and provide effective leadership • Keep teams productive and motivated
Course Date:
Programme One: Module one takes place on 22nd and 23rd April and module two on 6th and 7th May
Programme Two: Module one takes place on 20th and 21st May and module two on 10th and 11th June
In an ever-increasingly complex and interconnected world the consequences of getting things wrong can be dramatic, far-reaching and very expensive. Yet with the benefit of hindsight, the causes of many failures and sub-optimal performance can often appear obvious, so why were they not picked up in the design phase?
Systems Thinking is an incredibly powerful approach to handling complexity, providing an insight and understanding. By treating real-world things (products, processes, services, organizations) as systems, we can systematically build a holistic view of any challenge, allowing us to solve previously unsolvable problems, exploit opportunities and prevent the occurrence of issues.
The purpose of this half-day awareness session is to demonstrate the power of applying Systems Thinking to design. The session is free to attend and will be delivered by Burge Hughes Walsh Limited
Burge Hughes Walsh Limited provide advice, training and project support in product and service design. Their client list includes Dyson, BAE Systems, Airbus, Rolls-Royce, LG, Vestas, GE, HMRC, Fife Council, Aberdeenshire Council, Companies House, NHS Digital to name a few.
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.
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 sandwich lunch with crisps and cakes will be provided. Refreshments will be available throughout the duration of this course.
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
Formulae and Functions
Simple formulas & Functions
Relative and Absolute References
Named Ranges
AutoSum
AutoFill
Paste Function
Average, Max, Min & Count Functions
Multiple Panes
Freeze and Unfreeze
Formatting a Worksheet
Using Borders and Shading to improve presentation
Font & Number Formatting, Alignment
Printing
Print Preview & Setup
Headers & Footers
Print Row/Column headings
File Management
Saving, Closing and opening files
New Workbooks
Good Working Practice
Creating a Chart
Creating Charts
An explanation of different versions
For more details or any enquiries, please contact us on 01603 788950, or email [email protected]
In today’s competitive world, it doesn’t matter if you are a starter business or global international company: the real difference in the performance of your business is how people perform.This is very often forgotten when businesses are looking to grow and improve their profitability.
Our free seminar will share with you some insightful and thought-provoking approaches to address these issues, removing barriers and creating an asset for your growth strategy.
Timings
Join us for refreshments from 9am.
The presentation will begin at 9.30am and you will have an opportunity to network with other guests from 11am.
Numbers are limited, so please ensure you book your space.
There is plenty of free parking available.
For further information, please telephone 01603 881689 or email [email protected]
About Us Turning Factor is a strategic learning and business development company. We engage, develop and deliver cutting-edge leadership and training solutions, helping organisations grow by enabling your staff and leadership to operate at a much higher level. We pride ourselves on our creativity in finding real and practical solutions, and are committed to helping people and businesses reach their full potential.
Are you showing up at Social Networking Platforms and not really achieving much; you’re unsure what to say, where to say it and how often you should be talking. If you’re unsure how to measure the impact Social Media is having on your business, then this is the course for you. This course is suitable for all Business people that know they should be using Social Media to enhance their business, but are unclear how to, find it difficult to manage, or struggle to build meaningful business relations on line. No equipment is necessary for you to bring to the course. Pens and note paper will be available. Please bring any login details you have for any platforms that you use. Lunch provided: For full day training courses a lunch with sandwich or salad, crisps and cake or fruit will be provided. Hot drinks and bottle water will be provided but please bring snacks with you at present. This may change dependent on restrictions and when your course will take place. We kindly ask delegates to where a face covering when moving around inside but these can be taken off when seated. Course Content: • Social Media the Big 4 and niche platforms • Define yourself as The Expert Help you to find your voice • Find your audience/customers • See case studies of people using Social Media well • Learn to connect with your audience using Video • How to be Internet Famous & the many ways to turn that into a profit. Course Cost: £77 – £99 per person. For more details or any enquiries, please do contact us on 01603 788950, or email [email protected]
With changes to allergen management & labelling incoming due to the introduction of Natasha’s Law. This qualification will help you understand the importance of having practical controls in place to reduce the risk of allergenic contamination.
Topics covered include the manager’s role in ensuring that food ingredients and allergens are effectively managed, procedures relating to the communication of ingredient information from supplier to consumer, the importance of implementing controls to prevent contamination from allergenic ingredients, and the methods for managing ingredient controls and procedures.
This course is suitable to a variety of supervisors and managers in catering, including those responsible for; the sourcing, purchase, delivery and storage of raw materials. Menu planning and design Kitchen supervision And also the owner/managers of smaller catering businesses
To book or for more information about this course please call 01603 473732 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 based businesses with less than 10 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]
This course is designed for anyone who deals with customers / clients, either face-to-face or over the telephone.
By the end of the course you should be able to understand body language, understand the need for good communication skills, answer the telephone in a professional way and learn to listen.
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
First impressions
Understanding the importance of communication
Body language
Barriers to communication
Methods/techniques used to deal with customer / clients
Telephone tactics ‘The Terrible Ten’ – 10 pet hates
Controlling the call
How to deal with difficult customers and clients (3 strike rule)
Location: Carrowbreck House, 7 Carrowbreck Road, Norwich, NR6 5FA Over the past 2 years, the accounting profession has seen one of the biggest changes in management information systems since the introduction of spreadsheets. This has arisen as a result of on-going technological advances across the globe and the increased demand for real time data. The use of online accounting software has increased exponentially and the benefits of using online solutions are numerous. Course Content – Configuration and Basic bookkeeping of QuickBooks Online – Raising sales invoices, quotes and statements to customers – Bank reconciliations – VAT returns and record keeping – Management accounts and reporting – Using real-time information to understand your business – Budgeting – Using technology to streamline your business – Growing the business – Exit strategy Some benefits of cloud accounting are; • Accessibility – The ability to access your data anywhere in the world where you have an Internet connection. This allows quicker management reporting at your fingertips. Some providers allow the data to be accessed across a platform of devices including iPads and iPhones. • Automation – Several of the cloud solutions now support bank feeds so that your bank transactions can automatically download directly into your software which can reduce processing time and eliminate errors. Reduced data entry can mean your scan your invoices in or take photos and the app will do the rest for you, instead of keying them in one by one. • Remote working – Without the need to access the data on a specific PC, we’ve seen an uptake in remote working, where bookkeepers can work away from their own office or even at home. With the pace of modern life, it can be essential that accounts are accessible anywhere. • Program updates and review – You will always be using the most up to date version of the software, and you won’t need to buy yearly program updates. Monitoring your business is performed in real-time, allowing you to run as efficiently as possible. Duration: 9:30am – 12:30pm Equipment: Pens and note paper will be available. Lunch provided: On half-day courses, light refreshments will be available throughout the duration of this course. Prices range from £38.50 – £49.50 per person. For more information, please do contact us on 01603 788950 or email [email protected]