• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

605 Courses in London

Vectorworks Night Training Courses

By ATL Autocad Training London

Why Choose Vectorworks Night Training Courses? Flexibility: Learn around your work schedule. Personalized Attention: Small classes for focused guidance. Practical Learning: Hands-on training for immediate application. Convenience: Balance work and learning seamlessly. Check our Website Training Duration: 10 hours. Approach: Personalized 1-on-1 Training and customized training. Timings: Schedule a convenient hour, Mon to Sat, between 9 am and 7 pm. Course Outline: Mastering Vectorworks Basics I. Introduction to CAD and Vectorworks Software Understanding the role of Computer-Aided Design (CAD) in modern workflows. Comprehensive introduction to Vectorworks software. II. Workspace Setup and Fundamental Options Configuring the workspace for efficient navigation and operation. Exploring basic options to enhance user experience. III. Basic Skills in Drawing and Object Selection Mastering fundamental drawing techniques. Expertise in selecting and manipulating objects. IV. Advanced Editing Techniques Combining shapes, mirroring, rotating, and grouping objects effectively. Working with precise scaling, preferences, and templates. V. Detailed Object Manipulation and Attributes Drawing and moving objects accurately within the design space. Utilizing advanced editing tools like fillet and offset. Introduction to basic attributes and group editing. VI. Advanced Drawing Techniques and Graphics Creating room plans with walls, windows, and doors. Implementing graphic elements such as hatching, gradients, and image fills. Drawing elevations using various methods and techniques. VII. Resource Management and Design Layers Importing images for graphic illustration. Creating symbols and navigating the Resource Browser. Organizing the drawing effectively using design layers. VIII. Labels, Annotations, and User Interface Mastery Labeling drawings and incorporating simple title block text. Navigating the user interface, understanding key terminologies. Plotting, printing, creating sheets (A1, A2, A3), and working with viewports. IX. Advanced Object Manipulation and Customization Converting drawings into PDF files. Efficiently working with files, objects, and data. Utilizing object snaps, quick selection, division, and measurement. X. Dimensioning, Text, and Tool Palettes Implementing dimensioning and annotations effectively. Working with text, custom tool palettes, and organizing these palettes. Creating standard views and additional drawing objects (Arc, Donut, Ellipse). XI. 3D Modeling Introduction and Real-World Units Introduction to 3D modeling, focusing on creating extrudes. Working with real-world units for accurate representation. XII. Advanced Object Manipulation and Exporting Manipulating objects, changing object angles, creating mirror images. Dealing with architectural elements like walls, doors, windows, and floors. By the end of the Vectorworks Evening Training Course, participants will: Demonstrate proficiency in using the Vectorworks interface, tools, and navigation. Create and edit 2D drawings, including walls, doors, windows, floors, ceilings, stairs, and railings. Effectively manage layers, classes, and views for organized and controlled object placement. Create and edit dimensions and annotations for accurate measurements and documentation. Develop skills in creating, modifying, and utilizing symbols for increased efficiency. Generate and edit 3D geometry, apply textures, and create sections and elevations from 3D models. Create polished presentation drawings using viewports, annotations, and text for clarity. Summarize course content and confidently apply learned skills in Vectorworks projects. Utilize available resources for further learning and professional development. Who Should Attend? Perfect for those aiming to master Advanced 2D Plans, Sections, Elevations and Construction detailing, lighting, and rendering in Vectorworks. Schedule Flexibility: Book personalized 1-on-1 sessions, Monday to Saturday, 9 a.m. to 7 p.m. Split 10 hours to fit your schedule. Method: Choose in-person or Live Online 1-on-1 sessions with tailored content and individual support, including Zoom options. Why Vectorworks? A pioneering CAD software, Vectorworks seamlessly integrates 2D and 3D capabilities, making it ideal for architects and designers. Free Educational Access: Students and professors can access a complimentary Vectorworks Designer license via the Academic Portal. Explore Vectorworks: Transform your designs with Vectorworks, the leading 2D, 3D, CAD, BIM software. Download or try now: https://www.vectorworks.net Tailored Training Solutions: We offer customized and project-focused training programs, designed to meet your specific needs and goals. Individualized Coaching: Receive personalized one-on-one guidance tailored exclusively for you. Adaptable Timings: Choose training slots that align with your schedule, ensuring flexibility in your learning journey. Ongoing Assistance: Access continuous post-course support to enhance your understanding and resolve queries. Comprehensive Learning Resources: Receive detailed materials providing in-depth insights for effective learning and reference. Recognition of Participation: Earn a Certificate of Attendance upon completion of your personalized training. Affordable Learning: Benefit from cost-effective rates, making quality education accessible to all. Software Setup Guidance: Get expert assistance in setting up your software on your devices for seamless learning experiences. Rewards for Referrals: Recommend our courses to others and enjoy special rewards for each successful referral. Group Learning Benefits: Enjoy exclusive discounts when you opt for group training, making it an ideal choice for teams. Convenient Hours of Operation: Access our training services at your convenience, with operating hours extending to accommodate your busy schedule. Tailored Learning Paths: Experience courses curated specifically for your needs, ensuring targeted and effective learning outcomes.

Vectorworks Night Training Courses
Delivered in London or OnlineFlexible Dates
£360

M.D.D DATING ADVICE FOR WOMEN WITH BUSY CAREERS PACKAGE (DATING ADVICE FOR WOMEN)

4.9(27)

By Miss Date Doctor Dating Coach London, Couples Therapy

When your career is a priority sometimes other areas of your life suffer It is very common to suddenly realise your love life is not progressive It is also common to realise that despite your career successes something is missing Many females that are extremely successful in their careers find themselves single and alone In this package, we help you to meet potential dates Give you dating advice and practical tools and accessibility to exclusive members clubs Organise dates for you. Create online dating profiles for you Dating advice for women Relationship and dating training Separation of business persona to the personal persona (a common area of confliction for a career focused women) https://relationshipsmdd.com/product/dating-advice-for-women-with-busy-careers-package/

M.D.D DATING ADVICE FOR WOMEN WITH BUSY CAREERS PACKAGE (DATING ADVICE FOR WOMEN)
Delivered in London or UK Wide or OnlineFlexible Dates
£3,000

AutoCAD Basics-Advanced Training Classes

By London Design Training Courses

Why AutoCAD Basics-Advanced Training Classes? Click here for more info AutoCAD Basics to Advanced Level Training Master drawing, editing, and advanced techniques. Optimize productivity and customize workspace. Create precise 2D drawings for various industries. Access recorded lessons and lifetime email support. Duration: 16 hrs Method: 1-on-1, Personalized attention. 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. The AutoCAD from Basics leading to Advanced Training Course offers a comprehensive learning experience for participants to become proficient in AutoCAD. Whether you're a beginner or an experienced user, this progressive program covers the full spectrum of AutoCAD functionality. Participants will learn core features like drawing, editing, annotations, and dimensioning, progressing to advanced topics such as object manipulation, workspace customization, and workflow optimization. Upon completion, participants will create precise 2D drawings and designs. Interactive learning experiences with experienced instructors are available in-person or through live online sessions. AutoCAD 2D Course Outline: Session 1: Introduction to AutoCAD interface, commands, and tools Managing drawings and drawing basic shapes Basic modification techniques (erase, move, rotate, scale) Session 2: Working with layers and properties Creating and modifying text and dimensions Introduction to blocks and attributes Session 3: Advanced object modification techniques (fillet, chamfer, trim, extend) Using grips to modify objects Creating and modifying polylines and splines Session 4: Creating and editing tables Working with layouts and viewports Printing and exporting drawings Construction detailing and Detailed sections Course Highlights: Engaging exercises and projects to reinforce skills. Q&A and troubleshooting support. Solid understanding of AutoCAD 2D for basic to intermediate drawings. List of Topics Covered: Drawing: Line, Polyline, Circle, Arc, Rectangle, Ellipse, Spline, Polygon, Ray, Hatching, Gradient. Inquiry: Measure and Select All. Modify: Move, Copy, Rotate, Mirror, Fillet, Trim, Extend, Erase, Offset, Explode, Array, Stretch, Break, Polyline Edit, Hatch Edit, Scale. Layers: Creating, Managing, Changing, Line Type, Line Weights. Annotation: Dimensions, Text, Dimension Style, Text Style, Leaders. Properties: Colors, Line weights, Line Types, Line Type Scaling. Blocks: Create, Insert, Edit, Explode, Export. Insert: Insert, Attach. View: Navigate, View, Windows. Plot/Print: Model Space, Layouts/Workspaces, Viewports, Layout Scaling, Paper Setup, What To Plot, Plot Scale, Plot Offset, Plot Options. Final Project: Create a Plan, Section, and Elevation drawing. Option for a personal project. Free Trial - Download AutoCAD Software & Toolsets: Participants can download a free trial of AutoCAD and industry-specific toolsets from Autodesk's official website: (https://www.autodesk.co.uk). Master AutoCAD Basics: Understand the interface, commands, and drawing tools. Create and Modify Drawings: Proficiently manage drawings and apply various modification techniques. Work with Layers and Annotations: Effectively use layers, text, and dimensions. Utilize Advanced Drawing Techniques: Apply advanced object modifications and work with polylines. Navigate Layouts and Viewports: Manage layouts, viewports, and printing/exporting. Hands-On Project Experience: Practice skills through exercises and a final project. Personalized Learning: Receive focused one-to-one attention. Convenient Options: Choose in-person or live online sessions. Lesson Recordings and Support: Access recorded lessons and receive ongoing email assistance. Enhance Career Opportunities: Develop valuable 2D drawing skills for career advancement.

AutoCAD Basics-Advanced Training Classes
Delivered in London or OnlineFlexible Dates
£465

Microsoft Project White Belt 2016

By IIL Europe Ltd

Microsoft® Project White Belt® 2016 This workshop serves as an introduction to the interface and features of Microsoft® Project. This workshop serves as an introduction to the interface and features of Microsoft® Project. It is kept up to date with the framework outlined by Project Management Institute's A Guide to the Project Management Body of Knowledge (PMBOK® Guide). This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work. What you Will Learn You'll learn how to: Define key scheduling concepts and terms Effectively navigate the user interface and interpret common views Configure essential elements of a new schedule Enter and modify a task list Set dependencies between tasks Create a basic resource list and generate assignments Format targeted areas of the Gantt Chart view Prepare the schedule for printing Getting Started Introductions Course objectives Course outline Navigating the User Interface and Views The ribbon The Quick Access Toolbar General and display options Major elements on the Project screen The Gantt chart, calendar, and network diagram views The help Setting up a New Schedule New schedules from blank, templates or other files The project starting date and forward scheduling The project standard calendar and exception days Entering, Modifying, and Outlining Task Data Task entering options and edition Unscheduled tasks Duration estimates for a single task or multiple tasks Tasks organization Multi-level outline Notes to detail tasks Creating Dependencies by Setting Links The critical path Critical path calculation in Project Dynamic schedules and dependencies Link tasks in Project Displaying the critical path Entering and Assigning Resources Resource planning Resource list Resource assignments Formatting Gantt Chart View Format options for text and Gantt charts Print options

Microsoft Project White Belt 2016
Delivered In-Person in LondonFlexible Dates
£495

AutoCAD 2D Basics to Advanced Course

By ATL Autocad Training London

Who is this course for? AutoCAD 2D Basics to Advanced Course. Click here for more info: Website This course enables you to learn the skills in the CAD. Upon completion, you'll proficiently edit and create 2D drawings, utilizing advanced features like Paperspace and Block Attributes for increased efficiency.   1-on-1 sessions. Our booking are available Mon to Sat, 9 am to 7 pm Duration: 16 hours, which you can flexibly distribute across as many days you want. Approach: In-person or live online training. AutoCAD Basics to Advanced Level Training Course Outline. Fundamental Concepts: Introduction to AutoCAD interface, commands, and tools. Managing drawings and creating basic shapes. Basic modification techniques like erase, move, rotate, and scale. Intermediate Techniques: Working with layers and adjusting properties. Creating and modifying text and dimensions. Introduction to blocks and attributes. Advanced Topics: Advanced object modification techniques such as fillet, chamfer, trim, and extend. Utilizing grips for object manipulation. Creating and editing polylines and splines. Course Highlights: Engaging exercises and projects for skill reinforcement. Access to Q&A and troubleshooting support. Proficiency in AutoCAD 2D for basic to intermediate drawings. Topics Covered: Drawing techniques encompassing various shapes. Inquiry tools for measurement and selection. Modification commands for object manipulation. Layer management and attributes. Annotation and dimensioning. Hatching objects and working with reusable content. Layouts and viewports for better organization. Annotating drawings effectively. Polylines, splines, ellipses, and tables. Plotting drawings and creating templates. Multi-lines, revision clouds, and wipeout objects. Working with point objects and calculations. Creating and managing templates. Annotation scaling and text manipulation. Dimensioning and geometric annotations. Dynamic blocks and attributes. Layer management best practices. Introduction to sheet sets and their properties. Utilizing fields and attributes in sheet sets. Working with tables, table styles, and advanced tables. Exporting and importing tables. Creating tables linked to external data. Download AutoCAD Software https://www.autodesk.co.uk What Will I Gain from this Course? Throughout this course, you will develop expertise in the following areas: CAD layering techniques Text and dimension style manipulation Proficiency in creating and editing 2D drawings Mastery of attributed block creation and editing Efficient utilization of Paperspace Dynamic input and grips utilization This comprehensive training program not only provides you with an advanced comprehension of 2D drawing in AutoCAD but also offers a fundamental introduction to 3D drawing concepts. Upon completion of this course, you will possess the skills to: Swiftly generate schematics, parts, and assemblies Enhance efficiency by reusing content and customizing tool palettes Save time through the use of dynamic blocks, which can be edited in place Gain full control over your viewports and layouts Is This Course Right for Me? This advanced AutoCAD 2D training assumes that you are already a proficient AutoCAD user. We recommend prior attendance of our Introduction and/or Intermediate AutoCAD 2D training courses or practical experience in the topics covered in those courses. If you have any doubts about the suitability of this course for your skill level, please feel free to contact us, and we will be happy to assist you. In this course, you will gain proficiency in utilizing essential features of AutoCAD (Computer Aided Design) to enhance the efficiency of producing and editing 2D CAD drawings. You will acquire expertise in layering, text and dimension styles, the creation and modification of attributed blocks, and effective use of Paperspace. Additionally, you will master dynamic inputs, grips, and the art of renaming and purging. This flexible course grants you 16 hours to complete, typically spanning 4 to 5 days. It serves as a valuable continuation of skills acquired from the CAD: AutoCAD 2D Essentials course or as an opportunity to expand your existing AutoCAD knowledge. Upon course completion, you will possess the ability to efficiently create and modify 2D drawings, leveraging advanced features like Paperspace and Block Attributes. Your instruction will be provided by an Autodesk-certified instructor with industry experience." 1. All-encompassing course designed to accommodate both novices and advanced users. 2. Addresses essential functions and advanced methodologies in AutoCAD. 3. Enhances proficiency in creating precise and professional 2D drawings. Interactive instruction guided by seasoned educators. Benefit from on-demand access to lesson recordings for convenient revision. Receive ongoing support through lifetime email and phone assistance. Post-course Assistance: Enjoy continuous support via lifetime email and phone assistance. Should you encounter any challenges or queries after the course, we are readily available to address your concerns via email or phone calls."

AutoCAD 2D Basics to Advanced Course
Delivered in London or OnlineFlexible Dates
£558

3D AutoCAD Basics to Advanced Training Course

By ATL Autocad Training London

Why Choose 3D AutoCAD Basics to Advanced Training Course? Students learn how to create and modify both solid and surface models. This AutoCAD Training course also teaches students how to present their designs in 3D products and designs. Check our Website Duration: 16 hours Approach: 1-on-1, Book your own day and time. We are open Monday to Saturday 9 am to 7 pm.  How to Book this course? Call us on 02077202581 and we will book the dates and times you like. Flexible Schedule: 1-on-1 Face to Face or Live Online. AutoCAD 3D Training: Comprehensive Course Overview Exploration of 3D Modeling and Imaging Generating 3D Drawings Navigating the 3D Modeling Workspace Crafting 3D Shapes using Solid Tools Extruding Polylines into 3D Forms Isolating Coordinates with Point Filters Navigating and Orienting Your Model Achieving Visual Effects Converting 3D Views into 2D AutoCAD Drawings Advanced 3D Techniques Setting Up AutoCAD for 3D Mastering the User Coordinate System Leveraging UCS Options Utilizing Viewports for 3D Drawing Employing Array Tools Crafting Complex 3D Surfaces Constructing Spiral Forms Developing Surface Models Manipulating Objects in 3D Space Rendering and Visualization of 3D Drawings Introduction to Rendering Rapid Rendering Techniques Simulating Sunlight and Shadows Application and Adjustment of Materials Creating Effects with Lights and Materials Texture Mapping and Adjustments Exploration of Rendering Options Enhancing Views with Cameras Printing Rendered Drawings Simulating Natural Lighting Editing and Visualizing 3D Solids Overview of Solid Modeling Creation of Basic and Complex Solids Editing Solid Forms Improving the 2D Drawing Process Visualization and Analysis of Solids Exploration of 3D Mesh and Surface Modeling Introduction to 3D Meshes and Surfaces Creation and Editing of 3D Meshes Crafting Mesh Surfaces Conversion of Meshes to Solids Understanding and Editing 3D Surfaces Customization of Interface and Tools Customization of Workspaces Personalization of the User Interface Creation of Macros in Tools and Menus Working with Expanded Text Boxes Saving and Managing Customizations Exploration of the Diesel Macro Language Designing Custom Linetypes and Hatch Patterns Management and Sharing of Your Drawings Sharing Drawings Online ePublishing Your Work Managing Drawings with DesignCenter and Tool Palettes Exploring the Drawing Library with Content Explorer Establishment of Office Standards Conversion of Layer Settings https://www.autodesk.co.uk  Download a free 30-day trial of AutoCAD Learning outcomes after completing the AutoCAD 3D course. Professional Presentation: Create dynamic walkthroughs and presentations that effectively communicate your 3D models and designs. Certification: Obtain a certification as proof of your proficiency in AutoCAD 3D modeling, validating your skills in the industry. Mastery of 3D Modeling: Possess comprehensive skills, from fundamental concepts to advanced techniques in 3D modeling. Enhanced Career Prospects: Improve your career opportunities and prospects in various design-related fields such as architecture, engineering, and product design. Realistic Rendering: Be able to create highly realistic visualizations that enhance the quality of your designs. Practical Hands-On Experience: Gain practical experience and confidence in 3D modeling through extensive hands-on practice. Personalized Learning: Benefit from one-on-one attention and tailored training to meet your specific learning needs and pace. Lifetime Email Support: Continue to receive assistance and guidance through lifetime email support, ensuring you are supported even after completing the course. 3D AutoCAD Training Courses Gain confidence and proficiency in AutoCAD. Discover the fundamentals of 3D modeling and object creation in this introductory AutoCAD 3D course. Booking Your Training Course: Experience personalized training with our adaptable 1-on-1 sessions. You have the freedom to customize your schedule by reserving a convenient hour at your discretion. Our booking slots are available from Monday to Saturday, spanning from 9 a.m. to 7 p.m. You can also reach us at 02077202581 to make a booking over the phone. Course Duration: 10 hours "You have the flexibility to divide these 10 hours across multiple days to suit your ideal schedule." Training Method: 1-on-1 (In-person face-to-face or Live Online) Expect personalized attention, tailor-made content, a flexible learning pace, and dedicated individual support throughout your training journey. This hands-on course provides ample opportunities to experiment with newly acquired techniques and seek answers to your questions. Key Features: An introductory course tailored to AutoCAD 3D's essential features. Abundant one-on-one guidance and dedicated question time. Friendly expert trainers, small class sizes, and a comfortable learning environment. Comprehensive course materials and additional resources. Ongoing support and assistance with post-course challenges. What Will You Learn? This course will equip you with the foundational knowledge and workflows necessary to create 3D models within AutoCAD 3D. You will delve into the creation and modification of both solid and surface models. Upon completion, you will be able to: Effortlessly fashion intricate shapes by combining simple elements. Precisely extract geometries and dimensions from your creations. Easily customize the view and presentation style of your objects. Is This Course Right for You? No prior experience with AutoCAD 3D is required. This course caters to individuals proficient in working with 2D objects who aspire to construct 3D models of their designs. Gain proficiency in the fundamental tools and functionalities to create precise and professional 2D and 3D drawings, advancing to more complex techniques. Enhanced Efficiency: Discover time-saving strategies, tips, and workflows that will boost your productivity and streamline your design process within AutoCAD 3D. Versatility in Design: Develop the skills needed to undertake a wide range of projects, from architectural plans and engineering drawings to mechanical components and electrical schematics. Industry-Recognized Expertise: Cultivate in-demand skills relevant to architecture, engineering, construction, and manufacturing, paving the way for career advancement and professional development. Accessible Lesson Recordings: Access recorded lessons at your convenience to review and reinforce course material whenever necessary. Continuous Email Support: Benefit from ongoing assistance with lifetime email support, ensuring you have access to guidance, answers, and clarifications even beyond the completion of the course.

3D AutoCAD Basics to Advanced Training Course
Delivered in London or OnlineFlexible Dates
£696

Microsoft Project White Belt 2016: In-House Training

By IIL Europe Ltd

Microsoft® Project White Belt® 2016: In-House Training This workshop serves as an introduction to the interface and features of Microsoft® Project. This workshop serves as an introduction to the interface and features of Microsoft® Project. It is kept up to date with the framework outlined by Project Management Institute's A Guide to the Project Management Body of Knowledge (PMBOK® Guide). This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work. What you Will Learn You'll learn how to: Define key scheduling concepts and terms Effectively navigate the user interface and interpret common views Configure essential elements of a new schedule Enter and modify a task list Set dependencies between tasks Create a basic resource list and generate assignments Format targeted areas of the Gantt Chart view Prepare the schedule for printing Getting Started Introductions Course objectives Course outline Navigating the User Interface and Views The ribbon The Quick Access Toolbar General and display options Major elements on the Project screen The Gantt chart, calendar, and network diagram views The help Setting up a New Schedule New schedules from blank, templates or other files The project starting date and forward scheduling The project standard calendar and exception days Entering, Modifying, and Outlining Task Data Task entering options and edition Unscheduled tasks Duration estimates for a single task or multiple tasks Tasks organization Multi-level outline Notes to detail tasks Creating Dependencies by Setting Links The critical path Critical path calculation in Project Dynamic schedules and dependencies Link tasks in Project Displaying the critical path Entering and Assigning Resources Resource planning Resource list Resource assignments Formatting Gantt Chart View Format options for text and Gantt charts Print options

Microsoft Project White Belt 2016: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£495

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

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

Microsoft Excel Intermediate - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Mental Health First Aid - Adult 2 day

By The Training Co

The Training Co is an Accredited Center with Mental Health First Aid England and we offer a range of Mental Health First Aid Courses across England. You can join our open courses in at many city center venues or organise a group course at your office.

Mental Health First Aid - Adult 2 day
Delivered In-PersonFlexible Dates
£285

DevOps for networking engineers

5.0(3)

By Systems & Network Training

Network DevOps course description This course is not a soft skills course covering the concepts of DevOps but instead concentrates on the technical side of tools and languages for network DevOps. Particular technologies focussed on are ansible, git and Python enabling delegates to leave the course ready to starting automating their network. Hands on sessions follow all major sections. More detailed courses on individual aspects of this course are available. What will you learn Evaluate network automation tools. Automate tasks with ansible. Use git for version control. Use Python to manage network devices. Use Python libraries for network devices. Network DevOps course details Who will benefit: Administrators automating tasks. Prerequisites: TCP/IP Foundation Duration 5 days Network DevOps course contents What is DevOps Programming and automating networks, networks and clouds, AWS, OpenStack, SDN, DevOps for network operations. Initial configuration Configuring SSH, ZTP, POAP. Hands on Initial lab configuration. Getting started with ansible The language, the engine, the framework. Uses of ansible, orchestration. The architecture, Controlling machines, nodes, Agentless, SSH, modules. Configuration management, inventories, playbooks, modules, roles. Hands on Installing ansible, running ad hoc commands. Ansible playbooks ansible-playbook, YAML, plays, tasks, handlers, modules. Playbook variables. Register module, debug module. Hands on Running playbooks. Ansible Inventories /etc/ansible/hosts, hosts, groups, static inventories, dynamic inventories. Inventory variables, external variables. Limiting hosts. Hands on Static inventories, variables in inventory files. Ansible modules for networking Built in modules, custom modules, return values. Core modules for network operations. Cisco and/or Juniper modules. ansible_connection. Ansible 2.6 CLI. Hands on Using modules. Ansible templating and roles aConfiguration management, full configurations, partial configurations. The template module, the assemble module, connection: local, Jinja2 templates, variables, if, for, roles. Hands on Generating multiple configurations from a template. Network programming and modules Why use Python? Why use ansible? alternatives, ansible tower, Linux network devices. Programming with Python Python programming Functions. Classes, objects and instances, modules, libraries, packages. Python strings, Python file handling, pip list, pip instal. Hands on Python programming with pyping. More Python programming Functions. Classes, objects and instances, modules, libraries, packages. Python strings, Python file handling, pip list, pip install. Hands on Python programming with pyping. Git Distributed version control, repositories, Git and GitHub, Alternatives to GitHub, Installing git, git workflows, creating repositories, adding and editing files, branching and merging, merge conflicts. Hands on working with Git. Python and networking APIs, Sockets, Telnetlib, pysnmp, ncclient, ciscoconfparse. Paramiko SSH and Netmiko Integrating Python and network devices using SSH. Netmiko, Netmiko methods. Hands on Netmiko. NAPALM What is NAPALM, NAPALM operations, getters, Replace, merge, compare, commit, discard. Hands on Configuration with NAPALM. Integrating ansible and NAPALM. Python and REST REST APIs, enabling the REST API. Accessing the REST API with a browser, cURL, Python and REST, the request library. Hands on Using a REST API with network devices.

DevOps for networking engineers
Delivered in Internationally or OnlineFlexible Dates
£3,697