1278 Accountant courses

***AML : Anti Money Laundering Course*** Every year, billions of dollars are laundered, making compliance more important than ever. Even with advancement of technology, financial infrastructures are not totally safe from fraud and cybercriminals. The huge amount of illegal money floating 'below the surface' and disrupting the economic balance is the main reason for the implementation of anti-money laundering policies. Anti-money laundering (AML) regulations and procedures require financial institutions to monitor and prevent their customers from engaging in money laundering activities. AML seeks to deter criminals from transferring illegal funds into the financial system while also protecting your organisation. With this Course, you will learn about AML policies and gain a thorough understanding of financial crime. Through this AML: Anti Money Laundering Course you will learn what money laundering is and how AML plays a role in preventing money laundering. This course will teach you how criminals use a variety of methods to launder money and convert black money into white money. This course covers a wide range of essential topics, including the evolution of AML regulations, a risk-based approach, customer due diligence, suspicious activity/transactions, record keeping, and much more. By the end of this AML: Anti Money Laundering Course, you will have a clear understanding of the responsibilities of a money laundering reporting officer as well as the skills required to make your mark in the financial world. Learning Outcomes After completing this Course, learner will be able to: Gain a thorough understanding of Money Laundering Gain in-depth knowledge about proceeds of crime act 2002 Understand the development of anti money laundering regulation Understand responsibility of the money laundering reporting officer Understand risk-based Approach Understand customer due diligence Gain a solid understanding of record keeping Understand the importance of staff awareness and training Why Choose this Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the Course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Anti-Money Laundering (AML) Training course] [ AML: Anti Money Laundering Course] course curriculum Module 01: A Quick Overview of Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Evolution of Anti Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Employees and Agents Awareness and Training Assessment Method After completing each module of the Anti-Money Laundering (AML) Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Anti-Money Laundering (AML) Training course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Course is suitable for anyone interested in learning about AML legislation and how terrorist financing works in order to protect their business and customers. Ethics & Compliance Professionals AML Analysts Accountants & Bookkeepers Bankers Money Laundering Reporting Officer AML Officer Risk & Compliance Analyst Compliance Manager Requirements There are no specific requirements for this Course because it does not require any advanced knowledge or skills. Career path This Course may lead you to a variety of career opportunities. Such as: AML Analyst Compliance Manager Money Laundering Reporting Officer Lawyer In the UK, the average annual salary for these job opportunities ranges from £15,000 to £75,000 per year. Certificates Certificate of completion Digital certificate - Included

A Diploma in Conveyancing is vital in the modern world, offering specialized knowledge in property law and risk management. This course, encompassing modules such as Property Law & Conveyancing Practice, Law of Contract, and Taxation Issues for Conveyancers, equips learners with comprehensive skills crucial for effective risk management in real estate transactions. Mastery in preparing legal documents and understanding accounting procedures is essential for ensuring compliance and mitigating potential risks. The importance of risk management cannot be overstated, especially with frequent updates from the Land Registry and evolving laws that impact standard conveyancing transactions. In the UK, professionals with expertise in conveyancing and risk management are in high demand, with job opportunities ranging from conveyancers to legal advisors. Salaries for conveyancers in the UK average around £25,000 to £45,000 annually, reflecting the value of skilled risk management. The conveyancing sector is on the rise, with an estimated growth of 10-15% over recent years. This upward trend underscores the increasing need for proficiency in risk management, making this diploma a strategic investment for career advancement in the property law sector. Key Features: CPD Certified Diploma in Conveyancing Course Free Certificate from Reed CIQ Approved Diploma in Conveyancing Course Developed by Specialist Lifetime Access Course Curriculum: Module 01: Introduction To Conveyancing Module 02: Key Conveyancing Fundamentals Module 03: Property Law & Conveyancing Practice Module 04: Land Registry Updates And Law Module 05: Law Of Contract Module 06: Landlord And Tenant Module 07: Standard Conveyancing Transactions Module 08: Understanding Accounting Procedures For Conveyancing Transactions Module 09: Preparing Legal Documents Module 10: Taxation Issues For Conveyancers Learning Outcomes: Understand conveyancing procedures and key legal principles in property transactions. Apply property law knowledge to ensure compliance with conveyancing practices. Analyze Land Registry updates and law for accurate conveyancing transactions. Demonstrate proficiency in drafting and preparing legal documents for conveyancing. Identify taxation issues relevant to conveyancing transactions in the UK. Execute standard conveyancing transactions while adhering to accounting procedures. CPD 10 CPD hours / points Accredited by CPD Quality Standards Diploma on Conveyancing 2:39:57 1: Module 01: Introduction To Conveyancing Preview 12:58 2: Module 02: Key Conveyancing Fundamentals 11:07 3: Module 03: Property Law & Conveyancing Practice 12:30 4: Module 04: Land Registry Updates And Law 23:43 5: Module 05: Law Of Contract 16:20 6: Module 06: Landlord And Tenant 18:33 7: Module 07: Standard Conveyancing Transactions 15:25 8: Module 08: Understanding Accounting Procedures For Conveyancing Transactions 13:37 9: Module 09: Preparing Legal Documents 11:52 10: Module 10: Taxation Issues For Conveyancers 21:52 11: CPD Certificate - Free 01:00 12: Leave A Review 01:00 Who is this course for? This Diploma on Conveyancing course is accessible to anyone eager to learn more about this topic. Through this Conveyancing course, you'll gain a solid understanding of Diploma on Conveyancing. Moreover, this course is ideal for: Aspiring conveyancers seeking comprehensive legal knowledge in property transactions. Law students aiming to specialize in conveyancing practice and procedures. Real estate professionals looking to expand their expertise into conveyancing. Individuals interested in pursuing a career in property law and transactions. Accountants or financial professionals seeking specialization in conveyancing transactions. Requirements There are no requirements needed to enrol into this Diploma on Conveyancing course. We welcome individuals from all backgrounds and levels of experience to enrol into this Diploma on Conveyancing course. Career path After finishing this Diploma on Conveyancing course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Diploma on Conveyancing are: Conveyancer - £25K to 50K/year. Property Lawyer - £30K to 60K/year. Legal Executive - £20K to 40K/year. Land Registry Officer - £20K to 35K/year. Estate Agent - £18K to 40K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Whether you're an aspiring finance professional, a small business owner, or just someone who wants to understand the financial health of your investments, our Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting Course is your gateway to mastering the language of business! According to Reed a Financial Analyst can earn from £45,000 to £50,000 in a year depending on qualification, experience, location and other factors. So enrol into our Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course for learning everything that you need to in order to thrive in this competitive market Key Features: CPD Certified Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course Free Certificate from Reed CIQ Approved Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course Developed by Specialist Lifetime Access Course Curriculum of Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting: Module 01: Overview of Financial Analysis Module 02: Challenges in Evaluating Financial Assets and Balancing Sheets Module 03: Comprehensive Insight into the Income Statement Module 04: Unravelling the Cash Flow Statement Module 05: Financial Reporting Fundamentals Module 06: Exploration of Profitability Concepts Module 07: EBITDA - Earnings Before Interest, Taxes, Depreciation, and Amortisation Module 08: In-Depth Analysis of Credit Module 09: Essential Insights into Equity Analysis Module 10: Analysing Financial Ratios Learning Outcomes: Evaluate financial assets using balance sheets for informed decision-making. Analyse income statements for a comprehensive understanding of financial performance. Interpret cash flow statements to assess liquidity and financial stability. Demonstrate proficiency in financial analysis, reporting fundamentals and disclosure requirements. Apply profitability concepts and EBITDA analysis in financial assessment. Utilise financial ratios for in-depth analysis and benchmarking purposes. CPD 10 CPD hours / points Accredited by CPD Quality Standards Financial Analysis, Income Statement, Cash Flow & Balance Sheet 2:20:00 1: Module 01: Overview of Financial Analysis 10:00 2: Module 02: Challenges in Evaluating Financial Assets and Balancing Sheets 14:00 3: Module 03: Comprehensive Insight into the Income Statement 16:00 4: Module 04: Unravelling the Cash Flow Statement 16:00 5: Module 05: Financial Reporting Fundamentals 13:00 6: Module 06: Exploration of Profitability Concepts 13:00 7: Module 07: EBITDA - Earnings Before Interest, Taxes, Depreciation 14:00 8: Module 08: In-Depth Analysis of Credit 17:00 9: Module 09: Essential Insights into Equity Analysis 11:00 10: Module 10: Analysing Financial Ratios 14:00 11: CPD Certificate - Free 01:00 12: Leave A Review 01:00 Who is this course for? This Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting. Moreover, this course is ideal for: Professionals in finance seeking advanced financial analysis skills. Business students aiming to enhance financial statement comprehension. Accountants looking to deepen their understanding of financial analysis and reporting. Investors interested in making informed investment decisions based on financial analysis. Individuals involved in credit analysis or equity evaluation roles. Requirements There are no requirements needed to enrol into this Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reportingcourse. We welcome individuals from all backgrounds and levels of experience to enrol into this Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course. Career path After finishing this Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course you will have multiple job opportunities for you. Some of the Job sectors of Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting are: Financial Analyst Credit Analyst Equity Research Analyst Investment Manager Corporate Treasurer Financial Consultant Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Anti-Money Laundering (AML) Training Every year, billions of dollars are laundered, making compliance more important than ever. Even with advancement of technology, financial infrastructures are not totally safe from fraud and cybercriminals. The huge amount of illegal money floating 'below the surface' and disrupting the economic balance is the main reason for the implementation of anti-money laundering policies. Anti-money laundering (AML) regulations and procedures require financial institutions to monitor and prevent their customers from engaging in money laundering activities. AML seeks to deter criminals from transferring illegal funds into the financial system while also protecting your organisation. With this course, you will learn about AML policies and gain a thorough understanding of financial crime. Through this course you will learn what money laundering is and how AML plays a role in preventing money laundering. This course will teach you how criminals use a variety of methods to launder money and convert black money into white money. This course covers a wide range of essential topics, including the evolution of AML regulations, a risk-based approach, customer due diligence, suspicious activity/transactions, record keeping, and much more. By the end of this course, you will have a clear understanding of the responsibilities of a money laundering reporting officer as well as the skills required to make your mark in the financial world. Learning Outcomes After completing this Anti-Money Laundering (AML) Training course, learner will be able to: Gain a thorough understanding of Money Laundering Gain in-depth knowledge about proceeds of crime act 2002 Understand the development of anti money laundering regulation Understand responsibility of the money laundering reporting officer Understand risk-based Approach Understand customer due diligence Gain a solid understanding of record keeping Understand the importance of staff awareness and training Why Choose Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Anti-Money Laundering (AML) Training course] [ Anti-Money Laundering (AML) Training] course curriculum Module 01: A Quick Overview of Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Evolution of Anti Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Employees and Agents Awareness and Training Assessment Method After completing each module of the Anti-Money Laundering (AML) Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Anti-Money Laundering (AML) Training course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Anti-Money Laundering (AML) Training course is suitable for anyone interested in learning about AML legislation and how terrorist financing works in order to protect their business and customers. Ethics & Compliance Professionals AML Analysts Accountants & Bookkeepers Bankers Money Laundering Reporting Officer AML Officer Risk & Compliance Analyst Compliance Manager Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Career path This course may lead you to a variety of career opportunities. Such as: AML Analyst Compliance Manager Money Laundering Reporting Officer Lawyer In the UK, the average annual salary for these job opportunities ranges from £15,000 to £75,000 per year. Certificates Certificate of completion Digital certificate - Included

Certificate in Anti Money Laundering (AML) Every year, billions of dollars are laundered, making compliance more important than ever. Even with advancement of technology, financial infrastructures are not totally safe from fraud and cybercriminals. The huge amount of illegal money floating "below the surface" and disrupting the economic balance is the main reason for the implementation of anti-money laundering policies. Anti-money laundering (AML) regulations and procedures require financial institutions to monitor and prevent their customers from engaging in money laundering activities. AML seeks to deter criminals from transferring illegal funds into the financial system while also protecting your organisation. With this Anti-Money Laundering (AML) Training, you will learn about AML policies and gain a thorough understanding of financial crime. Through this Anti-Money Laundering (AML) Training course you will learn what money laundering is and how AML plays a role in preventing money laundering. This course will teach you how criminals use a variety of methods to launder money and convert black money into white money. This Anti-Money Laundering (AML) Training course covers a wide range of essential topics, including the evolution of AML regulations, a risk-based approach, customer due diligence, suspicious activity/transactions, record keeping, and much more. By the end of this Anti-Money Laundering (AML) Training course, you will have a clear understanding of the responsibilities of a money laundering reporting officer as well as the skills required to make your mark in the financial world. Special Offers of this Certificate in Anti Money Laundering (AML) Course This Certificate in Anti Money Laundering (AML) Course includes a FREE PDF Certificate. Lifetime access to this Certificate in Anti Money Laundering (AML) Course Instant access to this Certificate in Anti Money Laundering (AML): Certificate in Anti Money Laundering (AML) Course Get FREE Tutor Support from Monday to Friday in this Certificate in Anti Money Laundering (AML) Course Learning Outcomes of Certificate in Anti Money Laundering (AML) After completing this Anti Money Laundering course, learner will be able to: Gain a thorough understanding of Money Laundering Gain in-depth knowledge about proceeds of crime act 2002 Understand the development of anti-money laundering regulation Understand responsibility of the money laundering reporting officer [ Note: Free PDF certificate as soon as completing the Anti Money Laundering course] ***Certificate in Anti Money Laundering (AML)*** course curriculum Industry Experts Designed this Certificate in Anti Money Laundering (AML) course into 08 detailed modules. Module 01: A Quick Overview of Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Evolution of Anti Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Employees and Agents Awareness and Training Assessment Method After completing each module of the Anti Money Laundering Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Anti Money Laundering course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Certificate in Anti Money Laundering (AML) This course is suitable for anyone interested in learning about AML legislation and how terrorist financing works in order to protect their business and customers. Ethics & Compliance Professionals AML Analysts Accountants & Bookkeepers Bankers Money Laundering Reporting Officer AML Officer Risk & Compliance Analyst Compliance Manager Requirements Certificate in Anti Money Laundering (AML) There are no specific requirements for this course because it does not require any advanced knowledge or skills. Career path Certificate in Anti Money Laundering (AML) This course may lead you to a variety of career opportunities. Such as: AML Analyst Compliance Manager Money Laundering Reporting Officer Lawyer In the UK, the average annual salary for these job opportunities ranges from £15,000 to £75,000 per year. Certificates Certificate of completion Digital certificate - Included

***Anti Money Laundering (AML)*** Every year, billions of dollars are laundered, making compliance more important than ever. Even with advancement of technology, financial infrastructures are not totally safe from fraud and cybercriminals. The huge amount of illegal money floating 'below the surface' and disrupting the economic balance is the main reason for the implementation of anti-money laundering policies. Anti-money laundering (AML) regulations and procedures require financial institutions to monitor and prevent their customers from engaging in money laundering activities. AML seeks to deter criminals from transferring illegal funds into the financial system while also protecting your organisation. With this Anti Money Laundering (AML), you will learn about AML policies and gain a thorough understanding of financial crime. Through this Anti Money Laundering (AML) course you will learn what money laundering is and how AML plays a role in preventing money laundering. This course will teach you how criminals use a variety of methods to launder money and convert black money into white money. This course covers a wide range of essential topics, including the evolution of AML regulations, a risk-based approach, customer due diligence, suspicious activity/transactions, record keeping, and much more. By the end of this course, you will have a clear understanding of the responsibilities of a money laundering reporting officer as well as the skills required to make your mark in the financial world. Learning Outcomes After completing this Anti Money Laundering (AML) course, learner will be able to: Gain a thorough understanding of Money Laundering Gain in-depth knowledge about proceeds of crime act 2002 Understand the development of anti money laundering regulation Understand responsibility of the money laundering reporting officer Understand risk-based Approach Understand customer due diligence Gain a solid understanding of record keeping Understand the importance of staff awareness and training Why Choose Anti-Money Laundering (AML) Training Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Anti Money Laundering (AML) course] ***Anti Money Laundering (AML)*** course curriculum Module 01: A Quick Overview of Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Evolution of Anti Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Employees and Agents Awareness and Training Assessment Method After completing each module of the Anti Money Laundering (AML) Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Anti Money Laundering (AML) course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Anti Money Laundering (AML) This course is suitable for anyone interested in learning about AML legislation and how terrorist financing works in order to protect their business and customers. Ethics & Compliance Professionals AML Analysts Accountants & Bookkeepers Bankers Money Laundering Reporting Officer AML Officer Risk & Compliance Analyst Compliance Manager Requirements Anti Money Laundering (AML) There are no specific requirements for this course because it does not require any advanced knowledge or skills. Career path Anti Money Laundering (AML) This course may lead you to a variety of career opportunities. Such as: AML Analyst Compliance Manager Money Laundering Reporting Officer Lawyer In the UK, the average annual salary for these job opportunities ranges from £15,000 to £75,000 per year. Certificates Certificate of completion Digital certificate - Included

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Business Communication Skills: Communicating effectively in the workplace   Course Description   Course Description Poor communication and presentation of business information breeds poor decisions. We may be masters of the spreadsheet and wizards with a project plan, but we are not always brilliant at communicating or presenting the results of our work Management meetings can, sometimes, be tedious and uninspiring, where managers compete for excuses to avoid attending! A good manager is someone who understands performance and can present information in a way that enables others to understand what the issues are and make correct decisions. A good manager can cut through the fog of numbers to make a clear point and assist others to make effective decisions. In “Business Communication Skills” we present tools and structures that will help you plan and deliver your message effectively and facilitate group meetings to achieve a useful outcome. Topics covered include the principles of good communication; planning your communication; structuring your message; and facilitating business meetings, including online meetings. We hope you enjoy it.   Key Learning Participants in this course will learn: The principles of effective communication Planning your communication – message, audience, medium, structure, call to action. How to structure your communication Language patterns to help get your message across How to facilitate Business Meetings The Skills of a good facilitator The rules for a well-structured meeting Planning your meeting agenda How to facilitate an online meeting What to look for when facilitating a session Tools you can use in facilitation. Evaluating your Facilitation   Curriculum L1 Effective Communication L2 Planning your Communication 1 L3 Planning your Communication 2 L4 Planning your Communication 3 L5 Exercise: Stakeholder Analysis L6 Facilitating Business Meetings L7 Planning your Meeting Agenda L8 As a facilitator what should I look for? L9 Tools you can use in facilitation L10 Facilitation Tools L11 Exercise: Planning your Agenda Resource: Tools to help you communicate and facilitate     Pre-Course Requirements None     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Selling Skills for Professionals: Part 2 Making the Sale   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to Selling Skills for Professionals: Part 2 Making the Sale.   In Part 1 of Selling Skills for Professionals I covered prospecting, that is identifying potential future clients and making the initial approach. In this course, Part 2 of Selling Skills for Professionals, I cover the sales process – converting a prospect into a client. In Selling Skills for Professionals: Part 2 Making the Sale, I look at the skills you need for selling professional services and how to create a series of webinars to build prospects’ interest. I then cover a five-step sales process in detail: Understand the current situation Surface the pain points Exploring the impacts of the pain points Shape the future state Close the sale   The course also covers why people buy professional services, and why they might not buy; and it shows how to deal with objections.   Selling professional services is not like selling a car, or solar panels. It’s about building a relationship with a prospect as a professional advisor; coaching them through the challenges facing them; and offering services tailored to their needs which will help the prospect make tangible improvements.   If you want to know how to sell professional services successfully, this is the course for you.   I hope you enjoy the course.     Key Learning Points  On completion of the course, delegates will be able to: Describe a five-stage sales process for professional services Identify the core skillset needed for selling professional services Deploy best practice when creating webinars to engage prospects Explore a prospect’s current situation on an online video call Identify a prospect’s pain points and explore their root causes and impacts Coach a prospect to visualise the future state they would like to get to be resolving the problems identified Handle objections surfaced as the prospect moves towards closing the sale Understand why people buy professional services, and why they don’t buy Reduce buyer’s remorse and plan to develop the client relationship after the sale     Curriculum Module 1: The Foundations for Selling Professional Services Lesson 1: The Purpose of Prospecting Lesson 2: The Selling Professional Services Skillset Lesson 3: Moving Beyond Prospecting Lesson 4: Script for the Webinar Follow-Up Call   Module 2: Building a Case for the Sale Lesson 5: No Pain No Gain Lesson 6: Building a Case: Initial Diagnosis Lesson 7: Building a Case: Root Causes Lesson 8: Building a Case: Impacts Lesson 9: Building a Case: Shaping the Future State Lesson 10: Building a Case: The Gap   Module 3: Closing the Sale Lesson 11: Selling is about Change Lesson 12: A Time to Close  Lesson 13: Closing (At Last)   Module 4: Evasion and Objections Lesson 14: Evasion Lesson 15: Handling Objections Lesson 16: Specific Example of Objections Part 1 Lesson 17: Specific Example of Objections Part 2   Module 5: After the Sale Lesson 18: Aftercare Lesson 19: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Duration 3 Days 18 CPD hours This course is intended for Experienced IT Asset Managers Overview By attending this course the attendee will be able to Understand and utilize the dependencies, relationships and benefits of the KPAs found within an effective IT Asset Management Program specify and define the duties and responsibilities necessary to be an effective IT Asset Manager be able to obtain and display an understanding of the resources and commitment necessary to implement a fully functional IT Asset Management Program. Attendees will learn about the entire ITAM Program and take with them the foundation plan for starting or improving their organization?s ITAM Program. The intense three-day course with certification is packed full of information and real-world experiences designed to make your ITAM Program more effective and efficient, and the CITAM Certification will lend notable credibility to both you and your ITAM Program.This course addresses each of the Key Process Areas (KPAs) identified within the IBPL that, when combined, empowers an organization and maximizes the value of their IT assets. The course will also review the core processes that encompass the ITAM Program and the projects that will help an organization build a productive and profitable business unit.The course includes exam for CITAM certification. Course Outline IAITAM and the Mission ITAM Code of Ethics Defining Primary Roles in an ITAM Program IAITAM?s 12 KPAs Relationships, Dependencies, and Benefits KPA Interdependencies Roles and Responsibilities Creating Dynamic Job Descriptions for ITAM Programs The Role of a Program Manager Project Management Relationship Triangle Sample Projects by KPA Prioritization and the ITAM Program Lifecycle Management Process Building Best Practices Gaining Executive Buy-in Business Case Template Maturity Assessment ITAM as a Core Business Function Additional course details: Nexus Humans Certified IT Asset Manager (CITAM) 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 IT Asset Manager (CITAM) 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.