1402 Opera courses in Blackpool delivered Live Online

Managing teams and projects to meet a private, public or voluntary organisation's goals.

Ensuring an efficient flow of goods and services between manufacturers and their skilled trade customer base.

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

SAP Training London: Overview What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Business Cases/ Live Project Our SAP training courses are designed in a way which gives the students maximum exposure of real-life scenario through no of business cases and guidance on implementation by professional SAP Consultants. Free SAP Access Free SAP Sandbox Access provided for 6 months so that you can practice even after your SAP training course. Certificate of Attendance- You receive a certificate once you finish the course from Osborne Training,  You can also do an external exam to receive certification from SAP (Optional), for details on exam booking you may visit the SAP website. SAP Training Modules Available Financial & Controlling (FICO) High-Performance Analytic Appliance (HANA) Supply Relationship Management (SRM) Customer Relationship Management (CRM)

SAP Courses Overview SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Business Cases/ Live Project Our SAP training courses are designed in a way which gives the students maximum exposure of real-life scenario through no of business cases and guidance on implementation by professional SAP Consultants. Certificate of Attendance- You receive a certificate once you finish the course from Osborne Training,  SAP Certification During the training, you get access to the SAP sandbox which continues even after training finishes until the completion of the Internship. You can also do an external exam to receive certification from SAP (Optional), for details on exam booking you may visit the SAP website. SAP Training Modules Available Financial & Controlling (FICO) High-Performance Analytic Appliance (HANA) Supply Relationship Management (SRM) Customer Relationship Management (CRM) Free SAP Access Free SAP Sandbox Access provided for 6 months so that you can practice even after your SAP training course.

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

SAP Training: Overview What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Business Cases/ Live Project Our SAP training courses are designed in a way which gives the students maximum exposure of real-life scenario through no of business cases and guidance on implementation by professional SAP Consultants. You receive a certificate once you finish the course from Osborne Training. SAP Certification During the training, you get access to Sap sandbox which continues even after training finishes until the completion of the Internship. You can also do an external exam to receive certification from SAP (Optional), for details on exam booking you may visit the SAP website. SAP Training Modules Available Financial & Controlling (FICO) High-Performance Analytic Appliance (HANA) Supply Relationship Management (SRM) Customer Relationship Management (CRM)

Learn the basics of financial awareness and better understand the language used by accountants and how financial statements fit together within organisations. Course overview Duration: 2 days (13 hours)  This workshop will provide participants with a grasp of basic financial awareness, to help them to better understand the language used by accountants and how financial statements fit together. Training is done in a jargon-free way that is aimed building attendees’ confidence in using financial terms and concepts within their organisation.  Competent financial management has many aspects, it is wide reaching and requires multiple skills but if participants work to become organised and effective in planning, these skills can be easily acquired. There is a misconception that to be a good operational manager dealing with financial decisions people must be accounting or numerical geniuses. There are basic skills that attendees can easily learn that will support them in those areas.  Objectives  By the end of the course you will be able to: Identify the importance of financial management and its impact Identify the link between financial information and decision making Set, manage, monitor and review budgets Analyse financial statements Demonstrate the link between the statements, budgets and decision making. Content Financial Management Budgeting process (generic / client specific if possible) Forecasting and re forecasting process The need for accurate forecasting Accrual v cash accounting revisited Financial Objectives of the business Users of the accounts Financial Tools Depreciation and Amortisation Accruals and Prepayments Deferred and Accrued Income Costs, Opex and Capex Financial Statements The Income Statement The Balance Sheet Understanding capital employed The relationship between balance sheet and income statement The cash flow statement Profitability: gross, operating and net margins Review of client’s management information reports Building the Business Case Break even analysis Discounted Cash Flow Discount factors Net Present Value (NPV) Internal Rate of Return (IRR)

Some 60% of injuries at work are caused by lifting heavy objects. This powerful, practical programme is designed to help stop any of your staff from becoming the next statistic. 1 Introduction and objectives 2 Overview of Health and Safety Legislation and HSE Injury Statistics Health and Safety at Work Act 1974 Management of Health and Safety at Work Regulations (MHSWR) 1992 MHSWR 1999 specific duties to risk assess Manual Handling Operations Regulations (MHOR) 1992 Breakdown of injury statistics and costs of poor manual handling 3 The musculoskeletal system explained Prevention and ill-health Ergonomics RSI The spine in detail 4 Risk assessment General principles The TILE method Employees' duties Workplace scenarios