35448 Courses delivered Online

This course is designed to enable candidates to develop the knowledge of the terminology and basic concepts of TOGAF Standard, 10th Edition and principles of Enterprise Architecture. Candidates will also be able to analyze and apply knowledge of TOGAF Standard.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Average entry-level pharma roles pay 96% of NHS Band 5 and come with opportunities for overtime, shift allowance and additional benefits as well as huge scope for career progression and salary increases.

Getting Started The QUALIFI Level 7 Diploma in Human Resource Management addresses the demands of senior/middle managers and accountants in running their businesses. It encourages them to progress to higher levels within their organisation. The role to be played by managers is very crucial. For instance, they need to be aware of the issues and the ability to analyse their potential results and decide how to react. It is optional that they are experts in all business sectors. The prime requirement is to have a general awareness of the existing facilities and services and find a way to carry out the roles. The program incorporates current topics with advanced content, reflecting core issues within the 21st-century business sector and the latest developments in management research. The Diploma is credited at the postgraduate Level 7 with 120 credits. We provide access to dissertations at one of our University partners for a related Master's Degree after completing the Diploma. Key Benefits This qualification will benefit the learner: To understand and apply the principles of human resource management in a business environment. Analyse problem-solving techniques specific to business and industry Resourcing talent management and development Investigating a Business Issue from an HR Perspective Analysing and understanding performance management and employee relation Key Highlights Are you passionate about developing a career as a human resource manager in a reputed organisation and acquiring knowledge and skills? Then, the QUALIFI Level 7 Diploma in Human Resource Management is the ideal starting point for your career journey. We will ensure your access to the first-class education needed to achieve your goals and dreams and to maximise future opportunities. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our Qualifi-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The Qualifi Level 7 Level Diploma in Human Resource Management can open many career pathways including, but not limited to: Human Resources Manager, with an estimated average salary of £46,240 per annum Employee Relation Manager, with an estimated average salary of £40,512 per annum Benefits Analyst /Manager, with an estimated average salary of £35,100 per annum HR Information Systems Manager, with an estimated average salary of £31,000per annum Labour Relations Manager, with an estimated average salary of £26,700 per annum   About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. What is included?   Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform. This facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Assessment Time-constrained scenario-based assignments No examinations Entry Requirements   The qualifications have been made available to all without artificial barriers denying access and progression. The primary requirement is to get through the interview, and they are expected to hold the following: Level 6 Qualification or First Degree. We also accommodate managers with significant years of experience despite needing formal qualifications. The criteria for admission will be through an interview for those who can demonstrate the skills to cope with the demands of the course. Progression   Learners completing the QUALIFI Level 7 Diploma in Human Resource Management will allow progress to: The QUALIFI Level 8 Diploma in Strategic Management and Leadership, or A university partner to complete a dissertation to receive a full master's degree or Directly into employment in an associated profession. University exemptions: With QUALIFI, the learners can progress to several Universities to pursue a Master's degree once they have completed a dissertation. The pathway indicates the learner's progress towards a University degree and is based on the University's review of QUALIFI's learning programs and outcomes. Further information is available here http://www.QUALIFI.net/learning-pathways/   Why gain a QUALIFI Qualification?   This suite of qualifications provides enormous opportunities to learners seeking career and professional development. The highlighting factor of this qualification is that: The learners attain career path support who wish to pursue their career in their denominated sectors; It helps provide a deep understanding of the health and social care sector and managing the organisations, which will, in turn, help enhance the learner's insight into their chosen sector. The qualification provides a real combination of disciplines and skills development opportunities. The Learners attain in-depth awareness concerning the organisation's functioning, aims and processes. They can also explore ways to respond positively to this challenging and complex health and social care environment. The learners will be introduced to managing the wide range of health and social care functions using theory, practice sessions and models that provide valuable knowledge. As a part of this suite of qualifications, the learners will be able to explore and attain hands-on training and experience in this field. Learners also learn to face and solve issues then and there by exposure to all the Units. The qualification will also help to Apply scientific and evaluative methods to develop those skills. Find out threats and opportunities. Develop knowledge in managerial, organisational and environmental issues. Develop and empower critical thinking and innovativeness to handle issues and difficulties. Practice judgement, own and take responsibility for decisions and actions. Develop the capacity to perceive and reflect on individual learning and improve their social and other transferable aptitudes and skills.   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. UNIT1- Contemporary HRM Reference No : HRM701 Credit : 20 || TQT : 200 This unit will help the learner to understand and analyse the impact of internal and external environmental forces on organisational strategy and management of people. UNIT2- Leading, Managing and HR Development Reference No : HRM702 Credit : 20 || TQT : 200 In the unit, Students will understand to evaluate the viability of organisational methodologies, measures in proficient and compelling initiative and the board, likewise the commitment of HRM/HRD experts to hierarchical change. UNIT3- Resourcing, Talent Management and Development Reference No : HRM703 Credit : 20 || TQT : 200 "The reason for this unit is to create skill in comprehension and examining work markets also, segment patterns to make and execute powerful, moral and suitable resourcing,maintenance, ability the board and improvement methodologies. . Learners will assess the role of HRM professionals in designing, implementing and evaluating strategic planning relevant to employee resourcing, talent management and development" UNIT4- Performance Management Reference No : HRM704 Credit : 20 || TQT : 200 To empower students to comprehend the principle components that impact the exhibition of workers at all levels inside an organisation and the manners by which such components can be overseen in a valuable way. Further to give students comprehension to devise and actualize suitable HR practices and techniques that identify with Performance Management. UNIT5- Employee Relations Reference No : HRM705 Credit : 20 || TQT : 200 The point of this unit is to acquaint students with the significance of good representative relations for business achievement and the effect of changes which have influenced work connections. Abilities needed by HRM experts in planning, actualising and assessing business relations techniques, plans, approaches, will be examined. Additionally to build up the capacity to make solutions for current/potential clash circumstances in consistence to legitimate and ethical considerations. UNIT6- Investigating a Business Issue from an HR Perspective Reference No : HRM706 Credit : 20 || TQT : 200 To build up student's abilities and information on free exploration, analyse and make suggestions for change or upgrades that are reasonable, applicable and useful to explicit association. To empower students to introduce a powerful business report and additionally a contemplated and consistent case for changes in arrangements, practices and methodologies reflecting scholastic exploration and composing aptitudes Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. 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.

Getting Started The CMI Level 7 Diploma in Leadership Coaching and Mentoring is designed for managers and leaders with the authority and responsibility to develop and implement a coaching and mentoring strategy across the organisation.  Achieving this renowned CMI Level 7 qualification will help you achieve the skills for leadership training for your lower-level employees and learn the techniques to improve the efficiency of the workforce in the organisation.  This extensive online CMI Level 7 Leadership Coaching and Mentoring qualification requires managers and leaders to develop their strategic management and leadership skills and focus on embedding these skills into an organisation's strategy. Key Benefits For Learners Developing core coaching and mentoring skills Achieve the skills for leadership training for lower-level employees Learn the techniques to improve the efficiency of the workforce in the organisation For Organisations Build strategic management and leadership skills to focus on the requirements of embedding into your organisation's strategy Key Highlights Are you a responsible leader for developing and implementing coaching and mentoring strategies across your organisation, or who wants to enhance your competency? The CMI Level 7 Leadership Coaching & Mentoring offered by the School of Business and Technology London is the ideal starting point for your career journey. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience.   Career Pathways The CMI Level 7 Leadership Coaching and Mentoring can open many career pathways, including but not limited to: Executive Leadership Coach with an estimated salary of £44,027 Senior Training Manager, with an estimated average salary of £47,465 per annum Senior Learning and Development Manager, with an estimated average salary of £67,550 per annum Leadership & Development Mentor, with an estimated average salary of £66,885 per annum Business Coach or Mentor with an estimated average salary of £78,000 per annum Senior Corporate Coach or Mentor with an estimated average salary of £68,950 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 12 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 3000 to 3500 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements The CMI Level 7 Diploma in Leadership Coaching and Mentoring is designed for managers and leaders. To be eligible for this course, you must: Be 21 years of age and over Have some work experience in the middle or senior management level, coach, mentor, or a similar role Possess the ability to complete the Level 7 Qualification Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression CMI would recommend the below qualifications as a possible progression route, once complete the Leadership Coaching and Mentoring qualifications: CMI Level 7 Qualifications in Strategic Management and Leadership   Why gain a CMI Qualification? The CMI Level 7 Diploma in Leadership Coaching and Mentoring is a prestigious qualification that allows you to develop core coaching and mentoring skills and build strategic management and leadership skills to focus on the requirements of embedding into your organisation's strategy. Upon completing this CMI Level 7 course, you will have the professionalism to deliver impact, behave ethically and demonstrate a commitment to continual learning and development. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 7 Diploma in Leadership Coaching and Mentoring course, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners need to complete all Group A units and any combination of units to a minimum of 7 credits from Group B. The Total Qualification Time is 460 hours. 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. UNIT1- Coaching and mentoring policies Reference No : Unit 7016V1 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Be able to construct organisational coaching and mentoring policies. 2. Be able to demonstrate how impact, support and recognition of coaching and mentoring is accepted in the organisation. UNIT2- Coaching and mentoring within organisational culture Reference No : Unit 7015V1 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Be able to demonstrate the links between strategic performance and coaching and mentoring. 2. Understand the impact of organisational culture on coaching and mentoring. 3. Understand how coaching and mentoring can impact the organisation. UNIT3- Organisational coaching and mentoring Reference No : Unit 7017V1 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Be able to analyse the issues involved during the adoption of organisational coaching and mentoring. 2. Be able to develop changes through the coaching and mentoring process. 3. Be able to determine the need for continual high level support for coaching and mentoring. UNIT4- Strategic impact of coaching and mentoring Reference No : Unit 7018V1 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand individual, team and departmental development from the coaching and mentoring process. 2. Understand the effect of coaching and mentoring on strategic performance objectives. UNIT5- Embedding coaching and mentoring in the organisation Reference No : Unit 7019V1 Credit : 7 || TQT : 70 LEARNING OUTCOMES 1. Be able to develop coaching and mentoring for individuals and organisations. 2. Be able to support evolving organisational objectives through coaching and mentoring. UNIT6- Leadership coaching and mentoring skills Reference No : Unit 7020V1 Credit : 7 || TQT : 70 LEARNING OUTCOMES 1. Understand how coaching and mentoring programmes support business objectives. 2. Understand the implementation of coaching and mentoring to achieve organisational objectives. 3. Be able to devise an implementation plan. UNIT7- Developing performance management strategies Reference No : Unit 7002V1 Credit : 7 || TQT : 70 LEARNING OUTCOMES 1. Be able to set performance targets of teams to meet strategic objectives. 2. Be able to agree team performance targets to contribute to meeting strategic objectives. 3. Be able to monitor actions and activities defined to improve team performance. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. 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. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... 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.

Designed for professional B2B salespeople to develop a modern approach to winning business

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

An 8 week coaching programme like no other. Discover how to build your business, free your time all the while making more money and doing more of the stuff you love. Stop not-earning when you're off on holiday, off for the weekend or off sick... Create a business that works for you, even when you're not there.

Getting Started The CMI Level 5 Diploma in Professional Consulting course is designed for practising and aspiring Professional Consultants wishing to develop essential skills in professional consulting, such as planning and managing consultancy interventions, client relationships, communication and problem-solving tools and techniques. It's an extensive course that allows you to develop the substantial skills and competencies required to become a consultant. The CMI Level 5 Diploma in Professional Consulting qualification has been developed in cooperation with the Institute of Consulting. With this comprehensive course, you'll build strategic skills with consulting and achieve a good understanding of consulting essentials. Key Benefits For learner: Build strategic skills with consulting, such as organisational structure and culture Develop your skills in one specific area of consulting, such as consultancy interventions, communication, client relationships or problem-solving tools and techniques Attain a good understanding of consulting essentials Focuses on the nature of consulting, personal development and effective communication Develop group dynamics Facilitating core skills For Organisation: Communicating core strategies for consulting Gives more comprehensive knowledge of the role of a Professional Consultant while focusing on the specific consulting subjects appropriate to the role of a Professional Consultant Gives you the skills and competencies needed to become a consultant Key Highlights Want to get noticed and develop yourself into a successful Professional Consultant? The CMI Level 5 Professional Consulting offered by School of Business and Technology London is the ideal starting point for your career journey. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide you with comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The CMI Level 5 Professional Consulting can open many career pathways including, but not limited to: Management Consultant, with an estimated salary of £55,343 per annum Consultant, with an estimated salary of £46,317 per annum Professional Consultant with an estimated salary of £50,205 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 12 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 2500 to 3000 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements The CMI Level 5 Diploma in Professional Consulting is aimed at practising and aspiring Professional Consultants wishing to develop key skills and knowledge to succeed and progress in professional consulting. To be eligible for this course, you must: Be 19 years of age and over Have some work experience as a consultant in any sector or similar job role Possess the ability to complete the Level 5 Qualification Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression IC and CMI would recommend for progression once completing the Professional Consulting qualifications would be to progress onto: CMI Level 6 Qualifications in Management and Leadership (RQF) CMI Level 7 Qualifications in Professional Consulting (RQF) Why gain a CMI Qualification? Achieving this CMI Level 5 qualification in Professional Consulting will provide you with a broader understanding of the role of a Professional Consultant while focusing on the specific consulting subjects appropriate to the role of a Professional Consultant. You will develop strategic skills with consulting and have the opportunity to attain a good understanding of the essentials of consulting upon completing this course. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 5 Professional Consulting, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. 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. UNIT1- The client relationship Reference No : Unit 5032 Credit : 8 || TQT : 80 LEARNING OUTCOMES 1. Understand the importance of the client/consultant relationship. 2. Be able to develop and manage the client relationship. 3. Be able to use negotiation and influencing skills in the client/consultant relationship. UNIT2- Planning a change process Reference No : Unit 6003V1 Credit : 7 || TQT : 70 LEARNING OUTCOMES 1. Understand the forces for change in an organisation. 2. Be able to assess the impact of the change process. 3. Be able to plan the change process. UNIT3- Planning and managing consultancy interventions Reference No : Unit 5030 Credit : 8 || TQT : 80 LEARNING OUTCOMES 1. Understand the need to adopt a structured approach to managing consultancy interventions. 2. Be able to use project management techniques in a consultancy intervention. 3. Know how to conduct a consultancy intervention. UNIT4- Problem solving, tools and techniques for consultants Reference No : Unit 5034 Credit : 9 || TQT : 90 LEARNING OUTCOMES 1. Understand how to identify the client need. 2. Understand data collection methods and confidentiality in a consultancy intervention. 3. Be able to apply analysis tools within consultancy interventions. UNIT5- Introduction to consulting essentials Reference No : Unit 5029 Credit : 8 || TQT : 80 LEARNING OUTCOMES 1. Understand the nature of consulting. 2. Be able to prepare for professional personal development as a consultant. 3. Know how to communicate effectively with clients. UNIT6- Communication for consultants Reference No : Unit 5033 Credit : 7 || TQT : 70 LEARNING OUTCOMES 1. Understand the importance of communication. 2. Be able to run effective meetings with clients. 3. Be able to present information, findings, conclusions and recommendations to clients. UNIT7- The role and responsibilities of a consultant Reference No : Unit 5031 Credit : 6 || TQT : 60 LEARNING OUTCOMES 1. Understand the role of the consultant. 2. Be able to assess current competencies, knowledge and behaviours against those required of a management consultant. 3. Know how to behave in a professional and ethical manner. UNIT8- Project development and control Reference No : Unit 5009V1 Credit : 6 || TQT : 60 LEARNING OUTCOMES 1. Be able to identify the components of project stages and lifecycle. 2. Understand project methodologies and their application. 3. Be able to develop a project plan, identify and mitigate risks. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. 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. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... 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.

The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.