17728 Step courses delivered Online

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

This course is designed to enable learners to increase their understanding of risk assessment and risk management in Health and Social Care settings.

This course is designed to enable learners to increase their understanding of risk assessment and risk management in Health and Social Care settings.

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

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 Foundation Certificate in Bookkeeping and Advanced Certificate in Bookkeeping from the 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

The first Club and Community Forum will be held online on September 30th, 7-8pm. We'll discuss: Introduction to the forum and gathering your expectations. Active Lancashire and Sport Welfare Officer roles. Creating positive club and community cultures. Future forum plans and your input. The forum aims to connect people, share experiences, and promote best practices. We look forward to a successful first meeting.

VAT Accounting, Preparation and Submission Training Course Overview: Knowledge of how to prepare and submit VAT Return can help you to stand out from the crowd of job seekers. Moreover, if you are running a business or thinking of running a business, the vat training course will help you to understand the issues relating to vat more clearly and help process VAT Return more accurately and efficiently. Our VAT Training courses are eligible CPD Training for accountants and attending this course can give you a more detailed understanding of how to do a VAT return correctly. What is VAT Return? Almost every business has to submit a VAT Return. VAT Return contains Output VAT and Input VAT information to be submitted to Taxman (HMRC). Through the VAT return, HMRC knows exactly how much the business owes to HMRC. Moreover, HMRC can pay back any VAT amount overpaid which only can be determined through an accurate VAT return. How to do VAT Return Firstly, businesses need to register with HMRC before they can process a VAT Return. Businesses must fulfil the criteria to become VAT registered and to get a VAT Registration no. Once the business is registered they can then regularly submit the VAT return using specified VAT forms. There are many VAT Schemes available in general. There are some specialised VAT schemes available only for specific industries. Certificate of Attendance Understanding VAT Principles Analysis of different VAT Scheme Preparing VAT in Spreadsheet Reconciliation of VAT Completing a VAT return Import and Export VAT analysis Calculating VAT for a business with mixed zero-rated and standard-rated sales, using Spreadsheet Introduction of TOMS (Tour Operator Margin Scheme) Submission Steps of VAT Return to HMRC Introduction to Making Tax Digital(VAT) scheme

Overview Knowledge of how to prepare and submit VAT Return can help you to stand out from the crowd of job seekers. Moreover, if you are running a business or thinking of running a business, the vat training course will help you to understand the issues relating to vat more clearly and help process VAT Return more accurately and efficiently. Our VAT Training courses are eligible CPD Training for accountants and attending this course can give you a more detailed understanding of how to do a VAT return correctly. What is VAT Return? Almost every business has to submit a VAT Return. VAT Return contains Output VAT and Input VAT information to be submitted to Taxman (HMRC). Through the VAT return, HMRC knows exactly how much the business owes to HMRC. Moreover, HMRC can pay back any VAT amount overpaid which only can be determined through an accurate VAT return. How to do VAT Return Firstly, businesses need to register with HMRC before they can process a VAT Return. Businesses must fulfil the criteria to become VAT registered and to get a VAT Registration no. Once the business is registered they can then regularly submit the VAT return using specified VAT forms. There are many VAT Schemes available in general. There are some specialised VAT schemes available only for specific industries. Understanding VAT Principles Analysis of different VAT Scheme Preparing VAT in Spreadsheet Reconciliation of VAT Completing a VAT return Import and Export VAT analysis Calculating VAT for a business with mixed zero-rated and standard-rated sales, using Spreadsheet Introduction of TOMS (Tour Operator Margin Scheme) Submission Steps of VAT Return to HMRC Introduction to Making Tax Digital(VAT) scheme

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

Learn the skills, knowledge and have the confidence to tackle difficult conversations in a productive way. Course overview Duration: 1 day (6.5 hours) Do you worry about how to give negative feedback or deal with performance issues? Are you concerned about giving bad news? This workshop is designed to give you the skills, knowledge and confidence to tackle these scenarios in a productive way. If you are a people manager, team leader or supervisor looking to make those challenging conversations less stressful and more effective, this workshop is for you. Lots of practical sessions will ensure you have the opportunity to relate your learning to your real life work situations. The one day session will use professional actors in the afternoon so that you can practice handling real-life challenging conversations. Objectives By the end of the course you will be able to: Deal with a wide range of challenging conversations Describe the preferred behavioural style for giving feedback State the most appropriate influencing technique to use in your situations Explain how to give successful constructive feedback Content What are challenging conversations What type of challenging conversations occur? Why do we find them challenging? Communication Practical exercise to demonstrate and act as a refresher of the fundamentals of communication Barriers to communication especially in a difficult discussion Choosing the right behavioural style Refresher of assertiveness and why it is important in this context Practical exercise demonstrating how behaviour breeds behaviour, and the impact of choosing an inappropriate style Steps to using assertive behaviour Influencing Cialdini’s model for influence How to use influencing techniques in handling challenging conversations Practical application Feedback Understanding feedback – positive vs. negative Using the ABCBC model for feedback Using the basics of emotional intelligence to give effective feedback Practical application Practical Activities Professional actors will work with you in small groups in the afternoon to practice real-life challenging conversations.