1101 Courses in London

This qualification covers complex accounting and finance topics and tasks leading to students becoming confident with a wide range of financial management skills and applications.  Course Overview This qualification covers complex accounting and finance topics and tasks leading to students becoming confident with a wide range of financial management skills and applications. Students will gain competencies in drafting financial statements for limited companies, recommending accounting systems strategies and constructing and presenting complex management accounting reports. Study the Level 4 Diploma in Professional Accounting to master complex accounting tasks and qualify for senior finance roles, as well as AAT full membership. The jobs it can lead to: • Accounts payable and expenses supervisor • Assistant financial accountant • Commercial analyst • Cost accountant • Fixed asset accountant • Indirect tax manager • Payroll manager • Payments and billing manager • Senior bookkeeper • Senior finance officer • Senior fund accountant • Senior insolvency administrator • Tax supervisor • VAT accountant Entry Requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success, we recommend that students begin their studies with a good standard of English and maths. Course Content: Applied Management Accounting (mandatory): This unit allows students to understand how the budgetary process is undertaken. Students will be able to construct budgets and then identify and report on both areas of success and on areas that should be of concern to key stakeholders. Students will also gain the skills required to critically evaluate organisational performance. Learning outcomes: • Understand and implement the organisational planning process. • Use internal processes to enhance operational control. • Use techniques to aid short-term and long-term decision making. • Analyse and report on business performance. Drafting and Interpreting Financial Statements (mandatory): This unit provides students with the skills and knowledge for drafting the financial statements of single limited companies and consolidated financial statements for groups of companies. It ensures that students will have a proficient level of knowledge and understanding of international accounting standards, which will then be applied when drafting the financial statements. Students will also have a sound appreciation of the regulatory and conceptual frameworks that underpin the preparation of limited company financial statements. Learning outcomes: • Understand the reporting frameworks that underpin financial reporting. • Draft statutory financial statements for limited companies. • Draft consolidated financial statements. • Interpret financial statements using ratio analysis. Internal Accounting Systems and Controls (mandatory): This unit teaches students to consider the role and responsibilities of the accounting function, including the needs of key stakeholders who use financial reports to make decisions. Students will review accounting systems to identify weaknesses and will make recommendations to mitigate identified weaknesses in future operations. Students will apply several analytical methods to evaluate the implications of any changes to operating procedures. Learning outcomes: • Understand the role and responsibilities of the accounting function within an organisation. • Evaluate internal control systems. • Evaluate an organisation’s accounting system and underpinning procedures. • Understand the impact of technology on accounting systems. • Recommend improvements to an organisation’s accounting systems. Business Tax (optional): This unit introduces students to UK taxation relevant to businesses. Students will understand how to compute business taxes for sole traders, partnerships and limited companies. They will also be able to identify tax planning opportunities while understanding the importance of maintaining ethical standards. Learning outcomes: • Prepare tax computations for sole traders and partnerships. • Prepare tax computations for limited companies. • Prepare tax computations for the sale of capital assets by limited companies. • Understand administrative requirements of the UK’s tax regime. • Understand the tax implications of business disposals. • Understand tax relief, tax planning opportunities and agent’s responsibilities in reporting taxation to HM Revenue & Customs. Personal Tax (optional): This unit provides students with the fundamental knowledge of the three most common taxes that affect taxpayers in the UK: Income Tax, Capital Gains Tax and Inheritance Tax. With this knowledge students will be equipped to not only prepare the computational aspects of taxes, where appropriate, but also appreciate how taxpayers can legally minimise their overall taxation liability. Learning outcomes: • Understand principles and rules that underpin taxation systems. • Calculate UK taxpayers’ total income. • Calculate Income Tax and National Insurance contributions (NICs) payable by UK taxpayers. • Calculate Capital Gains Tax payable by UK taxpayers. • Understand the principles of Inheritance Tax. Audit and Assurance (optional): This unit aims to give a wider understanding of the principles and concepts, including legal and professional rules of audit and assurance services. The unit will provide students with an awareness of the audit process from planning and risk assessment to the final completion and production of the audit report. Students will also get a practical perspective on audit and assurance, with an emphasis on the application of audit and assurance techniques to current systems. Learning outcomes: • Demonstrate an understanding of the audit and assurance framework. • Demonstrate the importance of professional ethics. • Evaluate the planning process for audit and assurance. • Review and report findings. Cash and Financial Management (optional): This unit focuses on the important of managing cash within organisations and covers the knowledge and skills to make informed decision on financing and investment in accordance with organisational policies and external regulations. Students will identify current and future cash transactions from a range of sources, learn how to eliminate non-cash items and use various techniques to prepare cash budgets. Learning outcomes: • Prepare forecasts for cash receipts and payments. • Prepare cash budgets and monitor cash flows. • Understand the importance of managing finance and liquidity. • Understand the way of raising finance and investing funds. • Understand regulations and organisational policies that influence decisions in managing cash and finance. Credit and Debt Management (optional): This unit provides an understanding and application of the principles of effective credit control systems, including appropriate debt management systems. Students will be introduced to techniques that can be used to assess credit risks in line with policies, relevant legislation and ethical principles. Learning outcomes: • Understand relevant legislation and contract law that impacts the credit control environment. • Understand how information is used to assess credit risk and grant credit in compliance with organisational policies and procedures. • Understand the organisation’s credit control processes for managing and collecting debts. • Understand different techniques available to collect debts. DURATION 420-440 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

This course is ideal for line managers who conduct appraisals for team members. The focus is on the conversations you will have in appraisals and how you can make them a positive experience for you, your employee and the organisation.

Learn CAD in 10 hrs

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

e-ALS ALS recertification

Enhance your knowledge of natural gas and LNG sales agreements with EnergyEdge course. Enroll now to gain valuable industry knowledge and skills.

Face to face training customised and bespoke. Online or Face to Face

Film and VFX face to face training customised and bespoke. One to One Online or Face to Face

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included