If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on managing complaints and complaining clients successfully.
If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on telephone etiquettes, communication and behaviours.
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.
Course Overview The Financial Engineering Courses – 8 Courses Bundle is a comprehensive training package designed to equip learners with a robust understanding of the mathematical, statistical, and analytical foundations of modern finance. This bundle merges core financial theories with quantitative models to support strategic financial decision-making. Learners will explore concepts ranging from derivatives pricing and risk modelling to portfolio optimisation and stochastic processes, gaining a solid foundation in the methodologies used in financial institutions and investment firms. By the end of the course, participants will be able to interpret financial models, assess risk frameworks, and contribute effectively to quantitative analysis roles. This course is particularly valuable for those aiming to strengthen their understanding of finance through an analytical lens, aligning with roles in investment banking, financial consultancy, or quantitative research. Course Description This course bundle offers eight interconnected modules covering a wide array of financial engineering topics. Learners will be introduced to financial mathematics, stochastic calculus, fixed income securities, options pricing, quantitative risk management, and algorithmic trading strategies. The programme provides an in-depth look into the mechanics of financial markets and the computational tools that underpin asset valuation and portfolio structuring. Through clear instruction and structured content, learners will build confidence in applying quantitative techniques and economic theory to real-world financial challenges. Emphasis is placed on theoretical rigour, analytical accuracy, and strategic application. Ideal for learners with a background or interest in finance, mathematics, or economics, this course supports a deeper understanding of financial markets and prepares participants for roles that require data-driven financial modelling and risk assessment skills. Course Modules Module 01: Introduction to Financial Engineering Module 02: Financial Mathematics and Modelling Techniques Module 03: Fixed Income Securities and Yield Curves Module 04: Derivatives and Options Pricing Theory Module 05: Quantitative Risk Management Fundamentals Module 06: Stochastic Processes in Finance Module 07: Portfolio Theory and Investment Analysis Module 08: Algorithmic and Computational Finance (See full curriculum) Bundle Instructions Access all eight courses through a single enrolment. Courses are self-paced and available online 24/7. Learners receive a certificate for each completed module. Support is available throughout the learning journey. Who is this course for? Individuals seeking to build a strong foundation in quantitative finance. Professionals aiming to advance their knowledge in financial modelling and analysis. Beginners with an interest in finance, mathematics, or data-driven investment theory. Graduates or career changers targeting roles in banking, analytics, or asset management. Career Path Quantitative Analyst Financial Risk Manager Investment Banking Analyst Asset or Portfolio Manager Financial Modelling Consultant Data Analyst in Financial Services Derivatives Pricing Specialist Economic Research Associate
Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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
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.
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 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report
Course Overview This course on Accounts Payable Management (Purchase Ledger) offers an in-depth exploration of the essential functions and responsibilities within the purchase ledger department. Learners will gain a solid understanding of purchase ledger processes, from basic concepts to advanced management techniques, making it ideal for those looking to enhance their financial accounting knowledge. Throughout the course, learners will explore the significance of accurate and efficient ledger management, its impact on overall financial operations, and how these skills contribute to business success. Upon completion, learners will be equipped with the knowledge required to manage purchase ledgers confidently and contribute effectively to an organisation’s financial management practices. Course Description This comprehensive course covers key topics related to the accounts payable function, such as managing purchase ledger accounts, controlling and reconciling transactions, and understanding the importance of accurate ledger management. Learners will explore the role of purchase ledger in business finance, developing core skills like reconciliation techniques and managing supplier relationships. In addition, the course includes a focus on the shift towards paperless operations, equipping learners with the tools to optimise processes using modern software solutions. By the end of the course, participants will possess the necessary skills to manage purchase ledgers efficiently, making them valuable assets to any accounting or finance team. Course Modules Module 01: Introduction to Purchase Ledger Module 02: Importance of Purchase Ledger Module 03: Skills for Purchase Ledger Management Module 04: Purchase Ledger Control Account Module 05: Managing Purchase Ledger Successfully Module 06: Reconciliation Module 07: The Key to a Paperless Purchase Ledger World (See full curriculum) Who is this course for? Individuals seeking to enhance their accounting and finance skills. Professionals aiming to manage purchase ledger operations effectively. Beginners with an interest in accounts payable and financial management. Those looking to progress in the accounts payable or finance departments. Career Path Accounts Payable Manager Purchase Ledger Supervisor Finance Assistant Financial Controller Accounting Technician