576 Finance courses in Peebles delivered Live 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 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

Join us at our Sustainability Summit for SMEs to learn how to build thriving businesses and resilient supply chains in a fun and interactive Refund Policy Contact the organiser to request a refund.Eventbrite's fee is nonrefundable. About this event Event lasts 5 hours 30 minutes Sustainability Summit for SMEs: Thriving Businesses and Strong Supply Chains! Welcome to the Sustainability Summit 2024, a 1-day online event focused on sustainability for founders and senior decision makers in small and medium enterprises (SMEs), including those in the supply chains of larger organisations! In today’s dynamic business landscape, sustainability isn't just a buzzword; it's a necessity. Small and medium size enterprises must go beyond policy statements and adopt cohesive, actionable strategies to thrive. WHEN Date: Tuesday, 22 October 2024 Time: 10:00 AM – 3:15 PM (BST) Where: online (virtual event) This online Sustainability Summit will cover essential topics such as: Marketing, HR (skills and talent development), Low-carbon digital assets, Procurement, Finance and ESG. It will feature Guest Speakers, dynamic panel discussions and real-world case studies. Designed with small and medium enterprises at the centre, this learning event promises to be inspiring and thought provoking. Speakers will provide practical, actionable insights for immediate implementation as well as share effective ways to enable you to be more adaptable in the medium to long-term. Book now to participate from the comfort of your workplace [or your home office]. Our lineup of speakers include: Prof. Dave Spicer, Director of Business & Community Engagement, Univ. of Bradford Richard Clarke, Founder and Managing Director of Highland Carbon Tracy Cartwright, SHEQ Consultant and Director of Applaud Business Consultancy Antony Gutsa, Founder & CEO of Ecoswap and Banking Professional Giles Metcalfe, Ethical Marketer at Giles Metcalfe Digital Carolyn McGarry Williams, Co-Founder of 4 My Card and Director of Marketing Trevor Gibbs, Web Accessibility Specialist Amelia Banful, Head of Business Strategy, Enviro Electronics Dr Veronica Broomes, Founder of Sustainability Support Service & Sustainability Expert David Conner, Founder at 2030hub & Global Goals Week Organiser BENEFITS: reasons why you should attend Expert Insights: Hear from Guest Speakers and Panellists about the latest trends in sustainability and forthcoming changes in policies and legislation. Real-world case studies: Discover success stories from other SMEs that integrated multiple facets of sustainability for business benefits. Innovative Strategies: Learn actionable approaches to embed sustainability in your business and how to showcase this to win new business and talent for the future. Future-proof your business: Get inspired by new processes and up-skilling opportunities. Equip yourself with the knowledge to adapt and thrive. Networking: Connect with attendees during an interactive and fun 'lunchtime' session. PRICE: from £97.00 PLUS BONUSES: YOUR SWAG BAG GIFTS: *Personalised digital business card: discounted price for 1 year subscription for attendees. [Usual price: £65 or US$70] *Eco-friendly gift card: 10% OFF *Sustainability Calendar 2025: 40% OFF for attendees [You save £27 or US$29] DONATION TO CHARITY Our commitment to People, Planet and Communities (business, geographic, places) is ongoing. For this 2024 Sustainability Summit [online], we will donate 1% of ticket price (ex. VAT) to The Rotary Foundation, our global charity of choice. WHO SHOULD ATTEND This Sustainability Summit is ideal for: • Business Founders and Senior Leaders: Gain strategic insights and learn practical actions to embed sustainability in your organisation’s DNA. • SMEs in Supply Chains: Understand how to meet the sustainability expectations of larger organisations and enhance your competitiveness. • Procurement and HR Professionals: Update your knowledge and gain useful insights about varied road maps to evidence sustainability -multiple pillars: planet, people for high social impact, ESG. Don’t miss this chance to learn more about how your business can be at the forefront and boost competitiveness with embedding sustainability for environmental, social and economic benefits. BOOK YOUR PLACE NOW https://www.eventbrite.co.uk/e/sustainability-summit-for-smes-thriving-businesses-and-strong-supply-chains-tickets-993387768557 DON'T MISS OUT Don't miss this opportunity to learn in a dynamic virtual meeting, network with business leaders and founders in a professional environment and gain the knowledge you need to take your business to the next level with capable and resilient supply chains! #sustainabilitysummit, #onlinesustainabilityevent, #sustainabilitytraining, #CSR, #sustainabilityforSMEs, #businesssustainability #summit, #greenbusiness, #online, #supplychains, #planet #forpurpose #betterbusiness, #netzero, #conference

Duration 5 Days 30 CPD hours This course is intended for This course is designed for The Dynamics 365 Supply Chain Management functional consultant. The Dynamics 365 Supply Chain Management functional consultant is a key resource that designs and configures apps to meet the requirements for a customer. The functional consultant analyzes business requirements and translates those requirements into fully realized business processes and solutions that implement industry-recommended practices. The functional consultant specializes in one or more of the following feature sets of Dynamics: finance, manufacturing, or supply chain management. They partner with architects, developers, administrators, and other stakeholders to deliver solutions that meet or exceed the needs of their customers. Overview Configure the most important Dynamics 365 Dynamics 365 Supply Chain Management functionalities. Process most of the Dynamics 365 Supply Chain Management transactions. Explain to others how Dynamics 365 Supply Chain Management features and functionalities works. This course is designed to build your foundation in Dynamics 365 Supply Chain Management application knowledge. This course will cover the most important features and functionalities needed by Dynamics 365 Supply Chain Management functional consultant including: The product information and how to configure, create, and manage your product and inventory. Supply chain management configuration and processing. The transportation management features, and the warehouse management features. Quality management and quality control functionalities. Master planning configuration and processing. This course includes lectures and several hands-on exercises. The exercises will be introduced to you on a form of a case study presented to a Dynamics 365 Supply Chain Management functional consultant. Each exercise will be bases on a business scenario followed by a question or discussion then a step-by-step guidance to perform the system related steps. Implement product information management Create and manage products Configure products for supply chain management Manage inventory pricing and costing Implement inventory management Configure Inventory management Manage and process inventory activities Implement and manage supply chain processes Implement Procurement and sourcing Implement common sales and marketing features Using Microsoft Guides Implement warehouse management and transportation management Configure warehouse management Perform warehouse management processes Implement transportation management Configure and manage quality control and quality management Configure quality control and quality management Manage quality control and quality management Implement master planning Configure master planning and forecasting Run master plans and manage planned orders Implement additional master planning features

Remote training session for Xero Accounting and Payroll software.

Remote training session for QuickBooks Accounting and Payroll software.

Board members face a huge amount of information and review before the board meeting. Here is step-by-step process for mastering your board meeting prep challenge.

Duration 1 Days 6 CPD hours This course is intended for It is essential information for beginning IT Asset Managers and other IT professionals involved in asset management, resource budgeting, finance, software licensing, contract management and strategic planning. Overview During this course, students learn best practices in Software Asset Management Reducing Risk Increasing Accountability Uncovering Savings Gaining Control of the IT Environment The IAITAM Certified Software Asset Manager (CSAM) Course is a foundational education program that ensures students are able to manage software assets. Students also learn about the ever-changing variables throughout our industry. From software piracy and compliance issues to legislation and organizational challenges, it is necessary to evaluate both the internal and external influences that bring about change in how organizations manage their IT assets. A successful Software Asset Manager must look at the overall goals of the organization and determine where Software Asset Management will be a strategic influence in achieving those goals. This course also includes the exam for CSAM certification. Course Outline The Scope of Software Strategic License Management Software Harvesting License Documentation The Right to Audit Proactive vs. Reactive SAM Developing Goals Savings Opportunities ITAM Compliance Audit Letter Examples of License Data Documentation Compliance Enforcement Understanding the EULA Due Diligence for Compliance The Art of Negotiation Ts & Cs Advice ITAM Automation Selecting a Discovery Tool ITAM Repository Hardware & Organizational Impacts Additional course details: Nexus Humans Certified Software Asset Manager (CSAM) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Certified Software Asset Manager (CSAM) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Our bespoke Xero Training sessions are designed to get your Xero working properly & showing you the correct information, and to save you time for the important things... Get Xero set up properly, working as it should, error free Fix all of your Xero issues, once & for all Learn how to deal with your transactions correctly Use reporting to understand how your business is performing Gain confidence using Xero Save oodles of time on your accounting every single day with our bespoke Xero Training!

Duration 4.375 Days 26.25 CPD hours This course is intended for CCISOs are certified in the knowledge of and experience in the following CISO Domains:Governance (Policy, Legal & Compliance)IS Management Controls and Auditing Management (Projects, Technology & Operations)Management ? Projects and OperationsInformation Security Core CompetenciesStrategic Planning & Finance Overview Please refer to Overview. The Certified CISO (C|CISO) course has certified leading information security professionals around the world and is the first of its kind training and certification program aimed at producing top-level Information Security Leaders. The CCISO does not focus solely on technical knowledge but on the application of information security management principles from an executive management point of view. The program was developed by seasoned CISOs for current and aspiring CISOs. Governance Drivers that Influence Governance Corporate Governance Activities Information Security Governance Activities Governance and Ethical Decision Making Security Risk Management, Controls, and Audit Management Risk Management Audit Management Risk Treatment Risk Management Frameworks Risk Communication and Organizational Reporting Security Program Management and Operations Information Security Portfolio Management Information Security Program Management Information Security Project Management Security Operations Information Security Core Competencies Access Control Physical Security Network and Communications Security Threat and Vulnerability Management System and Application Security Encryption Concepts and Technology Strategic Planning, Financial Management, and Vendor Management Strategic Planning Financial Management Vendor Risk Management Additional course details: Nexus Humans EC-Council Certified CISO (C|CISO) w/exam training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the EC-Council Certified CISO (C|CISO) w/exam course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This course has been specifically designed to assist professionals applying for Real Estate positions where a Real Estate Financial Modelling test is a requisite part of the interview process.