2143 Courses

Computer Science GCSE Syllabus The GCSE Computer Science Tutor Syllabus is designed to provide tutors in England with a comprehensive framework for teaching the GCSE Computer Science curriculum effectively. This syllabus aims to equip tutors with the necessary knowledge and skills to support students in their understanding and application of core computer science concepts.  Module 1: Introduction to Computer Science - Overview of computer science and its relevance in today's world - Understanding the components of a computer system - Introduction to algorithms and problem-solving techniques - Exploration of programming languages and their uses Module 2: Computer Hardware - Understanding the main components of a computer system, including CPU, memory, and storage devices - Exploring input and output devices and their functionalities - Understanding the role of operating systems and software in computer systems Module 3: Software Development - Introduction to programming concepts and languages (e.g., Python or Java) - Understanding variables, data types, and operators - Building algorithms and logical reasoning skills - Introduction to flowcharts and pseudocode - Implementation of simple programs and debugging techniques Module 4: Data Representation - Understanding binary, hexadecimal, and denary number systems - Representation of text, images, and sound using binary - Introduction to data compression and encryption techniques Module 5: Computer Networks - Understanding the basics of computer networks, including LAN, WAN, and the Internet - Introduction to network topologies, protocols, and security - Exploring the impact of digital communication on society Module 6: Cybersecurity and Ethical Issues - Understanding the importance of cybersecurity and data protection - Introduction to common threats and vulnerabilities - Exploring ethical issues related to computer science, such as privacy and intellectual property rights Module 7: Algorithms and Programming Techniques - Advanced programming concepts, including conditionals, loops, and functions - Introduction to sorting and searching algorithms - Exploring data structures, such as arrays and lists Module 8: System Architecture - Understanding the structure and function of a CPU - Introduction to memory hierarchy and cache - Exploring the Von Neumann architecture and its limitations Module 9: Computational Thinking and Problem Solving - Advanced problem-solving techniques using computational thinking - Introduction to algorithms for complex problems - Exploring algorithmic efficiency and optimization techniques Module 10: Exam Preparation and Revision - Reviewing key concepts covered throughout the syllabus - Practicing past exam questions and providing guidance on exam techniques - Supporting students with exam preparation strategies Please note that the duration and depth of each module can vary depending on the level of expertise required and the specific needs of the learners. Additionally, it's important to adapt the curriculum to the learners' proficiency levels, whether they are A Level/GCSE students or adult learners with different experience levels.

Maya Evening Learning Sessions. Maya Evening Learning Sessions offer flexibility for professionals, interactive classes, supportive community, and skill enhancement in a convenient after-work schedule. Perfect for work-life balance and continued education. Click here for more info: Website Tailored Learning: Custom curriculum catering to your skill level. Course Duration: 10 hours. Approach: 1-to-1  Schedule: Craft your learning path by pre-booking hours from Mon to Sat, 9 am to 7 pm, accommodating your convenience. Maya 10-Hour Course Key Details: Duration: 10 hours of intensive training. Approach: Hands-on, interactive sessions focusing on essential Maya concepts and techniques. Curriculum Highlights: Introduction to Maya: Understanding the software interface and basic tools. 3D Modeling: Mastering polygon modeling techniques and object manipulation. Texturing and Materials: Learning to apply textures, materials, and UV mapping. Lighting and Rendering: Exploring lighting setups, camera compositions, and rendering methods. Animation Fundamentals: Grasping keyframe animation, editing clips, and basic character rigging. Special Effects and Dynamics: Creating particle systems, fluid simulations, and basic special effects. Who Should Attend: Beginners: Individuals new to 3D modeling and animation. Aspiring 3D Artists: Those aiming to pursue careers in animation, gaming, or visual effects. Creative Professionals: Designers and artists looking to expand their skill set into 3D graphics. Job Opportunities: Completing this Maya course equips participants with the skills necessary for various roles, including: 3D Modeler: Creating detailed 3D models for games, movies, or simulations. Animator: Bringing characters and scenes to life through animation. Texture Artist: Designing textures and materials to enhance 3D models. Lighting Artist: Illuminating scenes to evoke specific moods and atmospheres. Visual Effects Artist: Specializing in creating stunning visual effects for films and games. Participants completing the Maya 10-Hour Course will: Master Maya basics including modeling, texturing, lighting, and animation. Create 3D models, apply textures, and understand lighting and rendering principles. Develop essential skills in animation and special effects. Troubleshoot common issues in 3D projects. Recommended Books: "Introducing Autodesk Maya 2022" by Derakhshani: Comprehensive guide with hands-on tutorials. "Maya Character Creation" by Maraffi: Focuses on character modeling and animation techniques. "The Animator's Survival Kit" by Williams: Timeless principles applicable to any animation software. Maya 10-Hour Course Key Details: Duration: 10 hours of intensive training. Approach: Hands-on, interactive sessions focusing on essential Maya concepts and techniques. Curriculum Highlights: Introduction to Maya: Understanding the software interface and basic tools. 3D Modeling: Mastering polygon modeling techniques and object manipulation. Texturing and Materials: Learning to apply textures, materials, and UV mapping. Lighting and Rendering: Exploring lighting setups, camera compositions, and rendering methods. Animation Fundamentals: Grasping keyframe animation, editing clips, and basic character rigging. Special Effects and Dynamics: Creating particle systems, fluid simulations, and basic special effects. Who Should Attend: Beginners: Individuals new to 3D modeling and animation. Aspiring 3D Artists: Those aiming to pursue careers in animation, gaming, or visual effects. Creative Professionals: Designers and artists looking to expand their skill set into 3D graphics. Job Opportunities: Completing this Maya course equips participants with the skills necessary for various roles, including: 3D Modeler: Creating detailed 3D models for games, movies, or simulations. Animator: Bringing characters and scenes to life through animation. Texture Artist: Designing textures and materials to enhance 3D models. Lighting Artist: Illuminating scenes to evoke specific moods and atmospheres. Visual Effects Artist: Specializing in creating stunning visual effects for films and games. Adaptable Evening Maya Classes In-Depth 10-Hour Maya Program Hands-On Maya Projects Professional Maya Expertise Diverse Maya Applications Guidance from Experts Tailored Learning Experience Ongoing Email Assistance Access to Maya Trial and Resources Ignite Your Creative Potential!

The IMI PAC course in Light Vehicle Brake Fitting is 3 days in duration and is aimed at fitters who want to improve their knowledge and skills A minimum of 3 months practical experience is required as this is not an introductory course. An alternative course is available for those with no previous experience, contact us for more details Successful candidates will receive an IMI Professional Achievement Certificate in Light Vehicle Brake Fitting.  Course Details: Classroom based theory session Workshop practice session Examination and assessment Course Fees £499.00 + VAT per candidate *Please contact us for group rates  Course Content Theoretical Health & Safety Brake types (disc brake & drum brakes) Hydraulic operating systems Brake arrangements Brake valves Brake fluid Servo assistance Introduction to ABS and EPB Practical Brake pad and disc removal and re-fitting Brake drum and shoe removal and re-fitting Manufacturing a brake pipe Bleeding a hydraulic system IMI assessment and test A multi-choice theory question paper Five practical assessments, observed by an IMI approved assessor. What’s included Fully qualified and experienced trainers Course booklet Examinations Fees and Certification One year IMI membership To find out more, please use the live chat function, visit our contact page or call us on 024 76325880

We are very pleased to announce that Stephen Goldsmith aka the Gold polishing Guru is coming to our workshop 925 to teach his polishing masterclass. If you’re in the industry, he needs no introduction but for anyone who hasn’t heard of him, he is a master of the polishing craft with over 50 years experience, his client list past and present includes, Asprey, Garrard, Theo Fennell, Hamilton and Inches Crown Jewellers of Scotland, The Royal Mint, The Royal Society. He has polished and restored many famous silverware pieces including the Americas Cup; Davis Cup; Wimbledon Cup and the Premier League Cup and he has also advised the Tower of London Jewel House on the upkeep of their silver collections. He also judged the polishing section of Goldsmiths craft and design awards. WHEN: Thursday 31st October and Friday 1st November 2024 WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Stephen M Goldsmith ABOUT STEPHEN: Stephen M Goldsmith started out at Rochester Art college, now known as University for the Creative Arts and was apprenticed at C.J Vander’s in 1971 and indentured with The Worshipful Company of Goldsmiths’. Now a Master Polisher of over 50 years’ experience, originally working for the Crown Jewellers Asprey & Garrards and well-known society jeweller Theo Fennell. Many of the pieces polished are now seen in Palaces, Museums and the rich and famous across the world. Stephen is one the most respected jewellery & silver polishers and is currently is teaching polishing across Europe and is known affectionately as “The Gold polishing Guru”. He has polished and restored many famous silverware pieces including the Americas Cup; Cricket World cup, Wimbledon Cup, Dubai Gold Cup, Premier League Cup. He has also been privileged to work in the jewel house at the Tower of London restoring The Grand Punch bowl made in 1830 and used by the Royal family on many occasions. Also known for polishing the largest pure gold coins made by the Royal Mint the largest being the James Bond 7kg pure gold coin. He is a fellow of the Institute of Professional Goldsmiths (IPG) and their official ambassador and a Master of The Dutch Guild of Goldsmiths. He shares his trade skills by teaching nationally and internationally including at Goldsmiths Centre, School of Master Jeweller’s Birmingham and VanTol & Breet Academy (Netherlands), The School of Jewellery Dublin & The Design & Craft Irish Craft Council in Kilkenny, Vannilla Ink, Aka_bespoke Manchester, Sheila Fleet in Orkney, Patrick Mavros in Zimbabwe and Mauritius. Stephen is a Freeman of The Worshipful Company of Goldsmiths’ and was granted the Freedom of the City of London in 1975. He has also had the very rare honour of winning The Goldsmith’s Company Award twice, plus many other prestigious awards and served as a council member for The Goldsmiths’ Craft and Design Council and a published authority on polishing precious metals “Polishing and Finishing for Jewellers and Silversmiths by the Crowood Press. WHAT DOES THE DAY INVOLVE? We are very pleased to announce that Stephen Goldsmith aka the Gold polishing Guru is coming to our workshop 925 to teach his polishing masterclass. If you’re in the industry, he needs no introduction but for anyone who hasn’t heard of him, he is a master of the polishing craft with over 50 years experience, his client list past and present includes, Asprey, Garrard, Theo Fennell, Hamilton and Inches Crown Jewellers of Scotland, The Royal Mint, The Royal Society. He has polished and restored many famous silverware pieces including the Americas Cup; Davis Cup; Wimbledon Cup and the Premier League Cup and he has also advised the Tower of London Jewel House on the upkeep of their silver collections. He also judged the polishing section of Goldsmiths craft and design awards.You can get a glimpse of what he does on his instagramWHAT HAPPENS DURING THE MASTERCLASS?First, Stephen will talk about his career giving you an insight into the makings of a master craftsman. Then he will demonstrate just why he is known as master polisher. After this demonstration you will be guided by Stephen to try and replicate what you have been shown in the demonstration.After working through a few more exercises you will set to work on your own jewellery, receiving guidance on not just how to achieve the finish you would like for your jewellery but to reach a standard of finish you didn’t know you could.These Masterclasses are a great opportunity to learn from someone who is:a) A true master in our tradeb) Not a grump or condescending because you don’t know somethingc) Happy to chat and share his knowledge!All you need to bring is some of your own jewellery (around 6 items) at the point where it’s ready for polishing.You will have a spindle that is yours for the duration of the masterclass, mops, materials etc will be provided. It can be a messy business so make sure your clothing is workshop friendly!You will also have full access to our workshop, benches, tools and equipment if needed.This Masterclass will leave you with the knowledge and skills to take your polishing to a highly professional standard.EXPERIENCE REQUIRED: This class will benefit jewellers with some experience who are looking to learn to polish their work to a professional level. Our small classes mean we are able to provide each student with the support they require. CLASS SIZE: 6 WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. We have a microwave, kettle and fridge to store or cook your lunch choices. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.

Why Choose Enscape Rendering Training Course? Course info Best real-time visualization plugin, integrates with design tools like Revit, SketchUp, Rhino, ArchiCAD, and Vectorworks. Experience swift and real-time visualization within your preferred applications, eliminating extra costs and adjustments. Elevate your design projects effortlessly with Enscape. Duration: 5 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm What does the Enscape Training & Interactive Workshop offer? The Enscape Training & Interactive Workshop is designed to help you get up and running with Virtual Reality (VR) in a cost-effective manner. It covers hardware and software setup, navigation techniques, real-time updates, material settings, and more. The workshop also allows participants to experience VR firsthand. What will I learn in the Enscape (VR) Training and Interactive Workshop? The workshop covers hardware setup, software installation, and configuration. You will learn how to migrate models from Revit and SketchUp into VR, navigate through designs, update objects and materials in real-time, and utilize various visual styles and settings. The course also includes interactive workshops with support from our expert tutors. Course Outline: Enscape Rendering Software Training (5 hours) Course 1: Enscape for Revit Hour 1: 1. Introduction to Enscape: Overview of Enscape rendering software, its features, and benefits. 2. Installing and Setting up Enscape: Step-by-step guidance on installing and configuring Enscape for Revit. 3. Enscape Interface: Familiarizing with the Enscape user interface and navigation controls within Revit. Hour 2: 4. Enscape Materials: Exploring material creation, application, and customization within Enscape for Revit. 5. Lighting in Enscape: Understanding different lighting options, adjusting light settings, and creating realistic lighting effects. Hour 3: 6. Enscape Camera Settings: Manipulating camera angles, perspectives, and settings for optimal visualization. 7. Enscape Rendering Settings: Exploring various rendering settings and techniques to enhance the quality of the final output. Hour 4: 8. Enscape Rendering Workflow: Demonstrating a step-by-step workflow for generating renderings and walkthroughs using Enscape in Revit. 9. Advanced Features: Introduction to advanced features such as creating panoramas, virtual reality (VR) walkthroughs, and creating animations in Enscape. Hour 5: 10. Tips and Tricks: Sharing tips and techniques for maximizing efficiency and achieving high-quality results in Enscape for Revit. 11. Q&A and Troubleshooting: Addressing participant questions, providing troubleshooting guidance, and discussing common challenges and solutions. OR Course Outline: Enscape Rendering Software Training (5 hours) Course 1: Enscape for Sketchup Hour 1: 1. Introduction to Enscape: Overview of Enscape rendering software, its features, and benefits for SketchUp users. 2. Installing and Setting up Enscape: Step-by-step guidance on installing and configuring Enscape for SketchUp. 3. Enscape Interface: Familiarizing with the Enscape user interface and navigation controls within SketchUp. Hour 2: 4. Enscape Materials: Exploring material creation, application, and customization within Enscape for SketchUp. 5. Lighting in Enscape: Understanding different lighting options, adjusting light settings, and creating realistic lighting effects. Hour 3: 6. Enscape Camera Settings: Manipulating camera angles, perspectives, and settings for optimal visualization in SketchUp. 7. Enscape Rendering Settings: Exploring various rendering settings and techniques to enhance the quality of the final output. Hour 4: 8. Enscape Rendering Workflow: Demonstrating a step-by-step workflow for generating renderings and walkthroughs using Enscape in SketchUp. 9. Advanced Features: Introduction to advanced features such as creating panoramas, virtual reality (VR) walkthroughs, and creating animations in Enscape. Hour 5: 10. Tips and Tricks: Sharing tips and techniques for maximizing efficiency and achieving high-quality results in Enscape for SketchUp. 11. Q&A and Troubleshooting: Addressing participant questions, providing troubleshooting guidance, and discussing common challenges and solutions.

Being Prepared for CQC's New Assessment Framework Course

Being Prepared for CQC's New Assessment Framework Course

Course Information Join our comprehensive course, meticulously designed to equip individuals implementing Good Clinical Laboratory Practice (GCLP) within laboratories handling samples from clinical trials. Delve into the current regulatory landscape governing laboratory work supporting clinical trials, referencing key guidelines such as the ICH Guideline for Good Clinical Practice, the Clinical EU Trials Directive, relevant regulations, and leveraging insights from the RQA guidance document on GCLP. Is this course for you? This course is tailored for laboratory managers, analysts, investigators, trial coordinators, monitors, and auditors operating in diverse settings such as pharmaceutical company laboratories, central laboratories, contract research organisations, hospital laboratories, clinics, and investigator sites. This course will give you: Guidance on effectively interpreting and applying GCLP within the broader framework of Good Clinical Practice (GCP) Insight into the seamless integration of GCLP within clinical programmes (GCP) Practical strategies for implementing GCLP in the nuanced environment of clinical research laboratories The chance to update your knowledge with the latest interpretations and guidance on clinical laboratories by the UK Medicines and Healthcare Products Regulatory Agency (MHRA) Access to a seasoned panel of speakers with extensive expertise A unique opportunity to deepen your understanding of GCLP's application across diverse scenarios. Engage in: Lively discussions to foster ideas Problem-solving sessions targeting specific challenges Detailed exploration of specific aspects within the realms of GCP and GCLP. Tutors Tutors will be comprised of (click the photos for biographies): Vanessa Grant -, - Louise Handy Director, Handy Consulting Ltd Tim Stiles Consultant, Qualogy Ltd Programme Please note timings may be subject to alteration. Day 1 08:50 Registration 09:00 Welcome and Introduction 09:20 Good Clinical Practice and the Requirements of Good Clinical Laboratory Practice A review of Good Clinical Practice and its requirements for the laboratory analysis of samples from a trial. The thought processes behind the development of Good Clinical Laboratory Practice, its objective, scope, interpretation and application are explained. 10:00 Safety and Ethical Consideration Informed consent, confidentiality, expedited reporting, blinding and unblinding and serious breaches of the GCP are discussed. 10:40 Break 10:55 Organisation and Personnel Responsibilities within GCP and the Laboratory The responsibilities of key functions that should exist within a clinical laboratory including personnel records of training and competence are discussed. 11:30 Staff Training and Training Records Personnel records of training and competency assessments are discussed. 11:45 Laboratory Facilities, Equipment and Materials Suitable facility design, organisation and operation will be discussed. The calibration, validation and maintenance of equipment used in the conduct of sample analysis are examined, as are the suitability of materials and the identification and labelling of reagents and solutions. 12:30 Lunch 13:15 Workshop 1 - Facilities, Equipment and Responsibilities Some practical problems with regard to the facilities, equipment and responsibilities are explored. 13:45 Workshop 1 - Feedback 14:15 Computer Systems Validation Systems, including computerised systems, used in the analysis, collection and reporting of results should be appropriately tested, operated and controlled. What this means in practice is discussed. 14:45 Trial Protocols, Analytical Plans During this session we examine the purpose, content, control and change of these important documents. 15:30 Break 15:45 Workshop 2 - SOPs, Clinical Protocols, Analytical Plans and Validation The practicalities of managing and documenting the planning phase of analytical work on a trial are explored along with computerised system validation. 16:30 Workshop 2 - Feedback 17:00 Close of Day Day 2 09:00 Conduct of the Work and Quality Control Many of the issues that surround the conduct of sample collection, shipment, storage, analysis and management of Analytical Methods are discussed. This includes the quality control of the assay that may be employed and Quality Control checks. 10:00 Deviation Management The expectations around deviations and CAPA are discussed. 10:15 Workshop 3 - Conduct of the Work and Quality Control Practical work conduct and quality control issues are explored. 10:45 Break 11:00 Workshop 3 - Feedback 11:30 Source Data, Data Integrity, Records and Reports The creation and subsequent management of source data and records, data integrity, are discussed, together with the process of reporting analytical results. 12:10 Workshop 4 - Data, Records and Reports Practical problems with data, records and reports are investigated. 12:45 Lunch 13:30 Workshop 4 - Feedback 14:00 Quality Audit The requirements for and purpose of quality audits are discussed. The difference between quality audit and quality control are explained along with the role of the quality audit staff and their interaction with the analytical project managers, laboratory management and study staff. 14:40 Risk Management How should we assess risk and how can we use the process to assist in evaluation of audit findings. 15:15 Break 15:30 Regulatory Inspection The conduct of regulatory inspections and current expectations of the inspectors. Preparation for inspections and conduct during them will be discussed. 16:00 Panel Session This panel session will address any outstanding issues raised by the delegates. 16:15 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

Why Learn AutoCAD 3D Basics-Advanced Training Course? Course Link Learn 3D modeling, materials, lighting, and rendering, and parametric models. Learn real-world Architecture, products, mechanics. Enroll for in-person or online sessions to master AutoCAD 3D. Duration: 16 hrs Method: 1-on-1 Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. "Dial 02077202581 or WhatsApp 07970325184 to reserve your preferred dates and times.  AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics to Advanced Level Training Course Outline (10 hours): Session 1: Introduction to 3D Modeling (2 hours) Understanding 3D modeling concepts Working in the 3D Modeling Workspace Drawing 3D objects with Solid tools Extruding 2D polylines to create 3D objects Session 2: Advanced 3D Features and UCS (2 hours) Setting up AutoCAD for advanced 3D modeling Mastering the User Coordinate System (UCS) Using viewports to aid in 3D drawing Efficient modeling with Array tools Session 3: Rendering and Visualization (2 hours) Testing rendering techniques Creating a quick study rendering Simulating natural lighting and the sun Enhancing 3D models with materials and lights Session 4: Editing 3D Solids and Mesh Modeling (2 hours) Understanding solid modeling principles Creating and editing basic solid forms Editing 3D solids and streamlining 2D drawing process Exploring 3D mesh modeling and editing The AutoCAD 3D training course provides a comprehensive understanding of 3D modeling, visualization, and rendering. Participants will learn to create complex 3D models, render realistic visuals, and efficiently customize the AutoCAD interface for improved productivity. Master 3D Modeling: From basics to advanced techniques. Realistic Rendering: Achieve lifelike visualizations. Professional Presentations: Dynamic walkthroughs and showcases. Enhanced Career Opportunities: Stronger prospects in design fields. Personalized Learning: One-to-one attention for focused training. Practical Hands-On Practice: Building confidence in 3D modeling. Lifetime Email Support: Ongoing assistance beyond the course. Certification: Proof of proficiency in AutoCAD 3D modeling.

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