1307 Editor courses delivered Online

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

LOOKING FOR: ADULT FICTION Kate Barker has worked in publishing for over twenty years as an agent, commissioning editor and ghostwriter. Before setting up her own company, Kate Barker Literary Agency, she spent ten years at Penguin, where she was an Editorial Director for Viking, acquiring fiction and non-fiction. She has also worked for Orion, Curtis Brown and for digital publisher Bookouture. She is looking for commercial and reading group fiction for adults and would love to find an unputdownable thriller like Rosamund Lupton's Three Hours, a funny, heartbreaking contemporary novel like Queenie by Candice Carty-Williams or a romantic comedy with a unique premise like The Flatshare by Beth O'Leary. She also loves historical fiction and series crime. Kate would like you to submit a covering letter, one page synopsis and the first three chapters (Max 5,000 words) of your completed manuscript in a single word document. (In addition to the paid sessions, Kate 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 17th March 2025

LOOKING FOR: ADULT FICTION Louise Buckley has worked in publishing for well over a decade. She was inspired to enter the publishing industry after completing an MA in Creative Writing and then spent a hugely enjoyable year working as a bookseller for Waterstones, wishing that she could have a hand in publishing books. After a year working at Dorling Kindersley, she then spent almost five years working in the commercial fiction division at Pan Macmillan, where she published a mix of commercial bestsellers and award-winning authors. Most recently, she was an Associate Literary Agent at Zeno Agency Ltd. As an agent she represented a roster of commercial and literary fiction, including Anne Griffin’s When All is Said, which spent five weeks at number one in Ireland and sold into 17 territories. She is delighted to be working with Hannah at Hannah Sheppard Literary Agency. Louise is looking for:- Literary and upmarket fiction that focusses on the underdog, the repressed, the suppressed. Louise is especially interested in novels that represent working-class people or children going through difficult circumstances (think Shuggie Bain by Douglas Stuart, My Name is Leon by Kit de Waal or Boys Don’t Cry by FÍona Scarlett). Irish literary and book club fiction. Think Claire Keegan, Louise Kennedy or Anne Griffin. In commercial fiction she loves novels set during the Second World War, such as The Nightingale by Kristin Hannah, The Beekeeper of Aleppo by Christi Lefteri or The Midwife of Auschwitz by Anna Stuart. Louise recently read and loved The Last List of Mabel Beaumont by Laura Pearson and would love to see anything in the same ‘older person going on a journey’ category, a more recent The Unlikely Pilgrimage of Harold Fry. Louise had a lot of fun publishing a ‘pet fiction’ novel as an editor (Molly and the Cat Café) and would love to find an author who can write an Alfie the Doorstep Cat/Dog. She has a soft spot for novels featuring time-travel or parallel universes, a ‘what if’ that plays around with conventions. At the literary end this would be books like Life After Life by Kate Atkinson, The Shining Girls by Lauren Beukes or This is How You Lose the Time War by Amal El-Mohtar and Max Gladstone. At the more commercial end Louise loved Wrong Place, Wrong Time by Gillian McAllister, Dark Matter by Blake Crouch and Oona Out of Order by Martina Montimore. She also enjoys novels set in the real world but featuring a hefty dose of magic or the supernatural. They can be commercial or literary, present-day or historical. Think Rivers of London by Ben Aaronovitch, Threadneedle by Cari Thomas, A Discovery of Witches by Deborah Harkness or The Gifts by Liz Hyder. And also cosy fantasy in the vein of Legends and Lattes or The House in the Cerulean Sea. Cosy or humorous crime. Recently, Louise absolutely loved Over My Dead Body by Maz Evans. When she was an editor Louise published the hit Luckiest Girl Alive by Jessica Knoll and would love to represent incisive, intelligent suspense written by authors such as Jessica Knoll and Gillian Flynn, or something a little more subversive and blackly comic like My Sister, the Serial Killer by Oyinkan Braithwaite. More generally, Louise would also love to see novels with a disabled protagonist or someone (like herself) who is living with an invisible disability. As an ex-primary school teacher, she also warmly welcomes submissions from teachers, especially if the submission falls into one of the other categories she has listed. Following-on from this, she enjoys reading stories that follow a ‘beating the system’ narrative. Louise is NOT looking for: -romance -romantasy -epic, traditional fantasy -space opera -straightforward women’s fiction -children’s fiction of any kind -non-fiction Louise 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, Louise 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: Tuesday 18th March 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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. 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. 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

Limited Offer Time | 12-in-1 Premium Bundle | CPD QS Certified | 120 CPD Points | Gifts: Hardcopy + PDF Certificates + Transcript + Student ID Card | Lifetime Access | Customer Support

In today's fast-paced world, where communication and information are king, the role of proofreading & copyediting has never been more crucial. As a proofreader or copy editor, you wield the power to ensure the accuracy, clarity, and professionalism of written content, from marketing materials to legal documents. If you're fascinated by the nuances of language and have a sharp eye for detail, then this Level 5 Diploma in Proofreading and Copy Editing is the perfect course for you. It will equip you with the essential skills and knowledge to become a highly sought-after professional in this growing field. In this comprehensive program, you'll delve into the intricacies of proofreading & copyediting, learning to identify and correct grammatical errors, inconsistencies, and typos. You'll also gain expertise in applying style guides, ensuring adherence to industry standards and maintaining consistency across a wide range of written materials. So, Enrol today and discover the power of proofreading & copyediting to make a real difference in the world of written communication. Level 5 Diploma in Proofreading & Copy Editing Course Learning Outcomes: Develop a comprehensive understanding of proofreading & copyediting principles and practices Master the art of identifying and correcting grammatical errors, inconsistencies, and typos Apply style guides effectively to ensure adherence to industry standards and maintaining consistency Enhance your proofreading & copyediting skills through real-world case studies and exercises Explore career paths and strategies for success in the proofreading & copyediting industry Level 5 Diploma in Proofreading & Copy Editing Module 01: Proofreading Basics Module 02: Applying the Style Guide Module 03: Spelling and Grammar Module 04: Proofreading on Paper Module 05: Proofreading On-Screen Module 06: Copy-Editing Basics Module 07: Copy-Editing - The Use of Language Module 08: Copy-Editing - Checking Accuracy and Facts Module 09: Copy-Editing - The Beginning and The End Module 10: Copy-Editing - Legal Checks Module 11: Finding Work and Developing Your Career Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for Free to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Who is this course for? Level 5 Diploma in Proofreading & Copy Editing Proofreader Copy Editor Editorial Assistant Content Editor Technical Writer Marketing Copywriter Requirements Level 5 Diploma in Proofreading & Copy Editing To enrol in this Level 5 Diploma in Proofreading & Copy Editing, Purchasing & Procurement course, all you need is a basic understanding of the English Language and an internet connection. Career path Level 5 Diploma in Proofreading & Copy Editing Proofreader: £22,000 to £35,000 per year Copy Editor: £25,000 to £40,000 per year Content Editor: £28,000 to £45,000 per year Editorial Assistant: £20,000 to £30,000 per year Content Manager: £30,000 to £50,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

This video course is a perfect resource to start learning how to make websites without coding. This course will make you familiar with all the latest features of Wix and in no time you'll have all the skills needed to create and publish a robust and powerful website using Wix.

Spring Sale: 6 in 1 Exclusive Bundle! CPD Certified | Free PDF Certificate & ID Card | 60 CPD Points | Lifetime Access

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 24th March 2025

🌟 Unlock the Secrets to Building Dynamic Websites with Wix! 🌟   Are you ready to create stunning, high-performing websites that captivate audiences and elevate your online presence? Introducing our comprehensive online course: 'Creating Dynamic Websites with Wix.' 🚀 Transform Your Vision into Reality: Whether you're a beginner or an experienced developer, this course is your gateway to mastering Wix's powerful tools and unleashing your creativity. Discover how to design and customize websites that stand out in today's competitive digital landscape.   🌐 What You'll Learn: Mastering Wix's intuitive drag-and-drop editor Design principles for captivating layouts and user experiences Incorporating multimedia elements like videos, images, and animations seamlessly Implementing advanced functionalities with Wix Code Search Engine Optimization (SEO) strategies to boost visibility Mobile optimization for a flawless user experience across devices E-commerce setup and optimization for online businesses Tips and tricks to streamline your workflow and save time   🎓 Why Choose Our Course? Expert guidance from industry professionals with real-world experience Practical, hands-on tutorials and exercises for accelerated learning Access to exclusive resources, templates, and tools to fuel your creativity Ongoing support from a vibrant community of like-minded learners Lifetime access to course materials for continuous learning and updates   💡 Who Is This Course For? Entrepreneurs and business owners seeking a professional online presence Creatives wanting to showcase their portfolios or artistic work Marketing professionals aiming to enhance their digital marketing skills Anyone interested in building websites without coding knowledge   🌟 Join Thousands of Successful Website Creators! Empower yourself with the skills to craft dynamic, visually stunning websites that leave a lasting impression. Enroll now in 'Creating Dynamic Websites with Wix' and take the first step toward becoming a web design virtuoso! 🔥 Limited Time Offer: Enroll Today and Get Started on Your Journey to Website Mastery! 🔥 [Enroll Now Button] Invest in your future. Create your masterpiece with Wix today! ✨ Course Curriculum Basic Overview 00:00 Plans and Pricing 00:00 Wix Partner and Affiliate Programs 00:00 Sign Up and Basic Design 00:00 Adding a Section 00:00 Adding a Page 00:00 General Settings 00:00 Adding a Contributor 00:00 Advanced Settings - Part 1 00:00 Advanced Settings - Store Settings - Automated Order E-Mails 00:00 Advanced Settings - Paid Videos 00:00 Advanced Settings - Wix E-Mail Inbox 00:00 Advanced Settings - Quotes and Invoices 00:00 Video Settings Upload 00:00 Video Settings - Part 2 00:00 Live Streaming Video - Part 1 00:00 Live Streaming Video - Part 2 00:00 Live Streaming Codecs and Video Channels 00:00 Blog Post Creation 00:00 Conclusion 00:00 Advanced Overview 00:00 Adding the Chat App 00:00 Adding the Blog App 00:00 Adding the Instagram Feed 00:00 Addding the Video App 00:00 Adding the Events App 00:00 Adding the Members Area 00:00 Adding a Bookings App 00:00 Adding a Music App 00:00 Adding a Music App 00:00 Switching To the Wix Editor 00:00 The Wix Editor - Part 2 00:00 The Wix Editor - Part 3 - Backgrounds 00:00 The Wix Editor - Part 4 - Add Button 00:00 The Wix Editor - Part 5 - Media 00:00 The Wix Editor - Part 6 - Blog Management 00:00 The Wix Editor Tools 00:00 Wix App Market - Part 1 00:00 Wix App Market - Part 2 00:00 Conclusion 00:00