18351 Courses in Manchester 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

Each team has a unique 'team personality' made up from the individuals that form it. It is this aspect that determines how effectively the team works together, the quality of their performance and what they are capable of achieving. This course looks at how teams work together to achieve common results, referred to as team objectives. Effective teams have a common 'team spirit' which directly impacts on their results.

Much of what you achieve will depend on your ability to persuade other people. In many respects, persuasion is the highest form of communication. This course looks at the ability of persuasion and negotiation in producing successful outcomes and the skill required in moving towards a convergence of opinion and understanding. Like much of leadership, negotiation depends on your attitudes in approach, as well as your ability to devote time to planning.

Your ability to think is probably your greatest asset at work. Everything you say and do will be touched in some way by what is going on in your mind. Most certainly, performance and achievements are a direct function of your thinking abilities. This course looks at the skills of mental agility, conceptual and analytical thinking. Together, these skills allow you to conceive and form ideas in a practical sense and draw the right conclusions.

The role of an MLRO is one of high responsibility, with financial and personal consequences if something goes wrong. As an MLRO or Deputy MLRO, you need the confidence and practical skills to tackle the unique challenges these roles present.  Part of the ICA Practitioner Series, this unique certification is written by MLROs for MLROs and provides a practical framework and toolkit that gives you the knowledge and skills to: navigate the complex role of a Money Laundering Reporting Officer mitigate risks make changes and set goals challenge stakeholders make informed decisions and demonstrate the rationale manage relationships with boards and regulators effectively. This qualification covers the following topics: Interview questions and wider due diligence before taking up an MLRO / Deputy MLRO position Governance - senior management responsibilities - prescribed responsibilities Management information & report writing Risk assessment and risk appetite Policies, procedures & operational implementation Staff, training, leading and influencing/psychological models to develop interpersonal skills Quality of oversight - obtaining trusted data First 100 days - main risks and expectations Form A - FCA Registration, fit & proper interview Building Trust - stakeholder management, committees, management information, regulatory interaction, the MLRO Report Problem shooting and escalation pathways

LOOKING FOR: PICTURE BOOKS Perry Emerson is a Commissioning Editor at Little Tiger Press, where he works with authors and illustrators mostly on picture books and sometimes on novelty books. He is also a picture book author in his own right. Little Tiger Press publish a huge range of formats and genres, striving to create a diverse range of high-quality books, with something that will appeal to every reading taste, helping children develop a passion for books and a life-long love of reading. Authors who form part of the Little Tiger Picture Book Family include Bethan Clarke, Tracey Corderoy, Rachael Davis, Karl Newson, Jodie Parachini, Nima Patel, Steve Smallman, Stephanie Stansbie, Louie Stowell, Clare Helen Welsh, Becky Wilson and many more. When he’s not making books, he spends his time playing music and discovering new restaurants. Perry lives in London with his partner and their much-too-fluffy cat. For picture books, Perry would like you to submit a covering letter, and 1 complete manuscript, double-spaced, with spreads marked out, in a single word or PDF doc. By booking this session you agree to email your material to reach I Am In Print by the stated submission deadline to agent121@iaminprint.co.uk. Please note that I Am In Print take no responsibility for the advice given in your Agent121. The submission deadline is: Wednesday 20th August 2025

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions

Embark on a swift and immersive journey into the world of Microsoft Forms with our course, 'Learn the Basics of Microsoft Forms in Only 30 minutes!' In just half an hour, we'll unravel the intricacies of Microsoft Forms, providing you with a comprehensive understanding of its features and functionalities. This isn't your typical tutorial; it's a dynamic adventure designed to make you a Forms maestro in record time. From understanding the Forms Home Page to mastering advanced features like Branching and Themes, we've distilled the essentials into bite-sized modules, ensuring an engaging and efficient learning experience. Discover the art of creating and customizing forms effortlessly, preview and test your creations, and delve into the nuances of quiz creation and management. Perfect for beginners and enthusiasts alike, this course empowers you to harness the full potential of Microsoft Forms in just 30 minutes. Say goodbye to lengthy tutorials, and embrace a concise, impactful learning journey that transforms your proficiency with Microsoft Forms. Learning Outcomes Forms Mastery: Grasp the fundamentals of Microsoft Forms, from its basic components to advanced features like Branching and Themes. Efficient Form Creation: Learn to create new forms seamlessly, exploring the intricacies of form settings and customization. Quiz Creation Expertise: Delve into the world of quiz creation, mastering settings and learning to preview, test, and manage quizzes effectively. Data Analysis Proficiency: Explore how to view results and export data to Excel, enhancing your ability to derive meaningful insights from form responses. Optimized Form Distribution: Understand the process of sending form and quiz links, ensuring efficient and targeted distribution for your intended audience. Why choose this Learn the Basics of Microsoft Forms in Only 30 minutes! course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Learn the Basics of Microsoft Forms in Only 30 minutes! course for? Individuals eager to quickly grasp the basics of Microsoft Forms. Students seeking efficient learning resources for form creation and quiz management. Professionals looking to streamline data collection and analysis through Microsoft Forms. Educators aiming to enhance their quiz creation and distribution skills. Enthusiasts interested in a time-efficient exploration of Microsoft Forms. Career path Data Analyst Assistant: £22,000 - £30,000 Educational Technologist: £25,000 - £35,000 Administrative Coordinator: £20,000 - £28,000 Marketing Assistant: £22,000 - £30,000 Customer Support Specialist: £20,000 - £28,000 Research Assistant: £22,000 - £30,000 Prerequisites This Learn the Basics of Microsoft Forms in Only 30 minutes! does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Learn the Basics of Microsoft Forms in Only 30 minutes! was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Learn The Basics Of Microsoft Forms In Only 30 Minutes! Module 01: What are Microsoft Forms? 00:01:00 Module 02: Where to get Microsoft Forms 00:01:00 Module 03: Forms Home Page 00:02:00 Module 04: New Form 00:10:00 Module 05: Branching 00:02:00 Module 06: Themes 00:01:00 Module 07: Form Settings 00:01:00 Module 08: Previewing and Testing the Form 00:03:00 Module 09: View Results and Export to Excel 00:03:00 Module 10: Sending the Form Link 00:01:00 Module 11: New Quiz 00:06:00 Module 12: Quiz Settings 00:01:00 Module 13: Previewing and Testing the Quiz 00:02:00 Module 14: View Results and Export to Excel 00:01:00 Module 15: Sending the Quiz Link 00:01:00

Historical Association webinar series: Making GCSE history accessible: supporting all learners at Key Stage 4 Presenters: Gemma Hargraves  This session explores some of the hidden barriers faced by neurodivergent pupils in the history classroom, including anxiety and low self-confidence. It offers practical strategies to create an inclusive and supportive environment that enables all learners to engage meaningfully with historical learning. Key topics: • Recognising common anxiety triggers in history education • Building learner confidence through inclusive pedagogical approaches • Understanding and responding to the needs of neurodivergent pupils in GCSE history To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/bdNUSwLNrL Image: A Squire "Old English" padlock on a gate latch in Devon (Image: Partonez/Wikimedia Commons)

Historical Association webinar series: Practical approaches to disciplinary concepts in primary history Presenter: Emmy Quinn This session will give teachers tips on how to explore similarity and difference in a meaningful way in the primary classroom. It will look at introducing the concept in Key Stage 1 to more developed use of it in Key Stage 2, for example similarity and difference in the earliest civilisations. The session will show how to demonstrate that similarity and difference can be nuanced and will support with getting children to move beyond basic ideas To use your corporate webinar offer for this webinar please complete this form: https://forms.office.com/e/95945xGxdh