1061 Courses

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

Supervising Food Safety in Catering Are you seeking comprehensive training in food safety to ensure compliance with UK regulations and safeguard public health? Look no further. Our Supervising Food Safety in Catering course is packed with knowledge to increase your expertise in the food safety sector. Our Supervising Food Safety in Catering course provides a comprehensive overview of UK food safety laws, including supervising and managing food safety systems. From understanding microbiology and contamination hazards to implementing effective control measures, we equip you with the knowledge and tools to mitigate risks and prevent foodborne illnesses. This Supervising Food Safety in Catering course will help you recognise the signs and symptoms of bacterial and nonbacterial food poisoning and implement strategies to avoid foodborne illnesses. You will also learn to implement food safety management systems and tools to monitor and maintain compliance with regulatory standards. Moreover, this course will teach you the principles of temperature control to ensure food products' safe storage, handling, and serving. As you progress through the Supervising Food Safety in Catering course, you will gain the skills to evaluate the design and construction of food premises and equipment to optimise hygiene and sanitation practices. Furthermore, you will gain in-depth ideas about waste disposal, cleaning, and disinfection strategies that minimise environmental impact and uphold food safety standards. At the end of the course, you will gain expertise in pest management and food safety training for the staff. Enrol in the Supervising Food Safety in Catering course to improve your professional skills. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Food Safety - An Introduction Food Safety - Introduction 00:28:00 Module 02: Supervision of Food Safety Supervision of Food Safety 00:36:00 Module 03: Food Safety Legislation Food Safety Legislation 00:33:00 Module 04: Food Safety Management System Food Safety Management Systems 00:43:00 Module 05: Food Safety Management Tools Food Safety Management Tools 00:29:00 Module 06: Microbiology Microbiology 00:27:00 Module 07: Contamination Hazards Contamination Hazards 00:28:00 Module 08: Controlling Contamination Controlling Contamination 00:38:00 Module 09: Food Poisoning (Bacterial) and Food-Borne Illness Bacterial Food Poisoning and Food-Borne Illness 00:31:00 Module 10: Food Poisoning (Non-Bacterial) Non-bacterial Food Poisoning 00:31:00 Module 11: Personal Hygiene Personal Hygiene 00:29:00 Module 12: Food and Temperature Control Food and Temperature Control 00:33:00 Module 13: Checking, Verifying and Recording Temperature Checking, Verifying and Recording Temperature 00:24:00 Module 14: Food Spoilage and Preservation Food Spoilage and Preservation 00:37:00 Module 15: Food Premises and Equipment: The Design and Construction Food Premises and Equipment: The Design and Construction 00:32:00 Module 16: Waste Disposal, Cleaning and Disinfection Waste Disposal, Cleaning and Disinfection 00:34:00 Module 17: Pest Management Pest Management 00:29:00 Module 18: Food Safety Training for the Staff Food Safety Training for the Staff 00:17:00 Module 19: Reopening and Adapting Your Food Business During COVID-19 Reopening and Adapting Your Food Business During COVID-19 00:16:00

Overview This comprehensive course on Video Editing- DaVinci Resolve will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Video Editing- DaVinci Resolve comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Video Editing- DaVinci Resolve. It is available to all students, of all academic backgrounds. Requirements Our Video Editing- DaVinci Resolve is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 44 lectures • 02:52:00 total length •Module 01: Introduction: 00:02:00 •Module 02: Downloading DaVinci Resolve: 00:02:00 •Module 01: Importing media in the Media Page: 00:05:00 •Module 02: Working in the Cut Page: 00:10:00 •Module 03: Overview of the Edit Page: 00:15:00 •Module 04: The Colour Page Part 1: 00:08:00 •Module 05: The Colour Page Part 2: 00:06:00 •Module 06: The Fairlight Page: 00:05:00 •Module 07: The Fusion Page: 00:05:00 •Module 08: The Deliver Page: 00:07:00 •Module 09: The Menu: 00:03:00 •Module 01: Reconnecting Media: 00:01:00 •Module 02: Adding Titles: 00:03:00 •Module 03: Adjustment Layers: 00:03:00 •Module 04: Fade ins and Overlays: 00:03:00 •Module 05: Stabilising Footage: 00:02:00 •Module 06: Adding Blurs: 00:02:00 •Module 07: Right Click: 00:05:00 •Module 08: Crop: 00:02:00 •Module 09: Audio - Mono to Stereo: 00:01:00 •Module 10: Review Video: 00:01:00 •Module 11: Speed Adjustment: 00:03:00 •Module 12: Creative Effects part 1: 00:05:00 •Module 13: Creative Effects part 2: 00:02:00 •Module 14: Creative Effects part 3: 00:01:00 •Module 15: Subtitling: 00:03:00 •Module 16: Exporting an Alpha Channel: 00:03:00 •Module 17: Highlighting an area: 00:03:00 •Module 18: Recording Audio in Fairlight: 00:02:00 •Module 19: Countdown timer: 00:04:00 •Module 20: Green Screen Chroma Key: 00:06:00 •Module 21: Green Screen Delta Key: 00:02:00 •Module 22: Masking in the Colour Page: 00:03:00 •Module 23: Make you footage look like VHS: 00:04:00 •Module 24: Mask Tracking: 00:03:00 •Module 25: Moving Masks: 00:04:00 •Module 26: Recording a podcast: 00:09:00 •Module 27: Importing an XML file: 00:02:00 •Module 28: Multicam Edit: 00:04:00 •Module 29: Auto Scene Cut Detect: 00:02:00 •Module 01: Editing a Dance Film part 1: 00:02:00 •Module 02: Editing a Dance Film part 2: 00:13:00 •Module 01: Final Thoughts: 00:01:00 •Assignment - Video Editing- DaVinci Resolve: 00:00:00

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over £570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases. Many of the breaches resulting in enforcement action involved failures by the fee earners to conduct appropriate due diligence, adequately check the source of funds and/or wealth or recognise and report red flags. As highlighted by enforcement action being taken against individuals as well as firms, fee earners cannot hide behind their firm when AML failures occur and may be held personally accountable by the SRA for non-compliances with the MLR 2017. This course will cover the following to assist fee earners in the application of AML in their casework. How to comply with your obligations and stay compliant Written CRA & MRA Client Booms Risks – what to consider? PCPs – CDD &EDD POCA / TA SOF and SOW On going monitoring Reporting to MLRO/MLCO Tipping off Target Audience The online course is suitable for fee earners or legal practitioners that want to improve their AML knowledge. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Helen Torresi, Consultant, DG Legal Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services. Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

We are offering a very convenient two hour session for a promotional price of £355.00. You will be able to perform in an ideal room with a perfectly tuned and regulated premium piano for two hours. Our Sound Engineer will assist you along the session.

The MOST DEMANDED PATHWAY are WAITING for YOU Are you eager to explore the thrilling world of Voice Acting and become a real "Voice Actor"? This means that instead of just recording commercials, promos, and announcements as voiceovers for income, you can hone your vocal acting skills and gain the ability to act in various audio scenarios! Look no further - this comprehensive voice acting training course will provide you with everything you need to get ahead. From learning about dialects and accents to developing character voices, you'll be able to start your journey towards becoming an expert voice actor. With interesting activities, amusing examples, and constructive exercises designed to challenge your abilities, you're sure to find this voice acting course rewarding, invigorating, and truly captivating. Voice Acting Course Package: Course 01: Voice Actor Training Course 02: Public Speaking Voice Acting Training Learning Outcomes: Upon successful completion of this highly appreciated Voice Acting Training course, you'll be a skilled professional, besides- Discover your "business voice". Develop your marketing and branding skills. Determine the tools you'll need to construct your studio. Learn proper studio etiquette and recording techniques. Learn the fundamentals of audio editing for a clear sound. Find out how and where to land your first jobs. Create a character bag that contains a variety of personas. Along with the Voice Acting Training course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Embark on your next step in life today - enrol now and make yourself one step closer to success. Course contains advanced and latest curriculum study modules: Course 01: Voice Actor Training Module 01: Introduction Module 02: Voiceover Basics Module 03: Finding Your Voice Module 04: Using Your Instrument Module 05: Exercising Your Voice Module 06: Useful Tips Module 07: Plan Your Demo Module 08: The Audition Module 09: Record Your Voice Module 10: The Studio Module 11: Promoting Your Voice Module 12: UK Voice Acting Industry Course 02: Public Speaking Module 01: Hook Your Audience Module 02: Show Confidence Module 03: Overcome Nervousness Module 04: Tailor Your Approach Module 05: Speak Well Module 06: Body Language Module 07: Keep Their Attention Module 08: Maximize Media Impact Module 09: Manage Pace Module 10: Answer Questions Module 11: Make It Enjoyment Module 12: Handle Distractions Module 13: Close Well CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? If you want to master professional acting abilities to turn your inherent talent in creating 'funny voices' into paid regular work, this is for you! Great for seasoned voice actors who want to increase their revenue by adding gaming and animation studios to their clientele! Ideal for trained actors who need to make money while waiting for stage bookings. All varieties of voices are required for voice acting job in video games and animation, therefore regardless of your age, this course is for you to help start your voice acting career! Requirements To enrol in this Voice Acting Training course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this Voice Acting course, you can explore trendy and in-demand jobs related to Voice Training, such as- Voiceover Artist: £20,000 to £50,000 per year Audiobook Narrator: £25,000 to £50,000 per year Commercial Voice Actor: £25,000 to £60,000 per year Video Game Voice Actor: £25,000 to £60,000 per year Animation Voice Actor: £25,000 to £60,000 per year Certificates 1 CPD Accredited Hard Copy Certificate Hard copy certificate - Included 1 CPD Accredited Hard Copy Certificate- Delivery charge: Inside the UK: £3.99, Outside of the UK: £9.99 Certificate of completion Digital certificate - Included CPD Accredited PDF Certificate Other CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 Other CPD Accredited Hard Copy Certificate for £9.99 Delivery charge: Inside the UK: Free Outside of the UK: £9.99

Are you intrigued by how speech recognition is driving the growth of the AI market? This course is a reliable guide if you're looking to pursue a career as a speech recognition professional and understand industry best practices.

Whether you're looking to improve your customer experience, streamline with new systems, or delegate to a new team member; understanding your customer journey is the best place to start.

Minute Taking is an intensive course designed to teach participants the necessary skills to record accurate notes during meetings, as well as communicate and take notes in meetings effectively.