44298 Courses

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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 classroom, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

If you’ve ever found yourself listening to others, offering guidance, or wondering how people navigate life’s challenges, the Social Worker - CPDQS Accredited Bundle Course might just be your thing. This online course is designed for anyone who wants to understand the systems and support structures behind social care work. You’ll explore key areas like mental health, family dynamics, safeguarding, substance misuse, and more — all from your own home, with the flexibility to learn when it suits you. Whether you're looking to explore a new direction or aiming to add weight to your existing knowledge, this course gives you a strong foundation in the field of social work. With the growing demand for support workers across the UK — and average salaries ranging between £23,000 and £42,000 — this is a timely opportunity to gain insight into a sector that genuinely makes a difference. The course is accessible, jargon-free, and written in plain English, making it ideal for learners of all levels who want to engage with meaningful topics and pursue a rewarding role in social services. Key Features of Social Worker Bundle CPD Accredited Social Worker Course Instant PDF certificate Fully online, interactive Social Workercourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Social Worker Bundle course to excel! To become successful in your profession, you must have a specific set of Social Worker skills to succeed in today's competitive world. In this in-depth Social Workertraining course, you will develop the most in-demand Social Worker skills to kickstart your career, as well as upgrade your existing knowledge & skills. Social Worker Curriculum Course 01: Social Worker Course 02: Youth Work Diploma Level 3 Course 03: Mental Health Self-Care Course 04: Social Care Worker Course 05: Level 3 Coaching & Mentoring Course Course 06: Level 3 Diploma in Management and Leadership Course 07: Career Development Course 08: Anger Management Course 09: Positive Psychology Course 10: Life Coaching Course 11: Safeguarding Children: Internet Safety Course 12: Adult Social Care Course 13: Adverse Childhood Experiences and Cure Course 14: Substance Misuse Awareness Online Certification Course Course 15: Anti Social Behaviour (ASB) Course 16: Child Protection and Safeguarding Level 3 Course 17: Counselling Level 3 Course 18: Equality & Diversity Course 19: Cross-Cultural Awareness Training Course 20: How to Save Children from Abuse Accreditation This Social Worker bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Social Worker course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Social Worker basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Social Worker Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

🗓 Date: Wednesday 24th September ⏰ Time: 9:30am – 10:30am 📍 Location: Hatch 1, The Hat Factory, Luton 🎯 Level: Intermediate Thinking of creating a website for your business but unsure where to start—or how much it’ll cost? This beginner-friendly session is designed for business owners and entrepreneurs who want to get online quickly and affordably, without needing to hire a developer. In just one hour, you’ll explore simple, cost-effective website platforms that allow you to build your own site with confidence and ease—even with zero technical experience. What You’ll Learn: Overview of popular low-cost website platforms (Wix, Google Sites, Squarespace, and more) Live demo: how to build a free website using Google Sites Tips for choosing the right layout and features for your business Introduction to Search Engine Optimisation (SEO)—how to help your website show up in Google Useful tools to maintain and improve your website over time Perfect for startups, sole traders, creatives, and side-hustlers who want an affordable web presence that works.

Gain a comprehensive understanding of immunisation and vaccines with our "Foundations of Immunisation and Vaccines" course. Designed for healthcare professionals, public health workers, and individuals interested in immunisation, this course covers vaccine development, administration, safety, and the role of vaccines in preventing infectious diseases.

Level 7 Diploma In Risk Management Pathway To MSc In Risk Management Level 7 Diploma in Risk Management (QCF) – 6 - 8 Months Credits: 120 Credits The objective of the Level 7 Diploma in Risk Management is to provide learners with the skills and understanding of risk management that align with good strategic decision making to maintain organisations’ competitive advantage. The OTHM Level 7 Diploma in Risk Management programme provides an in-depth understanding of risk and its application in practice both for financial and non-financial organisations. Learners will learn both theoretical and practical understanding of risk including risk measurement and modelling. This programme is a Pathway programme to MSc in Risk Management. Course Details The Level 7 Diploma in Risk Management qualification consists of 6 mandatory units making a combined total of 120 credits, 1200 hours Total Qualification Time (TQT) and 600 Guided Learning Hours (GLH) for the completed qualification.Modules (120 Credits): Principles of Risk Management Strategic Risk Management Responsible Leadership and Governance Organisational and Environmental Risk Risk Analysis and Modelling Advanced Research Methods Accreditation All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. University Progression University Top-up On completion of this course, students have the opportunity to complete a Master degree programme from a range of UK universities. The top-up programme can be studied online or on campus. The top-up comprises the final 60 credits which consist of either a dissertation or a dissertation and one module. (The course tuition fee listed above does NOT include the top-up fees) University Progression Click here to see University routes and fee information for progression. Entry Requirements For entry onto the Level 7 Diploma in Risk Management leading to the MSc in Risk Management qualification, learners must possess: An honours degree in related subject or UK level 6 diploma or equivalent overseas qualification i.e. Bachelors Degree or Higher National Diploma OR Mature learners (over 25) with at least 5 years of management experience if they do not possess the above qualification (this is reviewed on a case by case basis) Workshops Workshops are conducted by live webinars for all students. Visa Requirements There is no Visa requirement for this programme.

Level 7 Diploma In Project Management Pathway To MSc In Project Management Degree Level 7 Diploma in Project Management (QCF) – 6 - 8 Months Credits: 120 Credits This Level 7 Diploma Project Management qualification is designed to meet the needs of senior managers responsible for projects and provide a comprehensive understanding of the fundamental topics needed to manage business projects within a complex and ever-changing environment. This qualification will develop a deeper understanding of both theoretical and practical aspects of project, programme and portfolio management and facilitate the essential skills and competencies necessary to plan, monitor, control and deliver successful projects, programmes and portfolios. This programme is a Pathway programme to MSc in Project Management Degree. Course Details Project management impacts directly on the growth and advancement of most modern organisations and is a much-sought-after qualification. The MSBM Postgraduate Diploma in Project Management is a specialized programme that enables students to develop an advanced understanding of concepts, approaches and tools relevant to the field of project management in the 21st Century. The programme enhances the capacity of managers to improve production and service delivery thereby contributing to organisational effectiveness. The programme also provides for the attainment of quantitative skills in Project Finance and Project Management. Programme Structure This program consists of 6 compulsory units which are equal to a total of 120 credits. Accreditation All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. University Progression University Top-up On completion of this course, students have the opportunity to complete a Master degree programme from a range of UK universities. The top-up programme can be studied online or on campus. The top-up comprises the final 60 credits which consist of either a dissertation or a dissertation and one module. (The course tuition fee listed above does NOT include the top-up fees) University Progression Click here to see University routes and fee information for progression. Entry Requirements For entry onto the Level 7 Diploma in Project Management leading to the MSc Project Management qualification, learners must possess: An honours degree in related subject or UK level 6 diploma or equivalent overseas qualification i.e. Bachelors Degree or Higher National Diploma OR Mature learners (over 25) with at least 5 years of management experience if they do not possess the above qualification (this is reviewed on a case by case basis) Workshops Workshops are conducted by live webinars for all students. Visa Requirements There is no Visa requirement for this programme.

Level 7 Diploma In Education Management And Leadership Pathway To (MA In Education Management And Leadership) Level 7 Diploma in Strategic Marketing (QCF) – 6 - 8 Months Credits: 120 Credits Level 7 Diploma in Strategic Marketing qualification provides the learners with the skills and understanding in marketing & branding that align with good strategic decision making to maintain organisations’ competitive advantage.  Successful completion of this qualification will develop learners’ strategic marketing management, consumer behaviour and branding skills and their ability to focus on the requirements of implementing an organisation’s strategy. This programme is a Pathway to MSc in Strategic Marketing. Course Details The Level 7 Diploma in Education Management and Leadership qualification consists of 6 mandatory units for a combined total of 120 credits, 1200 hours Total Qualification Time (TQT) and 600 Guided Learning Hours (GLH) for the completed qualification.Modules: Contemporary Issues in Education: Theory, Policy and Practice The Management of Educational Change Managing Effective Intercultural Communication and Perspectives Pedagogy and Practice in Education Leading Reflective Practice in Education Research Methods in Education Accreditation All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. University Progression University Top-up On completion of this course, students have the opportunity to complete a Master degree programme from a range of UK universities. The top-up programme can be studied online or on campus. The top-up comprises the final 60 credits which consist of either a dissertation or a dissertation and one module. (The course tuition fee listed above does NOT include the top-up fees) University Progression Click here to see University routes and fee information for progression. Entry Requirements For entry onto the Level 7 Diploma in Education Management and Leadership leading to the MA Education Management and Leadership qualification, learners must possess: An honours degree in related subject or UK level 6 diploma or equivalent overseas qualification i.e. Bachelors Degree or Higher National Diploma OR Mature learners (over 25) with at least 5 years of management experience if they do not possess the above qualification (this is reviewed on a case by case basis) Workshops Workshops are conducted by live webinars for all students. Visa Requirements There is no Visa requirement for this programme.

Level 7 Diploma In Tourism And Hospitality Management Pathway To MA In Tourism And Hospitality Management Level 7 Diploma in Tourism and Hospitality Management (QCF) – 6 - 8 Months Credits: 120 Credits Level 7 Diploma in Tourism and Hospitality Management enables the learner to polish their planning, organizing and management skills for the challenges of the hospitality industry by learning practical approaches to effectively navigate resources for the best service delivery. The qualification provides learners with a contemporary, critical, and international programme that supports their development as managers with a lifelong-learning orientation. The qualification enables learners to analyse complex management problems and to apply and adapt specialist skills and technical terminology to propose solutions to these problems informed by best practice and contemporary research. This programme is a Pathway to MA in Tourism and Hospitality Management. Course Details Successful completion of this qualification will enable learners to progress into or within employment and/or continue their study towards a relevant Master’s programme with advanced standing.The Level 7 Diploma in Tourism and Hospitality Management consists of 6 mandatory units for a combined total of 120 credits, 1200 hours Total Qualification Time (TQT) and 600 Guided Learning Hours (GLH) for the completed qualification.Modules (120 Credits): Strategic Management and Marketing Destination Management International Tourism Policy and Development E-Tourism and Social Media Organisational Behaviour in International Contexts Advanced Research Methods Accreditation All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. University Progression University Top-up On completion of this course, students have the opportunity to complete a Master degree programme from a range of UK universities. The top-up programme can be studied online or on campus. The top-up comprises the final 60 credits which consist of either a dissertation or a dissertation and one module. (The course tuition fee listed above does NOT include the top-up fees) University Progression Click here to see University routes and fee information for progression. Entry Requirements For entry onto the Level 7 Diploma in Tourism and Hospitality Management leading to the MA in Tourism and Hospitality Management, learners must possess: An honours degree in related subject or UK level 6 diploma or equivalent overseas qualification i.e. Bachelors Degree or Higher National Diploma OR Mature learners (over 25) with at least 5 years of management experience if they do not possess the above qualification (this is reviewed on a case by case basis) Workshops Workshops are conducted by live webinars for all students. Visa Requirements There is no Visa requirement for this programme.

Level 7 Diploma In Logistics And Supply Chain Management Pathway To MSc In Logistics And Supply Chain Management Level 7 Diploma in Logistics and Supply Chain Management (QCF) – 6 - 8 Months Credits: 120 Credits The objective of the Level 7 Diploma in Logistics and Supply Chain Management qualification is to broaden learners’ understanding of logistics and supply chain management and is designed for those who wish to prepare for a first professional role and future career in the field. It is also suitable for logistics and supply chain professionals in the early stages of their career looking to enhance their knowledge and skills and move to the next level professionally.This programme is a Pathway programme to MSc in Logistics and Supply Chain Management. Course Details Successful completion of this qualification will equip learners with the specialist knowledge and skills needed to further their career as a logistics and supply chain professional as well as the opportunity to embark on further study towards a relevant Master’s programme with advanced standing.The Level 7 Diploma in Logistics and Supply Chain Management consists of 6 mandatory units for a combined total of 120 credits, 1200 hours Total Qualification Time (TQT) and 600 Guided Learning Hours (GLH) for the completed qualification.Modules (120 Credits): Logistics Management Supply Chain Planning, Modelling and Analytics Procurement and Supply Management Supply Chain and Operations Strategy Sustainable Operations Management Business Research Methods Accreditation All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. University Progression University Top-up On completion of this course, students have the opportunity to complete a Master degree programme from a range of UK universities. The top-up programme can be studied online or on campus. The top-up comprises the final 60 credits which consist of either a dissertation or a dissertation and one module. (The course tuition fee listed above does NOT include the top-up fees) University Progression Click here to see University routes and fee information for progression. Entry Requirements For entry onto the Level 7 Diploma in Logistics and Supply Chain Management leading to the MSc Logistics and Supply Chain Management qualification, learners must possess: An honours degree in related subject or UK level 6 diploma or equivalent overseas qualification i.e. Bachelors Degree or Higher National Diploma OR Mature learners (over 25) with at least 5 years of management experience if they do not possess the above qualification (this is reviewed on a case by case basis) Workshops Workshops are conducted by live webinars for all students. Visa Requirements There is no Visa requirement for this programme.

10 QLS Endorsed Courses for Teacher | 10 Endorsed Certificates Included | Life Time Access