11312 Courses

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

"Elevate your skills, one-on-one" Say goodbye to crowded classes and generic curriculums. Say hello to personalised mentorship and hands-on training that helps you reach your full potential. At Peaches Training Academy your learning style will be catered for and you’ll not fade into the background of a class full of other people. You’ll experience true, quality training in a 1-1 setting. What’s more? You can choose for it to be in our academy or in the comfort of your own salon or beauty room. When you book Peaches for your next beauty course, you’ll experience: 🍑 1-1 training 🍑 On-site in the comfort of your own salon or beauty room 🍑 All courses are accredited (therefore are true qualifications) 🍑 Free lifetime student support in WhatsApp 🍑 No kit required for your training, we provide everything for the day Imagine being the centre of attention, all day long and learning in the best possible way for you. That’s the reality at Peaches. Enroll now and kickstart your beauty career

Our Intermediate course is designed for Barbers and Hairdressers to further their skill set over an intensive three days of training. Keeping class sizes small, our educators will develop your techniques and introduce new methods to further you in your career with daily lectures, demonstrations and practical hands on sessions on up to 8 live models provided by the Sid Sottung Academy. A bespoke course catered to each student, you will leave with an extended understanding of mens cutting and a refined eye to detail.

This course has been developed to give students a comprehensive, introduction to filmmaking. It is a creative, highly practical week in which the students form a film crew to make a short film from start to finish over 5 days. Our team are industry professionals who have extensive experience and lots of enthusiasm for working with students from a wide range of backgrounds and cultures. Our team all have enhanced CRB clearance and have undergone safeguarding training. Many of our students have been so inspired by their experience with us that they have gone on to a career in the industry and have returned to take part in an internship with us. Hands on experience from Day 1 Work as a professional film crew in state of the art studios Direct actors on set Learn Acting to camera techniques Learn how to light a set Use professional broadcast quality filmmaking equipment Build your confidence in a creative environment Gain a realistic insight into the career opportunities in the film industry Work in a small group with a high ratio of mentors to student (max. 12 students to 1 mentor)

Networks demystified training course description A concise overview course covering all aspects of networking with particular emphasis of use of the 7 layer model as a framework for discussing and learning new network terms enabling delegates to recognise the main buzzwords used in the industry. What will you learn Use the 7 layer model to classify networking terms. Differentiate between LANS and WANS. Recognise bandwidth measurements. List LAN and WAN technologies. Recognise cabling issues in a network. Networks demystified training course details Who will benefit: Sales staff, managers and other non-technical personnel. Technical personnel may benefit more from our Intro to data communications and networking course. Prerequisites: None. Duration 1 day Networks demystified training course contents What are networks? What is a network? Types of network, Local Area Networks (LANs), Wide Area Networks (WANs), connecting networks together with routers. The 7 layer model What is the 7 layer model? The importance of standards, using the 7 layer model to classify networking terms. Cables Copper, Fibre, Air, standards, connectors, LAN cables, WAN cables, distance limitations, hubs and repeaters, other issues. The radio spectrum. Bandwidth Bits and bytes. Bandwidth measurements, common technologies and their bandwidth, the impact of applications on bandwidth. Full and half duplex. Joining cables together to increase bandwidth (Link aggregation). LANs and WANs What is Ethernet? What is WiFi? What are Leased lines? What is MPLS? Ethernet switches Ethernet 'packets', MAC addresses, what is a switch, what is the difference between a hub and a switch. TCP/IP What is TCP/IP? What is a protocol? What is IP? What is TCP? The role of routers in joining LANS and WANS, What is the Internet? Applications Ways to use the network, clients, servers, web browsing and HTTP, Email, instant messaging, multimedia applications.

Embark on a journey to become a workplace hero with our comprehensive one-day Pediatric First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

Domestic ACS Re-assessment to be completed every 5 years.

Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

The IMI Level 2 Award in MOT Testing is the second stage in becoming a qualified MOT tester. It was developed alongside the Driver and Vehicle Standards Agency (DVSA) and is designed to equip learners with the qualification, knowledge and skills necessary to carry out and accurate and repeatable MOT Test Routine. Once you have successfully completed and passed this award, the final stage (stage 3) will be to complete a VT8 demonstration MOT test with a DVSA assessor to receive your certificate of competence. This will normally be conducted in your own Vehicle Testing Station (VTS) and successful completion will allow you to commence testing with immediate effect. What you will achieve Successful completion of the IMI Level 2 Award in MOT Testing (Classes 4 and 7), will give you a valuable academic qualification recognised by the DVSA that demonstrates your skills and knowledge in conducting MOT testing. Cost of Course The cost of this course is £795 + VAT per candidate. Course Overview The main topics covered during the course are: Working Safely within a Vehicle Test Centre Working Relationships Professional Development Pre-Test Checks Conducting the The MOT Test routine. Our courses are ran using a blend of practical and theory based study in small groups of 4 candidates in order to maximise on tutor contact time. Upon application, we will send you some pre-course learning materials and videos to study that will fully prepare you for what is a very demanding course and assessment. Completion of this work forms part of the guided learning hours for this course and is therefore mandatory. Candidates failing to complete this work may be refused entry onto the course. Entry Requirements To be eligible to undertake the The IMI Level 2 Award in MOT Testing (Classes 4 and 7), you must: have a current and full UK driving licence for the classes of vehicle you wish to test be a skilled mechanic, with at least 4 years full-time employment in the service and repair of cars and vans. have a suitable level 3 qualification (please see list below) have no unspent convictions for criminal offences connected with the MOT testing scheme or the motor trade, or involving acts of violence or intimidation and be of good repute. Click here for acceptable entry qualifications. Who Should Attend The IMI Level 2 Award in MOT Testing (Classes 4 and 7), has been developed for individuals who would like to improve their career by becoming qualified MOT Testers. The course is run over four days with the final assessments being conducted on day 4. Pre-course training material will be sent through 2 weeks before start date to complete prior attendance. The assessments consists of an online test of 40 questions and a demonstration MOT where you will be observed carrying out a full MOT demo test. The theory part of the test is ‘open book’ which means you will be able to use reference materials such as the MOT Testers Manual during the test. The pass mark for this test is 80%. Learners wishing to undertake this course MUST poses a good standard of written and spoken English as all MOT training and testing is conducted in English.

Develop the skills to become a professional bartender and fast-track your career, progress in a cocktail bartender position, having one week fun in Manchester City Center!