1228 Design courses in Ashtead

LINX 3 training course description A detailed study of BGP, from the basics of how it works through to advanced issues such as route reflectors, policy, filtering, route selection and routing registries. The course culminates with a study of an industrial strength BGP template illustrating important issues such as bogon filtering. Practical hands on with routers follow the major sessions to reinforce the theory. A multiple choice exam, leading to the LAIT III certification, is available after the course. The exam consists of 60 questions and lasts 2 hours. What will you learn Connect enterprises to the Internet, and ISPs to each other. Describe how BGP works. List, describe and configure the main BGP attributes. Implement and troubleshoot BGP. Work with route aggregation and calculate CIDR prefixes in seconds. Influence traffic paths with BGP. LINX 3 training course details Who will benefit: Network engineers. Prerequisites: LAIT I and II OR CCNP and take LAIT I and LAIT II exams whilst on this course. Duration 5 days LINX 3 training course contents Basic BGP IGPs, EGPs, What's BGP? BGP RIB, in/out process, tables peers, adding routes. Hands on Simple configuration and troubleshooting. The Internet and peering ASs, AS numbers, Internet structure, ISP types, ISP network design, IXs, peering vs. transit, public/ private peering, bi/multi-lateral peering. Hands on AS information gathering. How BGP works Incremental updates, Path vector protocols, BGP protocol stack, the BGP header, message types, NLRI, withdrawn routes, route refresh, route dampening. Hands on More troubleshooting, packet analysis. MBGP and IPv6 Multiprotocol routing, AFI, SAFI, MBGP and multicasts, IPv6, MPLS VPNs. Hands on IPv6 BGPv4 aggregation CIDR, benefits, techniques, shortcuts, configuring BGP aggregation, leaking routes. Hands on Reducing routing table size. BGP path selection BGP attributes, attribute types, route selection order, Local preference, AS prepend, MEDs. Hands on Influencing traffic with BGP. BGP routing policies What is policy? Examples, route filtering, AS filtering, REs, applying preference selectively, peer groups. Hands on Sophisticated policies. RIPE and routing registries RIRs, Allocations, assignments, PI vs. PA. Objects, RPSL, routing registry, Hands on The RIPE database. Automating BGP configuration Automation tools, whois, IRRToolSet, Bogon lists, tracking bogon lists, HTTP, Peering, routing registries, DNS. Communities What is a community? Community names, communities for: peer types and geography. RFC 1998, default communities. Hands on Setting local preference on other routers. Route servers What are route servers? LINX route servers, route server policy control, What are route collectors, Looking glasses. Hands on Setting up and working with a route server. Peer relationships IBGP, EBGP, next hop self, advertising routes into/out of BGP, synchronisation. Hands on IBGP, troubleshooting a large BGP network. Route reflectors and confederations Full mesh IBGP, Route reflectors, RR configuration and design, confederations, migration issues. Hands on RR configuration. BGP architectures Stub vs. transit AS, when to use BGP, multihoming strategies and issues, default routes. Multihop EBGP, load balancing. Hands on Multihoming. BGP security RFC 7454, security steps, BGP TTL security, filters, RPKI, ROAs, rsync, rrdp, validators. A secure BGP template. Hands on RPKI prefix validation.

Leading SAFe®: In-House Training During this course, attendees gain the knowledge necessary to lead a Lean-Agile enterprise by using the Scaled Agile Framework® (SAFe®) and its underlying principles derived from Lean, systems thinking, Agile development, product development flow, and DevOps. Participants in the class gain insights into mastering business agility to thrive in competitive markets. They discuss how to establish team and technical agility and organize and re-organize around the flow of value. Attendees also learn and practice the skills to support and execute PI Planning events and coordinate multiple Agile Release Trains (ARTs). Class participants will explore the importance of adopting a customer-centric mindset and Design-Thinking approach to Agile Product Delivery. Learners will also understand how to implement a Lean Portfolio Management function within their enterprise. What you will Learn After attending this class, attendees should be able to: Lead the transformation to business agility with SAFe® Become a Lean-Agile leader Understand customer needs Design Thinking Enable Agile Product delivery Implement Lean Portfolio Management Thrive in the digital age with business agility Become a Lean-Agile leader Establish Team and Technical Agility Build solutions with Agile Product Delivery Explore Lean Portfolio Management Lead the change Become a Certified SAFe® Agilist

Software development training course description This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-361, and build an understanding of these topics: Core programming, Object-Oriented programming, general software development, web applications, desktop applications, and databases. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. What will you learn Describe core programming. Explain Object Oriented programming. Describe general software development. Describe Web applications. Describe desktop applications. Explain how databases work. Software development training course details Who will benefit: Anyone looking to learn the fundamentals of software. Prerequisites: None. Duration 3 days Software development training course contents Core programming Computer storage and data types How a computer stores programs and the instructions in computer memory, memory stacks and heaps, memory size requirements for the various data storage types, numeric data and textual data. Computer decision structures Various decision structures used in all computer programming languages; If decision structures; multiple decision structures, such as If…Else and switch/Select Case; reading flowcharts; decision tables; evaluating expressions. Handling repetition For loops, While loops, Do...While loops and recursion. Understand error handling Structured exception handling. Object-oriented programming Classes Properties, methods, events and constructors; how to create a class; how to use classes in code. Inheritance Inheriting the functionality of a base class into a derived class. Polymorphism Extending the functionality in a class after inheriting from a base class, overriding methods in the derived class. Encapsulation Creating classes that hide their implementation details while still allowing access to the required functionality through the interface, access modifiers. General software development Application life cycle management Phases of application life cycle management, software testing. Interpret application specifications Application specifications, translating them into prototypes, code, select appropriate application type and components. Algorithms and data structures Arrays, stacks, queues, linked lists and sorting algorithms; performance implications of various data structures; choosing the right data structure. Web applications Web page development HTML, CSS, JavaScript. ASP.NET web application development Page life cycle, event model, state management, client-side versus server-side programming. Web hosting Creating virtual directories and websites, deploying web applications, understanding the role of Internet Information Services. Web services Web services that will be consumed by client applications, accessing web services from a client application, SOAP, WSDL. Desktop applications Windows apps UI design guideline categories, characteristics and capabilities of Store Apps, identify gestures. Console-based applications Characteristics and capabilities of console- based applications. Windows Services Characteristics and capabilities of Windows Services. Databases Relational database management systems Characteristics and capabilities of database products, database design, ERDs, normalisation concepts. Database query methods SQL, creating and accessing stored procedures, updating and selecting data. Database connection methods Connecting to various types of data stores, such as flat file; XML file; in-memory object; resource optimisation.

Why Learn Adobe InDesign Advanced Training Course? Master Adobe InDesign for efficient page layouts with our advanced course. Learn document setup, text formatting, and special effects. Suitable for beginners and advanced users. London Design Training Course provides top InDesign course with Adobe Certified Instructors. Course Link Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own schedule by pre-booking hours of your choice, available from Mon to Sat between 9 am and 7 pm Flexible Learning Options: Choose between in-class training at our London center or participate online. Both options provide hands-on, practical learning with step-by-step demonstrations and ample opportunities for questions. Introduction to InDesign: Exploring InDesign Basics Customizing Preferences and Workspace Navigating Panels and Windows Setting Up Toolbar and Properties Panel Document Management: New Document, Pages, and Order Quick Navigation Techniques with Shortcuts Smart Layout: Organizing Layouts with Guides and Grids Understanding Bleed, Slug, and Margins Utilizing Smart Guides for Precision Typography: Mastering the Type Tool Adding Text to Pages and Using Placeholder Text Text Formatting with Character and Paragraph Controls Editing Text Frames and Justifying Text Multi-column Setup and Styling with Character/Paragraph Styles Working with Bullet Points and Numbering Working with Images: Creating Frames and Placing Images Content Fitting Options: Proportional Fit, Content-Aware Fit, Auto-Fit Manipulating Frame Properties: Fill, Stroke, Effects Utilizing Object Styles for Consistent Frames Advanced Techniques: Image Frame Grids, Merging Frames, Text Wrap Options Understanding Image Formats and Resolution Tabs and Alignment: Mastering Tab Palette and Alignment Options Adding Leaders for Enhanced Formatting Color Theory and Editing: Basics of Color Theory and Color Modes Creating Color Themes with the Color Theme Tool Swatches, Color Libraries, and Gradients Editing Gradient Fills and Colors Advanced Interactive Actions: Adding Animation Effects with Animation Panel Fine-tuning Animations with Timing Panel Creating Complex Object States and Action Buttons Adding and Testing Hyperlinks, Page Transitions Parent Page Basics: Understanding Parent Pages Page Numbering, Order, Headers, and Footers Inserting Text Variables for Dynamic Content Advanced Object Styles and Effects: Opacity Control and Blending Modes Black and White Conversion, Color Blending Modes Adding Dimension with Bevel and Emboss Effects Advanced Text Frame Options: Auto-sizing Text Frames and Balancing Column Height Inset Spacing and Fill Colors for Text Boxes Hot Corner Resizing Shortcuts and Anchor Objects Footnotes: Purpose and Usage of Footnotes Adding, Editing Footnotes with Footnote Options By the end of this Adobe InDesign training, participants will: Understand InDesign basics and its interface. Create effective page layouts with text formatting and image placement. Work with layers, apply special effects, and manage tables. Ensure error-free and print-ready documents through preflighting. Receive a practical training guide and an e-certificate upon completion.

Why Choose Photoshop Evening Training Course? Click here for more info Become proficient in Photoshop, the premier photo editing software, with our London Software Training course. Gain essential skills in photo editing, enabling independent navigation of the interface for successful edits and graphic creation. Duration: 10 hours Approach: 1-on-1 guidance, Customized instruction. Schedule: Tailor your own hours, available from Mon to Sat between 9 am and 7 pm.Or Call 02077202581 or WhatsApp 07970325184. Participate in our Photoshop Evening Training Course, hosted at the UK's largest training school. Whether you're a beginner or an expert, our course is tailored to suit your level, offered both live online and in person. Adobe Photoshop Course Highlights: Embark on your design journey with our Adobe Photoshop course, conducted at the UK's leading Adobe Training Centre. Acquire proficiency in Adobe's premier digital imaging software, crucial for digital content creation. Our courses prioritize hands-on exercises, ensuring practical learning experiences. Whether you're new to Photoshop or an experienced user seeking efficiency, our diverse courses cater to your needs. Join us to master Photoshop and unleash your creative potential. Course Details: Duration: 10 hours Approach: Personalized 1-on-1 guidance, customized instruction. Schedule: Flexible hours available from Mon to Sat between 9 am and 7 pm. For inquiries, call 02077202581 or WhatsApp 07970325184. Evening Adobe Photoshop - 10-Hour Training Course Module 1: Introduction to Photoshop (1 hour) Overview of Photoshop interface and tools Understanding file formats and resolution Navigating the workspace and customizing preferences Essential keyboard shortcuts for efficient workflow Module 2: Working with Layers (1 hour) Mastering the concept of layers and their importance Organizing and managing layers effectively Applying layer styles for creative effects Utilizing blend modes for stunning compositions Module 3: Selection Techniques (1 hour) Understanding different selection tools and their uses Precise selections using the Marquee, Lasso, and Magic Wand tools Advanced selections with Quick Selection and Refine Edge Creating masks for non-destructive editing Module 4: Image Editing and Retouching (1 hour) Essential photo retouching techniques for portraits and landscapes Correcting exposure, color, and tone with Adjustment Layers Using the Healing Brush and Clone Stamp for seamless repairs Removing distractions and blemishes with Content-Aware tools Module 5: Typography and Text Effects (1 hour) Working with text layers and formatting options Creating eye-catching text effects using Layer Styles Manipulating text along paths and shapes Designing typographic compositions Module 6: Advanced Image Manipulation (1 hour) Combining images with layer masks and blending modes Creating composite images and surreal artwork Applying transformations and distortions for creative effects Working with Smart Objects for non-destructive editing Module 7: Filters and Special Effects (1 hour) Exploring various filters for artistic and practical purposes Applying blur, sharpening, and distortion filters Creating artistic effects with the Filter Gallery Using smart filters for flexible editing Module 8: Drawing and Vector Graphics (1 hour) Working with shape layers and vector tools Creating custom shapes and icons Utilizing the Pen tool for precise illustrations Designing logos and scalable graphics Module 9: Advanced Color Correction (1 hour) Mastering color adjustments with Curves and Levels Using Adjustment Layers for selective color control Understanding color spaces and profiles Creating duotones and split-tones Module 10: Designing for Web and Print (1 hour) Preparing images for web and social media platforms Understanding resolution and color modes for print Exporting files in various formats for different purposes Final project: Designing a digital artwork or print-ready composition Learning Outcome refers to what students are expected to know, understand, or be able to do at the end of a learning experience, such as a course, training program, or educational module. Learning outcomes are usually specific, measurable, and achievable objectives that demonstrate the effectiveness of the learning process. For example, learning outcomes for a Photoshop course could include: Participants will be proficient in using essential Photoshop tools and features. Participants will demonstrate the ability to apply advanced image editing and retouching techniques. Participants will be able to create visually appealing designs using layers, typography, and special effects. Participants will understand and utilize different file formats and color modes for various output requirements. Participants will produce a final project showcasing their skills and creativity in Adobe Photoshop.

Overview This Compliance and Risk Management Course is designed for anyone looking for a pathway into this profession and wanting to develop their industry knowledge and skills. It covers the role of the Compliance Officer and compliance department in detail, with step-by-step training in compliance auditing and risk management. This Compliance and Risk Management Training Course will equip you with the fundamental skills needed to identify and manage regulatory risk in your organization, taking you through key topics such as how to implement an efficient Compliance Management System, ethics and compliance, risk types and classifications, and how to design a solid risk management strategy. By the end of this Compliance and Risk Management Training Course, you'll have an excellent understanding of core compliance issues, as well as how to promote a positive compliance culture for your organization, which will give you a head start when it comes to standing out in the relevant job market. 

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

Why Choose Vray for Maya Essentials Course?  Learn V-Ray's power for stunning 3D visualizations. In design and architecture, it's essential for effective idea communication, offering an intuitive interface and efficient rendering, ensuring faster images and animations. Click here for more info: Website Duration: 10 hours Training Approach: 1-To-1 Sessions. Schedule: Customize your schedule by pre-booking a convenient hour of your choice, available Mon to Sat between 9 am and 7 pm. Module 1: Introduction to Vray for Maya (2 hours) Understand the significance of Vray and its integration with Maya. Installation and setup of Vray for Maya. Familiarize with the Vray interface, workflow, and materials overview. Module 2: Lighting with Vray (2 hours) Explore various lighting techniques in Vray. Understand different Vray lights and their settings. Master the creation and control of Vray sun, sky, dome lighting, and IES lights. Learn efficient lighting workflows with Vray. Module 3: Vray Camera (2 hours) Grasp Vray camera settings and exposure control. Work with Vray depth of field and create camera animations. Understand Vray frame buffer functionalities. Module 4: Vray Materials (2 hours) Explore Vray materials, realistic material creation, and custom material libraries. Utilize Vray material overrides for enhanced customization. Module 5: Vray Rendering and Post Production (2 hours) Dive into Vray rendering settings and techniques for both images and animations. Enhance post-production skills using Photoshop and Vray frame buffer. Learn the art of compositing Vray render elements and utilizing Vray denoiser. Additional Topics Covered: Global Illumination in VRay: Exploring techniques such as Irradiance Map, Light Cache, Quasi-Monte Carlo/Brute Force, and Environmental Lighting. Image Sampling: Understanding Fixed, Adaptive QMC, and Adaptive Subdivisions for optimal rendering quality. VRay Lights: Mastering Plane Light, Dome Light, Sphere Light, VRay Sun, VRay Shadow, Image-Based Lighting HDRI, and Object-Based Lighting. VRay Camera: Manipulating Focal Length, Film Speed, and Shutter Speed for precise camera control. VRay Materials: Customizing Diffuse Color, Reflection, Refraction, and Blurry Reflections for lifelike material creation. Rendering Test Scenes: Practical application by rendering interior and exterior scenes for a hands-on learning experience. V-Ray-Maya Trial  https://www.chaos.com Master Vray for Maya to create high-quality renders. Apply various lighting techniques for realistic and visually appealing scenes. Control Vray camera settings and create dynamic shots. Create and customize realistic Vray materials for 3D scenes. Optimize rendering settings for high-quality output. Enhance renders with post-production techniques in Photoshop. Establish an efficient workflow with Vray in Maya. Gain hands-on experience and access valuable resources for further practice. Vray Proficiency: Master Vray tools, interface, and workflows in Maya for advanced 3D visualization. Advanced Lighting Skills: Expertise in diverse lighting techniques, including Vray sun, sky, and IES lights. Camera Control: Proficient manipulation of Vray camera settings, exposure, and animations. Material Customization: Create and customize realistic materials, utilizing custom libraries and overrides. Rendering Excellence: Skills in rendering images and animations, post-production, and compositing techniques. Global Illumination Mastery: Understand advanced global illumination methods for realistic scene lighting. Potential Jobs: 3D Lighting Artist: Specialize in illuminating scenes for films, games, or animations. 3D Visualization Specialist: Create realistic architectural or product visualizations. 3D Rendering Specialist: Focus on rendering high-quality images and animations. 3D Animator: Animate scenes within the context of realistic lighting. 3D Modeler: Develop detailed 3D models, ensuring realistic rendering. Visualization Consultant: Provide expert advice on visualization techniques. Freelance Vray Artist: Work independently on diverse projects, rendering scenes with exceptional realism. Expert Guidance: Receive guidance from certified tutors and industry professionals, benefitting from their deep expertise and practical insights. They will share valuable tips and techniques to enhance your rendering skills. Flexible Learning: Choose between in-person or live online sessions, tailored to your preference and location. Schedule training at your convenience, available Monday to Sunday, 9 am to 8 pm. Lifetime Assistance: Access lifetime email support, ensuring continuous guidance even after course completion. Our dedicated team is committed to addressing your queries and helping you overcome challenges. Unlock Your Potential: Enroll in our V-Ray for Maya Training Course to harness the power of this industry-leading rendering engine. Elevate your visual effects and animation skills, unleashing your creativity with stunning and lifelike renders.

About this Training Course On a day-to-day basis, one of the most common technologies utilised in well intervention is Coiled Tubing. This is prevalent in the oil industry and the technology is used during drilling, completion and production phases of Oil & Gas wells worldwide. This 5 full-day course will look at the following areas: Equipment for surface and pressure control Assembly components for bottom-hole Details of the different types of interventions performed with Coiled Tubing, and How to deal with fatigue and corrosion. The aim of this course is to enable the participants to gain key knowledge that they will require to actively and efficiently participate in the planning, design, and / or execution of a Coiled Tubing intervention. With this, the participants will learn how to calculate the string operating limits and the volumes and rates during nitrogen interventions. The course will walk the participants through the emergency responses and contingencies to deal with in various scenarios. Time will be allocated for the participants to work on the practical exercises as well as real field cases and problems. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, the participants will be able to: Plan, design, manage and execute interventions for Coiled Tubing Enhance operational performance during interventions for Coiled Tubing Explain the recommended equipment for various Coiled Tubing field conditions and applications Discuss the proper pressure control equipment for any particular well condition Learn about the most commonly used downhole tools and explain their function Understand how to calculate and define string limits for Coiled Tubing Learn how to work safely with liquid nitrogen Target Audience This course is aimed at Drilling and completion engineers Production engineers Surface/subsurface engineers Operations engineers Service company managers Field engineers This course will also benefit professionals who would like to increase their knowledge in the planning, design and/or execution of Coiled Tubing and Liquid Nitrogen interventions. Course Level Basic or Foundation Training Methods Other than the daily quizzes to reinforce the materials presented in the session, the participants will work through exercises such as: Selecting suitable BHAs for various operations Rigging up equipment in the correct order and preparing an outline testing programme Carrying out suitable calculations to perform an N2 lift Preparing an outline programme for a balanced cement plug Identifying issues in various videos & photos and suggesting mitigations Basic N2 safety quiz Final exercise will be preparing an outline programme for a Proppant Clean out, including a detailed Risk Register and Mitigation options Trainer Your expert course instructor has over 40 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in well intervention and completions. After a number of years working for intervention service companies (completions, slickline & workovers), he joined Shell as a well service supervisor. He was responsible for the day-to-day supervision of all well intervention work on Shell's Persian/Arabian Gulf platforms. This included completion running, coil tubing, e-line, slickline, hydraulic workovers, well testing and stimulation operations. An office-based role as a senior well engineer followed. He was responsible for planning, programming and organising of all the well engineering and intervention work on a number of fields in the Middle East. He had a brief spell as a Site Representative for Santos in Australia before joining Petro-Canada as Completions Superintendent in Syria, then moved to Australia as Completions Operations Superintendent for Santos, before returning to Shell as Field Supervisor Completions and Well Interventions in Iraq where he carried out the first ever formal abandonment of a well in the Majnoon Field. While working on rotation, he regularly taught Completion Practices, Well Intervention, Well Integrity and Reporting & Planning courses all over the world. In 2014, he started to focus 100% on training and became the Technical Director for PetroEDGE. Since commencing delivering training courses in 2008, he has taught over 300 courses in 31 cities in 16 countries to in excess of 3,500 participants. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Overview In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models. Objectives Harness Excel's tools within a best practice framework Add flexibility to their models through the use of switches and flexible lookups Work efficiently with large data volumes Model debt effectively Approach modelling for tax, debt, pensions and disposals with confidence Build flexible charts and sensitivity analysis to aid the presentation of results Learn and apply Excel tools useful in financial forecasting Understand and design the layout of a flexible model Forecast financial statements of a public or private company Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation