426 Courses in London

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 classroom, 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. 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

SIA Door Supervisor Training with Free First Aid

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

InDesign face to face training customised and bespoke.

Why 3ds max and V-Ray Training Course? This course is ideal for 3D artists and professionals in various industries seeking advanced rendering skills. If you work with 3ds Max and want to master superior photorealistic rendering using V-Ray, this course is tailored for you. V-Ray, a third-party engine compatible with 3ds Max,  Click here for more info: Website Duration: 10 hours. Approach: Personalized 1-on-1 Sessions and Flexible Learning. Scheduling Flexibility: Mon to Sat between 9 am and 7 pm. Choose your own day and time. 10-hour Vray for 3ds Max Training Course Outline: Module 1: Introduction to Vray for 3ds Max (2 hours) What is Vray and its integration with 3ds Max? Installation and setup of Vray for 3ds Max Understanding Vray interface and workflow Overview of Vray materials Module 2: Lighting with Vray (2 hours) Various lighting techniques in Vray Types of Vray lights and their configurations Creating and managing Vray sun and sky Vray dome lighting and IES light usage Efficient lighting workflows in Vray Module 3: Vray Camera (2 hours) Understanding Vray camera settings Controlling exposure with Vray camera Working with Vray depth of field Creating Vray camera animations Utilizing Vray frame buffer Module 4: Vray Materials (2 hours) Understanding Vray material properties Creating realistic materials using Vray Building and storing custom Vray material libraries Implementing Vray material overrides Module 5: Vray Rendering and Post Production (2 hours) Overview of Vray rendering settings Rendering images and animations with Vray Post-production techniques in Photoshop Understanding and utilizing Vray frame buffer Compositing Vray render elements in Photoshop Working with Vray denoiser Modeling Techniques: Edit Poly Modeling Extrude, Chamfer, Cut, and Slices Symmetry Mirror Modeling Designing furniture and basic architectural models Lines, Shapes, and Plan Import from AutoCAD/Vectorworks Modifiers: Compound objects (Connect, Scatter, Pro Boolean, Loft, Terrain) Bend and Taper Basic Lights: Omni Light, Spot Light, Direct Light Camera Control: Free Camera, Target Camera Texturing and Rendering: Diffuse and Bump Mapping Environment and Background Images Advanced Rendering Techniques (Interior and Exterior Scenes) Vray Specifics: VRay Lights (Plane, Dome, Sphere, Sun, Shadow) VRay Camera Settings (Focal Length, Film Speed, Shutter Speed) VRay Materials (Diffuse Color, Reflection, Refraction, Blurry Reflections) Upon completing the 10-hour Vray for 3ds Max Training Course, participants will: Master Vray Integration: Understand setup, interface, and tools for effective usage. Excel in Vray Lighting Techniques: Learn diverse Vray lighting methods, enhancing scene realism. Vray Camera Control: Manipulate camera settings, exposure, and create dynamic animations. Vray Material Skills: Create realistic materials, manage libraries, and override material properties. Perfect Rendering and Post-Production: Optimize rendering, produce high-quality images, and enhance results in post-production. Advanced 3D Modeling Expertise: Develop complex shapes, utilize modifiers, and import plans effectively. Recommended Resources: "V-Ray My Way: A Practical Designer's Guide to Creating Realistic Imagery Using V-Ray & 3ds Max" by Lee Wylde "3ds Max Modeling for Games: Insider's Guide to Game Character, Vehicle, and Environment Modeling" by Andrew Gahan "Photoshop for 3D Artists, Volume 1" by 3DTotal Publishing Job Opportunities: Students can pursue careers as: 3D Visualization Artists: Creating realistic visuals for architecture, products, and entertainment. Game Designers: Developing game environments and assets for interactive experiences. Architectural Visualizers: Producing high-quality architectural renders for firms and clients. Product Designers: Crafting detailed product visualizations for marketing and prototyping. Freelance 3D Artists: Offering services on platforms like Upwork, catering to diverse client needs. Opportunities exist in architecture, gaming, animation, advertising, and freelancing. A strong portfolio and networking enhance job prospects. Skills Acquired: Vray Advanced Lighting: HDRI, Global Illumination Mastery. Vray Material Expertise: Shaders, Textures, Realistic Material Replication. Scene Optimization: Large-scale Scene Handling, Speed Optimization. Post-Production Skills: Vray and Photoshop Enhancement, Atmosphere Addition. Career Opportunities: Architectural Visualization Specialist Product Design Visualizer 3D Visualization Artist Freelance Rendering Expert In-House Rendering Consultant Learn the advanced Vray rendering skills, 1-on-1 training courses, boost your career prospects in architectural visualization, product design, and animation industries.  Download 3ds max. Autodesk Download a free 30 day trial of 3ds Max, 3D modelling and rendering software for design visualisation, games and animation to create with full artistic Download Vray V-Ray for 3ds max is an integral rendering software for SketchUp, enabling designers to experience their designs in real-time. Say Goodbye to Group Courses: Welcome to our Personalized Learning Experience! Why Choose Us? Our Course Benefits Include: ​ One-on-One Training: Experience personalized coaching from practicing architects and designers tailored exclusively for you. 1-on-1, Face to Face at (SW96DE) or Live online. Open: Monday to Saturday 9 am to 7 pm. Customized Tutorials: Take home bespoke video tutorials designed to enhance your learning journey. Comprehensive Resources: Receive a digital reference book for thorough revision, ensuring you grasp every concept. Free Ongoing Support: Enjoy continuous after-course support via phone or email, guaranteeing your success even after the class ends. Flexible Syllabus: We adapt syllabus and projects to match your needs, ensuring you learn precisely what matters most to you. Official Certificate: Certificate upon course completion. Why Us? Supported Individual Learning: Our courses, ranging from 10 hours to 120 hrs Diploma training Courses, offer unwavering support at every step. With personalized homework assignments and free after-course assistance, we pave the way to mastering software with unparalleled guidance. Personalized Attention, Not Crowded Classrooms: Bid farewell to crowded classrooms. Experience the intimacy of one-on-one learning. This ensures you receive the undivided attention you deserve, fostering a confident and comfortable learning environment. Financial Flexibility: Embarking on your educational journey shouldn't be a financial burden. We offer a variety of payment plans tailored to your needs. Discover the options available to you and start your learning adventure today. Expert Instructors, Real-world Insight: Our instructors are experts meticulously chosen for their extensive industry knowledge and passion for teaching. They are dedicated to imparting invaluable skills to anyone eager to learn.

Recruiting great people to our organisations is the key to high performance and sustainable business success.

Why Learn AutoCAD 2D Introduction to Intermediate Course? Click here for more info: Website Whether you're starting a career, enhancing skills, or exploring creativity, this course is tailored for you. Learn on Windows or Mac, transform into a confident AutoCAD user. Transition to our Intermediate to Advanced Course post-completion. Duration: 10 hrs. Personalized 1-on-1 training. Perfect for beginners, this course offers flexible scheduling (Mon-Sat, 9 am-7 pm) and covers 2D plan and elevation creation in AutoCAD. AutoCAD 2D Course Outline Workspace Exploring the working environment Managing files Displaying objects Constructing fundamental drawings Inputting data Constructing basic objects Utilizing object snaps Utilizing Polar Tracking and PolarSnap Implementing object snap tracking Handling units Manipulating objects Selecting objects in the drawing Adjusting an object's position Generating new objects based on existing ones Modifying an object's orientation Creating mirrored versions of existing objects Designing object patterns Altering an object's dimensions Organizing and querying drawings Utilizing layers Modifying object attributes Matching object attributes Utilizing the properties palette Applying linetypes Using inquiry commands Modifying objects Trimming and extending objects to specified boundaries Generating parallel and offset geometries Merging objects Dividing an object into two separate entities Applying rounded corners to objects Producing angled corners between objects Modifying an object's shape Layouts and viewports Harnessing layouts Creating layout configurations Modifying layouts and employing page setups Working with viewports Creating layout viewports Managing layout viewports Controlling object visibility within layout viewports Annotating a drawing Generating multiline text Creating single-line text Implementing text styles Editing text Dimensioning Creating dimensions Utilizing dimension styles Adjusting dimensions Implementing multileaders Hatching objects Hatching elements Editing hatch patterns Managing reusable content Working with blocks Exploring DesignCenter Utilizing tool palettes Designing additional drawing elements Managing polylines Generating splines Crafting ellipses Working with tables Producing plotted drawings Employing page setups Utilizing plotter configuration files Creating and applying plot styles Plotting drawings Plot style tables Publishing drawings Generating drawing templates Leveraging drawing templates Download AutoCAD AutoCAD Trial https://www.autodesk.co.uk  After completing the AutoCAD 2D Introduction to Intermediate Course, you will: Master Fundamentals: Understand AutoCAD basics, including navigation and terminology. Create Precise Drawings: Develop the skills to create accurate 2D drawings like plans and elevations. Manipulate Objects: Learn object selection, modification, and pattern creation. Dimension Proficiency: Create and edit dimensions and use text styles effectively. Layer Control: Organize drawings with layer management. Annotation Skills: Handle text and annotations with ease. Layouts and Viewports: Work with layouts and viewports for presentation. Plotting Expertise: Plot and publish drawings confidently. Customization Options: Explore advanced features for efficiency. Intermediate-Level Competency: Transition from beginner to an intermediate level of AutoCAD proficiency. This course equips you with essential skills for various industries, including architecture and engineering. This one-on-one CAD course is perfect for students who are either entirely new to the software or possess limited self-taught knowledge. Regardless of your starting point, our goal is to get you drawing plans within the very first hour of your class. We'll begin by building a strong foundation in AutoCAD, ensuring that you understand its core principles before delving into more advanced topics. If you have specific preferences, we can customize your AutoCAD learning experience to align with your goals. On the initial day of the course, we'll cover fundamental aspects such as user interface and terminology. Subsequently, you'll engage in a diverse range of lessons designed to deepen your understanding of AutoCAD and its creative processes. Topics covered will include introductory drawing techniques, editing functions, drawing aids, working with layers, managing text, and handling dimensions. Throughout the course, you'll practice through various drawing exercises and explore the intricacies of plotting. By the course's conclusion, you'll possess the skills needed to create your own simple drawings, suitable for applications in architectural, interior, engineering, events, furniture, or product design. Included in the course price are the following: Lifetime Email Support: Enjoy unlimited access to our support via email throughout your learning journey. Expert Instruction: Benefit from expert teaching provided by practicing architects, designers, and software professionals. Hands-On Learning: Engage in practical, hands-on lessons that can be customized to match your project requirements. Comprehensive Resources: Access video recordings and a digital reference PDF book for revision and continuous development. Certification: Receive a certificate of completion from us to enhance your CV and LinkedIn profile. Career Guidance: Gain valuable insights into pursuing design roles or establishing a creative business. Our experienced tutors will help you acquire the technical skills needed to make your CV and portfolio stand out. Our instructors, who are accomplished interior designers, animators, architects, and software experts, will not only impart technical expertise but also provide guidance on achieving success in the design industry or entrepreneurial endeavors.

Charisma is a rare quality – we know when we see charisma because we feel compelled to listen to those who have it. There is a magic about them. We notice them as soon as they walk into a room. We are so inspired by what they say that we find ourselves almost as enthusiastic as they are about the thing they are speaking about. They have a way of communicating that brings us alive and makes us feel good.

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. Tailored in company 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 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

Who Should Attend Rhino 3D Evening Training Course? Click here for info. This Evening Course is for individuals seeking to learn 2D and 3D modeling skills in a supportive and creative learning environment. Whether you are new to Rhino or want to expand your existing knowledge, this course is for product, furniture, architectural, and jewelry design industries. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own schedule hours of your choice, available from Mon to Sat between 9 am and 7 pm Course Inclusions: Free Lifetime email support: Enjoy the flexibility of a free lifetime email support. Expert Instruction: Learn from experienced architects, designers, and software professionals, ensuring top-notch teaching. Hands-On Learning: Engage in practical, hands-on lessons with personalized project work to apply your skills effectively. Digital Reference: Access valuable video tutorials and a digital reference book for convenient revision and continuous development. London Design Training Course Certificate of Completion: Receive a certificate upon course completion, enhancing your CV and LinkedIn profile. Free Career Guidance: Benefit from career guidance, including tips on job applications and setting up a creative business, to stand out in the competitive design industry. Rhino 3D Basic to Intermediate Training Course Course Duration: 10 hours Introduction to Rhino and Interface: Familiarizing with Rhino's command system and toolbar usage. Navigating the geometry menus, command line, and status bar efficiently. Understanding the Properties window and its functionalities. Managing file operations, including opening and saving files. Grasping the three entity types: curves, surfaces, and solids. Exploring various geometric elements, such as Bezier curves, B-splines, NURBS objects, isocurve surfaces, and mesh surfaces. Setting measurement units for accurate modeling. Navigation: Introducing the viewport and its features. Using construction planes to aid in modeling. Utilizing shading modes for better visualization. Learning essential viewport controls: pan, zoom, rotate, and reset. Workflow Basics: Creating basic objects like curves, surfaces, and solids. Performing fundamental transformations to manipulate objects. Organizing projects efficiently using layers. Drawing: 2D Geometry: Understanding the creation of lines, polylines, rectangles, polygons, arcs, circles, and ellipses. Drawing freeform curves for more creative designs. Modeling: 3D Surfaces: Comparing various 3D surface types. Utilizing extrusion to add features to models. Creating surfaces with loft, revolve, rail revolve, sweep rail, and network surface commands. Constructing complex surfaces with the Network Surface tool. Modeling: 3D Solids: Introducing solid modeling techniques. Creating solids with primitives and curves. Applying Boolean operators to create unique shapes. Editing solids using the solid edit tool. Transforming solids and incorporating modeling aids like Grid Snap, Ortho, and Planar. Editing and Transforming Objects: Using Fillet and Chamfer to edit corners. Employing curve Booleans for trimming and splitting. Mastering the Drag and Nudge tools for object movement and rotation. Copying, pasting, and grouping objects effectively. Scaling and duplicating objects with the Mirror command. Analysis and Degrees: Understanding degrees of curves and surfaces. Creating screen captures for quick proofs. Generating 2D views and rendering projects. Preparation for 3D Printing and Manufacturing: Preparing models for prototyping by ensuring closed gaps. Using the shell technique to create wall thickness suitable for 3D printing.