3410 Courses

REFERENCE CODE 600/6511/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in plastering activities in the workplace. It is not expected that candidates working in this industry all do the same activities so the qualification has been developed to allow opportunities for those carrying out work in any one of the following broad categories: solid basic plastering, solid full plastering, basic fibrous plastering and full fibrous plastering. Those taking the qualification must also prove knowledge and competence in working at heights, calculating quantities and wastage and the use of powered and hand tools and equipment. All work completed must be done in accordance with building regulations and industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the core skills above, candidates will also be able to select optional units recognising skills including, working with direct bond dry linings, laying sand and cement screeds, installing mechanically fixed plasterboard and carrying out repair work. The standards cover the most important aspects of the job. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Transformers Themed Activity Day at Derbyshire Hill Family & Community Centre for children and teens aged 7+ Come and join us for an exciting HAF Activity themed around Transformers which includes graffiti art, djing, parkour, obstacle courses and games with our talented team from Powered by Hip Hop (UC Crew) Children aged 7+ and parents/carers/grandparents who are eligible for free HAF activities are all welcome to join us for our FREE funded activity day.

Did you know 1 in 4 people in the UK are likely to experience mental health problems each year? Mental health is just as important as physical health, yet whilst we know how to take care of our own physical health, many people do not know how to support relatives, friends and even colleagues who are experiencing poor mental health. By developing a greater understanding of common mental health issues, as well as how best to support and guide someone to professional help, you can help further reduce the stigma associated with mental health in the UK. The QA Level 3 Award in Mental Health First Aid in the Workplace (RQF) is a regulated and nationally recognised qualification that has been specifically designed for those who would like to raise their awareness of mental health, develop an understanding on how best to support, reassure and signpost colleagues to professional support. What’s more, candidates will develop the knowledge, skills and confidence to actively promote positive mental health within their workplace, making it an ideal qualification for mental health champions/first aiders, human resources, managers, supervisors and team leaders. What’s Covered? Understanding mental health and its importance The roles and responsibilities for mental health in the workplace Importance of own wellbeing as a mental health first aider Common mental health conditions, including: Characteristics and features Work-related stress Anxiety Eating disorders Depression Post-traumatic stress disorder (PTSD) Obsessive compulsive disorder (OCD) Phobias Bipolar Self-harm Psychosis Suicide Promoting positive mental health first aid in the workplace Best practice for employers Mental health first aid at work action plan Appropriate coping strategies How employers can provide support to employees in the workplace Assisting those off work or returning to work Procedures to support employees who are off work whilst experiencing poor mental health Types of support available both locally and nationally

Are you, or your company in need of high quality first aid training? Do you require excellent training to fully support colleagues in the workplace? MHA Training Ltd would love to help with any of these requirements. MHA Training is approved by Qualsafe Awards, an Awarding Organisation recognised by Ofqual. This means we can offer regulated Qualifications in these courses. All of our courses are aimed to help employers to comply with the Health & Safety (First Aid) Regulations. First Aid Training is required by who? A knowledge of basic first aid can make the difference between life and death. Studies have shown that effective first aid can be vital in the first few minutes after an emergency. There are plenty of success stories in the media about this training saving lives as it’s such an important life skill. A first aid qualification can help your resume, CV, or even open up job opportunities. There may also be opportunities to volunteer using your first aid skills. It has been a vital life skill that people have used for members of their own family not just in the workplace. The 3 main goals are to preserve life, prevent worsening and promote recovery. You never know when the need will arise to put these skills to use. The First Aid Training experience. A First Aid training course should be an interactive fun learning experience, not all chalk and talk. This is achieved by using fully qualified trainers/assessors, who are very experienced “hands on” training professionals. Our trainers are sympathetic to the needs of the individual trainee and adept at getting the best possible standard from the delegates. First Aid At Work Regulations: In the event of injury or sudden illness, failure to provide first aid could result in a casualty’s death. The employer should ensure that an employee who is injured or taken ill at work receives immediate attention. HSE will prosecute in cases where there is a significant risk, a disregard for established standards or persistent poor compliance with the law. HSE First Aid at Work – IMPORTANT! After 1st October 2013 the HSE is no longer responsible for approving providers of First Aid at Work courses. Providers must be approved by an Ofqual or SQA Awarding Body. MHA Training Ltd fully meets all of the new requirements. MHA Training has been established for 15 years, based at our training centre in Warrington, Cheshire. We provide an array of services On-Site also for clients around the North West in areas such as Manchester, Liverpool, Widnes, St Helens, Runcorn, Wigan, Preston and Leeds. Over the years we have expanded and have instructors available Nationwide.

In today's competitive business world firms are under unprecedented pressure to deliver value to their shareholders and other key stakeholders. Senior executives in all parts of the organisation are finding that they need some degree of financial know how to cope with the responsibility placed on them as business managers and key decision-makers; monitoring and improving business performance, investing in capital projects, mergers and acquisitions: all require some degree of financial knowledge. The key financial skills are not as difficult to learn as many people believe and in the hands of an experienced senior executive they can provide a formidable competitive advantage. After completing this course delegates will be able to: Understand fundamental business finance concepts; understand, analyse and interpret financial statements: Profit Statement, Balance Sheet and Cashflow Statement Understand the vital difference between profit and cashflow; identify the key components of working capital and how they can be managed to generate strong cashflow Evaluate pricing decisions based on an understanding of the nature of business costs and their impact on gross margin and break-even sales; managing pricing, discounts and costs to generate strong business profits; understand how lean manufacturing methods improve profit Use powerful analytical tools to measure and improve the performance of their own company and assess the effectiveness of their competitors Apply and interpret techniques for assessing and comparing investment opportunities in capital projects, business acquisitions and other ventures; understand and apply common methods of business valuation Understand the role of business finance in formulating and implementing competitive business strategy; the role of budgeting as part of the planning process and the various approaches to budgeting and performance measurement 1 Basic principles Delivering value to key stakeholders Accounting concepts, GAAP, IFRS and common terms Understanding and using the balance sheet Understanding and using the profit statement Recognising the vital difference between profit and cashflow Understanding and using the cashflow statement What financial statements can and cannot tell us 2 Managing and improving cashflow Sources of finance and their advantages and disadvantages What is working capital and why is it so important? Managing stocks, debtors and creditors Understanding how working capital drives business growth Understanding and avoiding the over-trading trap Unlocking the funds tied up in fixed assets: asset backed loans and leasing 3 Managing and improving profit Understanding how profits generate cashflow The fundamental nature of costs: fixed and variable business costs Understanding gross margin and break-even How common pricing methods affect gross margin and profit Effective strategies to improve gross margin Using value chain analysis to reduce costs Lean manufacturing methodsUnderstanding Just-in-time, 6 Sigma and Kaizen methods Improving profitEffective and defective strategies 4 Measuring and managing business performance Measures of financial performance and strength Investor behaviour: the risk and reward relationship Return on investment (ROI): the ultimate measure of business performance How profit margin and net asset turnover drive return on net assets Why some companies are more profitable that others Understanding competitive advantage: cost and differentiation advantage Why great companies failWhat happened to Kodak? Using a 'Pyramid of Ratios' to improve business performance Using Critical Success Factors to develop Key Performance Indicators 5 Budgeting and forecasting methods Using budgets to support strategy Objectives and methods for effective budgets Using budgets to monitor and manage business performance Alternative approaches to budgeting Developing and implementing Balanced Scorecards Beyond Budgeting Forecasting methods and techniques Identifying key business drivers Using rolling forecasts and 'what-if' models to aid decision-making

The Quintessential Customer Experience (QCx) Forum is a ‘peer advisory’ community of communications and Cx professionals whose primary objectives are: To help members keep abreast of the latest CX developments To share best practice across different industry sectors. To provide individual support, advice and guidance for members Membership includes quarterly meetings, team coaching, 1:1 mentoring and online resource. Benefits The QCx Forum benefits both the CX professional and the organisations they work for. Employer Benefits include: Benchmarking performance against organisations in different sectors Keeping up to date with latest trends Maintaining competitive advantage through exceptional customer experience. Individual Member Benefits include: Inspiration for new ideas and approaches Guidance and advice to implement new strategies Support and reassurance from peers What’s included: The current membership package* includes: Forum Meetings Quarterly ‘Mastermind Group’ gatherings in person at a London venue. Each meeting features a specialist speaker providing insights about new trends and best practice. Team Coaching Attendees have the opportunity to share and solve key CX-related challenges they face.  1:1 Mentoring Support Members have access expert mentors to develop new strategies, gain valuable new knowledge and enhance their professional growth. Online Resource Members have access to a dedicated portal providing access to useful templates, tools and articles. * The first annual conference is planned for 2024 Membership Fees and options Three options are available: Essentials - quarterly Forum meetings, team coaching and online resources. £1,400.00 (ex VAT) pa Standard annual membership - includes quarterly forum meetings, team coaching, 4 x 1:1 mentoring sessions and online resource.  £3,600.00 (ex VAT) per annum Platinum membership - over and above the standard membership, includes an intensive quarterly programme of bi-weekly coaching sessions  £4,700.00 (ex VAT) per annum Credentials The Chair of the QCx Forum is Quentin Crowe MA, FCIM. His CX consultancy journey began in 2001 working with clients in the fitness and education sectors. Using an adaptation of the SERVQUAL methodology, he and his team have worked with clients in the charity, quality assurance, construction and cutout sectors (including ISG). Quentin also mentors entrepreneurs, senior marketers and corporate executives. He also chairs a number of ‘mastermind’ groups.  Brands represented include Shell, Asahi, Reuters and St James’s Place Welsh Management.

The current global demand for clean energy has resulted in rapid growth in the renewable energy sector. As the renewable industry grows, so does the demand for talent to work within it, bringing lots of new career prospects. The industry is the perfect transition for individuals leaving the armed forces who will have benefitted from exposure to many of the skills and experience, as well as the work ethic, that are required to work within this exciting, fast-paced industry.

AAT Level 4 is the highest level or final stage of the AAT Accounting qualification. This qualification provides the skills necessary for a 'Finance Officer' role including the complex management accounting tasks, general management skills, drafting financial statements and specialist learning areas. This provides you with an opportunity to become a professional member of AAT and use it MAAT after your name. You are also entitled to exemptions in the UK's chartered and certified accounting qualifications. Besides, if you want to pursue your career further in University, you are entitled to exemptions for up to two years in various universities in the UK. What is AAT? AAT is an awarding body for vocational accountants. AAT is highly recognised globally with members over 130,000 worldwide. What are the benefits after completing AAT courses? A newly qualified AAT member can expect to earn an average of £21,600. Some accounting technicians work as accounts clerks; others go on to become managing directors or finance directors of well-known companies. Some go to work as a self employed accountant as AAT allows the student to become chartered. Osborne Training is an AAT Approved Training Provider in London. In taking the Association of Accounting Technicians qualification with Osborne Training, you will make one of the greatest decisions of your career. Duration You can expect this qualification to take 1-1.5 year to complete for most students. Tutors Tutors are highly qualified with extensive knowledge of accountancy. Study Options Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Osborne Books are delivered to students address with additional study materials and Tutorial support online. Online Live - Interactive tutorial sessions by expert tutors and access to world-class Virtual Learning campus for additional study materials. Classroom Based- Osborne Training offers Evening and Weekend sessions for AAT Level 4 from various centres in London, Watford, Birmingham etc. Once you finish AAT qualification and pass all exams successfully, you will be awarded globally recognised AAT Certificate in Accounting from AAT. AAT Level 4 Course Syllabus Management Accounting: Budgeting Management Accounting: Decision and Control Financial Statements of Limited Companies Accounting Systems and Controls Business Tax Personal Tax

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups