623 Courses in Manchester delivered Live Online

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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. Tailored training courses: In, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

Autocad face to face training customised and bespoke.

This award introduces the critical concepts associated with AI and explores its relationship with the systems and processes that make up the digital ecosystem. It explores how AI can empower organisations to utilise Big Data through the use of Business Analysis and Machine Learning, and encourages candidates to consider a future vision of the world that is powered by AI.

EFQM Certified Model Foundation Course The EFQM Foundation course will help you to benchmark and improve the performance of every organisation by using the new EFQM Model and RADAR diagnostic tool, version 2025! This is a two-day online course, delivered via a mix of work-rooms, presentations, videos, and one-to-one support. This course is credited as part of the admission to the EFQM Assessor, Performance Improvement Practitioner or Excellence Practitioner courses. Who is the EFQM Certified Model Foundation course for? This is the essential course for anyone who wants to find out about the EFQM Model and RADAR and how these tools can benefit an organisation. This course is suitable for anyone who wants to understand the new EFQM Model and how it can be used to make their organisation more effective. Whilst this training is effective as a stand-alone course, it is also a pre-requisite for anyone considering one of the EFQM qualification routes as a way of progressing their management development and career. At the end of the course, you will be able to: - demonstrate how the EFQM Model could benefit your organisation and how it could be used to overcome current and future challenges - explain how the Model is structured and how the different elements apply to your organisation - start applying the RADAR as both a diagnostic tool - to identify strengths and areas for improvement – and a performance improvement methodology - conduct a high-level self-assessment of your organisation - understand the opportunities provided by EFQM data and insights - gain an insight into the alternative uses of the EFQM Model The EFQM Foundation Course Training Programme Following the welcome and introduction, this course comprises of 9 modules: Module 0: Welcome & course objectives Module 1: Why we need a model to face & master complexity? Why the EFQM Model? Module 2: Introduction to the EFQM Model Module 3: The Model (part 1): Direction Module 4:The Model (part 2): Execution Module 5: The Model (part 3): Results Module 6: RADAR Module 7: Assessment Module 8: Data & Insights Module 9: Next steps Delivery The course is delivered through a virtual trainer led live class Cost £800 + VAT If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

face to face training customised and bespoke. Online or Face to Face

Course Objectives At the end of this course you will be able to: Collaborate on documents Add reference marks and notes Make long documents easier to use Secure a document Work with forms '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. Collaborating on Documents Modify User Information Share a Document Compare Document Changes Review a Document Merge Document Changes Review Tracked Changes Coauthor Documents Adding Reference Marks and Notes Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibliography Simplifying and Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Ancillary Table Manage Outlines Create a Master Document Securing a Document Suppress Information Set Formatting and Editing Restrictions Add a Digital Signature to a Document Restrict Document Access Forms Create Forms Manipulate Forms Who is this course for? Who is this course for? This course is designed for users who would like to create and work with lengthy and well structured documents, collaborate with others on documents, and create forms in Microsoft Word Requirements Requirements Preferably, delegates should have attended the Word Intermediate course. Career path Career path Microsoft Office 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

Unity 3d face to face training customised and bespoke.

  The GDPR Foundation training enables delegates to understand how to define and implement a privacy compliance framework aligned to best practice. During this training course, you will be able to understand the fundamental privacy principles and become familiar with the role of the Data Protection team and the DPO. About This Course   At Foundational level, candidates prove they have understood the fundamental methodologies, requirements, best practice and management approach of a Privacy Compliance Framework. Learning principles;   Understand the General Data Protection Regulation requirements and the fundamental principles of privacy Understand the obligations, roles and responsibilities of the Data Protection Officer Understand the concepts, approaches, methods and techniques to effectively participate in the implementation process of a compliance framework with regard to the protection of personal data.   Educational approach; Lecture sessions are illustrated with practical questions and examples Practical exercises include examples and discussions Practice tests are similar to the Certification Exam   Course Agenda Day 1: Introduction to GDPR and Data Protection Principles Day 2: The General Data Protection Regulation requirements and Certification Exam Prerequisites   There are no prerequisites for this course. What's Included?   Refreshments & Lunch (Classroom courses only Course Slide Deck CPD Certificate   Who Should Attend?   Individuals involved in the processing of Personal Data and Information Security Individuals seeking to gain knowledge about the main privacy principles Individuals interested to pursue a career in Data Protection Provided by   This course is Accredited by NACS and Administered by the IECB Assessment   Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 40 question, multiple choice exam on Day 2 of the course. The overall passing score is 70%, to be achieved within the 60 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success.

Why learn V-Ray for architects and designers? Realistic Visuals: V-Ray produces lifelike renderings for precise design visualization. Enhanced Presentations: Stunning visuals secure approvals and investments effectively. Time and Cost Efficiency: Streamlines design iterations, cutting down prototyping expenses. Click here for more info: Website Scheduling Your Training: You can also call 02077202581 to book. Training Duration: 10 hours Method: In-person face-to-face sessions or live online.  Course Title: V-Ray Essentials for Architects and Designers Course Duration: 10 Hours Course Overview: Unlock the power of V-Ray, the industry-standard rendering software, and elevate your architectural and design projects to new heights. In this comprehensive 10-hour course, you'll dive deep into V-Ray and gain the skills needed to create stunning visualizations. Whether you're an architect or designer, this course will equip you with the knowledge and techniques to bring your ideas to life. Module 1: Introduction to V-Ray (1 hour) Understanding the V-Ray interface Navigating the V-Ray toolbar Setting up your first V-Ray project Module 2: Lighting Mastery (2 hours) Utilizing various light sources Achieving realistic daylight simulations Creating artificial lighting setups Mastering V-Ray's advanced lighting tools Module 3: Material Magic (2 hours) Exploring V-Ray materials Creating realistic textures and finishes Understanding material properties Working with material libraries Module 4: Perfecting Render Settings (1 hour) Configuring render settings for optimal results Setting up render elements for post-processing Achieving photorealistic renderings Module 5: Advanced Rendering Techniques (2 hours) Fine-tuning render settings for specific scenarios Creating stunning visual effects Optimizing render times Rendering animations and walkthroughs Module 6: Realistic Environments (1 hour) Incorporating background images and environments Adding context to your architectural scenes Achieving seamless integration of 3D models and backgrounds Module 7: Portfolio-Ready Projects (1 hour) Applying V-Ray skills to complete a professional project Assembling a portfolio showcasing your work Course Benefits: Master V-Ray for architectural and design projects. Create photorealistic renderings with confidence. Customize lighting, materials, and textures for your designs. Optimize render settings for efficiency and quality. Enhance your portfolio with impressive visualizations. Receive lifetime email support for continued guidance. Explore career opportunities as a rendering specialist. Who Should Attend: Architects Interior Designers 3D Artists Visualization Specialists CGI Artists Architectural Renderers Game Environment Artists Virtual Reality (VR) Developers Anyone passionate about architectural rendering and design Method of Instruction: 1-on-1 personalized training In-person or live online sessions Hands-on exercises and practical projects Upon completing the "V-Ray Essentials for Architects and Designers" course, participants will: V-Ray Proficiency: Master V-Ray rendering for photorealistic visualizations. Advanced Lighting Skills: Create dynamic and realistic lighting scenarios. Material Expertise: Customize textures and materials for enhanced visuals. Optimized Renders: Configure settings for efficient workflows. Advanced Techniques: Learn rendering tricks for stunning effects. Realistic Environments: Integrate 3D models seamlessly into real-world settings. Portfolio Development: Build a competitive portfolio showcasing advanced rendering skills. Benefits for Interior Designers and Architects: Enhanced Visualization: Improve design communication with realistic visualizations. Competitive Edge: Stand out with high-quality renderings. Efficient Decision-Making: Experiment and refine designs before execution. Streamlined Workflows: Produce quality renders efficiently. Career Opportunities: Explore roles in architectural visualization, 3D art, and CGI. In short, this course equips interior designers and architects with V-Ray skills to create impressive visualizations, improve communication, gain a competitive edge, streamline workflows, and expand career options. Master Vray Rendering: Achieve proficiency in Vray rendering for architectural and interior design projects. Industry Excellence: Learn industry-standard practices and workflows to produce high-quality results. Flexible Learning: Choose between in-person or live online training to suit your schedule. Resourceful Learning: Access recorded lessons for convenient review and reinforcement. Ongoing Support: Benefit from lifetime email support, ensuring you receive guidance beyond the course. Career Guidance: Receive free career advice to make informed decisions about your professional growth. Upon completion, our Vray for Architects and Interior Designers Training Course opens doors to various career opportunities in the architecture and design industry. Graduates with advanced rendering skills can explore roles such as: Architectural Visualizer Interior Designer 3D Artist Rendering Specialist Visualization Specialist CGI Artist Architectural Renderer Game Environment Artist Virtual Reality (VR) Developer Freelance Rendering Professional Vray Mastery: Gain expertise in Vray rendering for architectural and interior design projects. Industry-Approved Methods: Learn tried-and-true workflows for exceptional results. Flexible Learning: Opt for in-person or live online training at your convenience. Easy Review: Access recorded lessons to reinforce your knowledge conveniently. Lifelong Support: Receive ongoing guidance even after course completion. Career Consultation: Make informed decisions about your professional growth. Career Opportunities: Unlock doors to diverse roles in architecture and design, including Architectural Visualizer, Interior Designer, 3D Artist, Rendering Specialist, and more.

Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Customer Feedback Very clearly explained Good pace. Lucy Tailor - ACER ' 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. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. Career path Career path Microsoft Office 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