696 Other courses in Cambridge

Employee Assistance Programme Training

If you want to start installing independently or with an electrical contractor look no further as this course will give you the skills and knowledge required. This package which will allow you to become a fully qualified domestic installer and enable you to join a Competent Person Self-Certification Scheme and certify your own domestic work.

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

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 and Business Intelligence. 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. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Our one-day Park Tool School Basic: Ride with Confidence Course is perfect for anyone looking to learn how to address common issues while out riding. It is suitable for people with little to no knowledge of bike maintenance. This course is intended to ensure that participants leave at the end of the day with the confidence to fix common problems with their bikes. The maximum group size is 7. Our fully trained mechanic will be on hand to answer questions as they come up, and there is plenty of opportunity for practice. This course is fully endorsed by the Bikeabillity Trust for mechanic certification! For those participants seeking a Bikeability accreditation, there will be an assessment after the training. Please note for all other participants there is no assessment.   Course Detail Basic Mechanical Skills – tools, stands, home shop set-up, tension & torquing bolts, lubrication, threadlockers & cleaners, health & safety Safety “M” check Tyres, tube & puncture repair (innertube replacement), with wheel removal and installation Looking after your drivetrain: lubrication, cleaning and wear of chains, rear sprockets and chainrings Disc brake systems – differences of cable vs hydraulic, rotors, basics of brake alignment, pad replacement Caliper rim brake adjustment and pad replacement for v-brake, dual pivot road caliper and cantilever Field repairs – what tools to take and tips & tricks to get you home! Please note that we will be concentrating on standard derailleur geared bikes. If you have a bike with hub brakes and hub gears you may find some parts of this course less relevant to your bike, though most things are transferable. If you have any questions or worries, please ask.   Price The course costs £96 per person and includes: All tools and equipment A bicycle for you to work on if required (although we encourage you to bring your own where possible) Participants taking the course for a Bikeability accreditation will have an additional £20 fee for assessment and administration. When booking please tick the box in ‘Section 1: Choose Appointment’ to add this to your order. Please choose a course date below and fill out the form, you’ll then be able to pay online and further instructions for the course will be emailed to you. Refunds for courses are only given under exceptional circumstamces and never within 7 days of the advertised course. If we cancel the course for any reason a full refund will be given and a choice of alternative dates offered. If you have any further questions, do please get in touch. Finally, if you’re a Cambridge Cycling Campaign Member, we offer a 15% discount to support the good work that they do. Please get in touch for further details.    Assessment For Bikeability Instructors The Bikeability assessment will include: Conduct an “M” check Check and correct tyre pressure Check and correct loose wheels, handlebars, or other parts Correct saddle orientation Identify poor braking and correct pad placement and cable tension Checking and correcting bike fit, including saddle and handlebar height, and brake/shift lever orientation Further Details Course participants must be 18 years or above. We do welcome younger participants 16+ but we accept these on a case by case basis based on their prior experience. Please contact us to discuss prior to booking. Our scheduled courses are run at our training workshop in Cambridge. If you have any further questions, do please get in touch. For more information, please read our Terms & Conditions. 

Outspoken Cycles Park Tool School courses are aimed at home mechanics who wish to have an in-depth knowledge of their bikes as well as those individuals required to maintain bikes for friends, schools, clubs, businesses and other organisations. The 2 Day Intermediate course teaches you mechanical skills following the Park Tool Big Blue Book of Bicycle Repair syllabus to familiarise you with many bicycle systems and workshop practices. Completion of assessment leads to the award of a certificate. You are encouraged to work on your own bike. Please be aware for some elements of the course certain bikes may not be suitable, however, there are also a number of classroom bikes to work on where necessary. We can provide a classroom bike if you’re unable to bring your own.  Course Detail Over two days you will cover: Chains (Assessing wear, chain care regimes, removal, sizing and installation) Pedals, Cranks and Drivetrain (Assessing wear, removal and installation of all components) Cassettes and Freewheels (Removal and installation, assessing wear) Gear Setup (Cabling and setup) Rim & Mechanical Disc Brakes (Assessing wear, strip down and re-installation) Bicycle Setup (Choosing the right bike, saddle height) Frame Assessment (new and damage frame assessment, tools used for frame prep) Price The course costs £275 inc VAT. This includes Park Tool Big Blue Book of Bicycle Repair and the use of all tools and equipment while on course.  If you’re a Cambridge Cycling Campaign member, we offer a 15% discount to support the good work that they do. Please email us for access to your coupon code. Refunds for courses are only given under exceptional circumstances and never within 7 days of the advertised course. In the unlikely event we have to make the difficult decision to cancel a course, participants will be offered a refund or the option to reschedule. Please read our terms & conditions for full details. Pre-requisites Course participants must be 18 years old or above. We may be able to accommodate younger participants 16+, we accept these on a case by case basis based on prior experience. Please contact us to discuss. Participants should have a good knowledge of the key content outlined in the Basic: Ride With Confidence course before booking the Intermediate as this level of knowledge is assumed by the instructor on the day. There will be a brief refresher, but if you are unsure do get in touch to discuss. Course Timings, Assessment, Location & Travel Courses run 9am-4pm over two days, or 9:30am – 4:30pm for weekend courses. Courses take place in our dedicated training workshop at our offices in Cambridge. We have an abundance of bike racks, and we are close to Cambridge North Station. There is limited parking on site on a first-come-first-served basis and we are close to parking at Cambridge North Station. There is some limited on-road parking (at owners risk). You may also park for free at the Milton Park & Ride, which is only a short 15 minute cycle to our workshop.  Further details If you have any further questions, please do please get in touch to discuss.

This 3 day practical course (taken in professional beauty salon) designed to show You how to carry out manicures. This course is designed for complete beginners, who wish to learn from basic to professional most popular nail art techniques to start Your career as nail technicians. It is also good to refresh knowledge and learn new techniques for those of You that are already in business.

Course Information Embark on our GLP course offering extensive guidance and pragmatic support tailored for individuals serving as Study Directors or Principal Investigators overseeing non-clinical safety studies on pharmaceuticals, agricultural, and industrial chemicals within the realm of Good Laboratory Practice (GLP). This comprehensive programme extends its benefits to study staff and management operating in GLP-compliant environments. The course extensively covers the current OECD GLP Principles and UK GLP legislation, while also referencing international standards, regulations, and guidelines pertinent to the field. Benefits of this course: Practical help and guidance on the interpretation and application of GLP An opportunity to update your knowledge of GLP with the current interpretation of requirements Access to an experienced panel of speakers Information on how other organisations address GLP issues An opportunity to improve your understanding of the GLP requirements as they are applied in different situations. This course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Examine particular aspects of GLP Learn from the experience of others. Tutors Tutors will be comprised of (click the photos for biographies): Tim Stiles Consultant, Qualogy Ltd Tony Woodall Head of Quality Assurance, Alderley Analytical Gill Armour Study Monitor Team Leader, AstraZeneca Jane Elliston Senior Quality Assurance Auditor, Battelle UK Vanessa Grant -, - Jeanet Logsted CEO, Scantox Programme Please note timings may be subject to alteration. Day 1 09:00 Registration 09:15 Welcome and Introductions 09:35 Development of Good Laboratory Practice A review of the history of GLP, its current scope and application, with a synopsis of current European and international standards. 10:05 Roles and Responsibilities The responsibilities of study director, test facility, management and study staff in the conduct of a GLP study. 10:45 Break 11:00 The Roles and Responsibilities of the Study Director and Test Facility Management The role of the study director in the management and control of a study, as defined by GLP, and management's roles are explored. 11:45 Multi-site Studies What is a multi-site study and when should such concepts be applied on a study. The role of the study director and principal investigator in the planning, conduct and reporting of multi-site study are explored. 12:30 Study Plan (Protocols) GLP requirements for the preparation of a study plan, content, authorisation, amendments and deviations are discussed. 13:00 Lunch 13:45 Workshop 1 - The Study Plan Some practical problems with study plans and amendments explored. 14:45 Workshop 1 - Feedback 15:00 Standard Operating Procedures The control, content and authorisation of SOPs and the principles behind the practice. 15:30 Break 15:45 Workshop 2 - Practical Study Conduct Problems Dealing with practical problems encountered during the conduct of studies. 16:40 Workshop 2 - Feedback 17:15 Close of Day Day 2 09:00 Questions and Answers Discussion of issues raised by course delegates. 09:20 Quality Assurance The interactions between QA, management, study director and principal Investigator are discussed as is QAs role when conducting a multi-site study. 10:00 The Final Report The content of the final report and the role of those involved in its preparation and approval. Specific reporting requirements when conducting a multi-site study are also explained. 10:30 Break 10:45 Workshop 3 - Final Report Problems Practical problems of report preparation including compliance statements. 11:30 Workshop 3 - Feedback 12:00 Management of Raw Data and Records A view on how records and materials are managed and archived in compliance with GLP. 12:45 Lunch 13:30 Workshop 4 - Data and Sample Management Issues Dealing with data and sample management issues. 14:15 Workshop 4 - Feedback 14:45 Regulatory Inspection Government monitoring for compliance with Good Laboratory Practice. 15:15 Panel Session This panel session will address any outstanding issues raised by delegates. 15:45 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 14 Points Development Level Develop

The NVQ Level 3 is designed to provide both new entrants and those seeking progression in their career, with the opportunity to develop the necessary skills to carry out job roles and responsibilities associated with the installation and maintenance of Electrotechnical systems. There are two options to complete the NVQ Level 3 in Electrical Installations, these are the C&G 2346 and C&G 2357. Successful completion of the NVQ and AM2 assessment will satisfy the entry criteria for JIB accredited electricians

The NVQ Level 3 is designed to provide both new entrants and those seeking progression in their career, with the opportunity to develop the necessary skills to carry out job roles and responsibilities associated with the installation and maintenance of Electrotechnical systems. The EWR is for electricians who have been working in the industry for at least 5 years but have not formally completed an industry apprenticeship or Level 3 NVQ qualification. Successful completion of the NVQ and AM2 assessment will satisfy the entry criteria for JIB accredited Gold Card status. Bear in mind that the C&G 2391-50 and 18th Edition courses are pre-requisites to the Experienced Worker route. In case you don’t hold them, we can help you with a Pre-Experienced Worker Route package.