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.
Your Questions Answered #11 – Tips and Tricks Live extended
In last month’s ‘Excel Tips and Tricks live – your questions answered’ webinar, David Benaim and Ian Pay tackled Excel questions and queries covering best practices when using Power Query, the use of formulas such as XLOOKUP, and a range of techniques for data handling and analysis in Excel. In this article, David returns to answer some of the unanswered questions from the webinar.
How we applied AI to combat modern slavery
The iEARTHS project is a causal AI system designed to tackle modern slavery. David Wray, ICAEW member and one of its creators, explains the considerations that went into its development.
My ACA Journey: the home straight
As she prepares for her first Advanced Level exams, Ashwini Poopalasingham looks back at everything she’s learned so far, and forwards to life after the qualification.
Evolution of mid-tier accountancy firms
ICAEW's latest research into mid-tier practices reveals reaction to the increase in private equity funding to the sector, as well as expectations for profit growth and shifts in services lines over the next three years.
Data protection and privacy are matters of professional concern to accountants in practice, industry or commerce. Organisations that collect, store or process personal information (personal data) on living and identifiable people (data subjects) must comply with the Data Protection Act 2018 and the General Data Protection Regulation (GDPR). Other relevant data protection and privacy legislation includes the Privacy and Electronic Communications Regulations (PECR), the Freedom of Information Act (FOIA) and the Data Protection (Charges and Information) Regulations 2018. This content is not intended to constitute legal advice. Specific legal advice should be sought before taking or refraining from taking any action in relation to the matters outlined.
No Query Set
Please select a Query.
The Excel Community provides a 'one-stop shop' for accountants who want to use Excel.
Free CPD: Excel essentials
Are you using Excel to its full potential? From the basics of good spreadsheet practice to time-saving tips, brush up on your Excel knowledge while gaining Continuous Professional Development (CPD) hours.
Exclusive
Simple but effective, part 7
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity.
Your Questions Answered #11 – Tips and Tricks Live extended
In last month’s ‘Excel Tips and Tricks live – your questions answered’ webinar, David Benaim and Ian Pay tackled Excel questions and queries covering best practices when using Power Query, the use of formulas such as XLOOKUP, and a range of techniques for data handling and analysis in Excel. In this article, David returns to answer some of the unanswered questions from the webinar.
Exclusive
The truth about the FILTER function
In this article, Mark Proctor takes us deep into the world of TRUE and FALSE to demonstrate creative ways of using the FILTER function.
Exclusive
The underused Table feature in Excel & Google Sheets
From my experience, every spreadsheet user already considers their data to be in tables, simply by virtue of data being in rows & columns, but very few have ever used the actual feature called “Tables” which means sadly that almost every regular user is missing out on one of spreadsheets’ most useful features.