Staff awareness of Cyber Security and related threats is a key element of a successful cyber security strategy.
This short course will help non-technical teams understand the risks posed by Cyber Criminals and fraudsters, both at work and at home, and help them protect themselves at both.
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.
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:
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
Summarising data from multiple sheets
Linking workbooks
Advanced Functions
Functions with more than one argument e.g. the IF Function
Named Ranges
Naming ranges
Navigating using named ranges
Using named ranges in formulas
Natural language formulas
Excel as a Database
Sorting your data
Filtering a list
Useful database features
Good Working Practice
Copy and Paste
Using the Windows clipboard
Paste-Special
Linking to other files and applications.
Replacing formulas with data
The Drawing Tools
Auto shapes
Layers
Rotation
Alignment
Grouping
An explanation of different versions
For more details or any enquiries, please do contact us on 01603 788950, or email [email protected]
The LSIP Roadshow events are happening across Norfolk and Suffolk – join us in the heart of Norwich.
What is the LSIP programme?
We want you as a business to have a bigger say in what skills are needed in the workplace for today, tomorrow and the future.
The Norfolk and the Suffolk Chambers of Commerce is working with the Department for Education (DfE) to put employers at the heart of the skills agenda with the launch of the Norfolk and Suffolk Local Skills Improvement Plan (LSIP.)
Why should I get involved?
You want to increase the growth of your business.
You want your team to have the skills they need to be engaged, empowered and moving forwards.
It’s vital to retain the talent within your business.
You want to attract the right people, for culture, for growth and for success.
We are engaging with businesses of all sizes, stakeholders, colleges, training providers and universities to enable a more responsive and collaborative approach to the development of the local workforce.
What’s the event about?
We’re hosting a series of breakfast events that will be across Norfolk and Suffolk, for you to come and discuss keys areas of the LSIP programme, and what it can bring to your workforce, we will be talking about Skills, Wellbeing, Training, Retention.
Enjoy some morning networking over bacon rolls, tea and coffee with local businesses to discuss and highlight the skills gaps, issues and successes you are experiencing.
We want to engage and meet with local businesses of all sizes to enable a more responsive and collaborative approach to the development of the local workforce.
This session will be led by the LSIP Project Manager Dean Pierpoint.
Event Agenda
Arrival from 8am – Networking with tea, coffee and Bacon Rolls (dietary requirements will be catered for)
8.30am – Welcome from Dean Pierpoint
8.35am – Council Representative
8.45am – Presentation on LSIP
9.00am – Challenge for the Roundtable
9.10am – Fact Finding
9.20am – Skills Conversation
9.40am – Presentation from our Strategic Partners, Turning Factor
10.00am – Event close
What happen next?
Over the coming months, we will be conducting Employer Engagement surveys, telephone interviews, opportunities for 1-2-1 discussions, focus groups and events.
Our LSIP Board is now in place to provide direction, oversight, and review of the development of an effective LSIP for the region, the first meeting took place yesterday, 17th January and was a huge success in steering the programme forward.
You can view the Suffolk Chamber of Commerce programme of events across Suffolk here
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.
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 course.
Course Content
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
Summarising data from multiple sheets
Linking workbooks
Advanced Functions
Functions with more than one argument
e.g. the IF Function
Named Ranges
Naming ranges
Navigating using named ranges
Using named ranges in formulas
Natural language formulas
Excel as a Database
Sorting your data
Filtering a list
Useful database features
Good Working Practice
Copy and Paste
Using the Windows clipboard
Paste-Special :–
Linking to other files and applications.
Replacing formulas with data
The Drawing Tools
Auto shapes
Layers
Rotation
Alignment
Grouping
An explanation of different versions
Course costs £109 per person. For more details please contact us at [email protected] or on 01603 788950.
Norfolk is full of talented business men and women and we’re delighted to have some of them giving up their time to provide free mentoring sessions for young professionals (under 35s) across Norfolk.
Date: 5th February 2024.
Time: Hourly slots available between 10am – 2pm
Meet in person at Royal Norwich, The Weston Estate, Weston Hall Road, Weston Longville, Norwich, NR9 5JE
Topics
HR
Personal Growth and Development
How mindset can impact the bottom line of a business.
Wellbeing
Performance
About Gemma
Gemma Crane has been in an HR Capacity in the corporate world for 24 years in a variety of sectors and industries. In the last 10-12 years has also become an NLP Practitioner, Life Coach and Results Internation Performance Coach.
Gemma is also a trustee for the Norwich Red Balloon Charity, enjoys public speaking and supports and partners with organisations to improve their processes and practices in relation to their people strategy.
Mindset-HR was founded by Gemma Crane in 2022. As the lead HR Consultant, Gemma works with businesses to think differently about their ‘People Strategy’ and processes.
Coming out of the pandemic and studying the mind for over 10 years now it is crazy how ‘people’ have changed and the changes to their priorities of what a meaningful life looks like to them.
Businesses that make changes to their culture to recognise this will thrive and achieve better results and revenue.
Norfolk is full of talented business men and women and we’re delighted to have some of them giving up their time to provide free mentoring sessions for young professionals (under 35s) across Norfolk.
Date: 26th February 2024.
Time: Hourly slots available between 10am – 2pm
Meet in person at Swaffham Cafe, 3 Market Place, Swaffham, Norfolk, PE37 7AB
Topics
Sales
Coaching
Training
Management
Project Management
Construction
About Zoe
Zoe has been running her own builders merchant for the last 10 years but has been in the trade for around 30. She has worked in small and large companies, a manufacturer for 10 years working at a senior level working on sales, operations, manufacturing and working across divisions delivering training and selling a range of products incorporating other areas of the organisation. She has also worked alongside Mckinsey (London) in delivering a change programme. So she understands corporate life and running a business.
Course will provide delegates with the training, skills and knowledge in emergency first aid and comply with the requirements of the Health and Safety (First Aid) Regulations 1981.
All delegates will be awarded a Norvic certificate of attendance accredited by Qualsafe Awards who are recognised by Ofqual. It is valid for three years.
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
· Role and responsibility of first aider
· Introduction to first aid
· The recovery position
· Heart attack
· Choking
· Burns and scalds
· Incident management and safety
· Basic life support
· Adult and paediatric resuscitation
· Use of AED
· Control of bleeding and shock
· Simple record keeping and first aid equipment
“Information presented in a clear and concise way at a good pace. Enjoyable course, very informative”.
“Lots of hands on role play, was a very good way to learn.”
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 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
Course costs £109 per person. For more details please contact us at [email protected] or on 01603 788950.
Our engagement groups represent local businesses in the community, to connect, support, and give voice to every business in Norfolk.
As well as having the opportunity to discuss key topics, you’ll also be able to network with fellow businesses.
Our aim is to have groups in many cities, towns, market towns, and villages across Norfolk, to connect, support, and give voice to every business in Norfolk. These groups are accessible to all businesses, whether you are a Chambers member or a non-member.
These groups will provide you with a platform to debate issues that are most important to you, and your business and the Chamber network will lobby and influence on your behalf, using our dedicated team, our website, social media channels, and our digital platform.
Your feedback will be used by our team and the Chamber’s Board to help shape the strategic direction of Norfolk Chambers to ensure we can truly be the voice of Norfolk businesses.
Whether the local challenge is skills, road, rail, digital infrastructure, recruitment, or the rising costs of doing business, we want to hear from you.
Agenda
9am Arrival and networking
9.10am Welcome from Norfolk Chambers
9.15am Introductions
9.20am start conversations
10am Event close
This event is kindly sponsored by one of our Strategic Partners, Uptech – Your Trusted IT Partner and Expert in Managed IT Services.
Management is like orchestrating a flawless concert, making sure every instrument plays its part efficiently, whereas leadership is more like being the Rockstar on stage… getting the crowd going and creating an unforgettable experience. Both are essential for a successful show, but they play different roles.
Do you feel your workplace is full of rockstars or conductors?
What does management mean to you? Does Leadership matter to you?
We want to know how the young professionals in Norfolk feel on this topic, join us on Thursday 18th January at The Forum, Norwich, where we shall discuss the difference between management and leadership. Joined by a panel of local rockstars and conductors, we shall hear from them first hand on their own experiences and how they feel on the topic. Factoring in how you, the young professionals of Norfolk feel about management and leadership.
Welcome drinks and light canapes served from 5.15pm with the event beginning shortly afterwards. Catering kindly sponsored by Uptech.
Panel
·Jamie Minors, Co-Founder of Minors & Brady Estate Agents
·Kelly Cartwright, Owner of Core Recruiter Ltd
·Stephen Moseley, Course Leader and Lecturer at City College Norwich
·Jason Carlton, Managing Director at Uptech
·Sam Squires, CEO of Inspire 2 Ignit
·Julie Furnell, Managing Director of Mobilityways
Opportunity to network and connect with other under 35’s in Norfolk while gaining insightful knowledge.
Norfolk is full of talented business men and women and we’re delighted to have some of them giving up their time to provide free mentoring sessions for young professionals (under 35s) across Norfolk.
Date: 19th February 2024.
Time: Hourly slots available between 10am – 4pm
Meet in person at Royal Norwich, The Weston Estate, Weston Hall Road, Weston Longville, Norwich, NR9 5JE
Topics
Procurement & Supplier Management
Networking & Connecting
Running your own business as a Solopreneur
Sounding board & Signpost for your ideas
About Chris
Chris is a Chartered Procurement & Supply Professional and Fellow of CIPS. Chris is an active Member of the Institute of Directors and proactive networker across the Norfolk and London business communities.
Chris has been an independent professional through CJC Procurement Ltd since 2016, a classic case of redundancy into consultancy and Solopreneurship and Chris has supported Norfolk Chambers to set up our Co.Solo programme.