• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

21702 Courses

Appointment setting (In-House)

By The In House Training Company

This course has a simple objective: to help gain appointments with potential clients. In most consultative selling situations clients won't commit to purchases over the telephone. This means setting up a meeting to discuss the options with them face-to-face. But getting 'face time' can be tricky. This practical workshop can help. Participants will acquire essential tools, skills and methods; discuss specific organisational issues; and identify areas for improvement. They will discover how to: Increase their effectiveness through proper preparation Construct attention-grabbing opening statements Help potential clients feel comfortable agreeing to a meeting Develop tactics for responding to difficult excuses and objections Stress the benefits of a face-to-face consultation Develop and enhance their questioning and listening skills Prevent customers cancelling booked appointments 1 Introduction to appointment setting Key trends that have changed the way people buy today - and will buy tomorrow Why many sales people avoid picking up the phone The difference that makes a difference - what makes a good appointment-maker? 2 Before you pick up the telephone It all starts with a plan... Who and what to focus our attention How much research should we undertake and why? Setting primary and secondary objectives 3 Making your approach Key considerations Every call is an opportunity - creating a positive mind-set Using a structured approach Using partnership language 4 Gaining an insight into the customer's needs How to quickly 'tune in' to your customers, so that you can serve them more easily Developing speech patterns that put customers at their ease Using effective questioning and listening skills Finding and building pain points 5 Dealing with excuses and objections Pre-empting potential excuses Developing techniques for responding to client objections Keeping the door open for future contact 6 Securing the appointment Selling the benefits of a consultancy meeting Techniques for avoiding cancelled appointments Gaining commitment 7 Action plans Course summary and presentation of action plans

Appointment setting (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Introduction to contract management (In-House)

By The In House Training Company

This very practical one-day IACCM-approved programme enables participants to manage the process of commercial contracting and contract management effectively and efficiently to ensure value for money, improved service, and appropriate relationships. It covers a wide range of contract types in terms of risk and value. The programme empowers participants with the tools and techniques needed to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the total process of managing contracts Exploit opportunities to extract even more added value Develop appropriate relationships with contractors Understand and use a range of contracting strategies and options Measure and improve contract performance Understand the impact of legislation on contract performance 1 Welcome Introductions Aims and objectives Plan for the day 2 Contract management An overview of the contracting process, mapping the 'territory' 3 Contract managers Skills Knowledge Attributes Responsibilities 4 Critical success factors Defining successful outcomes Effective stakeholder engagement Creating a shared vision of the outcomes 5 Placing contracts How to develop an effective specification and scope of work documents How to develop a robust contracting strategy Appropriate types of contract 6 Customers and stakeholders Customer and stakeholder analysis Managing expectations and the 'shared vision' concept to ensure customer co-operation, satisfaction, and delight 7 Working with suppliers Creating and developing commercial relationships Types of relationship How to manage difficult relationships Contractor motivational issues How to use incentives 8 Negotiation and related skills Introduction to key negotiation skills Persuading and influencing skills to work with stakeholders to improve outcomes for all 9 Dealing with change Claims and variations How to challenge contractor claims and requests for variations by making use of contractual terms Specifications to prevent false claims 10 Performance improvement How to measure and improve contractor performance Developing KPI systems Using contractual terms and conditions and basic legal principles 11 Contract close The importance of effective contract close processes 12 Close Review of key learning points Personal action planning

Introduction to contract management (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Word - introduction (In-House)

By The In House Training Company

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document

Word - introduction (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

BSc (Hons) Early Childhood Studies Top-Up - Inclusive of Level 4 and 5 Pathway Diploma

By School of Business and Technology London

Getting Started The BSc in Early Childhood Studies programme provides a comprehensive education on child development, education, and care. It equips students with the knowledge and skills necessary to work effectively with young children and their families in various educational and childcare settings. This programme establishes a strong foundation for early childhood education and advocacy careers. The BSc (Hons) Early Childhood Studies programme delivers a dynamic educational experience for students aspiring to engage in early childhood education and development. This undergraduate degree programme strongly emphasises comprehending the critical stages of early childhood, spanning from infancy to primary school age. It delves into the multitude of factors that influence a child's growth and learning. Throughout the programme, students are exposed to a wide array of topics, including child psychology, early education pedagogy, child health and well-being, and the socio-cultural influences on early childhood development. The curriculum is thoughtfully crafted to nurture a deep understanding of the unique needs and challenges faced by young children and their families, equipping graduates with the knowledge and skills necessary to impact the field positively. Anglia Ruskin University's BSc (Hons) Early Childhood Studies programme offers a supportive learning environment with experienced faculty and access to cutting-edge research. Graduates from this programme are well-prepared for a diverse range of career opportunities in early childhood education, social services, child advocacy, and more. It serves as a solid foundation for individuals passionate about nurturing and shaping the future of our youngest learners. The programme comprises two phases; the first is the Qualifi Level 4 and 5 Diploma in Early Learning and Childcare, awarded by Qualifi and delivered by the School of Business and Technology London. The second phase is the BSc (Hons) in Early Childhood Studies Top Up, awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Assignments and Project No examinations Entry Requirements A Level or Equivalent Minimum 1 Year of experience in Early Learning and Childcare. Further, candidates are also required to demonstrate their English language proficiency. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase 1 - Qualifi Level 4 and 5 Diploma in Early Learning and Childcare Programme structure Level 4 The Qualifi Level 4 Diploma in Early Learning and Childcare comprises 9 units. To obtain the Diploma, learners must complete all mandatory units, earning 34 credits. Additionally, they should select at least 6 credits from the optional units. A total of 40 credits is necessary for Diploma completion, along with at least 30 hours of teaching practice. Mandatory units:  Child development and enabling children to learn Reference No: J/650/0974 Credit: 9 || TQT: 90 This unit aims to equip learners with a comprehensive understanding of diverse early years pedagogical approaches influencing holistic learning in babies and children aged from birth to five years. It delves into local statutory planning and monitoring requisites. Learners will also explore leadership, mentoring, and managerial skills. The unit emphasises comprehending how babies and young children learn and translating theory into practical application. Additionally, it examines developmental disparities, the potential for developmental delays, the impacts of transitions, and how children learn in various environments. It empowers learners with proficiency in utilising observation, Assessment, and planning to foster children's development. To demonstrate their assimilated knowledge, learners must integrate it into their day-to-day responsibilities with children aged from birth to five years and document practice modifications in their setting via a portfolio. Physical activity and nutrition co-ordination (PANCo) in early years Reference No: K/650/0975 Credit: 6 || TQT: 60  In this unit, learners will grasp the advantages of physical activity and the significance of a balanced diet for the health and well-being of babies, children, and their families. They should consider statutory framework mandates and national, local, and international initiatives, advice, and perspectives relevant to health and well-being.  Supporting children with additional needs Reference No: J/650/0992 Credit: 4 || TQT: 40 This unit endeavours to enhance the leadership and management capabilities of the Special Educational Needs Coordinator (SENCO) in effectively guiding best practices for children with Special Educational Needs and Disabilities (SEND) and their families. Partnership working in early years settings Reference No: L/650/0976 Credit: 6 || TQT: 60 This unit seeks to assist learners in comprehending the legal obligations associated with collaborating with families. It emphasises the positive impact of effective partnerships with other professionals on the well-being and development of babies and children. Learners will also delve into the varied needs of families and strategise ways to surmount potential obstacles to successful partnership working. Implementing and evaluating change through a research project Reference No: M/650/0977 Credit: 6 || TQT: 60 This unit mandates learners to devise, execute, and assess change about a chosen theme, accomplished through a modest research endeavour. Learners will also grasp the ethical considerations integral to research. The chosen theme, subject to agreement with the assessor, enables learners to introspect on their practices, employ current research to propose enhancements within their setting, put these proposals into action, and report on their outcomes. Legal requirements in Childcare Reference No: R/650/0978 Credit: 3 || TQT: 30 This unit encompasses the necessary knowledge and understanding regarding health and safety, equality and inclusion, the Welfare Requirements of the Early Years Foundation Stage, Employment Rights, and Special Educational Needs, including Looked Children. It also addresses the preparations for Ofsted inspections, the formulation of policies and procedures, and the utilisation of information to oversee the quality of the setting's practices. Optional Units Assessing and planning for children's changing developmental needs Reference No: T/650/0979 Credit: 6 || TQT: 60 This unit's objective is to equip learners with the knowledge, comprehension, and skills required to conduct observations for assessing and planning for children's evolving developmental needs over an extended duration, commonly referred to as a longitudinal study. The study is to be conducted over six months. Caring for babies Reference No: D/650/0980 Credit: 6 || TQT: 60 This unit fosters the knowledge, understanding, and skills necessary to care for infants aged 0-18 months. Caring for children through play out of school Reference No: F/650/0981 Credit: 6 || TQT: 60 This unit aims to cultivate the knowledge, understanding, and skills required to provide care for children and young people outside of regular school hours and during school holidays. Level 5 The Qualifi Level 5 Diploma in Early Learning and Childcare comprises 10 units. To attain the diploma, learners must finish all mandatory units for 96 credits. Additionally, they must select a minimum of 24 credits from optional units. In total, a minimum of 120 credits must be achieved, along with 100 hours of teaching practice. Mandatory units: Management of children's care Reference No: H/650/0982 Credit: 20 || TQT: 200 This unit aims to provide learners comprehensive knowledge and comprehension of theories, principles, and models pertinent to early learning and childcare. Learners will apply these concepts, deepening their grasp of communication and Assessment in this context. The unit will additionally encompass the utilisation of theories and models for specialised curriculum development and the application of theories and models for reflective practice. Children's well-being and resilience Reference No: J/650/0983 Credit: 26 || TQT: 260  This unit strives to equip learners with the knowledge, understanding, and skills essential for comprehending and nurturing children's well-being and resilience. This encompasses appreciating each child as an individual and ensuring inclusive treatment for all. Positive behaviour in early years Reference No: K/650/0984 Credit: 20 || TQT: 200 This unit's objective is to give learners the necessary knowledge, understanding, and skills for formulating and executing strategies and policies to promote positive behaviour in children. Child development and communication skills in early years Reference No: L/650/0985 Credit: 30 || TQT: 300 This unit aims to enhance learners' comprehension of the anticipated trajectory of children's development and the factors that impact it. Specifically, it seeks to deepen learners' understanding of how children's communication skills progress from birth to 7 years old.   OPTIONAL UNITS Managing children's holistic development in early years Reference No: M/650/0986 Credit: 16 || TQT: 160 The goal of this unit is to enable learners to effectively strategise and oversee the comprehensive development of children, tailored to their specific requirements. Learners will assess strategies for enhancing literacy and numeracy and implement theoretical approaches in their professional practice. Developing children's literacy skills Reference No: R/650/0987 Credit: 16 || TQT: 160 This unit aims to empower learners to foster children's literacy skills. Developing children's mathematical skills Reference No: T/650/0988 Credit: 8 || TQT: 80 This unit aims to enable learners to enhance children's mathematical skills. Safeguarding in early years Reference No: Y/650/0989 Credit: 16 || TQT: 160 This unit aims to cultivate learners' comprehension of the role and extent of safeguarding in early years education and the policies and procedures for enacting safeguarding protocols. Health and safety in the early years Reference No: F/650/0990 Credit: 8 || TQT: 80 This unit aims to foster learners' knowledge and comprehension of the early years education's pertinent health and safety prerequisites. It further aims to equip them with the capability to implement policies and processes related to health and safety. Special Educational Needs and Disability (SEND) in early years Reference No: H/650/0991 Credit: 8 || TQT: 80 This unit seeks to enhance the learner's knowledge and comprehension of the legislation about children with Special Educational Needs and Disabilities (SEND) and the measures in place to address additional needs in early years education.   Phase 2 - BSc (Hons) in Early Childhood Studies Programme structure Early Childhood Leadership and Management Children's Rights Interdisciplinary Perspectives Leading Change in Early Childhood Contexts Early Childhood Graduate Competencies Undergraduate Major Project Delivery Methods The programme comprises two phases; the first is the Qualifi Level 4 and 5 Diploma in Early Learning and Childcare, awarded by Qualifi and delivered by the School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The programme is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the BSc (Hons) in Early Childhood Studies Top Up, awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

BSc (Hons) Early Childhood Studies Top-Up - Inclusive of Level 4 and 5 Pathway Diploma
Delivered OnlineFlexible Dates
Price on Enquiry

Working with Elected Members (In-House)

By The In House Training Company

It is important for Officers to understand the roles and responsibilities, processes and procedures involved when working with Elected Members. They also need to appreciate the significance of Elected Members as the decision-makers in local government. Officers have a responsibility to work and communicate with Elected Members effectively. This very successful course is designed to help Officers with this. Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. To provide managers with the knowledge and understanding they need to have productive working relationships with Elected Members and provide appropriate support. By the end of the course participants will: Understand the roles, responsibilities, processes and procedures in place for working with Elected Members Be able to identify the best way to approach potentially sensitive issues Understand the skills and behaviours required for working effectively with Members Be able to deploy their influencing skills more successfully Review their learning and have an action plan to take back and implement at work Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. 1 Introduction Welcome and introductions Objectives and programme overview 2 Working in a political environment What is political awareness? Contact and experience with Members Importance of the role of Members 3 Why be an Elected Member? Perceptions of what Elected Members are and do Values of Members and their motivations for doing what they do 4 Political decision-making in local government Current challenges and drivers affecting the organisation / the council Roles and responsibilities of Officers and Members Centrality of Members' strategic role 5 (Option) A day in the life of an Elected Member An Elected Member gives a talk about what they do 6 Having a beneficial relationship between Officers and Members 7 Member / Officer communication Discussion of the formal processes, service procedures, etc (whether enshrined in a protocol, Memorandum of Understanding, etc) Response times and requirements Procedures required by Heads of Service [if appropriate] 8 Influencing styles and strategies Different forms of power and how they impact Developing an appropriate 'influencing style' Exploring strategies for improving communication and influencing at work 9 Review and evaluation Review and evaluation of learning Personal action plans

Working with Elected Members (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Project management made easy! (In-House)

By The In House Training Company

Project management can seem scary and rather intimidating. The whole aim of this programme is to give people a simple and straightforward way of dealing with projects without having to use complex and confusing systems. This two-day course is designed to introduce the apparently complex world of project management in a simple and practical manner. The programme is for anybody who has to run a project of any nature. It has been attended by people from as diverse fields as events management, fashion, charities, oil companies and so on. The programme is run without using any IT project management systems although an introduction can be given if required. At the end of the programme participants will leave understanding: What a project is and why projects are so important today The roles of a project manager Some key language and concepts A simple 5-step model for organising projects How to make sure you understand what your 'client' really wants A set of three simple tools to plan the project How to make decisions What to monitor when the project is running How to close the project 1 Introduction What is the aim of this programme? 2 Background thinking What is a project? The project manager's eternal triangle (cost-quality-time) What are the characteristics of successful projects? Who are the key characters in a project? What are the roles of a project manager? 3 The project process Why have one? 4 Project initiation What is the aim? Identifying key information Key skill: mission analysis Initial risk analysis Document and sign-off 5 Decision-making - 'Stop, Think, Act!' The 'Stop, Think, Act!' technique Recognise the opportunity to make a decision The 3 Cs - making sure we understand the decisions we have to make Identifying options Making your decision Taking it to action 6 Creativity 7 The planning stage Identify all discrete tasks Sequence and dependencies Time line - critical path Resources Project base-line 8 Execution stage - delivering the result Monitor Evaluate Adapt Control Review 9 The project close Review Documentation Have we delivered? What have we learned?

Project management made easy! (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Sales awareness for IT professionals (In-House)

By The In House Training Company

In the fast-changing world of business, and especially IT, everyone in the organisation should be involved in sales. One of the best ways is to give the customer an outstanding experience. The customer experience is the competitive battlefield of today. Sales may be won or lost here. You can either close a sale for a quick buck, or open a long-term relationship to create a high lifetime value customer. By developing excellent communication skills, rapport and, most of all, a desire to serve and listen to the needs of the customer to the best of their ability, both sales teams and other IT professionals will create trust, nurture relationships and develop awareness of other opportunities with the customer. By the end of this course, participants will be able to: Understand the power of a positive customer experience in developing sales opportunities Recognise and develop a sales opportunity when it arises Engage with customers and develop rapport and trust Use verbal and non-verbal communication skills and pick up on signals Ask powerful questions - and listen to the answers Create 'magic moments' for the customer Turn a complaint into an opportunity Know when to ask for referrals and testimonials Pass on leads to the relevant people 1 Introduction Aims and objectives Beliefs about sales 2 Building rapport First impressions Short cuts to rapport Finding common interests 3 Selling or serving? Managing emotions and behaviour - Transactional Analysis Moments of truth - creating 'magic moments' Speed sells - the follow-up 4 Meetings Planning a successful meeting Pre-meeting connection and assistance Sales meeting failure reasons Right v wrong mindset 5 Communication - verbal and non-verbal The 3 Vs - Visual, Verbal, Vocal Picking up on signals 7 power questions Questioning techniques LISTEN - 3 types of listening skills 6 Influencing 6 levels of influence Framing to change perspectives Turning complaints into opportunities 7 Referrals The power of referrals How and when to ask for a referral 5 steps from rapport to referral 8 Presentation and pitching (optional session) Basic presentation structure and delivery Creating powerful impressions Creating a 60-second pitch The elevator 10-second pitch - answering 'What do you do?' Sales presentations Emotion v Intellect - how to engage Using visuals

Sales awareness for IT professionals (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Excel - intermediate (In-House)

By The In House Training Company

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Excel - intermediate (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

10 practical ways to save time using ChatGPT and AI tools (In-House)

By The In House Training Company

ChatGPT, along with other AI tools, aims not to replace the human touch in management, but to enhance it. By addressing repetitive, daily tasks, these tools free up managers to concentrate on core responsibilities like strategic decision-making, team development, and innovation. As we move further into the digital age, integrating tools such as ChatGPT isn't a luxury; it's the future of proactive leadership. In this guide, we'll delve into 10 practical ways through which AI can elevate your efficiency and refine the quality of your work. Gain familiarity with prominent AI tools in the market Efficiently compose and respond to emails Generate concise summaries of complex reports and data. Obtain quick insights, data, and research across varied topics Streamline the writing of articles, training notes, and posts Craft interview tests, form relevant questions, and design checklists for the hiring process 1 Streamlining emails An inbox can be a goldmine of information but also a significant time drain for managers. Here's how to optimise it: Drafting responses: Give the AI a brief, and watch it craft a well-structured response. Sorting and prioritising: By employing user-defined rules and keywords, ChatGPT can flag important emails, ensuring no vital communication slips through the cracks. 2 Efficient report writing Reports, especially routine ones, can be time-intensive. Here's a smarter approach: Automate content: Supply key data points to the AI, and let it weave them into an insightful report. Proofreading: Lean on ChatGPT for grammar checks and consistency, ensuring each report remains crisp and error-free. 3 Rapid research From competitor insights to market trends, research is a pivotal part of management. Data synthesis: Feed raw data to the AI and receive succinct summaries in return. Question-answering: Pose specific questions about a dataset to ChatGPT and extract swift insights without diving deep into the entire content. 4 Reinventing recruitment Hiring can be a lengthy process. Here's how to make it more efficient: Resume screening: Equip the AI to spot keywords and qualifications, ensuring that only the most fitting candidates are shortlisted. Preliminary interviews: Leverage ChatGPT for the initial rounds of interviews by framing critical questions and evaluating the responses. 5 Enhancing training Especially for extensive teams, training can be a monumental task. Here's how ChatGPT can assist: Customised content: Inform the AI of your training goals, and it will draft tailored content suitable for various roles. PowerPoint design: Create visually appealing slide presentations on any topic in minimal time.

10 practical ways to save time using ChatGPT and AI tools (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Trade secrets - the business perspective (In-House)

By The In House Training Company

Trade barriers are going up across the globe. And cybercrime is on the increase. The link between the two? The value of trade secrets. As countries become increasingly protectionist as regards international trade, so their IP law has been changing, with the result that companies that previously would have sought protection through patents are opting to go down the trade secret route instead. But is this a high-risk strategy? Technology is changing and this is having an impact on forms of commercial co-operation. Collaborative or open forms of innovation by their very nature involve the sharing of intellectual property (IP), and in many instances this IP is in the form of valuable confidential business information (ie, trade secrets). Little surprise, then, that trade secrets disputes have increased accordingly. At the same time, the changes in technology make trade secrets more vulnerable to attack, misappropriation, theft. So just how effective are the legal protections for trade secrets? How can organisations safeguard the value in their IP (increasingly, the single biggest line in their balance sheets)? This programme is designed to help you address these issues. Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. This session is designed to give you a deeper understanding of: Emerging trends in trade secrets protection and exploitation The current situation in key jurisdictions Recent case law How leading companies are responding The importance of trade secret metadata Different external stakeholders and their interests Key steps for effective protection of trade secrets Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. 1 What are trade secrets? Definitions Examples Comparison with other forms of IP (patents, confidential information, know-how, copyright) 2 Current trends The various changes taking place affecting trade secrets - legal changes, trade wars, cybercrime, technology, commercial practice The current position in the UK, Europe, USA, China, Japan, Russia Corporate best practice 3 Trade secret disputes - how to avoid them Trade secret policies, processes and systems Administrative, legal and technical protection mechanisms The role of employees The sharing of trade secrets with others 4 Trade secret disputes - how to manage them Causes Anatomy of a trade secret court case 'Reasonable particularity' 5 Related issues Insurance Tax authorities and investigations Investor relations 6 Trade secret asset management roadmap Maturity ladder First steps Pilot projects

Trade secrets - the business perspective (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry