Get advanced data analysis, from number crunching and spreadsheets to decision-support and strategy, including access to useful and practical Excel guidance. Plus, find out how big data is used and can benefit the accountancy profession.
ICAEW recently hosted a webinar where three experienced internal audit professionals shared their insights on the evolving landscape of internal audit, the skills needed to succeed in this field, and strategies for overcoming common challenges.
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the concept of a combo chart in Excel that can be used for two or more series of data.
This month we look at what can be learned from state-sponsored cyber attacks, how to avoid falling victim to increasingly sophisticated account takeover scams, and the ICO guidance on levels of fines for data breaches.
ICAEW is urging accountancy firms to sign up to a new £7.4m funding pot to help staff at small and medium sized businesses boost their artificial intelligence (AI) skills.
webinar slides
This webinar explores the fundamentals of Power Pivot and how to best use this functionality in Excel to structure and analyse data, based on real-life examples accounting and finance professionals will encounter.
Could bad data be holding your forecasts back? If you want to perform incisive cash flow forecasts and empower your clients to make the best business decisions, you need to have a focus on data quality. In this webinar, we will delve into the impact of good data on your cash flow forecasting. We will consider the processes you can implement today to ensure your clients’ data is captured, processed, and presented in the most effective manner, and look at how Futrli can help.
Join our experts as they tackle your Excel questions, quandaries, and more.
Disclaimer: The opinions expressed by external guest speakers in interviews or other publications included on this website are, by their nature, those of the speaker. They are not necessarily fully endorsed by the ICAEW or purport to reflect the official policies and views of the ICAEW or its members.
The flow of sensitive information and the number of parties typically interacting in M&A, raising finance or a restructuring can increase the cyber security risk of all those involved. This guide aims to help organisations manage cyber risk and improve its governance, setting out good practice within the context of a corporate finance transaction.
A snapshot of the steps being taken by audit firms to better facilitate fraud deterrence and detection.
Data analytics allows firms to harness data, both internal and external, to provide faster, deeper analysis for better decision-making. These tools offer accountants the ability to track client performance at a more granular level and identify ways to build in efficiencies.
The Library & Information Service provides a hand-picked collection of eBooks as a benefit of membership. If you are unable to access an eBook, please see our Help and support or contact library@icaew.com
The first of a two-volume series covering Python, a general-purpose programming language, for accounting and business tasks. This volume covers the concepts of Python and select foundational libraries using examples, codes, and accompanying outputs. Examples are tailored to accounting and business use-cases.
Includes examples and case studies that teach users the tricks for analysing data in Excel.
For those new to data analysis. Takes the reader on a tour of Excel's data analysis tools.
Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons.
This book delivers a powerful analysis of the new technological forces buffeting the accounting profession. Using case studies and practical examples, the author demonstrates how big data, blockchain, robotic process automation and artificial intelligence can help accountants adapt to new realities.
This book will help accountants and financial managers better understand big data and analytics, including its history and current trends. It dives into the platforms and operating tools that will help you measure program impacts and ROI, visualize data and business processes, and uncover the relationship between key performance indicators.
This book hopes to provide the reader with an inventory of basic algorithms which can be easily expanded and customized to fit an auditor's specific challenges. Accessible and comprehensive tools for these additional approaches are covered in this book, as are research approaches to take advantage of the additional explanatory power that these approaches offer to auditing. Coverage of software, methodologies, and fit statistics provide a concise reference for the conduct of audits, helping assure that audit opinions and decisions are defensible, fair, and accurate.
This book takes a thoughtful look at how the digital finance industry is evolving. It explains how to integrate digital finance concepts into existing traditional finance platforms and explores what successful companies are doing to maximize their opportunities in this context.
Terms of use: You are permitted to access, download, copy, or print out content from eBooks for your own research or study only, subject to the terms of use set by our suppliers and any restrictions imposed by individual publishers. Please see individual supplier pages for full terms of use.
Article discusses openness and transparency in data collection from customers. The authors argue that companies that are open about what they are doing with customer data and offer something fair in exchange are at an advantage over companies that are not trusted with data.
The article highlights the importance of data management and security in today's digital supply chain, where every enterprise is considered a "data enterprise." As companies transition to digitally integrated supply chains, they must prioritize data stewardship, embed data governance and security into their operations, and adapt to changing practices and regulations.
The article focuses on data classification as a pre-requisite for data protection, security, and compliance, and it explores the tools available for data classification, including offerings from major tech companies as well as open-source options. It mentions these tools use machine learning and artificial intelligence to automate data classification, ensuring accurate data management and governance.
Article discusses how Ai-driven decisions have led to discrimination against women and minorities in recruitment, criminal sentencing, medical diagnosis and credit approval and led to thousand of fines under GDPR. An overview of a robust ethical review is given and the 'Five Ps of ethical data handling'
Article explains that descriptive analytics is the process of analysing data to find trends and patterns that support decision-making, monitoring, and other initiatives. It's the most fundamental building block of data analytics.
The article discusses the need for finance leaders to recognize the importance of data analytics to become effective in their roles. The need to ensure that employees work in a culture that sustains collaboration and exchange of ideas and information by leaders is noted. It discusses ways in which management accountants can demonstrate leadership such as competence in financial planning and imparting technical accounting knowledge.
Terms of use: You are permitted to access articles subject to the terms of use set by our suppliers and any restrictions imposed by individual publishers. Please see individual supplier pages for full terms of use.
Provided by Tibco this textbook offers support on the application of statistics and data mining. It covers a variety of applications, including: business statistics, credit scoring, forecasting and survey research, data mining and quality control.
Case studies of the use of analytics, searchable by industry, application, benefit or function
This discussion paper looks at the implications of big data, artificial intelligence (AI) and machine learning for data protection, and explains the ICO’s views on these.
ICAEW accepts no responsibility for the content on any site to which a hypertext link from this site exists. The links are provided ‘as is’ with no warranty, express or implied, for the information provided within them. Please see the full copyright and disclaimer notice.