Name: Presentation Skills 1 Day Workshop in Stirling
Price: 595 GBP
Availability: InStock

Stirling

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Overview:</h1>This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.Course Contents:Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.Course Topics:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Qualities of an Effective Leader&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Leader or Manager?&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">That Vision Thing&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Developing Your Team Goals&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivation&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">What Motivates?&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Being Consistently Different&nbsp;&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Dealing With Difficult Team Members&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coaching&nbsp;&ndash; Using a simple method of coaching, including action plans.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Three Key Skills of Coaching&nbsp;&ndash; Looking at the skills required to be an effective coach.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Instant Results Coaching&nbsp;&ndash; Coaching in a hurry!</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Can Do Coaching Practice&nbsp;&ndash; Putting the learning into practice</li></ul>Course Feature:By the end of this training you will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the qualities of an effective leader</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Benchmark themselves against those qualities and develop actions to improve</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the difference between leading and managing</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the value of sharing the business vision with the team</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop team goals based on the business vision</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Deal with difficult staff members</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Challenge staff in a meaningful and effective way</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coach staff effectively using a simple process</li></ul>Certification:Once after the training you receive course completion certificate from MangatesWho can Attend?Anybody who is interested in learning Effective Skills to Lead a Team.

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
Events do not just happen, they take time to plan, develop, and create. This workshop is designed to give your participants the tools needed to host a great event. They will touch on planning and administrative techniques that will give them the confidence to run an engaging event that will leave a positive and lasting impression on each attendee.
With our Event Planning workshop y,our participants will explore ways to work with vendors, security, technicians, and wait staff. They will touch on different event types such as awards ceremonies, charity events, and business conferences. By utilizing the correct skill set you will be provided the details to pull off a successful event.
Target Audience:
Anybody who is interested in learning Event Planning Skills
Learning Objectives:
By the end of the course, participants will be able to understand:
Types of Events
Brainstorming
Types of Entertainment
Support Staff
Technical Staff
Vendors
Finalize the Plan
Administrative Tasks
Get Organized
Post Event Activities
Wrapping Up
Agenda:
Module One: Types of Events
Awards
Charity
Conferences and Seminar
Holiday
Case Study
Module One: Review Questions
Module Two: Brainstorming
Determine the Event’s Purpose
Determine a Theme
Write Down & Review Ideas
Determine a Date
Case Study
Module Two: Review Questions
Module Three: Types of Entertainment
Games
Activities
Speakers
Performers
Case Study
Module Three: Review Questions
Module Four: Support Staff
Security
Valet
Wait Staff
Clean up Crew
Case Study
Module Four: Review Questions
Module Five: Technical Staff
Visual Technician (lighting)
Media Technician (website, Facebook, etc.)
Audio Technician (Sound)
Specialized Electrical Equipment Technician (for performers)
Case Study
Module Five: Review Questions
Module Six: Vendors
Food
Equipment
Decorations and Furnishing
Photography/ Video
Case Study
Module Six: Review Questions
Module Seven: Finalize the Plan
Venue
Registration
Entertainment
Cuisine and Decor
Case Study
Module Seven: Review Questions
Module Eight: Administrative Tasks
Create a Budget
Branding and Marketing
Insurance and Permits
Contracts (for event staff, entertainment, rentals, and vendors)
Case Study
Module Eight: Review Questions
Module Nine: Get Organized
Form a Team
Timeline
Checklists
Backup Plans
Case Study
Module Nine: Review Questions
Module Ten: Post Event Activities
Survey
Share Media (photos and video)
Send Thank you Notes
Start planning the Next Event!
Case Study
Module Ten: Review Questions
Module Eleven: Wrapping Up
Words From The Wise
Review Of The Parking Lot
Lessons Learned
Recommended Reading
Completion Of Action Plans And Evaluations

Mangates

Event Planning 1 Day Training in Stirling

The Ultimate Guide to Event Planning - 1 Day Workshop in Stirling

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Course Overview:According to a 1973 survey by the Sunday Times of London, 41% of people list public speaking as their biggest fear. Forget small spaces, darkness, and spiders, standing up in front of a crowd and talking is far more terrifying for most people. Through this workshop you will become more confident and relaxed in front of an audience which will translate into a successful speaking event.However, mastering this fear and getting comfortable speaking in public can be a great ego booster, not to mention a huge benefit to your career. The Public Speaking workshop will give participants some public speaking skills, including in-depth information on developing an engaging program and delivering their presentation with power.Learning Objectives:Inside This Training, You&#39;ll Learn<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Completely remove your stage fear and become a dynamic speaker</li><li fr-original-style="" style="box-sizing: border-box;">Raise your confidence up to a level you never thought to be possible!</li><li fr-original-style="" style="box-sizing: border-box;">Deeper insights into group dynamics</li><li fr-original-style="" style="box-sizing: border-box;">Presentation design, skills &amp; styles</li><li fr-original-style="" style="box-sizing: border-box;">Tools to get your audience to say yes to you</li><li fr-original-style="" style="box-sizing: border-box;">Advanced new behavior patterns required for public speaking</li><li fr-original-style="" style="box-sizing: border-box;">Control time for effective training</li><li fr-original-style="" style="box-sizing: border-box;">Secrets of mind control techniques</li><li fr-original-style="" style="box-sizing: border-box;">Develop your personal winning style</li></ul>Prerequisites:NoneCourse Materials:Attendees will receive a course manual with presentation slides and reference materials.Agenda:Module One: Identifying Your Audience<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Performing a Needs Analysis</li><li fr-original-style="" style="box-sizing: border-box;">Creating an Audience Profile</li><li fr-original-style="" style="box-sizing: border-box;">Identifying Key Questions and Concerns</li></ul>Module Two: Creating a Basic Outline<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Outlining the Situation</li><li fr-original-style="" style="box-sizing: border-box;">Identifying the Task That Had to Be Performed</li><li fr-original-style="" style="box-sizing: border-box;">Listing the Actions You Took</li><li fr-original-style="" style="box-sizing: border-box;">Revealing the Results</li></ul>Module Three: Organizing the Program<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Making Organization Easy</li><li fr-original-style="" style="box-sizing: border-box;">Organizational Methods</li><li fr-original-style="" style="box-sizing: border-box;">Classifying and Categorizing</li></ul>Module Four: Fleshing It Out<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Identifying Appropriate Sources</li><li fr-original-style="" style="box-sizing: border-box;">Establishing Credibility</li><li fr-original-style="" style="box-sizing: border-box;">The Importance of Citations</li></ul>Module Five: Putting It All Together<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Writing Your Presentation</li><li fr-original-style="" style="box-sizing: border-box;">Adding a Plan B</li><li fr-original-style="" style="box-sizing: border-box;">Reviewing, Editing, and Rewriting</li></ul>Module Six: Being Prepared<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Checking Out the Venue</li><li fr-original-style="" style="box-sizing: border-box;">Gathering Materials</li><li fr-original-style="" style="box-sizing: border-box;">A 24 Hour Checklist</li></ul>Module Seven: Overcoming Nervousness<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">A Visit from the Boss</li><li fr-original-style="" style="box-sizing: border-box;">Preparing Mentally</li><li fr-original-style="" style="box-sizing: border-box;">Physical Relaxation Techniques</li><li fr-original-style="" style="box-sizing: border-box;">Appearing Confident in Front of the Crowd (Even If You Don&acirc;&euro;&trade;t Feel That Way)</li></ul>Module Eight: Delivering Your Speech (I)<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Starting Off on the Right Foot</li><li fr-original-style="" style="box-sizing: border-box;">Using Visual Aids</li><li fr-original-style="" style="box-sizing: border-box;">Checking the Volume of Your Voice</li></ul>Module Nine: Delivering Your Speech (II)<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Adjusting on the Fly</li><li fr-original-style="" style="box-sizing: border-box;">Gauging Whether Breaks Are Required</li><li fr-original-style="" style="box-sizing: border-box;">Wrapping Up and Winding Down</li></ul>Module Ten: Questions and Answers<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Ground Rules</li><li fr-original-style="" style="box-sizing: border-box;">Answering Questions That Sound Like an Attack</li><li fr-original-style="" style="box-sizing: border-box;">Dealing with Complex Questions</li></ul>Module Eleven: Wrapping Up<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Words from the Wise</li><li fr-original-style="" style="box-sizing: border-box;">Review of Parking Lot</li><li fr-original-style="" style="box-sizing: border-box;">Lessons Learned</li><li fr-original-style="" style="box-sizing: border-box;">Completion of Action Plans and Evaluations</li></ul>Target Audience:Anybody who is interested in Public Speaking Skills.Technical Requirements:For eBooks:Internet for downloading the eBookLaptop, tablet, Smartphone, eReader (No Kindle)Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)eBook download and activation instructions

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
This networking skills training will help you to build a professional reputation and develop a network of connections through the two key methods available to you; face-to-face and online.
You will discover how to effectively combine these two approaches and create a strategy for networking success that will generate your own community and actively grow your personal network. This will result in an improved performance in your approach to networking and consequently provide opportunities and prospects that will increase your business success.
The training provides you with the tools and techniques to both plan a successful, strategic approach to networking and develop your personal communication skills, which will ensure you build effective business relationships.
Course Contents:
Effective Networking Strategies and Techniques – Business Networking Training
Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. You need to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation.
Perhaps you’re looking to improve the networking performance of a management or sales team. Or you want to include networking skills training as part of management and leadership training programmes. Whatever your need, We provide you with a comprehensive networking skills training course to make your life easy.
This business networking training is aimed at helping you develop your business or career. You will help ensure you have the skills, knowledge and techniques to develop a joined-up networking strategy that gets you the outcomes you want.
You will also be encouraged to develop the correct behaviours and attitudes to help build your visibility and credibility through networking so that you develop strong working relationships that last.
Course Topics:
Why Network? – Establishing the importance of networking with some shocking statistics and an activity that defines the importance of networking to the individual. This is followed by some insight into the key aims of a networking strategy, what puts people off as well as some personal revelations about networking
Increase Your Business Presence – Looking at the components of a strong business presence, including; credibility, personal brand, visibility and social capital.
Developing a Networkers Attitude – An exercise that clarifies the perfect attitudes and behaviours of great networkers and comparing the participants against this. Thus identifying areas for development.
Face to Face Networking – An overview and insight into the main types of face to face networking opportunities available with the benefits and pitfalls of each.
Online Networking – An overview of the different social media and online networking tools and how to get the best out of them. Includes; LinkedIn, Twitter, Facebook and online forums.
Communication Skills for Networking Success – Ensuring a good first impression, creating an opening sound bite and writing an online profile that promotes and engages.
Developing a Conversation – Building on the opening sound bite and developing a conversation through good questioning techniques and following a selection of key networking rules. Including an activity to test and practice the skills.
Working a Room – A fun activity that embeds and develops learning while encouraging practice and communication. This activity covers 10 of the main skills required to work a room.
Breaking into a Group – Identifying body language to spot when a group or pair is open to new people entering the conversation or would rather not encourage participation. Knowing how to break into a group, what to say and how to remain professional.
Exiting a Conversation – Developing some techniques to extricate oneself from a conversation without causing embarrassment or rudeness.
The Follow Up – Using a structure to identify the most important contacts created and establishing when and how to follow up with each group. Includes example follow up email and a chance to develop their own.
Creating a Network Plan – Participants are provided with a networking action plan to review and complete. This sets them on the journey of developing their networking skills and ensures they have a strategy and goals to target.
This training is highly interactive and includes lots of activities and exercises to stimulate discussion and develop learning opportunities.
Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. You need to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation.
Perhaps you’re looking to improve the networking performance of a management or sales team. Or you want to include networking skills training as part of management and leadership training programmes. Whatever your need, We will provide you with a comprehensive networking skills training course to make your life easy.
Course Feature:
At the end of this business networking skills training, you will be able to:
Develop a successful networking strategy
Maximise their effectiveness with face-to-face and online networking opportunities
Improve their approach, attitude and behaviours when networking
Create a plan for networking that will help them meet their goals
Certification:
Once after the training you receive course completion certificate from Mangates
Who can Attend?
Anybody who is interested in learning Business Networking Skills.

Networking Skills

Business & Marketing

Business Networking 1 Day Training in Stirling

Master Business Networking in Just 1 Day - Join our Workshop in Stirling

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
We all know an angry face when we see one. Anger is such a universal and powerful emotion that can make you physically and emotionally ill, sap your energy, and poison your relationships or it can motivate you to make needed changes and add vitality to your life. This training program aims to help you adopt a more constructive attitude towards your anger and to more effectively manage anger in others as well. Practical activities and tools will empower those who act out their anger in negative ways to gain better control of their anger and their lives and use it as a tool to motivate and empower them to affirm their integrity or boundaries. The program will encourage participants to look deep inside to explore the roots of their anger and present alternatives to the old ways of thinking and dealing with anger.
Learning Objectives:
By the end of this training course participants will be able to:
Understand both the “Right” skill set and mindset needed to properly manage their anger.
Learn to communicate angry feelings assertively and in ways that will take into account the needs of others.
Adopt a more constructive attitude towards anger and understand the difference between constructive and destructive anger.
Use practical techniques to properly handle anger in others.
Agenda:
Module 1: Anger Anatomy:
Is anger good or bad?
Five famous myths about anger
Having the “Right Mindset” for managing anger
Physical effects of anger
Module 2: The Anger Management Skill Set:
Having the “Right Skill Set” for managing anger.
The 4 deep sources of anger.
The assertive statement to communicate anger.
Rules of assertive behavior.
Module 3: The Anger Management Process:
My personal anger assessment – Self-assessment.
A four-step process to effectively express your anger.
Module 4: Handling Anger in Others:
The importance of listening.
Summarizing and reflecting back on what was said.
Reflecting emotions and reframing statements.
Three-step technique for handling anger in others.
Target Audience:
Anybody who is interested in learning Anger Management Skills.
Prerequisites:
None

Anger Management

Anger Management 1 Day Training in Stirling



































































 
















The Art of Staying Calm: Anger Management in Action 1 Day Workshop in Stirling

Aberdeen

Certificate: Course Completion Certificate | Language: English

Duration: 2 Days | Credits: 16 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course Description:

In the competitive construction industry, the need for training is more vital than ever. Organizations that devote resources to professional development are more likely to see higher productivity and greater efficiency. On-the-job training can provide crucial knowledge to perform tasks at hand, but the best professionals constantly seek to learn about new techniques and technologies to improve their performance on-site and in the office.

Our Construction Project Manager Course (PMC) provides project managers the chance to sharpen the skills necessary to work more efficiently, increase productivity, and propel your construction business to the next level. PMC provides the ideal opportunity for project managers to gain crucial knowledge and leadership skills to stay competitive. This program will provide participants with skills they can immediately implement on the job and in the field. Everyone who goes through the program has something to gain over an intense week of workshops, assignments, and team-building activities.

PMC participants experience an interactive program that explores 15 critical areas of project management that seasoned project managers tackle on a daily basis. PMC provides participants with practical solutions to current industry challenges they can take back to immediately impact performance and improve project results.

Learning Objectives: 

Upon successful completion of this course, the learner will be able to:

● Identify the importance of pre-planning and its correlation with a company’s bottom line.
● Discuss the impact of low job site productivity on the project contractor, craftsperson, project owner, and designer.
● Discuss information required to evaluate and select subcontractor and vendor services and material and equipment purchases.
● Identify legal actions, or lack thereof, that can have far-reaching legal consequences for the project manager, their company, and many others.

Course Topics:

Day 1:

1.Project Planning
Importance of pre-planning.
Developing comprehensive project plans.
Correlation between planning and profitability.
Tools and techniques for effective planning.

2.Safety Management
Importance of safety in construction.
Developing and implementing safety plans.
OSHA regulations and compliance.
Risk assessment and mitigation.

3.Construction Productivity
Factors affecting job site productivity.
Techniques to improve productivity.
Measuring and tracking productivity.
Case studies of productivity improvements.

4.Subcontractor & Vendor Management
Evaluating and selecting subcontractors and vendors.
Contract negotiation and management.
Performance monitoring and quality control.
Building and maintaining strong relationships.

5.Critical Path Method (CPM) Scheduling
Basics of CPM scheduling.
Developing and maintaining project schedules.
Identifying and managing critical paths.
Tools and software for scheduling.

Day 2:

1.Claims Management
Types of claims in construction.
Preventing and managing claims.
Documentation and communication strategies.
Dispute resolution methods.

2.Legal Issues & Contract Clauses
Key legal concepts in construction.
Important contract clauses and their implications.
Managing legal risks and liabilities.
Case studies of legal issues in construction.

3.Cost Control
Budgeting and cost estimation.
Tracking and controlling project costs.
Analyzing cost performance.
Techniques for cost reduction.

4.Project Recordkeeping
Importance of accurate recordkeeping.
Types of project records and documentation.
Best practices for maintaining records.
Tools for efficient recordkeeping.

5.Communication
Importance of effective communication.
Strategies for improving communication.
Tools and technologies for communication.
Case studies of communication failures and successes.

6.Time Management
Techniques for effective time management.
Prioritizing tasks and managing deadlines.
Tools for time tracking and management.
Case studies of time management in construction.

7.Problem Solving & Decision Making
Techniques for problem-solving.
Decision-making frameworks.
Analyzing and evaluating options.
Case studies of problem-solving in construction.

8.Innovation
Importance of innovation in construction.
Identifying and implementing new technologies.
Encouraging a culture of innovation.
Case studies of successful innovation.

Conclusion: 

The PMC course aims to equip project managers with the skills and knowledge necessary to excel in the construction industry. By addressing the critical areas of project management, participants will leave the course with practical strategies and tools to enhance their performance and drive their projects to success.
Who Can Attend?
The Construction Project Manager (PMC) 2 Days Training course is designed for:

Project Managers: Experienced project managers looking to enhance their skills and stay updated with the latest industry practices and technologies.
Construction Managers: Individuals responsible for overseeing construction projects who want to improve their management techniques and project outcomes.
Site Supervisors: Supervisors and foremen seeking to gain a deeper understanding of project management principles and practices to better support project managers.
Engineers and Architects: Professionals involved in the planning, design, and execution of construction projects who want to enhance their project management knowledge and skills.
Construction Professionals: Anyone in the construction industry, including estimators, planners, and coordinators, aiming to improve their project management capabilities and advance their careers.
Business Owners and Executives: Owners and executives of construction companies who want to ensure their project managers and teams are well-equipped with the necessary skills to drive project success and business growth.
Aspiring Project Managers: Individuals aspiring to move into project management roles within the construction industry, seeking foundational knowledge and skills to prepare for the transition.
HR and Training Managers: Human resource and training managers responsible for the professional development of their company's construction management teams.
Prerequisites
While there are no strict prerequisites for attending the PMC course, having a basic understanding of construction processes and some experience in construction project management will be beneficial. Participants should come prepared to engage in interactive discussions and practical exercises that require critical thinking and problem-solving skills.
Benefits of Taking the Construction Project Manager (PMC) 2 Days Training Course In-House
1. Customization to Your Needs:
● The course can be tailored to address the specific challenges and requirements of your organization, ensuring the content is relevant and directly applicable to your projects and team dynamics.

2. Convenience and Flexibility:
● Conducting the training in-house eliminates the need for travel, saving time and reducing costs for your employees. It also allows for scheduling flexibility to fit the course around your team's availability.

3. Team Building and Collaboration:
● In-house training fosters a collaborative learning environment, encouraging team building and improved communication among your employees. It provides an opportunity for your team to work together on practical exercises and case studies, strengthening their ability to collaborate effectively on future projects.

4. Immediate Application:
● The skills and knowledge gained during the course can be immediately applied to your current projects, leading to quick improvements in productivity, efficiency, and project outcomes.

5. Cost-Effective:
● In-house training is often more cost-effective than sending multiple employees to external courses. You save on travel and accommodation expenses, and there are often discounts available for group bookings.

6. Consistent Training:
● Ensuring that all relevant team members receive the same high-quality training ensures consistency in the application of project management principles and practices across your organization.

7. Confidentiality:
● In-house training allows your team to discuss sensitive and proprietary information freely without concerns about confidentiality. This can lead to more open discussions and practical problem-solving sessions.

8. Enhanced Engagement:
● Training conducted in a familiar environment can increase engagement and participation. Employees may feel more comfortable and willing to engage in discussions, ask questions, and participate in activities.

9. Long-Term Benefits:
● Investing in in-house training demonstrates your commitment to employee development, which can boost morale, job satisfaction, and retention rates. Employees are more likely to stay with an organization that invests in their professional growth.

10. Direct Access to Trainers:
● Having trainers on-site allows for more personalized interaction, immediate feedback, and the opportunity to address specific concerns or questions that arise during the training.

11. Aligns with Organizational Goals:
● In-house training can be aligned with your organizational goals and strategies, ensuring that the skills and knowledge gained are directly contributing to your company's overall objectives.

12. Follow-Up Support:
● Trainers can offer follow-up support and coaching to ensure that the concepts and techniques learned during the course are successfully implemented in your organization.

13. Increased Productivity:
● With the entire team trained together, there is a reduced learning curve, leading to quicker implementation of new practices and increased productivity.

14. Industry-Relevant Case Studies:
● Trainers can incorporate industry-relevant case studies and examples specific to your organization, making the learning experience more relatable and impactful.

By choosing to conduct the PMC 2 Days Training course in-house, your organization can maximize the benefits of professional development, ensuring that your team is equipped with the essential skills and knowledge to excel in the competitive construction industry.

Construction Management

Project Manager

Construction Project Manager 2 Days Training in Stirling

Certificate: Course Completion Certificate | Language: English

Duration: 1 Day | Credits: 8 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course Overview:

This training is aimed at helping hiring managers understand the concepts behind delivering a sound recruitment campaign: What are they trying to achieve, why and how?

Course Contents:

Improve the recruitment skills of the managers within your organization to help build effective teams

Recruitment is a crucial factor in the success of any business. All organizations are defined by the employees within it, so ensuring you employ the right staff at the right time is critical to your success. Aside from this, it is important that the people responsible for recruiting within the business are focused on ensuring they follow legislation and best practice to avoid any potential embarrassment or costly litigation.

This course materials will provide you with everything you need to effectively develop the skills of hiring managers within your organization. They will be taken through the full process of recruitment; developing a wide understanding of the requirements of an effective recruitment campaign in order to help them provide a robust approach to recruitment that helps secure the right candidate for the role.

Why is taking this recruitment skills training a good idea?

Well, just imagine if you were better able to:

Present the company as a professional organization that anyone would want to work for.
Consider legislation and best practice to ensure the recruitment process is fair, robust and fit for purpose.
Create a positive work environment through the introduction of employees that have a range of skills and experience.
Provide a fair assessment and selection process that identifies the best candidate and demonstrates evidence.
Improve their behavioral and situational questioning skills to make interview conversations effective.
Simply apply core recruitment skills, for overall organizational success.
Ultimately this training allows you to develop a managers approach to recruitment, making them better able to effectively recruit the right employees for a role and consequently assist the organization in meeting its business targets.
This Recruitment Skills training will help you to develop your recruitment skills and ensure they are able to effectively attract the best employees into the organization. You will learn how to manage the recruitment process from end to end, managing the relationship with the candidate effectively, performing effective assessment and selection with evidence to support it – all while selling the role and organization.

Course Topics:

Aims of a Recruitment Campaign – Defining what we want to achieve from a recruitment campaign. To ensure we identify the best candidate for the role, minimize the time spent on recruiting, while keeping within legislation requirements. This includes a review of the key tasks required throughout a recruitment campaign.

Recruitment as a Manager’s Responsibility – Identifying the challenges, concerns and benefits of being a hiring manager. Looking at how to overcome any issues or fears the manager may have and establishing the key components of an effective recruitment campaign. This includes a review of a to-do list of recruitment responsibilities.

The Law and Best Practice – An overview of the legislation for equality, how this affects recruitment and how to ensure individuals are neither discriminated against or overlooked. Ensuring the recruitment campaign is fair, robust and fit for purpose, catering for all needs and that evidence is maintained at every stage to demonstrate compliance.  Highlighting the difference between best practice and the law.

Defining the Role – Starting the recruitment process off on the right foot by effectively defining the role through the Job Description and Person Specification – setting the basis for making the process fair, robust and fit for purpose. Including our organizational values within this framework.

A Brief History of Interviewing – A review of how recruitment has progressed. Looking at; Recruiting for the ‘right fit’, Competency Based Recruiting and Value Based Interviewing. Exploring the benefits and pitfalls of each and how to ensure we use the right approach.

Making Improvements Without Increasing Workload – Including value related behaviors in the person specification that helps ease the recruitment process and helps improve your ability to select the person with that best suits the role.

Advertising – Attracting Candidates – Creating a good job advert that is tailored to the role and the target audience. Being able to sell the role while being honest and fair.

Assessment and Selection – Establishing the importance of this part of the process while identifying the best type of assessment methods for different roles. Highlighting the importance of gathering evidence throughout assessments.

Telephone Interview – Identifying the benefits of telephone interviews, when to use them and how best to approach the task. Includes a telephone interview template.

The Interview – Determining what you want to get out of an interview. Includes the key components below.

Interview Preparation – The main elements to cover prior to running an interview

The WASP Technique – A clear interview structure, explained in detail

The key elements of an interview  Explaining the Role, Work History etc.

Interview Questions – An understanding of the general questions you should ask, moving on to Structured, Competency based questions that focus on Behavioral and Situational questions. Exploring these with an in-depth activity.

Selling the Opportunity and the Organization – Developing an approach to appealing to the candidate and showing the organization in a good light. Making the candidate want to work for you.

Closing Questions and Parting – Asking vital questions that will determine the deal breakers for the candidate and ensure both you and the candidate leave the interview knowing all the facts.

Capturing the Evidence – Ensuring you have delivered a fair and effective interview by gathering relevant data and including this in your interview notes.

Getting the Most Out of an Interview – An activity that provides participants with the opportunity to test their ability to identify key data from an interview and assess a candidate's suitability for the role. establishing any discrepancies, contradictions or issues during interviews with candidates.

This Recruitment Skills course is interactive and engaging with activities and exercises throughout.

Course Feature:

At the end of this recruitment skills training, you will be able to:

Describe the concepts behind delivering an effective, fair and robust recruitment campaign that is fit for purpose
Define best practice and the legislation surrounding recruitment
Explain the options available when running a campaign
Confidently make independent recruitment decisions
Effectively recruit, assess, filter and place candidates

Certification:

Once after the training you receive course completion certificate from Mangates

Who can Attend?

Anybody who is interested in learning Recruitment Skills.

Recruitment Skills 1 Day Workshop in Stirling

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session

Course Overview:
This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.
Course Contents:
Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.
Course Topics:
Qualities of an Effective Leader – Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.
Leader or Manager? – Establishing the difference between the two and comparing themselves to those qualities.
That Vision Thing – Making the business vision ‘live’ for the team by answering key questions.
Developing Your Team Goals – Reviewing an action plan that develops clear goals for their team based on the business vision.
Motivation – Determining the ‘Why’ for their staff and developing an understanding of emotions in a business context.
What Motivates? – Looking at specific motivators for individuals and understanding that everyone is motivated by different things.
Being Consistently Different – Going against popular leadership theory and identifying that each staff member needs to be treated differently.
Dealing With Difficult Team Members – Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that ‘difficult’ behavior sometimes has its benefits.
Coaching – Using a simple method of coaching, including action plans.
Three Key Skills of Coaching – Looking at the skills required to be an effective coach.
Instant Results Coaching – Coaching in a hurry!
Can Do Coaching Practice – Putting the learning into practice
Course Feature:
By the end of this training you will be able to:
Explain the qualities of an effective leader
Benchmark themselves against those qualities and develop actions to improve
Explain the difference between leading and managing
Explain the value of sharing the business vision with the team
Develop team goals based on the business vision
Motivate their staff by understanding their drivers and developing actions to support them
Deal with difficult staff members
Challenge staff in a meaningful and effective way
Coach staff effectively using a simple process
Certification:
Once after the training you receive course completion certificate from Mangates.
Who can Attend?
Anybody who is interested in Learning Effective Skills to Lead a Team.

Leading Effective Teams 1 Day Workshop in Stirling

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session

Course Overview:
We all know an angry face when we see one. Anger is such a universal and powerful emotion that can make you physically and emotionally ill, sap your energy and poison your relationships or it can motivate you to make needed changes and add vitality to your life. This training program aims to help you adopt a more constructive attitude towards your anger and to more effectively manage anger in others as well. Practical activities and tools that will empower those who act out their anger in negative ways to gain better control of their anger and their lives and use it as a tool to motivate and empower them to affirm their integrity or boundaries. The program will encourage participants to look deep inside to explore the roots of their anger and present alternatives to the old ways of thinking and dealing with anger.
Target Audience:
Anybody who is interested in learning Anger Management Skills.
Learning Objectives:
By the end of this training course participants will be able to:
Understand both the “Right” skill set and mindset needed to properly manage their anger.
Learn to communicate angry feelings assertively and in ways that will take into account the needs of others.
Adopt a more constructive attitude towards anger and understand the difference between constructive and destructive anger.
Use practical techniques to properly handle anger in others.
Agenda:
Module 1: Anger Anatomy:
Is anger good or bad?
Five famous myths about anger
Having the “Right MindSet” for managing anger
Physical effects of anger
Module 2: The Anger Management Skill Set:
Having the “Right Skill Set” for managing anger.
The 4 deep sources of anger.
The assertive statement to communicate anger.
Rules of assertive behavior.
Module 3: The Anger Management Process:
My personal anger assessment – Self-assessment.
A four-step process to effectively express your anger.
Module 4: Handling Anger in Others:
The importance of listening.
Summarizing and reflecting back what was said.
Reflecting emotions and reframing statements.
Three-step technique for handling anger in others.

Train-The-Trainer 1 Day Training in Stirling

Grantham

The Dangerous Goods Safety Advisor training course is designed for individuals looking to undertake their exams to become a qualified Dangerous Goods Safety Advisor.

Total Compliance provides a comprehensive 5-day training course for Dangerous Goods Safety Advisors (DGSAs), Classroom in-person course or remote online Course. DGSAs play a crucial part in preventing potential risks to individuals, property, and the environment that may arise from the transportation of hazardous materials.

What Does the Course Content Include? The training course encompasses a wide range of topics to equip participants with the necessary knowledge and skills. It includes the following subjects: Core, Road, and All Classes. 
Please note that Rail and Inland Waterways are not covered in this course.
1. Relevant Legislation and Regulations. 
2. Classification and Identification of Dangerous Goods. 
3. Packing, Labelling, and Packaging.
4. Dangerous Goods Documentation. 
5. Environmental Protection.
6. Staff Training Requirements.
7. Vehicle Marking.
8. Legalities and Responsibilities of DGSA.

Benefits of Attending the DGSA Training:
1. Preparation for Dangerous Goods Safety Adviser Examinations.
2. Ensuring Regulatory Compliance.
3. Equipping Attendees to Safeguard their Company.
4. Enhanced Safety and Risk Reduction
5. Fulfilling Legal Responsibilities.
How Long is the Course?
Dangerous Goods Safety Advisor Training is 5 days, arrival for 8.30am each day and starting by 9am each day. Lunch and refreshments are included. 

What Do You Need to Know?
You can find out more about the syllabus of the course by using this link https://www.dgsafetyadvisers.org.uk/DGSA/Home 

Provided on the course: 
Carriage of Dangerous Goods: Approved Derogations and Transitional Provisions April 2012 Carriage of Dangerous Goods and Use of Transportable Pressure Equipment Regulations 2009 Carriage of Dangerous Goods and Use of Transportable Pressure Equipment (Amendment) Regulations 2011 Dangerous Goods Emergency Action Code List 2023


Exams information: 
Candidates have to pass three subject papers within a 12-month period but can re-sit within that time if required and other subject passes would still count.

Exam Dates: 
Exam Dates	Enrolment Open Dates	Enrolment Closing Dates
12 September 2024	14 June 2024	22 August 2024
21 November 2024	13 September 2024	07 November 2024
06 March 2025	22 November 2024	13 February 2025
12 June 2025 	07 March 2025	22 May 2025
11 September 2025 	13 June 2025	21 August 2025
20 November 2025	12 Sept 2025	06 November 2025

Exams can be booked at the following locations: 
Aberdeen (C132)
Basingstoke (C176)
Belfast (C141)
Birmingham (C120)
Bolton (C170)
Bristol (C175)
Hull (C166)
Manchester (C171) 
Middlesbrough (C135)
Northampton (C167)
Stirling (C137)
Exams can be booked by Total Compliance (non-refundable or transferable) - 1 subject - £130 2 subjects - £240 3 subjects £320 4 subjects £430
To avoid additional course booking fees, please contact our training department who can book you in directly. 
Course Location: 28 Market place, Floor 2, Grantham, Lincolnshire NG31 6LR (Remote classroom option available too) 
For more information about this course or if you would like to book in, please email: training@totalcompliance.co.uk or Call: 0345 9001312

Please review our Terms and Conditions for more information.

Total Compliance 

Driving & Vehicles

Compliance & Safety

Dangerous Goods

Dangerous Goods Safety Advisor

Dangerous Goods Safety Advisor (DGSA) Course Sept 2025

General Admission

Shrewsbury

Making genuine silver jewellery is easier than you think. Come and find out how and take home your own gorgeous silver pieces (that is purer than Stirling Silver). You will learn at least two techniques and come away with 2-4 pieces depending on what you choose to make. With a wide variety of options from necklaces to cufflinks the hardest bit will be choosing which lovely piece to make!There is a maximum of 4 students per course so there will be lots of help and time to create your beautiful pieces. Bigger groups can be accommodated at a larger studio close by.

Making genuine silver jewellery is easier than you think. Come and find out how and take home your own gorgeous silver pieces (that is purer than Stirling Silver). You will learn at least two techniques and come away with 2-4 pieces depending on what you choose to make. With a wide variety of options from necklaces to cufflinks the hardest bit will be choosing which lovely piece to make!
There is a maximum of 4 students per course so there will be lots of help and time to create your beautiful pieces. Bigger groups can be accommodated at a larger studio close by.



Rachel Ellen

 If you're looking for a new skill to master, look no further.

This silver clay workshop is the perfect way to spend a morning learning a new skill and having a blast in the process. During this workshop, you'll learn how to roll, cut, add texture, fire, and finish your piece. You'll be able to take your pieces home on the same day!

You'll leave with something truly unique—and have had an exciting experience learning something new.

Beginner Silver Clay Workshop - One to One - 3 Hours

Certificate: Course Completion Certificate | Language: English

Duration: 1 Day | Credits: 8 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course Contents:

In a survey carried out amongst experienced, middle and senior executives, designed to determine the things that they feared most, public speaking came out as number one. Death was eighth on the list! So, most of us would rather die than stand up and present!
This session will provide you with the ideas and techniques to help them feel more confident about presenting, and will help you to become an effective presenter.

Course Topics:

Problems and fears with Presentations – Looking at the past problems delegates have felt and seen with presentations. What their fears are and their likes and dislikes of presenting.

Qualities of an Effective Presenter – Identifying what makes a presenter good and analysing the skills required.

Planning a Presentation – Key considerations when planning a presentation and planning around the audience.

Structuring Your Presentation – Considering the attention span of an audience and structuring the session around this. Using the ‘Communicating to Convince’ model to structure the presentation.

Opening Attention Grabbers – How to start a session with a bang.

Using Visual Aids – The do’s and don’ts regarding visual aids and making them effective.

Presentation Models and Tools – Identifying alternatives to PowerPoint.

Presentation style – Considering their style, including; mannerisms, gestures, eye contact, voice and nerves.

Presentation Practice – A chance to test their presenting skills and provide feedback in a safe environment.

Course Feature:

At the end of this presentation skills training course you will be able to:

Plan a presentation keeping the audience in mind
Develop clear objectives for their presentation
Use ‘attention grabbers’ to enhance their opening
Develop effective visual aids
Use several different methods and tools for presenting
Use positive presentation style behaviours
Practice their skills of presenting

Certification:

Once after the training you receive course completion certificate from Mangates

Who can Attend?

Anybody who is interested in learning Presentation Skills.

Presentation Skills 1 Day Workshop in Stirling

Course ObjectivesAt the end of this course you will be able to:<ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul>'Customer Feedback<ul><li>Best Training Ever!</li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</li><li>Marving Lopez - AM Best Europe</li></ul><ul><li>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</li><li>Darren Barkey - Direct Wines</li></ul><ul><li>Great content and learnt a lot. Really enjoyable :)</li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul>1 year email support serviceTake a closer look at the consistent excellent feedback visiting our site ms-officetraining co ukWith more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses.Tailored In Company training:You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.Advanced Functions<ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul>Analysing Data<ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul>PivotTables<ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul>Formula auditing<ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul>Data Validation<ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul>Consolidation<ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul>Outline (group) data in a worksheet<ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul>Connect external data to your workbook<ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul>Working with Form Controls; Buttons, Option Buttons and Scroll BarsIntroduction to Macros<ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
 
 Who is this course for?
 
 <div>Who is this course for?</div>
 </h2>

 <div id="who_is_this_course_for">
 This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.
 </div><h2>
 
 Requirements
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 Preferably, delegates should have attended the Excel Intermediate course.
 </div><h2>
 
 Career path
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 Excel know-how can instantly increase your job prospects as well as your salary.80 percent of job openings require spreadsheet and word-processing software skills
 </div><h2>
 
 Certificates
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>Certificate of completion</h4>
 
 Digital certificate -
 Included
 

 </div>

Course Objectives
At the end of this course you will be able to:
Work with advanced lookup and reference functions
Create macros to automate common tasks
Use advanced techniques to analyse data
Create PivotTables and PivotCharts
Work with data validation tools
Import and export data
'
Customer Feedback
Best Training Ever!
Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.
Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All
The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.
Marving Lopez - AM Best Europe
Pedro was excellent. Very knowledgeable, clear and great rapport with class.
Darren Barkey - Direct Wines
Great content and learnt a lot. Really enjoyable :)
Kristie-Lee Ryan - Stirling Ackroyd
1 year email support service
Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses.
Tailored In Company training:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.
Advanced Functions
COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL
IF, OR, AND, IFERROR
VLOOKUP to lookup Exact Values and Approximate values
MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET
Analysing Data
PMT function to calculate a monthly payment of a loan
What If Analysis using Goal Seek
Use scenarios to consider many different variables
Using Solver Add-in to optimize variables
PivotTables
Create a PivotTable to analyse worksheet data
Add or remove fields in a PivotTable
Change the data source for a PivotTable
Working with external data sources
Using different Statistical Functions
Calculate a Running Total, % of Grant Total, Difference From…
Using the Slicer and Timeline to filter the PivotTable
Using Filters in a PivotTable
Group by Date, Auto Group by ranges of values, Custom Group
Create a PivotChart
The GETPIVOTDATA function
Formula auditing
Precedents and dependents
Error checking
Watch a formula and its result by using the Watch Window
Evaluate a nested formula one step at a time
Data Validation
Number Validation
Data List Validation
Message Prompts and Alerts
Conditional Data Validation
Data Validation Errors
Consolidation
Consolidate data by position
Consolidate data by category
Use a formula to consolidate data
Outline (group) data in a worksheet
Create an outline of rows
Create an outline of columns
Copy outlined data
Hide or remove an outline
Connect external data to your workbook
Using the Power Query Editor to import data
From Text and CSV, From Access, From Web, From another Workbook
Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.
Deleting Applied Steps
Refreshing your data
Working with Form Controls; Buttons, Option Buttons and Scroll Bars
Introduction to Macros
Change Macro Security settings
How to Record a macro
Some Macro Examples
Delete a macro
Edit the macro to view the VBA code
Copy part of a macro to create another macro
Assign a macro to a button
 Who is this course for? Who is this course for? 
This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.
 Requirements Requirements 
Preferably, delegates should have attended the Excel Intermediate course.
 Career path Career path 
Excel know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
 Certificates Certificates 
Certificate of completion
 Digital certificate - Included 

Microsoft Office Training

Microsoft Power BI

Excel Analytics

Access VBA

Microsoft Excel

Microsoft Office

Microsoft Access

Microsoft Excel Advanced

London

Course ObjectivesAt the end of this course you will be able to:<ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul>'Customer Feedback<ul><li>Best Training Ever!</li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</li><li>Marving Lopez - AM Best Europe</li></ul><ul><li>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</li><li>Darren Barkey - Direct Wines</li></ul><ul><li>Great content and learnt a lot. Really enjoyable :)</li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul>1 year email support serviceTake a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co ukWith more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.<ul><li>Our competitive rates start from £550.00 per day of training</li></ul>Tailored training courses:You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.Advanced Functions<ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul>Analysing Data<ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul>PivotTables<ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul>Formula auditing<ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul>Data Validation<ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul>Consolidation<ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul>Outline (group) data in a worksheet<ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul>Connect external data to your workbook<ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul>Working with Form Controls; Buttons, Option Buttons and Scroll BarsIntroduction to Macros<ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
 
 Who is this course for?
 
 <div>Who is this course for?</div>
 </h2>

 <div id="who_is_this_course_for">
 This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.
 </div><h2>
 
 Requirements
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 Preferably, delegates should have attended the Excel Intermediate course.
 </div><h2>
 
 Career path
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 Excel know-how can instantly increase your job prospects as well as your salary.80 percent of job openings require spreadsheet and word-processing software skills
 </div><h2>
 
 Certificates
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>Certificate of completion</h4>
 
 Digital certificate -
 Included
 

 </div>

Course Objectives
At the end of this course you will be able to:
Work with advanced lookup and reference functions
Create macros to automate common tasks
Use advanced techniques to analyse data
Create PivotTables and PivotCharts
Work with data validation tools
Import and export data
'
Customer Feedback
Best Training Ever!
Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.
Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All
The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.
Marving Lopez - AM Best Europe
Pedro was excellent. Very knowledgeable, clear and great rapport with class.
Darren Barkey - Direct Wines
Great content and learnt a lot. Really enjoyable :)
Kristie-Lee Ryan - Stirling Ackroyd
1 year email support service
Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.
Advanced Functions
COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL
IF, OR, AND, IFERROR
VLOOKUP to lookup Exact Values and Approximate values
MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET
Analysing Data
PMT function to calculate a monthly payment of a loan
What If Analysis using Goal Seek
Use scenarios to consider many different variables
Using Solver Add-in to optimize variables
PivotTables
Create a PivotTable to analyse worksheet data
Add or remove fields in a PivotTable
Change the data source for a PivotTable
Working with external data sources
Using different Statistical Functions
Calculate a Running Total, % of Grant Total, Difference From…
Using the Slicer and Timeline to filter the PivotTable
Using Filters in a PivotTable
Group by Date, Auto Group by ranges of values, Custom Group
Create a PivotChart
The GETPIVOTDATA function
Formula auditing
Precedents and dependents
Error checking
Watch a formula and its result by using the Watch Window
Evaluate a nested formula one step at a time
Data Validation
Number Validation
Data List Validation
Message Prompts and Alerts
Conditional Data Validation
Data Validation Errors
Consolidation
Consolidate data by position
Consolidate data by category
Use a formula to consolidate data
Outline (group) data in a worksheet
Create an outline of rows
Create an outline of columns
Copy outlined data
Hide or remove an outline
Connect external data to your workbook
Using the Power Query Editor to import data
From Text and CSV, From Access, From Web, From another Workbook
Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.
Deleting Applied Steps
Refreshing your data
Working with Form Controls; Buttons, Option Buttons and Scroll Bars
Introduction to Macros
Change Macro Security settings
How to Record a macro
Some Macro Examples
Delete a macro
Edit the macro to view the VBA code
Copy part of a macro to create another macro
Assign a macro to a button
 Who is this course for? Who is this course for? 
This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.
 Requirements Requirements 
Preferably, delegates should have attended the Excel Intermediate course.
 Career path Career path 
Excel know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
 Certificates Certificates 
Certificate of completion
 Digital certificate - Included 

Office Skills & Productivity

Microsoft Excel Advanced - In-company

<div>
									<section>
						<div>
					<div>
			<div>
								<div>
				<div>
							Number Theory Basics is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Number Theory Basics and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills.Consisting of several modules, the course teaches you everything you need to succeed in this profession.The course can be studied part-time. You can become accredited within 9 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website.						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3>Why Choose Teachers Training</h3>		</div>
				</div>
				<div>
				<div>
			Some of our website features are:		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										This is a dedicated website for teaching
									</li>
								<li>
											
													
										24/7 tutor support
									</li>
								<li>
											
													
										Interactive Content
									</li>
								<li>
											
													
										Affordable price
									</li>
								<li>
											
													
										Courses accredited by the UK's top awarding bodies
									</li>
								<li>
											
													
										100% online 
									</li>
								<li>
											
													
										Flexible deadline
									</li>
						</ul>
				</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3> Entry Requirements
</h3>		</div>
				</div>
				<div>
				<div>
			No formal entry requirements. You need to have:		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										Passion for learning
									</li>
								<li>
											
													
										A good understanding of the English language
									</li>
								<li>
											
													
										Be motivated and hard-working
									</li>
								<li>
											
													
										Over the age of 16.
									</li>
						</ul>
				</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3>Certification</h3>		</div>
				</div>
				<div>
				<div>
							CPD Certification from The Teachers TrainingSuccessfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.<ul><li>You can get your digital certificate (PDF) for £4.99 only</li><li>Hard copy certificates are also available, and you can get one for only £10.99</li><li>You can get both PDF and Hard copy certificates for just £12.99!</li></ul>The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
							</div><table width="100%">				<tbody><tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Number Theory</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Basics of Number Theory</td>
				</tr>
								<tr>
					<td></td>
					<td>Number Theory</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Number Sets</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Number Patterns</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Even &amp; Odd Numbers</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Number Properties</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Proofs</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Number Bases</td>
				</tr>
								<tr>
					<td></td>
					<td>Number Bases</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Binary Base</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Binary Arithmetics</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hexadecimal Base</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hexadecimal Arithmetics</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td colspan="4">Factorials</td>
				</tr>
								<tr>
					<td></td>
					<td>Factorial</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Double Factorial</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Super Factorial</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Exponential Factorial</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Factorion</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stirling's Formula</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Number of Digits</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Divisibility</td>
				</tr>
								<tr>
					<td></td>
					<td>Divisibility</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Divisibility Rules</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Euclidean Division Theorem</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>GCD &amp; LCM</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>BÃ©zout's Identity</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Perfect Numbers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Practical Numbers</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Amicable Numbers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Fibonacci Sequence</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Tribonacci Sequence</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Golden Ratio</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Primes</td>
				</tr>
								<tr>
					<td></td>
					<td>Prime Numbers</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Fundamental Theorem of Arithmetics (FTA)</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Almost Primes</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prime Powers</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Factorial Prime</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Euclid's Theorems</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Prime Number Theorem</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Unsolved Problems</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Number Empire</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Modular Arithmetic</td>
				</tr>
								<tr>
					<td></td>
					<td>Modular Arithmetics</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Congruence</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Congruence Class</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Residue Systems</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Quadratic Residues</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modular Operations</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Inverses</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modular Exponentiation</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Wilson's Theorem</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Chinese Remainder Theorem</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Fermat's Little Theorem</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Euler's Totient Function</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Euler-Fermat Theorem</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Continued Fractions</td>
				</tr>
								<tr>
					<td></td>
					<td>Continued Fractions</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Negative Continued Fractions</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Finite Continued Fractions</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Infinite Continued Fractions</td>
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Periodic Continued Fractions</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Convergent</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Cryptography</td>
				</tr>
								<tr>
					<td></td>
					<td>Cryptography</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Early Ciphers</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Public Key Cryptography</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>RSA Encryption</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Diffie-Hellman Protocol</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Resources</td>
				</tr>
								<tr>
					<td></td>
					<td>Resource - An Introduction to Number Theory</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
				</tbody></table>

Number Theory Basics is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Number Theory Basics and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills.
Consisting of several modules, the course teaches you everything you need to succeed in this profession.
The course can be studied part-time. You can become accredited within 9 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website.
Why Choose Teachers Training
Some of our website features are:
This is a dedicated website for teaching
24/7 tutor support
Interactive Content
Affordable price
Courses accredited by the UK's top awarding bodies
100% online
Flexible deadline
 Entry Requirements

No formal entry requirements. You need to have:
Passion for learning
A good understanding of the English language
Be motivated and hard-working
Over the age of 16.
Certification
CPD Certification from The Teachers Training
Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.
You can get your digital certificate (PDF) for £4.99 only
Hard copy certificates are also available, and you can get one for only £10.99
You can get both PDF and Hard copy certificates for just £12.99!
The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.
Introduction			
	What is Number Theory		00:08:00
Basics of Number Theory			
	Number Theory		00:07:00
	Number Sets		00:09:00
	Number Patterns		00:10:00
	Even & Odd Numbers		00:11:00
	Number Properties		00:10:00
	Proofs		00:11:00
Number Bases			
	Number Bases		00:12:00
	Binary Base		00:12:00
	Binary Arithmetics		00:15:00
	Hexadecimal Base		00:13:00
	Hexadecimal Arithmetics		00:14:00
Factorials			
	Factorial		00:05:00
	Double Factorial		00:09:00
	Super Factorial		00:03:00
	Exponential Factorial		00:03:00
	Factorion		00:05:00
	Stirling's Formula		00:03:00
	Number of Digits		00:03:00
Divisibility			
	Divisibility		00:07:00
	Divisibility Rules		00:04:00
	Euclidean Division Theorem		00:08:00
	GCD & LCM		00:11:00
	BÃ©zout's Identity		00:08:00
	Perfect Numbers		00:04:00
	Practical Numbers		00:05:00
	Amicable Numbers		00:04:00
	Fibonacci Sequence		00:09:00
	Tribonacci Sequence		00:05:00
	Golden Ratio		00:11:00
Primes			
	Prime Numbers		00:09:00
	Fundamental Theorem of Arithmetics (FTA)		00:10:00
	Almost Primes		00:07:00
	Prime Powers		00:02:00
	Factorial Prime		00:03:00
	Euclid's Theorems		00:09:00
	The Prime Number Theorem		00:04:00
	Unsolved Problems		00:06:00
	Number Empire		00:07:00
Modular Arithmetic			
	Modular Arithmetics		00:09:00
	Congruence		00:13:00
	Congruence Class		00:12:00
	Residue Systems		00:04:00
	Quadratic Residues		00:04:00
	Modular Operations		00:06:00
	Inverses		00:07:00
	Modular Exponentiation		00:10:00
	Wilson's Theorem		00:05:00
	Chinese Remainder Theorem		00:09:00
	Fermat's Little Theorem		00:05:00
	Euler's Totient Function		00:07:00
	Euler-Fermat Theorem		00:04:00
Continued Fractions			
	Continued Fractions		00:08:00
	Negative Continued Fractions		00:11:00
	Finite Continued Fractions		00:14:00
	Infinite Continued Fractions		00:17:00
	Periodic Continued Fractions		00:10:00
	Convergent		00:12:00
Cryptography			
	Cryptography		00:09:00
	Early Ciphers		00:11:00
	Public Key Cryptography		00:13:00
	RSA Encryption		00:11:00
	Diffie-Hellman Protocol		00:04:00
Resources			
	Resource - An Introduction to Number Theory		00:05:00

44 Courses

The Ultimate Guide to Event Planning - 1 Day Workshop in Stirling

By Mangates

Master Business Networking in Just 1 Day - Join our Workshop in Stirling

By Mangates

The Art of Staying Calm: Anger Management in Action 1 Day Workshop in Stirling

By Mangates

Construction Project Manager 2 Days Training in Stirling

By Mangates

Recruitment Skills 1 Day Workshop in Stirling

By Mangates

Leading Effective Teams 1 Day Workshop in Stirling

By Mangates

Train-The-Trainer 1 Day Training in Stirling

By Mangates

Dangerous Goods Safety Advisor (DGSA) Course Sept 2025

By Total Compliance

Beginner Silver Clay Workshop - One to One - 3 Hours

By Rachel Ellen

Presentation Skills 1 Day Workshop in Stirling

By Mangates

Search By Location