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

4334 Courses

OTHM Level 7 Diploma in Logistics and Supply Chain

By School of Business and Technology London

Getting Started OTHM Level 7 Diploma in Logistics and Supply Chain Management aims to provide a broader understanding of logistics and supply chain management. It is designed for logistics and supply chain professionals in the early stages of their careers looking to enhance their knowledge. Upon successfully completing this program, the learners will be equipped with skills needed to further their careers as logistics and supply chain professionals and to work toward a relevant Master's programme with advanced standing. Key Benefits All the important management theories and models are covered in this course. As a result, the students will gain a better understanding of the various management techniques that are applicable in the workplace. Will be helpful to the students to develop their problem-solving skills through the practical application of the various management models and theories. A nationally - recognised qualification, the credits earned at this course can be transferred to other courses, if the students want to pursue MBA or any other Masters. On successful completion of the course the students will be able to demonstrate their proficiency in the various management practices which will improve their chances of making a successful career progression. About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. What is included? Time-constrained scenario-based assignments No examinations Entry Requirements For entry onto the OTHM Level 7 Diploma in Logistics and Supply Chain Management qualification, learners must possess: An honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification Mature learners (over 21 years) with management experience International students whose first language is not in English, they will need to have score of 5.5 or above in IELTS (International English Language Testing System) Progression   On successful completion of the OTHM Level 7 Diploma in Logistics and Supply Chain Management, a number of progression opportunities become available: Master's top-up programmes at many universities in the UK and overseas with advanced standing or Directly into employment in an associated profession.   Why gain a OTHM Qualification?   Quality, Standards and Recognitions- OTHM qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation); hence, the learners can be very confident about the quality of the qualifications as well. Career Development to increase credibility with employers- All OTHM qualifications are developed to equip learners with the skills and knowledge every employer seeks. The learners pursuing an OTHM qualification will obtain an opportunity to enhance learning and grow key competencies to tackle situations and work projects more effectively, giving learners the potential to get promotions within the workplace. Alternatively, it allows them to progress onto an MBA top-up/Bachelor's degree / Master's degree programme around the World. Flexible study options- All OTHM qualifications have a credit value, which tells you how many credits are awarded when a unit is completed. The credit value will indicate how long it will normally take you to prepare for a unit or qualification. Three different types of qualification are: The award is achieved with 1 - 12 credits The certificate is earned with 13 - 36 credits The diploma is completed with at least 37 credits The OTHM 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. 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- Logistics Management Reference No : J/618/1227 Credit : 20 || TQT : 200 The unit focuses on the valuing adding role of logistics in supply networks. It aims to impart learners with a thorough understanding of key theoretical and operational aspects of managing specifically transportation, storage/warehousing and packaging logistics. The related considerations for business competitiveness is emphasised as is the interdependency between operational, technological and regulatory aspects. UNIT2- Supply Chain Planning, Modelling and Analytics Reference No : R/618/1229 Credit : 20 || TQT : 200 The unit aims to provide learners with in-depth knowledge about planning processes across all key aspects of supply chain management. The relevance of each of the planning processes, the associated information requirements and modelling and analytic techniques are covered. UNIT3- Procurement and Supply Management Reference No : L/618/1231 Credit : 20 || TQT : 200 The unit seeks to provide learners with a thorough understanding of procurement and supply management from a strategic, technological, process and relationship perspective. The goal is to provide insights on the role of procurement within supply chain management, the negotiation and contractual issues encountered with suppliers , effective supplier relationship management, the tools and techniques to assess sourcing options and technological enablers in procurement. UNIT4- Supply Chain and Operations Strategy Reference No : Y/618/1233 Credit : 20 || TQT : 200 The aim of this unit is to develop learners' understanding of supply chain and operations management, including its scope, impact and importance as well as the strategic decisions that need to be made in today's world of global markets and global supply, taking into account the major competitive drivers. The unit discusses approaches and supply chain and operations management practices in a range of contexts. UNIT5- Sustainable Operations Management Reference No : H/618/1235 Credit : 20 || TQT : 200 The aim of this unit is to develop learners understanding including key elements of sustainability and their importance to businesses, knowledge and skills of sustainable operations management, the different practices across the supply chain that can be worked upon to improve sustainability as well as the performance measures and the business impact of sustainability, the business drivers and barriers affecting the move towards sustainability. A variety of different sectors are explored. UNIT6- Business Research Methods Reference No : T/508/0626 Credit : 20 || TQT : 200 The aim of this unit is to develop learners understanding of research principles including the formulation of literature reviews, statistical analysing using SPSS, research proposals, referencing, data collection using surveys and interviews, questionnaire design, qualitative data and methods for drawing conclusions from the analysed data. 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.

OTHM Level 7 Diploma in Logistics and Supply Chain
Delivered Online On Demand11 months
£908.64

OTHM Level 6 Diploma in Logistics and Supply Chain Management

By School of Business and Technology London

Getting Started The primary objective of the OTHM Level 6 Diploma in Logistics and Supply Chain Management is to equip learners with the essential knowledge and skills needed to assume roles as middle or senior managers within organisations. These individuals are typically tasked with overseeing and managing the organisation's logistics and supply chain operations. Key Benefits Recognise and mitigate supply chain risks. Understand how globalization impacts an organisation's logistics and supply chain. Gain insight into business entrepreneurship. Grasp the tools and methods employed in logistics management within the business context. Manage international-level operations Key Highlights The Level 6 Diploma in Logistics and Supply Chain Management is well-suited for individuals aspiring to advance into middle and senior management roles. We will ensure your access to the first-class education needed to achieve your goals and dreams and to maximize future opportunities. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exams. With the School of Business and Technology London, you can complete the qualification at your own pace by choosing online or blended learning from the comfort of your home. Learning materials, pathway materials, and study guides developed by our qualified 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 the blended learning option, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. 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 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 Internally assessed by the centre and externally verified by OTHM. Assignment-based assessment. No exams. Entry Requirements A relevant NQF/QCF/RQF Level 5 diploma or an equivalent recognized qualification. Learners must be 18 years or older to enroll at the beginning of the course. Learners over 21 years with management experience. English language requirements: Must provide evidence of English language competency for learners from non-English-speaking countries. Progression Relevant OTHM diploma qualifications at Level 7 This qualification holds approval and regulation by Ofqual (Office of the Qualifications and Examinations Regulation). So, learners are also qualified to pursue higher-level qualifications in their field. Why gain a OTHM Qualification? Quality, Standards and Recognitions- OTHM qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation); hence, the learners can be very confident about the quality of the qualifications as well. Career Development to increase credibility with employers- All OTHM qualifications are developed to equip learners with the skills and knowledge every employer seeks. The learners pursuing an OTHM qualification will obtain an opportunity to enhance their knowledge and grow key competencies to tackle situations and work on projects more effectively, which will, in turn, give learners the potential to get promotions within the workplace. Alternatively, it allows them to progress onto an MBA top-up/Bachelor's degree / Master's degree programme around the World. Flexible study options- All OTHM qualifications have a credit value, which tells you how many credits are awarded when a unit is completed. The credit value will indicate how long it will normally take you to prepare for a unit or qualification. Three different types of qualification are: The award is achieved with 1 - 12 credits The certificate is completed with 13 - 36 credits The diploma is completed with at least 37 credits 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- Entrepreneurship Development Reference No : A/617/6087 Credit : 20 || TQT : 200 The purpose of this unit is to motivate learners to explore the entrepreneurial landscape and industrial growth, ultimately equipping them to establish and manage their own small businesses. UNIT2- Global Logistics and Supply Chain Management Reference No : F/617/6088 Credit : 20 || TQT : 200 Within this unit, students will develop an awareness of the complexities associated with overseeing the global procurement of materials and components, the internationalization of manufacturing procedures, and meeting the demands of a global customer base. UNIT3- International Logistics Management Reference No : J/617/6089 Credit : 20 || TQT : 200 This unit underscores the strategic and value-boosting role of logistics in supply networks. Its aim is to provide students with a thorough grasp of all essential facets of logistics from a global viewpoint. UNIT4- Project Management Reference No : A/617/6090 Credit : 20 || TQT : 200 This module familiarizes students with the various aspects of projects and the principles associated with project planning, analysis, financing, selection, implementation, and assessment. UNIT5- Strategic Procurement Reference No : F/617/6091 Credit : 20 || TQT : 200 In this unit, learners will understand the process of developing a procurement strategy in a business setting and acquire knowledge about the most efficient practices in strategic procurement. UNIT6- Supply Chain Planning and Control Reference No : J/617/6092 Credit : 20 || TQT : 200 The objective of this unit is to introduce students to the various elements that make up the field of supply chain planning and control. Furthermore, the unit aims to make students cognizant of the significance of planning and control within an organization and how it impacts different facets of the supply chain. 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.

OTHM Level 6 Diploma in Logistics and Supply Chain Management
Delivered Online On Demand11 months
£908.64

Tableau Desktop - Part 2

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using Tableau to perform numerical or general data analysis, visualization, and reporting. They need to provide data visualizations from multiple data sources, or combine data to show comparisons, manipulate data through calculations, create interactive visualizations, or create visualizations that showcase insights from statistical analysis. This course is also designed for students who plan to obtain Tableau Desktop Certified Associate certification, which requires candidates to pass the Tableau Desktop Certified Associate exam. Overview Blend data multiple sources. Join data. Access data in PDFs. Refine visualizations with sets and parameters. Analyze data with calculations. Visualize data with advanced calculations. Perform statistical analysis and forecasting. Create geographic visualizations. Get answers with Ask and Explain The advent of cloud computing and storage has ushered in the era of "big data." With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data driven insights with peers, executives, and clients. Prerequisites Tableau Desktop: Part 1 Lesson 1: Blending Data from Multiple Sources Topic A: Blend Data Topic B: Refine Blends to Visualize Key Information Lesson 2: Joining Data Topic A: Create Joins Topic B: Troubleshoot Joins Topic C: Merge Data with Unions Lesson 3: Accessing Data in PDFs Topic A: Connect to PDFs Topic B: Clean Up and Organize PDF Data Lesson 4: Refining Visualizations with Sets and Parameters Topic A: Create Sets Topic B: Analyze Data with Sets Topic C: Apply Parameters to Refine Visualizations Topic D: Create Advanced Visualizations Lesson 5: Analyzing Data with Calculations Topic A: Create Calculated Fields to Analyze Data Topic B: Manipulate Data with Functions Topic C: Analyze Data with Table Calculations Lesson 6: Visualizing Data with Advanced Calculations Topic A: Create Groups and Bins with Calculations Topic B: Analyze Data with LOD Expressions Lesson 7: Performing Statistical Analysis and Forecasting Topic A: Perform Statistical Analysis Topic B: Forecast Data Trends Lesson 8: Creating Geographic Visualizations Topic A: Create Maps Topic B: Customize Mapped Data Lesson 9: Getting Answers with Ask and Explain Topic A: Ask Data Topic B: Explain Data Additional course details: Nexus Humans Tableau Desktop - Part 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Tableau Desktop - Part 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Tableau Desktop - Part 2
Delivered OnlineFlexible Dates
£1,400

FCA Compliance Essentials

5.0(4)

By LGCA | London Governance and Compliance Academy

Description FCA Compliance Essentials Begin your journey in compliance management with practical knowledge of the laws and legislations that make up the regulatory field in the United Kingdom. Do you know that FCA sets an annual CPD requirement both for senior managers and employees of financial service firms? As per TC 2.1.15 & 2.1.16, the requirement is 35 hours in each 12 months, including 21 hours of structured CPD activities. Furthermore, TC 2.1.20G27/05/2022 defines structures CPD activities as follows: 'Examples of structured continuing professional development activities include participating in courses, seminars, lectures, conferences, workshops, web-based seminars or e-learning.' Our FCA Compliance Essentials Bundle, with an overall duration of about 40 hours, fulfils and even exceeds the FCA requirement in terms of CPD hours and is ideal for any professional within Financial Services. Enroll now and enjoy a special price! Who should attend? Banks' managers/officers Investment Services Companies managers/officers Insurance Companies managers/officers Listed Companies managers IT managers/officers of companies developing IT systems/applications for financial institutions in order for them to meet the regulatory requirements Lawyers Officers exercising control activities (internal auditors, inspectors, external auditors, operational risk managers etc) Professionals wishing to work in Compliance in the future Graduate or post graduate students. Professionals that wish to make an international career in Compliance and would like to have a broader picture of how Compliance works and its methodologies, at international level. Compliance Officers Risk Managers MLROs

FCA Compliance Essentials
Delivered Online On Demand
£399.20

Excel 2007 Simplified

By iStudy UK

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

Excel 2007 Simplified
Delivered Online On Demand8 hours 4 minutes
£25

Certified TIA-942 Internal Auditor (CTIA)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for The primary audiences for this course are quality directors and quality assurance managers, managers responsible for the governance of an enterprise and management of its risks, technical experts, project managers and consultants, internal auditors, compliance officers and virtually anybody involved in ANSI/TIA-942 compliance certification related projects either from an end-user or vendor perspective. Participants must hold a valid CTDC certificate in order to be able to register for the CTIA class. Overview After completion of the course the participant will be able to: 1. Prepare the organisation for an audit according to ANSI/TIA-942 including preparation of the required documents, resource planning and management of the audit process itself 2. Conduct an internal audit according to ANSI/TIA-942 following ISO-19011 guidelines 3. Facilitate and support the external audit to ANSI/TIA-942 4. Manage the post-audit process with respect to CAR (Corrective Action Reports), gap closing and _nal certification 5. Facilitate surveillance and recertification audits This intensive course builds further on the technical understanding of the standard acquired in the CTDC© (Certified TIA-942 Design Consultant) course. Fundamental concepts and process of an internal audit Terms and de_nitions Difference between an internal and external auditor Audit principles Auditor competency requirements Managing an audit programme Establishing the audit objectives Establishing the audit programme Planning the audit Planning the schedule Resource planning Tools/equipment required Document requirements - Design documents - Process documents - Declarations Conducting the audit Conducting an opening meeting Conducting the audit Interviews Document review Facility review Typical non-conformities - Architectura - Electrica - Mechanical - Telecommunications Preparing the audit conclusions Conducting the closing meeting Preparing and distributing the audit report Audit report requirements Classification of non-conformities Typical format of an audit report Following up on the audit The CAR ? Corrective Action Report Evaluation of the Corrective Action Report Requesting a formal external auditIssuing a conformity certificate Requirements of the certificate Registration of the certificate Surveillance auditsRecertification auditsExam: Certified TIA-942 Internal Auditor) Actual course outline may vary depending on offering center. Contact your sales representative for more information. Additional course details: Nexus Humans Certified TIA-942 Internal Auditor (CTIA) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Certified TIA-942 Internal Auditor (CTIA) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Certified TIA-942 Internal Auditor (CTIA)
Delivered OnlineFlexible Dates
£1,500

Pet Business Certificate

4.3(43)

By John Academy

Description Learn how to train animals, walk them safely, look after them and start your own pet business! This Pet Business Certificate starts with the basics of first aid and find out how to administer pills, liquid medications, and injections to an uncooperative cat or dog. You will explore pet care, including nutrition, exercise, first aid, and identification of common diseases. You'll also explore sticky situations that can arise, such as lost pets, pets that die unexpectedly, and pets that need immediate veterinary care. You will learn about finances and explore start-up costs, accounting, fee-setting, business plans, and low-cost marketing. You'll learn how to obtain required insurance, hire employees as your business expands, and entice financial institutions to loan you money.  By the end of this course, you'll have all the knowledge you need to become a professional pet sitter. In addition, you'll see how your pet sitting business can grow to continually challenge and satisfy you. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is This Pet Business Certificate Course for? Pet Business Certificate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Pet Business Certificate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction 00:06:00 Legal Requirements Legal Requirements 00:37:00 Running Your Own Business Running Your Own Business 00:16:00 Marketing Marketing 00:16:00 Setting Your Prices Setting Your Prices 00:11:00 Business Costs Business Costs 00:08:00 Forms & Record Keeping Forms & Record Keeping 00:15:00 Pre-Service Visit Pre-Service Visit 00:07:00 Difficulties & Challenges Difficulties & Challenges 00:17:00 Assessment Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Pet Business Certificate
Delivered Online On Demand2 hours 13 minutes
£11.99

Loading Master Training Certification Course for Oil & Gas

By EnergyEdge - Training for a Sustainable Energy Future

Dive into the world of oil and gas with Energyedge's Loading Master Training Certification Course. Enroll now for a rewarding career ahead.

Loading Master Training Certification Course for Oil & Gas
Delivered In-PersonFlexible Dates
£2,399 to £2,599

Payroll Management: Payroll Systems, Procedures, Controls and Recordkeeping

5.0(5)

By Online Training Academy

Are you ready to master the intricacies of payroll management? Our comprehensive course covers everything you need to know to excel in managing payroll systems, procedures, controls, and recordkeeping. Whether you're new to payroll or looking to enhance your skills, this course provides a deep dive into essential concepts and practices. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access In the "Payroll Management" course, learners will gain comprehensive knowledge and skills essential for effectively managing payroll processes within an organization. They will understand the fundamental functions and responsibilities of the payroll department, including how to staff and organize it efficiently. Learners will learn methods for accurately tracking employee work hours and managing compensation and benefits. They will also explore the importance of payroll procedures and controls in ensuring accuracy and compliance with regulations. The course covers essential practices for maintaining detailed payroll records and guides learners in designing and implementing effective payroll systems. By completing this course, learners will acquire a solid foundation in payroll management, enabling them to contribute effectively to organizational payroll operations and ensure smooth financial transactions for employees. Course Curriculum Module 01: Basic Functions of the Payroll Department Module 02: Staffing the Payroll Department Module 03: Employee Time Tracking Module 04: Compensation Module 05: Benefits and the Payroll Department Module 06: Payroll Procedures and Controls Module 07: Payroll Recordkeeping Module 08: Creating a Payroll System Module 09: Payroll Management Basics Learning Outcomes Understand payroll department functions and basic operational responsibilities. Apply staffing strategies suitable for efficient payroll management teams. Implement effective employee time tracking systems in payroll operations. Analyze compensation and benefits within the context of payroll management. Develop and implement payroll procedures ensuring compliance and accuracy. Maintain comprehensive payroll records adhering to legal and organizational requirements. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? HR professionals seeking advanced payroll management skills. Business administrators responsible for payroll functions. Accounting professionals aiming to specialize in payroll. Small business owners managing their own payroll. Individuals pursuing careers in payroll administration. Career path Payroll Administrator Payroll Coordinator HR Payroll Specialist Payroll Manager Payroll Officer Benefits Administrator Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Payroll Management: Payroll Systems, Procedures, Controls and Recordkeeping
Delivered Online On Demand2 hours 36 minutes
£10

Football Agent Advanced Diploma

4.9(27)

By Apex Learning

Tired of browsing and searching for the Football Agent course you are looking for? Can't find the complete Football Agent package that fulfils all your needs? Then don't worry, as you have just found the solution.

Football Agent Advanced Diploma
Delivered Online On Demand
£75