3258 Courses delivered Online

Payroll is a very important function for any businesses that pay their employees wages or salaries through PAYE Scheme. Through the payroll, function businesses calculate the correct amount Tax and NI to pay wages and salaries accurately. The payroll function is responsible for providing payslips and other documents to employees and reporting correctly to managers and HMRC. Sage Payroll Courses Starting our Sage Payroll courses will enhance your career potentials and give you the skills and knowledge you need to get started in Payroll. Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. Changes in Payroll Are you up to date with the latest RTI (Real Time Information) regulations introduced by HMRC? It's essential that companies comply with the changes.

AAT Bookkeeping Course Online Overview If you want to become a certified bookkeeper with AATQB (AAT Qualified Bookkeeper) status, then you must complete the AAT bookkeeping course successfully. This bookkeeping course is broken down into two levels, Foundation Certificate in Bookkeeping Advanced Certificate in Bookkeeping Once you pass all 5 exams successfully, you can gain AATQB status giving you a leading edge to build a successful career in bookkeeping. Next steps after qualifying You will be awarded with Foundation Certificate in Bookkeeping and Advanced Certificate in Bookkeeping from Association of Accounting Technicians (AAT) once you have passed all the exams. Therefore, you will be eligible for Certified Bookkeeper Status. It gives you greater recognition and professional approval. What you will gain? Firstly, this course will help you develop your skills in double entry bookkeeping and give you an understanding of management and administrative processes. You'll learn how to use manual bookkeepin systems and to work with the purchase ledger, sales ledger and general ledger. You would also get better understanding about VAT system and how to do VAT Return. You will be awarded with Foundation Certificate in Bookkeeping and Advanced Certificate in Bookkeeping from Association of Accounting Technicians (AAT) once you have passed all the exams. Therefore, you will be eligible for Certified Bookkeeper Status. It gives you greater recognition and professional approval. The AAT bookkeeping course covers the following areas: Bookkeeping transactions Bookkeeping Controls Advanced Bookkeeping Final Accounts Preparation Indirect Tax

Sage Payroll Training Course - Fast Track This course brings you the skills you need to use this popular payroll program to confidently process any businesses payroll. Being able to use Sage 50 Payroll should lead to greater productivity. But it also helps the business conform to employment legislation and data security requirements. Furthermore, broken down into practical modules this course is a very popular and well received introduction to moving from manual payroll to computerised payroll. Moreover, it incorporates all the new government requirements for RTI reporting. Finally, Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. You will receive a CPD Completion certificate from Osborne Training once you finish the course. What skills will I gain? In this course you will be learning from Level 1 to Level 3 of Sage Computerised Payroll which could help you to land on your dream job in Payroll sector. Level 1 Introduction to payroll Introduction to Real Time Information (RTI) Preparing employee records Starters - new employees Calculation of Gross Pay The PAYE and National Insurance systems Creating Payslips and analysis Creating Backups and Restoring data Payment analysis Processing National Insurance contributions Voluntary deductions Processing Leavers Completing the payroll Procedures Level 2 Introduction to Payroll Introduction to Real Time Information (RTI) Preparing employee records Creating Backup and Restoring Data Starters - new employees Calculation of Gross Pay Deductions - Pension schemes and pension contributions Processing the payroll - introduction to the PAYE system Processing the payroll - income tax National Insurance contributions - Processing in the payroll Voluntary deductions Student Loan repayments Attachment of Earnings Orders & Deductions from Earnings Orders Processing Leavers Introduction to statutory additions and deductions Processing Statutory sick pay (SSP) Processing Statutory Paternity Pay (SPP) Statutory paternity pay and paternity leave Completing the processing of the payroll Creating Payslips and analysis Reports and payments due to HMRC Level 3 Advanced processing of the payroll for employees Preparation and use of period end preparation of internal reports Maintaining accuracy, security and data integrity in performing payroll tasks. Deductions - Pension schemes and pension contributions Processing the payroll -complex income tax issues Payroll Giving Scheme processing Processing Statutory Adoption Pay (SAP) Advanced Income tax implications for company pension schemes Student Loan repayments Processing Holiday Payments Processing Car Benefit on to the Payroll System Attachment of Earnings Orders & Deductions from Earnings Orders Leavers with complex issues Advanced processing of statutory additions and deductions Recovery of statutory additions payments - from HMRC Completing the processing of the payroll Complex Reports and payments due to HMRC Cost Centre Analysis Advanced, routine and complex payroll tasks Calculation of complex gross pay

AAT Bookkeeping Course If you want to become a certified bookkeeper with AATQB (AAT Qualified Bookkeeper) status, then you must complete the AAT bookkeeping course successfully. This bookkeeping course is broken down into two levels, Foundation Certificate in Bookkeeping Advanced Certificate in Bookkeeping Once you pass all 5 exams successfully, you can gain AATQB status giving you leading edge to build a successful career in bookkeeping. Next steps after qualifying You will be awarded with Foundation Certificate in Bookkeeping and Advanced Certificate in Bookkeeping from Association of Accounting Technicians (AAT) once you have passed all the exams. Therefore, you will be eligible for Certified Bookkeeper Status. It gives you greater recognition and professional approval. What you will gain? Firstly, this course will help you develop your skills in double entry bookkeeping and give you an understanding of management and administrative processes. You'll learn how to use manual bookkeepin systems and to work with the purchase ledger, sales ledger and general ledger. You would also get better understanding about VAT system and how to do VAT Return. You will be awarded with Foundation Certificate in Bookkeeping and Advanced Certificate in Bookkeeping from Association of Accounting Technicians (AAT) once you have passed all the exams. Therefore, you will be eligible for Certified Bookkeeper Status. It gives you greater recognition and professional approval. The AAT bookkeeping course covers the following areas: Bookkeeping transactions Bookkeeping Controls Advanced Bookkeeping Final Accounts Preparation Indirect Tax

AAT Bookkeeping Course Overview Are you looking to develop a career in Bookkeeping? As a successful Bookkeeper, you could earn on average more than £25,000 per year. (Source: National Career Service). And if you want to become a certified bookkeeper with AATQB (AAT Qualified Bookkeeper) status, then it is mandatory that you complete the AAT bookkeeping course to build a successful career in bookkeeping.  Bookkeeping Course Duration You can expect the AAT bookkeeping distance learning courses to take up to 6 months to complete for most students given that you attend classes and assessments regularly. Bookkeeping Courses Tutors Osborne Training tutors are highly qualified with extensive knowledge of bookkeeping. They helped thousands of students to achieve over 96% pass rate and to reach their career goal. They are industry recognised for bookkeeping courses in UK. Bookkeeping Courses from London Campus  Evening, Weekend and Daytime sessions for AAT Bookkeeping courses are offered from London campus. Why Osborne Training? Osborne Training tutors are expert and with many years of industry experience You get 24/7 Access to the State of the Art Virtual Learning Campus Free High quality study material Free exam preparation kit Flexible payment option available Expert Tutorial support from the tutor Student Discount Card from NUS* Exam Booking Service at our campus Various Campus around UK Free Tablet PC ( For Limited Period) Osborne Books are provided for AAT Bookkeeping Courses. Once you successfully complete the bookkeeping course, you will get a certificate from AAT to confirm your professional bookkeeping qualification achievement. Jobs available for Bookkeeper Senior Credit Controller Sales/Purchase Ledger Clerk Accounts senior Senior Bookkeeper In these roles, you could earn on average more than £25,000 annually. (Source: National Career Service) This AAT bookkeeping course is awarded by AAT and broken down into two levels, AAT Foundation Certificate in Bookkeeping  (also known as AAT Level 2 Bookkeeping) Bookkeeping Transactions Bookkeeping Controls Advanced Certificate in Bookkeeping Advanced Bookkeeping Final Accounts Preparation Indirect Tax Once you pass all 5 assessments successfully, you can gain AATQB status giving you competitive edge to build a successful career as a bookkeeper.

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Enhance your accounting skills and proficiency in Microsoft Excel with our Accounts Clerk and MS Excel Training course. Learn the fundamentals of bookkeeping, accounting principles, and Excel functions. Ideal for aspiring accounts clerks and professionals seeking to improve their Excel proficiency for efficient data management and analysis.

Duration 2 Days 12 CPD hours In this course, you will be introduced to Intuit?s cloud accounting software program, QuickBooks Online (QBO). Using a fictitious company called Luxury Lodging, Inc, students will learn how to navigate the QBO interface. We cover basic accounting, how to set up a new company, how to customize the chart of accounts and products and services list. In addition, students will learn how to give other users, such as accountants access to their data. In the sales center chapter, students will learn how to invoice customers and stay on top of accounts receivable balances. In the vendor center chapter, students will learn how to enter bills and expenses from vendors as well as stay on top of the accounts payable balances. The final chapter in the textbook is a final project that encompasses the key topics covered in this course. Course Outline Chapter 1 :Introduction Chapter 2 :An Overview of QBO & Navigation Basics Chapter 3 : Accounting Basics Chapter 4 : Setting up A New Company File Chapter 5 : Managing the Chart of Accounts List Chapter 6 : Managing the Products and Services (Items) List Chapter 7 : Adding and Managing Users Chapter 8 : The Sales Center Chapter 9 : The Vendor Center Chapter 10 : 1099 Tracking and Reporting Chapter 11 : Managing Bank and Credit Card Accounts Chapter 12 : Creating Financial Statement Reports Chapter 13 : Entering Historical Data and Opening Balances Chapter 14 : Putting It All Together Additional course details: Nexus Humans Get Started with QuickBooks Online 2021-2022 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 Get Started with QuickBooks Online 2021-2022 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.

Overview Show that you are committed to providing the absolute best in Customer Service with this expert training. This Customer Service for Hospitality course will coach you in Customer Service expectations and offer useful recommendations for displaying outstanding Customer Service performance. Any business is reliant on its Customer Service staff, showing consideration and attention to its clients, and you can be taught to embody this Customer Service protocol. You will learn how to pre-empt requests by Customer Service customers and to perform tasks diligently. The specific requirements for Customer Service are also covered in-depth, alongside the UK legislation that governs Customer Service events and establishments with Customer Service staff. This Customer Service course is designed to equip you with the essential Customer Service skills needed to excel in the hospitality industry. From understanding the nuances of Customer Service interactions to mastering the art of proactive Customer Service, you will be prepared to handle any Customer Service challenge that comes your way. Whether you are new to the field or looking to enhance your Customer Service expertise, this training will set you apart as a Customer Service professional. With a focus on practical applications, this Customer Service course ensures that you are not just learning theory but are also capable of applying Customer Service principles in need. Enrol today to elevate your Customer Service capabilities and make a lasting impression in the Customer Service sector. Why Choose this Customer Service Bundle? FREE Customer Service CPD-accredited certificate Get a free student ID card with Customer Service training (£10 applicable for international delivery) Lifetime access to the Customer Service course materials The Customer Service program comes with 24/7 tutor support Get instant access to this Customer Service course Learn Customer Service training from anywhere in the world The Customer Service training is affordable and simple to understand The Customer Service training is entirely online How will I get my Customer Service certificate? You may have to take a quiz or a written test online during or after the Customer Service course. After successfully completing the course, you will be eligible for the certificate. Who is this Customer Service course for? There is no experience or previous qualifications required for enrolment in this Customer Service for Hospitality. It is available to all students, of all academic backgrounds. Requirements Our Customer Service for Hospitality is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Customer Service course has been designed to be fully compatible with tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value of your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum Module One: Who We Are and What We Do - 00:17:00 Module Two: Establishing Your Attitude - 00:12:00 Module Three: Identifying and Addressing Customer Needs - 00:12:00 Module Four: Generating Return Business - 00:14:00 Module Five: In-Person Customer Service - 00:10:00 Module Six: Giving Customer Service over the Phone - 00:12:00 Module Seven: Providing Electronic Customer Service - 00:12:00 Module Eight: Recovering Difficult Customers - 00:15:00 Module Nine: Understanding When to Escalate - 00:14:00

Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Microsoft Office 2016 Excel Beginner to Advanced Course Description At this time and age, it is pretty impossible to land a good job without some basic Excel skills. So, if you want to build an impressive resume, it is high time you acquire advanced-level Excel skills. It will uplift your CV and keep you ahead of the competition. The Microsoft Office 2016 Excel Beginner To Advanced course is the perfect place to develop your Excel skills. Here, you will learn basic to advanced-level Excel in no time. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Receptionist Office Admin Data entry Officer Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources