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.
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re taking a fresh look at how to write and work with formulas that reference cells on other worksheets. This was first discussed in TOTW #275.
We have split the answers to the 2021 Christmas pantomime function name hunt across two articles to make the list of functions more manageable and to extend the suspense.
ICAEW Chief Executive Michael Izza and subject matter experts from around the organisation discuss the major trends we should see in 2022.
When working with reports interactively, it's often useful to be able to set a date or range of dates to filter the information. Here, we are going to compare the way date filtering works in Excel and in the free Power BI Desktop app.
In this March 2020 webinar bestselling author and strategic advisor, Bernard Marr, answers your questions on strategy, business performance and the intelligent use of data in business.
Accompanying slides for What's your data strategy? webinar.
Demystifying data. Before organisations can gain any value from data it is critical to have a clear data strategy that ties into an organisation's overall strategy.
A presentation and demonstration of the ICAEW Data Analytics Certificate Analyst Pathway.
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.
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.
Reduce the risk that your spreadsheet gives you the wrong answer.
A guide to the developments, opportunities and challenges that data analytics provides for auditors.
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
An in-depth overview of transaction multiples paid for UK private companies for the year ended December 2020.
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 takes a thoughtful look at how the industry is evolving, and it explains how to integrate concepts of digital finance into existing traditional finance platforms. It explores what successful companies are doing to maximize their opportunities in this context and offers suggestions on how to introduce digital finance into a firm's structure. Specific strategies for a digital future are presented, alongside numerous case studies that explore key attributes of success.
Understand, explore, and effectively present data using the powerful data visualization techniques of Python programming.
This book walks the reader through the wrangling process by exploring several factors-time, granularity, scope, and structure-that you need to consider as you begin to work with data.
A must-have guide to creating a robust data strategy. Explaining how to identify your strategic data needs, what methods to use to collect the data and, most importantly, how to translate your data into organizational insights for improved business decision-making and performance, this is essential reading for anyone aiming to leverage the value of their business data and gain competitive advantage.
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.
The Library & Information Service provides a hand-picked collection of industry press articles as a benefit of membership. If you are unable to access an article, please see our Help and support or contact library@icaew.com
Article looks at how data analytics and forecasting tools are critical for the accountancy firms of tomorrow.
Article looks at the disconnect between employers wanting people back in the office and their employees not wanting to return.
Article discusses the need for new workplace skills in the wake of the pandemic and the move to hybrid working . Employees are energized by it being made clear that reskilling was an investment in talent and directly supported growth plans.
Article looks for evidence that companies have moved from investigating the use of Blockchain to successful adoption.
Article outlines some recent developments in distributive ledger technology and cryptocurrencies and what they might mean for accountants and finance processionals moving forward.
Author discusses how business success and professional development both rely on continuous upskilling and keeping current with technical opportunities and challenges as they arise.
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.