210 Mac courses in Tyldesley

IPAF training is the most widely recognised standard for Mobile Elevated Work Platform operators. These are commonly known as MEWP’s or Scissor Lifts and Cherry Pickers. MHA Training is a fully approved and registered IPAF member and we can deliver a wide range of courses. This can be done at our training centre in Warrington or On-Site at customer premises Nationwide. The International Powered Access Federation (IPAF) promotes the safe and effective use of powered access worldwide. Set up in 1983, IPAF is a non-profit organisation that represents the interests of member training companies. Over the years, IPAF has played a key role in promoting many of the design safety and testing procedures that are now established in the powered access industry. Companies such as MHA Training in Warrington are responsible for training for over 90,000 operators each year. Those who successfully complete their training at our centre in Warrington, or out On-Site nationwide are awarded the PAL Smart card. The (Powered Access Licence) is the most widely held and recognised qualification for mobile platform operators. The PAL Smart card is valid for five years and shows the machine categories that an operator has been trained on. It also features the holders photo and signature, and can be verified on their website. IPAF itself does not provide any training, it is provided by approved quality training centres like MHA Training. Approved training centres are regularly audited by IPAF, which ensures the highest standards are consistently met. Class sizes are kept small and courses generally last 1-2 days and are a mixture of theory and practical. To ensure success candidates must then undergo a 30 question multiple choice paper and a practical test. Course material is available in many languages and training centre’s receive regular updates. MHA Training was established in 2008 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. IPAF E-Learning. IPAF’s new E-learning module is part of its full training programme for mobile elevating work platforms (MEWPs). The E-learning module delivers flexibility and interactive tools, with the same emphasis on practical training. Together with supervised written and practical testing of operator skills. E-learning can lead to a PAL Card (Powered Access Licence) which proves that the operator has successfully completed the training and is able to operate MEWP’s safely. Benefits: Flexible. Trainees complete the theory part anytime, anywhere, on any device, at their own pace. Interactive. Engages trainees with games, quizzes, videos and simulations. Operator E-learning does not replace practical training. Trainees who complete the online session must still pass a supervised theory test with an IPAF centre like MHA training. Also must successfully complete a minimum half-day of practical training and testing before being issued a PAL Card as proof of successfully completed operator training. Training Courses Available: Operators. Demonstrators. Static Boom (1b). Mobile Vertical (3a). Mobile Boom (3b). Push Around Vertical (PAV). Other courses: Harness Use and Inspection (H).

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

In the past, popular thought treated artificial intelligence (AI) as if it were the domain of science fiction or some far-flung future. In the last few years, however, AI has been given new life. The business world has especially given it renewed interest. However, AI is not just another technology or process for the business to consider - it is a truly disruptive force.

Data Ethics for Business Professionals is designed for individuals who are seeking to demonstrate an understanding of the ethical uses of data in business settings.

English courses for all levels are available through Mac International

REFERENCE CODE 610/0134/X COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in either site carpentry including first and second fixing, those who are involved in shopfitting site work or those who carry out shopfitting bench work. The qualification is at level 3 although there may be some units at different levels. Level 3 qualifications are primarily aimed at those who are fully trained and experienced in a wide range of work activities, It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so the qualification has been developed to make it as widely available as possible. All work completed must be carried out 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 pathways and units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. The qualification consists of 3 pathways. What is required from candidates? Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 404. Pathway 1 Site Joinery, Pathway mandatory units Level Credits Installing bespoke first fixing components in the workplace Installing bespoke second fixing components in the workplace Setting up and using transportable cutting and shaping machines in the workplace Erecting roof structure carcassing components in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 1 Site joinery – Optional units minimum of 1 unit must be achieved Erecting structural carcassing components in the workplace Maintaining non-structural and structural components in the workplace Pathway 2-Shopfitting site work-Pathway mandatory units Marking out from setting out details for routine shopfitting products in the Summary of the: GQA LEVEL 3 NVQ DIPLOMA IN WOOD OCCUPATIONS (CONSTRUCTION) Installing shopfitting frames and finishings in the workplace Installing shopfitting fitments in the workplace Installing shopfronts and finishings in the workplace Setting up and using transportable cutting and shaping machines in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting-Bench Work – Pathway mandatory units Producing setting out details for routine shopfitting products in the workplace Marking out from setting out details for routine shopfitting products in the workplace Manufacturing routine shopfitting products in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Manufacturing bespoke shopfitting products in the workplace Setting up and using fixed machinery in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting – Bench work – Pathway optional units a minimum of 1 unit must be achieved Producing CAD setting out details in the workplace Producing wood and wood-based products using computer numerically controlled/numerically controlled (CNC/NC) machinery in the workplace Producing setting out details for bespoke shopfitting products in the workplace Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, contact Oscar Onsite Academy

REFERENCE CODE 601/8330/5 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in installing roof sheeting and cladding systems and associated tasks on site working from drawings and specifications. It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so there is a group of optional units to cover these matters, however all candidates will need to prove competence in preparing the resources required, installation of sheeting and cladding systems and rainwater goods (gutters, pipes, downpipes and angles (swan necks, off sets), brackets and supports, sumps, overflows and outlets). All work completed must be carried out 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, repair and/or refurbishment of roof sheeting/cladding/rainscreen systems, working with boom and/or scissor type mobile elevating platforms (MEWPs), installing solar collectors, use of ergonomic manipulating machines or slinging/signalling the movement of loads.

REFERENCE CODE 601/8331/7 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in installing Rainscreen wall cladding systems and/or roof sheeting and cladding systems that involve curved and complex roof and wall formations in the workplace, working from drawings and specifications. It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so the qualification has been developed to make it as widely available as possible by having 2 distinct pathways. All work completed must be carried out 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 relevant mandatory pathway units of installation of the relevant system (roof and wall sheeting and cladding or rainscreen wall cladding systems) , candidates will also be able to select optional units recognising skills including, repair and/or refurbishment of roof sheeting/cladding/rainscreen systems, working with boom and/or scissor type mobile elevating platforms (MEWPs), installing solar collectors, use of ergonomic manipulating machines or slinging/signalling the movement of loads. The standards cover the most important aspects of the job. This qualification is at Level 3, although some units may be at different levels, qualifications at this level are primarily aimed at those who are fully trained and experienced in a wide range of roles that may involve decision making, quality checks, work planning and dealing with non-routine or complex installations. The qualification consists of 3 mandatory units and 2 pathways, Wall sheeting and cladding and Rainscreen Wall Systems. Candidates must achieve the 3 qualification mandatory units plus the required credits from the selected pathway. The minimum credit value of the Wall sheeting and cladding qualification is 132 credits, the minimum credit value of the Rainscreen wall systems qualification is 104 credits.

REFERENCE CODE 603/5204/8 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this Qualification for? This qualification is aimed those who carry out supervisory activities in a specific trade in the Construction Industry. The qualification certificate will carry an endorsement to show what trades the candidate was supervising during completion of this qualification. The qualification has a core group of 5 mandatory units that cover areas including Health and Safety, confirming work requirements and coordinating work operations. The qualification also has a group of optional units to allow flexibility to suit individual needs and responsibilities and completion of mandatory units and a minimum of 2 units from the optional group will give access to the relevant CSCS card. This qualification replaces version 1 of the GQA Level 3 NVQ Diploma in Occupational Work Supervision (Construction) QAN 601/3469/0 for anyone starting the qualification from 01/11/2019. What is required from candidates? This qualification consists of 5 mandatory units, which have a total of 57 credits and a group of optional units. Candidates must complete all 5 mandatory units and a minimum of 2 units from the optional group. GQA qualifications are made up of units that have a credit value or credits. These credits must be achieved in the correct combination of mandatory and optional units. Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria. The units of assessment set out learning outcomes which describe what learners need to be able to do and understand. The learning outcomes are defined by assessment criteria which are used to assess competence, expressed as skills achieved and learned knowledge and understanding, to achieve the units. Achievement of the mandatory units and chosen optional units will mean the qualification has been completed and will be subject to approval of a claim for certification. GQA Qualifications will issue a certificate complete with the learner’s name, the qualification and unit titles and the credits achieved. Mandatory units Level Credit Confirming Work Activities and Resources for an Occupational Work Area in the Workplace Developing and Maintaining Good Occupational Working Relationships in the Workplace Confirming the Occupational Method of Work in the Workplace Implementing and maintaining health, safety and welfare in the workplace Coordinating and organising work operations in the workplace Optional Units – Minimum of 2 units (19 credits must be achieved) Allocating and monitoring the use of plant, machinery, equipment or vehicles in the workplace Monitoring progress of work against schedules in the workplace Confirming work meets contractual, industry and manufacturers’ standards in the workplace Implementing procedures to support the team performance in the workplace 3 13 Co-ordinating and confirming the dimensional control requirements of the work in the workplace Entry requirements There are no formal entry requirements for learners undertaking this qualification. However, centres must ensure that learners have the potential and opportunity to gain the qualification successfully. Qualification support This qualification has been designed and developed by CITB and GQA Qualifications have authorised Oscar Onsite Academy to deliver this qualification in the Construction Sector. Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for Oscar Onsite Qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar