3082 Courses in London

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

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

We run four week beginner courses for new students. In this time you will learn the ABCs of Wing Chun and be well prepared to join the foundation level class on completion of the course. It costs £40 for the course and you can train twice a week, giving you access up to 12 classes in that time. Please contact us to book your place on the next available start date. 

This course will provide those who require it, the knowledge of how to use Face Masks correctly...

These courses are designed for aspiring 3D artists, students, graduates, creative professionals, CAD designers, and anyone passionate about 3D art. Whether you're looking to launch a career, enhance existing skills, or explore new creative avenues, our courses provide comprehensive training tailored to various skill levels and interests. Check our Website Duration: 16 hours Method: 1-on-1 and Tailored content Dates and Times: Select your preferred hour from Monday to Saturday, available between 9 am and 7 pm. CAD and 3D Studio Max Training Course Duration: 16 hours Course Outline: Introduction to AutoCAD Familiarizing yourself with the AutoCAD interface Navigating the drawing environment Mastering fundamental 2D geometry creation Exploring essential drawing tools and commands Introduction to blocks and symbols for efficient design Advanced AutoCAD Techniques Delving into advanced drawing methods Proficiently manipulating and editing 2D geometry Crafting custom symbols and blocks for enhanced productivity Working with text and annotations for clear communication Utilizing layers and line types for organized design 3D Modeling in AutoCAD Venturing into the world of 3D modeling Precision crafting of 3D solids and surfaces Seamless modification and manipulation of 3D geometry Crafting custom materials and textures for realistic designs Effective utilization of AutoCAD's lighting and camera systems Introduction to 3ds Max Embracing the 3ds Max interface and configuring the workspace Proficiency in navigating within 3ds Max Understanding the viewport for optimized design Exploring basic 3D modeling techniques in 3ds Max Materials and Textures in 3ds Max Application and modification of textures for enhanced designs Mastering the art of UVW mapping for precise texturing Utilizing the material editor for creative freedom Crafting custom materials aligned with your design vision Harnessing the power of Vray materials for lifelike renders Lighting in 3ds Max Introduction to various lighting techniques Grasping light properties for impactful designs Strategic setup of lights to enhance scenes Illuminating scenes with Vray lights Cameras in 3ds Max Mastery of camera systems in 3ds Max Exploring camera properties for cinematic effects Creating animations with cameras for dynamic scenes Utilizing Vray cameras for stunning renders Rendering in 3ds Max Unveiling the art of rendering Utilizing Vray Global Illumination for realistic lighting Leveraging Vray Physical Cameras for precise control Enhancing scenes with Vray HDRI Lighting Following a Vray Rendering Workflow for professional results Advanced Modeling Techniques Proficiency in crafting complex geometry Utilizing modifiers for intricate designs Exploring polygonal modeling for versatile creations Creating both organic and inorganic models with expertise Unleashing the potential of advanced modeling techniques Projects Application of acquired skills to create real-world scenes Designing a detailed interior scene with meticulous attention Crafting a visually impactful exterior scene Creating a complex scene featuring multiple objects and materials Course Requirements: A computer with AutoCAD and 3ds Max installed Basic knowledge of computer operations A keen interest in 2D and 3D modeling and design Course Goals: Upon course completion, you will possess a comprehensive understanding of AutoCAD and 3ds Max, enabling you to craft intricate 3D scenes enriched with advanced materials, textures, lighting, and rendering. These newfound skills empower you to advance your capabilities in both 2D and 3D modeling and rendering. Upon successful completion of this comprehensive AutoCAD and 3ds Max training, participants will attain the following skills: AutoCAD Proficiency: Mastery of 2D geometry, drawing tools, and symbols. Advanced AutoCAD Techniques: Expertise in editing, custom blocks, text, and layers. 3D Modeling in AutoCAD: Competence in crafting 3D solids, textures, and lighting. Introduction to 3ds Max: Proficient navigation of the interface and fundamental 3D modeling. Materials and Textures: Application and customization of textures using Vray. Lighting and Cameras: Mastery of lighting and camera systems within 3ds Max. Rendering: Production of high-quality renders through Vray. Advanced Modeling: Proficiency in handling complex geometry and creating organic models. Real-World Projects: Capability to design interiors, exteriors, and intricate scenes. Skills Acquired: Mastering 3D Modeling Techniques in 3D Studio Max Advanced Texturing and Material Application Skills Proficiency in Lighting and Rendering Techniques Expertise in Animation and Keyframe Techniques Comprehensive Scene Composition and Camera Setup Knowledge Career Opportunities: Senior 3D Modeler Experienced CAD Designer Lighting and Rendering Specialist Animation Director Architectural Visualization Expert Upon completing our 3D Studio Max and CAD Courses, students will acquire advanced 3D modeling, animation, and CAD design skills, paving the way for rewarding careers in roles such as Senior 3D Modeler, CAD Designer, Lighting Specialist, Animation Director, and Architectural Visualization Expert. You will gain access to the following benefits: An Autocad and 3ds Max Certificate of Attendance. A comprehensive PDF training guide for 3ds Max and CAD. Real-time feedback during sessions, with the option to record them as video archives. We offer the following advantages: Price guarantee to ensure the best value for your investment. Personalized one-on-one training for focused learning. Flexible scheduling options available seven days a week, from 9 am to 7 pm. Lifetime email and phone support for ongoing assistance. Assistance with software installation and computer setup. Referral discounts and special offers on group training courses.

A two-day programme designed to equip mediators, facilitators, coaches and change agents with the skills and processes that they need in order to resolve team conflicts across a diverse range of industries.

This qualification is aimed at those working in an environment where an AED is available.

Project Leadership Skills: In-House Training To be effective within an organization, project managers need to have a wide variety of skills and abilities. Included among these are: creating and executing on a vision; motivating others; influencing without authority; networking; communicating up, down and laterally; negotiating; managing stakeholders; and managing conflict. This highly interactive workshop focuses on building the soft skills that are critical to leading a team and creating sustainable business change. Participants will gain insight into the social science as well as the brain science behind motivating and empowering others. They will learn and experiment with a variety of influencing strategies and tactics. Working in pairs as well as small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to everyday challenges. Participants will also discover their personal communication preferences, strengths, and blind spots and will gain insight into how best to communicate with others they find 'difficult.' They will gain insight into managing the people side of change, learning strategies for dealing with each step in the process. Hands-on negotiation and conflict management activities enhance the theoretical learning, grounding it in real life and making it actionable. Interweaving role play with experiential learning and group activities, this course will help participants refine a skill set that is invaluable to their organization, and one that transfers easily across their professional and personal lives. What You Will Learn At the end of this course, you will be able to: Explain the importance of vision in driving motivation and engagement Apply science-based research to better motivate those around you Strategically leverage both personal and positional power to achieve positive project results Determine influencing and networking strategies needed for personal growth Identify ways to problem solve communication challenges when others have different personality styles Connect stakeholder expectations to project success criteria Assess key stakeholders across various dimensions of complexity Apply the four rules of principled negotiation to a real-life conflict situation Recognize key aspects of a physiological response to conflict Utilize selected tools and techniques to 'defuse' an emotional situation Leverage various strategies and tactics to successfully deal with ambiguity at work Getting Started / Foundation Concepts Introductions Course structure, goals, and objectives Beginning a personal action plan Managing Vision and Purpose / Motivating Others Communicating and aligning around vision Tying the present to the future The importance of purpose The art and science of motivation Networking and Influencing Positive politics and project success Types of power within organizations Power and influence Networking best practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder Management and Negotiation Identifying stakeholders Analyzing stakeholders Negotiation basics Principled negotiation Conflict Management Dynamics of conflict The anatomy of conflict Conflict management approaches and tools Dealing with ambiguity Summary and Next Steps Key concepts review Creating your personal action plan

Sketchup face to face training customised and bespoke.

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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 Jenny Price - 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project 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