Excel is one of the most popular end-user tools in the accountant’s portfolio. Spreadsheets enable us to quickly and flexibly perform analysis that otherwise would be difficult or time-consuming; however, there is a tendency to place undue trust in them. The Excel Community is a 'one-stop shop' for accountants who want to use Excel better and understand and minimise spreadsheet risk.
The Excel Community has created a new code – an application of the tenets of best practice and the Twenty principles for good spreadsheet practice to financial modelling construction.
Chartech, bi-monthly magazine to keep IT Faculty members up to date with changes in technology and useful tips and advice to help them in their working lives.
Chartech, bi-monthly magazine to keep IT Faculty members up to date with changes in technology and useful tips and advice to help them in their working lives.
Simon Hurst explains how to use Data Validation and hierarchical lists together.
How to model the draw down, interest, and repayments on a loan.
This is the second article in a series that looks at various Excel modelling issues and challenges in order to see whether the Power Query/Get & Transform tools can be a viable alternative to more traditional Excel cell-based solutions.
How to make a formula that picks up the most recent entry in a range.
Liam Bastick has been a model auditor for the best part of 30 years and has seen common mistakes made in modelling time and time again.
Power Query is a plug-in for Microsoft Excel which enables you to combine data from structured and semi-structured sources.
Spreadsheet risk is an important concern that affects organisations of all kinds and sizes.
Almost exactly two years ago, Rishi Sapra presented an excellent introduction to Power BI and its capabilities. Since then, Microsoft has continued to update Power BI with significant updates arriving monthly. This webinar will focus on the free version of Power BI, Power BI Desktop, and cover the different components of Power BI Desktop using a practical example to take you from raw data to interactive report.
ICAEW is collaborating with Deloitte to ensure its members and students have the knowledge and skills to take advantage of the opportunities offered by the fourth industrial revolution and to meet its challenges head on. Log-in to access exclusive content, including: eLearning, webinars and bite-sized summaries on individual technologies and the broader impact of digital technologies on finance.
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
Technology is moving mainstream. Words such as cyber, cloud and artificial intelligence are entering the lexicon as people become more comfortable and familiar with these terms - which in turn is leading to changing expectations. This guide is written in response to that.
A beginner's guide to financial modeling using Microsoft Excel.
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter
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.