1240 Courses

The VTCT Level 3 Award in Education and Training will enable the learner to enter teaching employment and progress on to a broader teaching qualification. This qualification has been mapped to the relevant Learning and Skills Improvement Service (LSIS) NOS, and is accredited on the Regulated Qualifications Framework. There are no formal prerequisite qualifications that you must have prior to undertaking this qualification. Your centre will have ensured that you have the required knowledge, understanding and skills to enrol and successfully achieve this qualification. If you're interested in pursuing a teaching career in further education, this course is designed for you. The course covers the essential teaching skills required to become an effective trainer or teacher. Upon completion, you'll be certified to teach at a nationally accredited standard and meet the standard required by awarding/accrediting bodies to create, deliver, and accredit your own beauty courses. This means you'll be fully insured to provide beauty training services. Our online course is offered through our e-learning platform and over Zoom training sessions. This means you can complete the course at your own pace and convenience, from the comfort of your own home. Our experienced instructors will guide you through the course content and provide support throughout your learning journey. The course costs 399 and includes everything you need to complete your certification. This includes access to our online course content, Zoom training sessions, and all necessary study materials. You'll also receive ongoing support from our instructors even after you've completed the course.

Why Book Revit Basic to Advanced Training Course? Learn BIM and Revit for engineers and architects, supporting 2-D and 3-D design for large-scale projects and combing with AutoCAD. Check our Website How to Book? 1-on-1 training tailored to your schedule. Book your sessions from Monday to Saturday between 9 am and 7 pm or call 02077202581 to book over the phone. Training Details: Duration: 16 hours Flexible scheduling, split across multiple days Method: 1-on-1 (In-person or Live Online) and Personalized attention Course Overview: I. Revit Fundamentals (1 hour) Understanding Revit's Purpose and Applications Navigating the Revit Interface and Essential Tools Mastering Navigation and Viewport Controls Creating and Managing Projects II. Project Setup (1 hour) Initiating a New Project Configuring Project Levels, Grids, and Site Information Defining Project Units for Precision III. Basic Modeling Techniques (2 hours) Building Walls, Doors, and Windows Designing Floors, Ceilings, Roofs, Stairs, and Railings IV. Advanced Modeling Skills (4 hours) Crafting Custom Parametric Families Utilizing Conceptual Modeling Tools Designing Complex Forms and Shapes Enhancing Models with Lighting and Materials Achieving Realism through 3D Rendering V. Views, Sheets, and Annotations (2 hours) Managing Views and Sheets Effectively Incorporating Schedules and Tags Crafting Detail Annotations for Construction Documents VI. Phasing, Worksharing, and Collaboration (2 hours) Understanding Phasing and Design Options Mastering Work Sharing and Collaboration Techniques VII. Project Collaboration and Management (1 hour) Establishing Work Sharing Environments Monitoring Worksets and User Activities Synchronizing Worksets for Seamless Collaboration VIII. Advanced Documentation Skills (2 hours) Creating Advanced Schedules and Legends Developing Construction Documents with Sheets and Title Blocks Customizing Schedules and Keynotes for Precision IX. Course Conclusion and Next Steps (1 hour) Reviewing Course Highlights Exploring Further Learning Resources and Tips Interactive Q&A Session and Feedback Opportunities Download Revit Master Revit Proficiency: Acquire advanced skills in Revit for 3D modeling, parametric design, and efficient project management. Craft Complex Architectural Designs: Create intricate building components, custom families, and detailed construction documents. Seamless Collaboration: Expertise in project collaboration, phasing, and work sharing, ensuring smooth teamwork and synchronization. Enhanced Visualization: Learn advanced rendering techniques for realistic 3D visualizations of architectural concepts. Customize Workflows: Adapt Revit tools, optimize workflows, and enhance efficiency in project execution. Career Opportunities: Architectural Designer: Create architectural plans, 3D models, and construction documents. BIM Specialist: Develop detailed digital models in collaboration with architects and engineers. Construction Documenter: Prepare comprehensive construction documents, including plans and schedules. Project Manager: Oversee projects, ensuring timely completion and adherence to design specifications. Revit Specialist/Trainer: Provide Revit training and support services to individuals, firms, or educational institutions. Elevate Your Revit Skills with Our Advanced Training! Our Revit Basic to Advanced Training Course is tailored to enhance your expertise in Autodesk Revit. Delivered through in-person or live online sessions, this program covers advanced modeling, parametric families, collaboration tools, and project phasing. Course Benefits: Master Advanced Skills: Learn intricate 3D modeling, design complex building components, and implement advanced BIM workflows. Expert Instruction: Industry professionals guide you through advanced concepts via engaging demonstrations and hands-on exercises. Flexible Learning: Choose in-person or live online sessions with interactive instruction and personalized guidance. Lesson Recordings: Access class recordings for convenient review and practice, reinforcing your learning. Lifetime Support: Benefit from lifetime email support for ongoing guidance from our experienced instructors. Enhance your Revit proficiency, streamline design processes, and boost project efficiency. Whether you're an architect, engineer, or design professional, this course unlocks advanced Revit skills. Join our training for comprehensive learning and expert support! Individualized Training: Experience personalized attention and tailored guidance. Flexible Learning Hours: Select your preferred schedule for training sessions. Ongoing Support: Access complimentary online assistance even after course completion. Comprehensive Learning Materials: Receive detailed PDF resources for effective learning. Certificate of Attendance: Earn a certificate acknowledging your course completion. Affordable Pricing: Enjoy budget-friendly training rates. Software Setup Help: Get assistance with software configuration on your device. Referral Benefits: Receive discounts on future courses by referring a friend. Group Discounts: Avail special rates for group training sessions. Extended Availability: Access training sessions every day with extended operating hours. Customized Curriculum: Engage in tailored training designed to meet your specific requirements.

Create a set of three personalised, calligraphy Christmas baubles with local artist Panna Chauhan on this private class at The Arienas Collective in Edinburgh City Centre.

Private mosaic making class with Mossy Mosaic at The Arienas Collective in central Edinburgh.

BOHS P304 is designed to give practical guidance on assessing the health risks caused by hazardous substances, in order to meet the requirements of the Control of Substances Hazardous to Health (COSHH) Regulations 2002 for a 'suitable and sufficient' risk assessment.

The course price includes Refreshments, Car Parking Fees, Workbooks, Resources including access to our Trainer Resource Pack via the Approved Trainer HUB, Approved Trainer Membership, Approved Trainer T-Shirt, Ongoing Quality Assurance , support and Certification. We deliver this course to small groups a maximum of 4 people attend this course at our training premises ensuring all our learners receive Quality time with the Trainers/ Assessors delivering the course.

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 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 classrom, one to one, tailored and bespoke courses. Tailored In Company training: 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

Learn how to make your own hallmark quality silver clay jewellery in this private class at The Arienas Collective creative workshop hub in Edinburgh City Centre

Private sketching tours and classes with ink and watercolour artist Mark Kirkham, known locally as The Edinburgh Sketcher hosted by The Arienas Collective, or at an agreed location of your choice.

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