6290 Courses

Level 1 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Master data retrieval in Excel with our XLOOKUP and VLOOKUP course. Learn to efficiently find and analyze data, enhancing your spreadsheet skills for better decision-making.

Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.

This five-day programme empowers participants with the skills and knowledge to understand and effectively apply best practice commercial and contracting principles and techniques, ensuring better contractor performance and greater value add. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Practitioner (CCMP) qualification. By the end of this comprehensive programme the participants will be able to: Develop robust contracting plans, including scopes of work and award strategies Undertake early market engagements to maximise competition Conduct effective contracting and commercial management activities, including ITT, RFP, negotiated outcomes Understand the legalities of contract and commercial management Negotiate effectively with key stakeholders and clients, making use of the key skills of persuading and influencing to optimise outcomes Undertake effective Supplier Relationship Management Appreciate the implications of national and organisational culture on contracting and commercial activities Appreciate professional contract management standards Set up and maintain contract and commercial management governance systems Take a proactive, collaborative, and agile approach to managing commercial contracts Develop and monitor appropriate and robust KPIs and SLAs to manage the contractor and facilitate improved contractor performance Appreciate the cross-functional nature of contract management Collaborate with clients to deliver sustainable performance and to manage and exceed client expectations Understand the roles and responsibilities of contract and commercial managers Use effective contractor selection and award methods and models (including the 10Cs model) and use these models to prepare robust propositions to clients Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Effectively manage the process of change, claims, variations, and dispute resolution Develop and present robust propositions Make appropriate use of best practice contract and commercial management tools, techniques, and templates DAY ONE 1 Introduction Aims Objectives KPIs Learning strategies Plan for the programme 2 The contracting context Key objectives of contract management Importance and impact on the business 3 Critical success factors Essential features of professional commercial and contract management and administration The 6-step model 4 Putting the 'management' into commercial and contract management Traditional v 'new age' models The need for a commercial approach The added value generated 5 Definitions 'Commercial management' 'Contract management' 'Contracting' ... and why have formal contracts? 6 Stakeholders Stakeholder mapping and analysis The 'shared vision' concept Engaging with key functions, eg, HSE, finance, operations 7 Roles and responsibilities Contract administrators Stakeholders 8 Strategy and planning Developing effective contracting plans and strategies DAY TWO 1 Contract control Tools and techniques, including CPA and Gantt charts A project management approach Developing effective contract programmes 2 The contracting context Key objectives of contract management Importance and impact on the business 3 Tendering Overview of the contracting cycle Requirement to tender Methods Rationale Exceptions Steps Gateways Controls One and two package bids 4 Tender assessment and contract award I - framework Tender board procedures Role of the tender board (including minor and major tender boards) Membership Administration Developing robust contract award strategies and presentations DAY THREE 1 Tender assessment and contract award II - processes Pre-qualification processes CRS Vendor registration rules and processes Creating bidder lists Disqualification criteria Short-listing Using the 10Cs model Contract award and contract execution processes 2 Minor works orders Process Need for competition Role and purpose Controls Risks 3 Contract strategy Types of contract Call-offs Framework agreements Price agreements Supply agreements 4 Contract terms I: Pricing structures Lump sum Unit price Cost plus Time and materials Alternative methods Target cost Gain share contracts Advance payments Price escalation clauses 5 Contract terms II: Other financial clauses Insurance Currencies Parent body guarantees Tender bonds Performance bonds Retentions Sub-contracting Termination Invoicing 6 Contract terms III: Risk and reward Incentive contracts Management and mitigation of contractual risk DAY FOUR 1 Contract terms IV: Jurisdiction and related matters Applicable laws and regulations Registration Commercial registry Commercial agencies 2 Managing the client-contractor relationship Types of relationship Driving forces Link between type of contract and style of relationships Motivation - use of incentives and remedies 3 Disputes Types of dispute Conflict resolution strategies Negotiation Mediation Arbitration DAY FIVE 1 Performance measurement KPIs Benchmarking Cost controls Validity of savings Balanced scorecards Using the KPI template 2 Personal qualities of the contract manager Negotiation Communication Persuasion and influencing Working in a matrix environment 3 Contract terms V: Drafting skills Drafting special terms 4 Variations Contract and works variation orders Causes of variations Risk management Controls Prevention Negotiation with contractors 5 Claims Claims management processes Controls Risk mitigation Schedules of rates 6 Close-out Contract close-out and acceptance / completion HSE Final payments Performance evaluation Capturing the learning 7 Close Review Final assessment Next steps

Data Analysis In Excel for School Administrators 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 Data Analysis In Excel for School Administrators 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 5 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 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 numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. 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. Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:06:00

Unlock the power of NFTs Demystified with our easy-to-follow course. This course provides a comprehensive overview of the concept, technology, and market behind NFTs Demystified, providing learners with the knowledge to navigate this emerging field with confidence. Discover the potential of NFTs Demystified and gain the skills to create, sell, and invest in them. Learning Outcomes: Understand the fundamentals of Non-Fungible Tokens (NFTs) Gain knowledge of blockchain and Ethereum technology Explore NFT marketplaces and projects Learn about NFT security and standards Create and sell NFTs with ease Gain insights into the future of NFTs This NFTs Demystified: An Easy-to-Follow course is a comprehensive overview of NFTs Demystified, covering topics such as blockchain, Ethereum, NFT marketplaces, NFT security and standards, creating and selling NFTs, investing in NFTs, and the future of NFTs. NFTs Demystified is a rapidly growing field that has the potential to revolutionise the digital market. Understanding NFTs and the technology behind them can give learners a competitive edge in their professional careers and open up new opportunities. This course is designed to provide learners with a solid foundation of NFTs Demystified. With expertly curated content, learners will gain a comprehensive understanding of NFTs and the technology behind them. The course is self-paced, allowing learners to complete it at their own convenience. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Entrepreneurs looking to capitalize on the potential of NFTs Demystified Investors seeking to gain insights into the NFT market Professionals looking to upskill in the digital market Curious learners seeking to understand NFTs Demystified Anyone interested in emerging technologies and their potential Career path Blockchain Developer - £45,000 to £75,000 Digital Marketer - £25,000 to £55,000 NFT Project Manager - £50,000 to £80,000 Cryptocurrency Trader - £30,000 to £60,000 NFT Art Curator - £35,000 to £65,000

The Magic of Macros The Magic of Macros Learn how Excel's Macros (a.k.a. VBA), can create incredible results in the blink of an eye! We'll start with a few basics, then move to more advanced topics and work through an example. Watch Excel create multiple totals in basically one line of code! This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Level 1 Certificate in Bookkeeping Diploma Embark on mastering Bookkeeping for accounts receivable and payable. Discover the intricacies of Bookkeeping for cash flow statements. Excel in Bookkeeping through advanced auditing techniques and topics. Learning Outcomes: Master fundamental principles of Bookkeeping. Utilise double-entry systems in Bookkeeping. Handle accounts receivable using Bookkeeping practices. Craft cash flow statements through Bookkeeping. Understand auditing's essential role in Bookkeeping. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Level 1 Certificate in Bookkeeping Diploma Course Syllabus Mastering Bookkeeping Fundamentals: Delve into the core principles of Bookkeeping, establishing a solid foundation for financial management. Bookkeeping Systems Mastery: Explore the essential double-entry system within Bookkeeping, ensuring balanced financial records. Accounts Receivable in Bookkeeping: Specialize in managing accounts receivable, a crucial aspect of Bookkeeping. Cash Flow in Bookkeeping: Develop expertise in creating and analyzing cash flow statements, a key component of Bookkeeping. Auditing within Bookkeeping: Investigate the role of auditing in maintaining accurate and compliant Bookkeeping records. Advancing in Bookkeeping: Stay ahead with the latest trends and advanced topics in Bookkeeping, continually refining your skills.

Getting Started The Master of Business Administration is a prestigious postgraduate qualification that leading employers highly value. The programme is designed to enhance business managers' strategic thinking and decision-making and develop their critical understanding of business management. This programme covers the core business sectors: entrepreneurship, marketing, accounting, statistics, finance, business ethics, business law, managerial economics, business strategy and analysis, operations, administration and communication. This programme, qualified from UK business schools, is well acknowledged and globally respected as it dominates critical thinking and research. MBA can also help you specialise in a new industry you want to move to or in your current sector. This professional qualification improves the chances of progression in a career path. This qualification helps the learner to oversee, supervise and allocate the operations in a business firm. The programme aims to make the candidate capable of understanding the functional aspects of a company and acquiring the skills for communication and decision-making. The programme comprises two phases; the first is the Qualifi Level 7 Diploma in Strategic Management and Leadership awarded by Qualifi and delivered by the School of Business and Technology London. The second phase is the MBA 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 bachelor's degree Applicant without a bachelor's degree but holding significant managerial experience will be considered for entry on a case-by-case basis. Further, candidates are also required to demonstrate their English language proficiency. Progression An MBA graduate can pursue a fruitful career in many industries. MBA can open career opportunities in various sectors such as banking and financial services, investment banking, management consulting, insurance, hospitality, media, information technology (IT) and marketing. MBA is often a pathway to promotion or a career change as you will gain a professional reputation and develop essential skills in the sector one chooses to pursue. 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 7 Diploma in Strategic Management and Leadership Programme Structure To attain 120 credits, learners must complete the six compulsory units and select at least two optional units. Mandatory Units Unit 702: Manage Team Performance to Support Strategy Unit code: Y/506/9067 TQT : 150 Credit: 15 This unit's objective is to enable learners to delve into the evaluation and enhancement of team performance to achieve strategic goals. Additionally, learners will be introduced to various management models, concepts, and ideas that can assist in establishing objectives for departments, projects, teams, and individual performance. Unit 704: Information Management and Strategic Decision Taking Unit code: H/506/9068 TQT : 150 Credit: 15 This unit aims to tackle the abundance and intricacy of data and information accessible to organisations and to teach how to analyse, apply, and ascertain its value in shaping strategic decisions. Unit 705: Leading a Strategic Management Project Unit code: L/506/9065 TQT : 150 Credit: 15 This unit will engage the learner in crafting research and methodologies to bolster a strategic management project. They will need to assess options and data sources critically before presenting the outcomes of the project. Unit 706: Strategic Direction Unit code: D/506/9068 TQT : 150 Credit: 15 The purpose of this unit is to delve into the strategic aims and objectives of an organisation and to understand their importance in defining direction, as well as gauging success and progress for the organisation. Additionally, the unit will examine how various strategic options may lead the organisation to alter its course. Unit 711: Strategic Planning Unit code: Y/506/9070 TQT : 150 Credit: 15 This unit focuses on the significance of the strategic planning process in crafting suitable strategies and creating a plan that garners support from stakeholders and other organizational leaders. Learners will also engage in a critical evaluation of the program and its subsequent success. Unit 724: Development as a Strategic Manager Unit code: J/506/9064 TQT : 150 Credit: 15 This unit aims to foster organizational and self-awareness in learners. It lays the groundwork for a self-critical and reflective approach to personal development, which is essential when operating strategically. Additionally, it considers broader contextual factors within the organization and the environment, recognizing their role in contributing to the overall strategic success of both the individual and the organization.   Optional Units Unit 703: Finance for Managers Unit code: D/506/9071 TQT : 150 Credit: 15 The purpose of this unit is to assist learners in comprehending and applying financial information and data. This unit holds significance for learners as it aids in making informed financial decisions. Unit 708: Strategic Marketing Unit code: M/506/9074 TQT : 150 Credit: 15 This unit will explore the foundational models, techniques, and theories that form the basis of marketing and can contribute to achieving strategic objectives. It will also give learners a critical comprehension of the marketing function within intricate organizations. Unit 710: Organisational Change Strategies Unit code: K/506/9073 TQT : 150 Credit: 15 The primary objective of this unit is to equip learners with the knowledge and skills to understand, plan, and execute organizational change effectively. While prevailing wisdom in the business world often emphasizes the need for fast, large-scale, and transformative change for corporate survival, there is evidence to suggest that many successful organizations adopt a slower and more cautious approach. Moreover, change initiatives have a reported failure rate of around 70%. This underscores the complexity of managing organizational change, making it a critical skill for successful leaders and organizations. This unit will scrutinize the evolving nature of organizations and the associated challenges they encounter. It will explore the key approaches to change management and demonstrate how these align with the various types of changes organizations undergo, particularly concerning individual, group, and organizational behaviour. Unit 712: Human Resource Planning Unit code: H/506/9072 TQT : 150 Credit: 15 This unit will cover key considerations in planning for and acquiring a workforce capable of achieving strategic objectives. It will also examine the limitations and external factors that impact an organization's HR practices.   Phase 2 - MBA Top-Up Programme Structure Dissertation (Major Project) Delivery Methods The programme comprises two phases; the first is the Qualifi Level 7 Diploma in Strategic Management and Leadership 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 program 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 MBA 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.

Overview This comprehensive course on NFT for Beginners will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This NFT for Beginners  comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this NFT for Beginners. It is available to all students, of all academic backgrounds. Requirements Our NFT for Beginners is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 8 sections • 8 lectures • 02:40:00 total length •Introduction to Non-Fungible Tokens: 00:25:00 •Blockchain and Ethereum: 00:25:00 •NFT Marketplaces and Projects: 00:25:00 •NFT Security and Standards: 00:20:00 •Creating and Selling NFTs: 00:20:00 •Investing In NFTs: 00:25:00 •The Future of NFTs: 00:20:00 •Assignment - NFT for Beginners: 00:00:00