2986 Link courses delivered Online

Advanced Microsoft Excel Training Course on Bookkeeping Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Microsoft Excel training | Excel Courses for Accountants: Excel Courses Overview Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel courses for accountants This course is a highly recognised excel course for accountants. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental program for professional Accountants. Excel spreadsheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills in excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills in Excel is a must for any potential professional accountants and who are already running a practice or considering opening a practice. Certificate of Attendance Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup, etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Our Fast Track Level 3 training course is tailor-made for immigration advisors and legal professionals seeking a targeted, time-efficient course focusing on essential OISC Level 3 syllabus fundamentals. This course is 1 day. Our fast track OISC Level 3 one day course is specifically designed for those interested in progressing to the next OISC level. This course focuses on 3 main areas which are introduced at Level 3: Preparation and conduct of appeals, Bail applications to the First-tier Tribunal and Pre Action-Protocol Letters. Throughout this training, you will acquire a comprehensive understanding of the intricate structures and frameworks governing UK immigration law at an advanced level. Our expert instructors will provide in-depth insights, practical knowledge, and invaluable tips to equip you with the necessary skills and confidence to handle complex immigration cases.   Course joining links, materials and instructions are sent out 24hours before the course starts. Why Study with Immigration Advice Service? Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our OISC Level 3 (Fast Track) preparation course is thoughtfully crafted to equip participants with a comprehensive understanding of the essential knowledge needed at OISC level 3. Our fully qualified and OISC regulated trainer will guide you through the process and ensure you are competent with elements covered within the course. Course Content: This fast track course is specifically designed to covers the following key areas. Introduction: The OISC Level 3 assessment The preparation and conduct of appeals Bail applications to the First-tier Tribunal Pre Action Protocol Letters Prior to judicial review Looking for a more in-depth training session? Why not check out our standard Level 3 training course which recaps and builds on from knowledge learnt at OISC Level 2 and delivered over a 2-day period.

Jennifer Holloway delivers keynotes, workshops and webinars for clients, both online and in person (no public courses are run). Here’s a selection of existing sessions to give you a flavour of what’s available (though new ones are being designed all the time, so if you don’t see what you need, just ask): Personal Brand – What? How? Why? An introduction to the subject of personal branding, this session explains what a personal brand is, why you already have one and how to define it so you can remain authentic at all times. Delivered as a 45-minute or 60-minute session x People Buy People – So Who Are You Selling? You want people to buy your personal brand…but what exactly is it? This session challenges people to think in a new way about what they bring to the table and what makes them tick, kicking off the process of defining their personal brand. Delivered as a 90-minute or 120-minute session x Discover Your Personal Brand When you really dig into the detail of not just what you offer but who you are, that’s when you discover your unique selling point. This session provides a step-by-step process to highlight your individuality and put it clearly into words. Delivered as a half-day or full-day session xx Deliver Your Personal Brand With Impact Every time you come into contact with people – whether online, on the phone or in person – they’re picking up clues about you. This session shares practical tips and techniques to ensure those clues create a positive impression. Delivered as a 120-minute or half-day session x Articulate Your Achievements To get the most from your personal brand you have to shine a light on the value you bring, but if you can’t communicate what that value is, you could be missing out. This session provides an easy-to-follow formula to set out your credentials in a subtle, yet very effective way. Delivered as a 60-minute or 90-minute session x How To Create A LinkedIn Profile To Be Proud Of Many of us have a LinkedIn profile, but how many of us are 100% certain it’s creating a positive impression? This session focuses on how to polish up your photo, headline and summary to get you noticed for the right reasons. Delivered as a 45-minute or 60-minute session x Networking For People Who Need Help Networking Some people are natural networkers – meeting people and building relationships with ease – but many feel less confident, unsure how to kick-start the process. This session offers easy-to-implement tips for connecting both in-person and online. Delivered as a 45-minute or 60-minute session And for those wanting an in-depth approach to developing their personal brand: Making The Most Of Your Personal Brand This programme delivers the full-monty: from learning what a personal brand is, to defining what your own brand is, to getting feedback on how others view your brand, to learning how to share your brand both in person and online. x It’s restricted to smaller groups, so every delegate gets individualised support, advice and feedback, plus it fosters an open and collaborative environment for each cohort. Delivered as blend of in-person and online learning, or entirely online

Course description Sage 50 Accounting / Bookkeeping Training - Fast Track Overview Want to open the door to working in Finance and Accountancy Industry? Starting Sage Line 50 Accounting Fast Track Training course will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Get a new direction for your career in Accountancy, according to statistics, the average salary for Accountants is £50,000 (Source: Reed), it is the sector where the employability rate is higher than any other sector. With the right skills and practical experience, you would be able to fast track your career in Accountancy and exactly that's where Osborne Training can fill the gap. The intensive programmes include all the skills required to fast track your career in professional Accountancy. Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime or Weekend sessions for Sage 50 Bookkeeping Training Course from London Campus. Online Live - Osborne Training offers online Evening sessions for Sage 50 Bookkeeping Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the exams. What qualification will I gain? You could Gain the following IAB qualifications provided that you book and register for IAB exams and pass the exams successfully: IAB Level 1 Award in Computerised Bookkeeping (QCF) 500/9405/1 IAB Level 2 Award in Computerised Bookkeeping (QCF) 500/9261/3 IAB Level 3 Award in Computerised Bookkeeping (QCF) 500/9407/5 Awarding body International Association of Book-Keepers Sage 50 accounts Course Syllabus Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Stock Valuation, Stock Control, Work in Progress and Finished Goods Prepare and Produce Final Accounts Extended Trial Balance Exporting Data including Linking to Other Systems Management Information Reports Making Decisions with Reports Using Sage Prepare and Process Year End Accounts and Archive Data Final Accounts for Partnerships including Appropriation Accounts The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

Get to grips with all the features of Teams, including calls and chats, Teams and Channels and Meetings Course overview Duration: 2 hours This session is aimed at those new or self-taught users of Teams to show them the features and how to setup and use it effectively. Objectives  By the end of the course you will be able to: Use the core functions of Microsoft Teams Set up Microsoft Teams Make Calls Send Chats to colleagues via teams Set up channels Run Teams meetings Content What is Teams Teams elements Setting up your Teams Setting up audio and video Using voicemail Setting voicemail language Calls and Chats Sending individual and group chats Making and receiving calls Missed call notification Searching Teams and Channels Creating channels Channel settings Setting channel notifications Emailing channels Creating private channels Posting to channels Alerting specific people in a channel Adding files to channels Sending links to channels Teams Meetings Setting up meetings Running meetings from channels Setting backgrounds Screen sharing in meetings Handing over control Creating meeting notes Adding files to teams or meetings Using the meeting chat

Expand your Power BI knowledge and take your reports to the next level. Course overview Duration: 1 day (6.5 hours) This course is aimed at existing users who want to expand their skills to use advanced reporting techniques and use DAX to create calculated columns and measures. Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data and create simple reports. Objectives  By the end of the course you will be able to: Import and connect data tables Create and use date calendars Create calculated columns Create and use measures Use drill down and drill through Create Tooltip pages Add and customise slicers Add action buttons Streamline your report for use in the Power BI Service Content Review of importing and loading data Importing data Transforming data Adding custom columns Creating data models Building visuals Creating date calendars Building date tables Creating Financial Year information Including Month and Day information Creating calculated columns Power Query custom columns vs DAX columns Creating DAX calculated columns Creating measures Implicit vs Explicit Measures Building measures Using DAX Common DAX functions Drill Down vs Drill Through Review of drill down Creating drill through pages Using drill through Creating ToolTips Pages Adding pages to use for Tooltips Linking ToolTip pages to visuals Using action buttons Adding images Adding buttons Setting actions Working with slicers Adding slicers Changing slicer settings Syncing slicers between pages Showing what has been sliced Setting slicer interactions Techniques in the Power BI Service Hiding the navigation bar Stopping users manually filtering

Learn how to use Microsoft Project to create and resource robust project plans and how to maintain and track throughout the project lifecycle. Course overview Duration: 1 day (6.5 hours) Our Project Planning and Control course gives you the essential skills to use Microsoft Project to build, resource and monitor project schedules. It looks at initial setup, building plans, using a work breakdown structure and managing resources through to baselining and progressing your schedule. This course is designed for new or existing users of Microsoft Project, and no previous experience of Project is required. Knowledge of planning techniques would be an advantage. Objectives  By the end of the course you will be able to: Create project schedules Build a Work Breakdown Structure Create relationships Set baselines Manage resources Set deadlines and task properties Print and report on your project Update and track project schedules Content Creating a new project Project defaults Project start date Setting default hours per day/week Setting daily working times Project timeline Building a project Creating a work breakdown structure Adding tasks and durations Estimated durations Setting milestones Recurring tasks Linking, Baselining and Resourcing Setting start dates and dependencies Task Inspector Resourcing Assigning resources Filtering available resources Baseline Setting a baseline Removing a baseline Managing resources Resource properties Dealing with over allocations Tasking information Constraint dates Setting deadline Assigning task specific calendars Task types Updating your project Completing work Completing work per resource Updating tasks Updating the project Rescheduling work Change highlighting Printing and reporting Setup and Printing Visual reports Using the Timeline Creating Dashboard reports

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

Getting Started The BSc in Health and Social Care is a comprehensive undergraduate program designed to equip students with the knowledge and skills necessary for success in the healthcare and social services sectors. This programme covers essential health, well-being, and social support topics, ensuring that graduates are well-prepared for fulfilling careers in these vital fields. Anglia Ruskin University offers the BSc (Hons) Health and Social Care program, a highly regarded undergraduate degree providing students with a deep understanding of the dynamic and crucial health and social care sectors. This program is tailored to equip students with the knowledge and skills essential for excelling in various roles within these sectors. The curriculum strongly emphasises integrating theory and practice, enabling students to develop the essential competencies required for effective healthcare and social work delivery. A standout feature of this program is its strong emphasis on real-world experience through placements and practical training, ensuring that graduates are well-prepared to tackle the challenges within the healthcare and social care sectors. Additionally, Anglia Ruskin University's distinguished reputation in healthcare education and research enhances the value of this program, making it an excellent choice for individuals aspiring to make a meaningful impact in these critical fields. The programme comprises two phases; the first is the Qualifi Level 4 and 5 Diploma in Health and Social Care, awarded by Qualifi and delivered by the School of Business and Technology London. The second phase is the BSc (Hons) Health and Social Care Top Up, awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Assignments and Project No examinations Entry Requirements A Level or Equivalent Minimum 1 Year of Health and Social care work experience Further, candidates are also required to demonstrate their English language proficiency. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase 1 - Qualifi Level 4 and 5 Diploma in Health and Social Care Programme Structure Level 4 - Modules The QUALIFI Level 4 Diploma in Health and Social Care comprises 120 credits, equating to 1200 hours of TQT and 600 hours of GLH. The diploma requires six mandatory units at Level 4.  Academic Study skills Reference No: T/505/9498  Credit: |20| TQT: 200 The primary objective of this unit is to equip individuals with the essential skills and knowledge required for effective higher education study, fostering the development of reflective and critical thinking abilities necessary for reaching their maximum learning potential and potentially advancing to the Level 5 Diploma in Health and Social Care. Communicating in Health and Social Care Reference No: H/505/9495  Credit: |20| TQT: 200 This unit aims to cultivate the learner's understanding of the various modes of communication utilised in health and social care settings and underscore their importance in ensuring efficient service delivery. An Introduction to Healthcare Policy  Reference No : F/505/9505   Credit: |20| TQT: 200 This unit seeks to enhance the learner's awareness of the diverse factors influencing healthcare and their impact on policy development. Evaluating healthcare policies will enable learners to scrutinise the crucial contemporary concerns facing policy-makers, service providers, and support recipients. Reflective Practice  Reference No : F/505/9519   Credit: |20| TQT: 200 Introducing learners to reflective practice in all its forms is the focus of this unit. Reflecting on and in practice holds significance in health and social care, promoting self-development and linking theoretical concepts to practical application. Managing people in Health and Social Care Reference No : L/505/9507  Credit: |20| TQT: 200 The primary objective of this unit is to provide learners with an understanding of the processes involved in the recruitment, management, and development of personnel in the health and social care workplace. Learners will investigate the procedures governing the management of individuals in this sector and explore how to instigate organisational change. Sociology: Concepts in Health and Social Care Reference No : M/505/9502  Credit: |20| TQT: 200 This unit aims to impart to learners an understanding of sociological concepts related to health and illness and their practical application in health and social care. It will enable learners to comprehend the nature of contemporary society and its influence on the perception of health and illness. Learners will delve into the structural aspects of culture, such as age, gender, ethnicity, social class, family, and households, and their impact on health and well-being. Level 5 - Modules The Level 5 Diploma is made up of 120 credits, which equates to 1200 hours of TQT and includes 500 hours of GLH. The Diploma requires five mandatory units at Level 5.  Principles Underpinning Health and Social Care Reference No : K/505/9496 Credit: |20| TQT: 200 Health and social care professionals must adhere to specific ethical and professional standards. This course module is designed to foster comprehension of the principles, theories, and regulations that form the foundation of health and social care practice. It also explores the various tools and systems in place to uphold high standards of practice within the industry. The Management of Quality in Health and Social Care Reference No : A/505/9521  Credit: |20| TQT: 200 Quality plays a significant role in the realm of health and social care. In this unit, students will acquire insight into diverse viewpoints concerning the quality of health and social care services and the methods used to evaluate them. This knowledge aims to empower and involve service users in the process. Research Project  Reference No : H/505/9500   Credit: |40| TQT: 400 The primary objective of this unit is to enhance students' research abilities, encouraging them to conduct a concise pilot study that directly pertains to their higher education program or career advancement. This endeavour aims to cultivate independent inquiry and critical analysis skills. Partnership working in Health and Social Care Reference No : A/505/9499  Credit: |20| TQT: 200 In this unit, students will grasp the significance of establishing favourable professional relationships in health and social care. The module will delve into the concept of partnership on three distinct levels: Collaboration with service users. Cooperation among health and social care practitioners. Engagement with organisations. Understanding these aspects will empower individuals to make informed choices and advocate for autonomy. Working with Service users with Complex Needs Reference No : T/505/9520  Credit: |20| TQT: 200 This course module aims to equip learners with insights into matters concerning health, disability, and illness. It further enables them to recognise effective strategies for assisting individuals with intricate physical and mental health requirements in their roles as healthcare professionals.   Phase 2 - BSc (Hons) Health and Social Care Programme Structure Leadership Practice in Health and Social Care Evaluating Research for Evidence-Based Practice Strategic Management in Health and Social Care Undergraduate Major Project Delivery Methods The programme comprises two phases; the first is the Qualifi Level 4 and 5 Diploma in Health and Social Care, awarded by Qualifi and delivered by the School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The program is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the BSc (Hons) Health and Social Care Top Up, awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.