507 Writing courses in Waltham Cross delivered Live Online

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner I™ training (PSPO) to master the fundamentals of Product Ownership. Learn how to take your understanding of Scrum frameworks and apply it to maximise product value. Course Description The Professional Scrum Product Owner (PSPO) course goes beyond requirement writing and Product Backlog management. It equips Product Owners with a comprehensive understanding of product management needed to drive value from their products. The PSPO course is Scrum.org certified and delivered by our professional Scrum trainers. We combine real world industry experience with a hands-on practical approach, the result of which is a 98% first-time pass rate. Say goodbye to PowerPoint and join our interactive PSPO training course to gain key practical skillsets and learn how how to implement frameworks immediately to deliver tangibel results. Embrace a product-focused mindset over project-oriented thinking. Bridge business strategy to product execution with Scrum. Recognise the Product Owner's role as an Agile Product Manager. Master Scrum Principles and Empiricism. Understand Product Owner responsibilities within the Scrum Team. Align the team with business strategy, product vision, Product Goal, and Sprint Goal. Communicate business strategy, product vision, and Product Goal effectively. Learn techniques for Product Backlog Management, Release Management, and Forecasting. Identify valuable metrics for tracking value creation and successful product delivery. Employ techniques to engage stakeholders, customers, and Scrum Team members effectively. Why Train With Us? Develop and solidify your knowledge of the Scrum Framework and the accountabilities of being a product owner with our immersive two-day online PSPO course through instruction and team-based exercises. Led by experienced industry professionals and supportive Professional Scrum Trainers & Product Owners, we go beyond powerpoint to offer engaging, hands-on learning experiences. From debunking myths to empowering your Scrum Teams with the right practices, we'll be with you every step of the way - from learning to passing the test and implementing it seamlessly into your job context. Who Should Attend This Course? Ideal for students across industries dealing with complex problem-solving, the Professional Scrum Product Owner course targets three key groups: Aspiring Product Owners seeking to start their career in the field. Experienced Product Owners aiming to enhance their understanding and address misconceptions about Scrum and the Product Owner role. Scrum Masters desiring to become effective coaches for Product Owners, gaining valuable insights from the course. Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

About this Training Course This is an advanced chemistry training course for power plant chemists and boiler engineers wishing to expand their knowledge and skills, and to become more effective in their day-to-day roles dealing with thermal power plant chemistry. This 5 full-day course will provide ample opportunity for robust technical discussion and expand on advanced concepts in thermal power plant cycle chemistry. It focuses only on the steam/water aspects of the thermal power cycle. This course is a MUST for all power plant chemists and boiler engineers. It is also beneficial for anyone involved in power plant operation and maintenance because it provides guidelines and rules for improving power plant performance and reliability. Training Objectives Gain a significant increase in understanding of cycle chemistry in steam power plants and the inter-relationships between plant operation, cycle chemistry and potential failure modes due to corrosion and/or deposition throughout the cycle Gain a thorough understanding of all causes of corrosion in a steam power plant and all the methods used to reduce the corrosion rate in a steam power plant Become better equipped to effectively manage the corrosion and deposition risks in a thermal power plant Learn how to reduce failure rate in boilers and steam power plants and improve plant performance Understand condensate polishing and treatment of condensate return to industrial boilers Discover the causes of boiler water contamination and treatment programs Learn about layup and offline corrosion protection Understand water chemistry limits to prevent steam contamination by carryover Learn about boiler water chemistry guidelines and control of steam chemistry Understand high-purity make-up treatment methods Perform demineralizer calculations Perform system design calculations Gain a thorough understanding of mixed bed polishing and reverse osmosis Target Audience Power Plant Chemists Boiler Engineers Engineers involved in the operation and maintenance of power plants Managers Technicians Maintenance personnel Other technical individuals (this seminar is suitable for individuals who do not have a background in chemical engineering) Course Level Advanced Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2012 in New York (800 pages) Water Chemistry for Thermal Power Plant Chemists and Boiler Engineers Manual (650 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

About this training course This 5 full-day course provide a comprehensive understanding of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, HART protocol, control valves, actuators, and smart technology. This course will focus on maximizing the efficiency, reliability, and longevity of these systems and equipment by providing an understanding of the characteristics, selection criteria, common problems and repair techniques, preventive and predictive maintenance. This course is a MUST for anyone who is involved in the selection, applications, or maintenance of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology because it covers how these systems and equipment operate, the latest maintenance techniques, and provides guidelines and rules that ensure their successful operation. In addition, this course will cover in detail the basic design, operating characteristics, specification, selection criteria, advanced fault detection techniques, critical components and all preventive and predictive maintenance methods in order to increase the reliability of these systems andequipment and reduce their operation and maintenance cost This course will provide the following information for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology: Basic Design Specification Selection Criteria Sizing Calculations Enclosures and Sealing Arrangements Codes and Standards Common Operational Problems All Diagnostics, Troubleshooting, Testing, and Maintenance Practical applications of smart instrumentation, SCADA, and Distributed Control Systems, control valves, actuators, etc in the following industries will be discussed in detail: Chemical and petrochemical Power generation Pulp and paper Aerospace Water and sewage treatment Electrical power grids Environmental monitoring and control systems Pharmaceutical plants Training Objectives Equipment Operation: Gain a thorough understanding of the operating characteristics of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Diagnostics and Inspection: Learn in detail all the diagnostic techniques and inspections required of critical components of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Testing: Understand thoroughly all the tests required for the various types of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Maintenance and Troubleshooting: Determine all the maintenance and troubleshooting activities required to minimize the downtime and operating cost of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Repair and Refurbishment: Gain a detailed understanding of the various methods used to repair and refurbish modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Efficiency, Reliability, and Longevity: Learn the various methods used to maximize the efficiency, reliability, and longevity of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Sizing: Gain a detailed understanding of all the calculations and sizing techniques used for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Design Features: Understand all the design features that improve the efficiency and reliability of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Selection: Learn how to select modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology by using the performance characteristics and selection criteria that you will learn in this course Equipment Enclosures and Sealing Methods Learn about the various types of enclosures and sealing arrangements used for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Commissioning: Understand all the commissioning requirements for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Codes and Standards: Learn all the codes and standards applicable for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Causes and Modes of Failure: Understand the causes and modes of failure of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology System Design: Learn all the requirements for designing different types of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: Industrial Instrumentation and Modern Control Systems Practical Manual (400 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

This workshop will provide all the techniques and support to write confidently with a broad calligraphy pen.

Autocad and Sketchup face to face training customised and bespoke.

LOOKING FOR: ADULT FICTION Nicky Lovick has worked as an editor for over twenty years, working for top five publishers. She is now an agent at WGM Talent, building the books list. She is looking for commercial fiction, from upmarket women’s fiction, bookclub, romance, domestic noir and psychological thrillers, to crime series. She loves hooky stories such as Freida McFadden’s The Housemaid and Turn of the Key by Ruth Ware set in confined settings, such as hotels. She’s always on the lookout for romcoms with a fresh, contemporary feel to them such as Emily Henry’s Book Lovers. Also historical fiction with a twist and sweeping family sagas. Nicky wants you to make her laugh, make her cry or keep her hooked.  Nicky would like you to submit a covering letter, 1-2 page synopsis and the opening three chapters of your manuscript in a single word document.  (In addition to the paid sessions, Nicky is kindly offering one free session for low income/underrepresented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 21st April 2025

Learn the Reading and Writing Skills you need to rise from the Advanced Level to REAL Proficiency and for studying an English-language college or university.

LOOKING FOR: MG, YA, ADULT FICTION, ADULT NON-FICTION, NON-FICTION FOR 7+ Megan Carroll is looking for writers in a variety of areas, and from a wide range of backgrounds – she is particularly keen to hear from Black, Asian, and LGBTQIA+ writers. Her main areas of focus this year are adult fiction and non-fiction, as well as non-fiction for 7+, and MG and YA fiction. In Fiction, Megan is keen to see high-concept love stories (think The Flat Share or The Lock In) for both commercial and reading group readers. She’d love to see those familiar romance tropes – enemies to lovers, friends to lovers, love triangles, forbidden love etc. – with underrepresented characters at the centre. She is also looking for historical fiction and gothic horror (think Laura Purcell, Stacey Halls and Silvia Moreno-Garcia) – anything that has a creepy, uneasy undertone is likely for Megan’s list. Megan is also actively looking for upmarket fiction and would love to see layered family drama, contemporary stories about life today and darkly comic novels that explore a specific time, place or experience. In Non-Fiction, Megan is keen to hear from experts in their field talking about topics relating to film, music, true crime, popular culture, history and issues from largely unrepresented perspectives. She is keen to see memoir, narrative non-fiction and essay collections. In Children’s and YA, she is keen to see contemporary YA with humour, and romance at the heart – fun and emotional stories that appeal to the interests and issues of the teenage readers. She’d also love to see thrillers and horror stories for this age group too. It’s unlikely that high fantasy novels for YA readers will be right for her, but she is keen to see stories with fantasy elements in a real world setting. On the younger end, Megan is looking for funny, contemporary middle grade – think Louise Rennison and Karen McCombie – and anything creepy and spooky for 8-12 year old readers too. She’d love to find something like Lemony Snicket’s A Series of Unfortunate Events and is keen to find original adventure stories in both fantasy and realistic settings. Megan would like you to submit a covering letter, 1 page synopsis and the first three chapters or 5,000 words of your manuscript in a single word document. (In addition to the paid sessions, Megan is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Thursday 24th April 2025

LOOKING FOR: YA/NA FANTASY, SFF, HORROR, ADULT FICTION John Baker (he/him) joined the Bell Lomax Moreton agency in 2019, cultivating a list shaped around his passion for science fiction, fantasy, and horror, though has lately also branched out into action/adventure fiction. John focuses on authors writing in the Adult, New Adult, and YA spaces. John leads the wider agency's film & TV desk, is the Secretary of the Association of Author’s Agents, and the co-chair of the AAA’s Bridge Committee. He also serves on the Kingston University MA Publishing Advisory Board. Under the umbrella of speculative fiction, John is looking for fantasy, science fiction, horror, romantasy, or literary speculative fiction. He has built a reputation as a champion of underrepresented voices and stories, be it from creators hailing from the global majority and their diasporas or neurodiverse authors, and naturally gravitates towards this kind of storytelling. In short, if he’s never read a story like yours before, he wants to see it. Adult fantasy: John loves beefy epic fantasy, especially non-Anglo Christian-inspired. Give him an immersive world, a fresh magical or mythic system, and an exciting cast of characters and he’ll be happy. He is a broad church in the genre so loves a political fantasy, swords and sorcery, courtly intrigue, monster hunting and dastardly villains. John is keen to find an urban fantasy that feels fresh and fun and he’s a sucker for a heroic quest narrative. He’s also very open to fantasy that isn’t easily categorised, but it is playing in that world. John is keenly hunting for more historical fantasy, especially inspired by modern history. He’s had fun with mythological retellings in the past, but as ever, let’s make sure it’s shining the spotlight on new stories. He would also love fantasy that centres on types of relationships less celebrated in fantasy, such as established and secure married couples, or siblings. NA/YA fantasy: In this genre, most importantly, John wants to have a good time, whether it’s swoon-worthy kisses in lush ball gowns, or gruesome gore and monsters, so send him pacy, plot-filled adventures. He’d love more books that teenage boys would love: Skullduggery Pleasant forever! Romantasy: The thriving new romantasy genre comes with its own set of challenges, so John wants to know what makes your romantasy different; what will set it out from the (very crowded!) market. Give it completely barmy stakes, cool and unique new settings, or a love story that will make your jaw drop. To be clear, he’s happily sorted for a human person meets a fae creature in the spooky woods. Also, cosmic romance is the genre of the future. Give him romantasy in space. Easy. Horror: John and horror are old friends. He loves horror inspired by myth and folklore, subversive weird horror that leaves your eyebrows in your hairline, historical horror that pulls from ghastly true stories, and anything that you’ll be reading with the light on. He also loves a gothic element and is particularly looking for horror with a strong romantic throughline, fun YA horror, and female & NB horror authors. Science fiction: SF is coming back! And John has been shouting about that. He loves to see an adventurous found-family romp through space or an epic, crunchy space opera. Speculative near-future is fun too, in the vein of Black Mirror’s more uplifting episodes, (e.g. San Junipero). He loves YA science fiction as well; the more creative the better. Literary: John is open to finding more rich magical realism or something character-led yet supernatural and would love a high-concept mystery, in the vein of Stuart Turton. He also loves spec fic that uses the speculative lightly as a way of confronting a deeper truth in society today. Weird stuff: John wants books that will blow people’s minds and defy categorisation. This is hard to describe, but think Gideon The Ninth, The Library At Mount Char, This Is How You Lose The Time War. John loves a pitch that leaves the editors baffled but intrigued. Action/Adventure, Historical Adventure, Espionage: John is branching out into non-speculative adventures, such as John Le Carré, Lee Child, Ian Flemming, and Mick Herron. More as his taste develops, but the hunt is on! Not looking for: military sci-fi or hard SF, or anything with biblical “character wakes up in purgatory/heaven/hell” narratives. The right comedic fantasy has yet to hit his inbox, but please don’t comp Douglas Adams or Sir Terry. John would like you to submit a covering letter, 1-2 page synopsis and the first three chapters (or 5,000 words whichever is longest) of your manuscript in a single word document. (In addition to the paid sessions, John is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 12th May 2025

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included