ExcelAnalyticsIn the current icaew member newsletter, Craig Stirk describes the uses and limitations of the Claude addin in Excel. Here is an example of where user caution is advised:
#ICAEW are giving two lucky winners the chance to win free access to their set of #Excel on-demand #courses: https://lnkd.in/eCfaVQ9G
The competition was inspired by a recent Excel Community post:
To enter, you must share your experience of an Excel inefficiency that you’ve come across, and the Excel features that you have been able to use to dramatically improve productivity.
https://www.linkedin.com/feed/update/urn:li:activity:7282368205782675456
Steve
Ciarán"Some years ago, I was involved in a somewhat heated online disagreement with an eminent professor of spreadsheet risk. I inadvertently provoked my adversary to describe me as an idiot and to compare me to a member of the Italian inquisition. The idiot accusation was probably fair enough, but I didn’t expect the Italian inquisition…"
Can spreadsheets show us how to deal with online misinformation?
We seem to have learned to live with spreadsheets, despite them giving us the wrong answer 90% of the time. Are there any lessons to be learnt from our ability to adapt to fallible spreadsheets that can help us deal with online misinformation?
Twenty Principles for Good #Spreadsheet Practice
Aug 7, 2024 10:00 AM BST
Join us to hear from #financial #modeller Angela Collins to discuss the latest release of #ICAEW’s well-known list of key considerations that could save you hours of effort or help prevent a career-ending spreadsheet catastrophe!
#Excel #Risk @EuSpRIG
Register below to join live and receive a copy of the recording after the event.
https://us02web.zoom.us/webinar/register/2717190393928/WN_Lwyzpi0HS0CG4hblYtTfdw?utm_source=Financial+Modelling+Updates&utm_campaign=4d14546009-SYD_Jan15_COPY_01&utm_medium=email&utm_term=0_54de6d7849-4d14546009-416814545&mc_cid=4d14546009&mc_eid=49ee820284#/registration
Other events: https://www.plumsolutions.com.au/meetup
Welcome! You are invited to join a webinar: Twenty Principles for Good Spreadsheet Practice . After registering, you will receive a confirmation email about joining the webinar.
Excel spreadsheets remain the dominant tool of choice for sharing and presenting financial information. However, when used incorrectly, they are fraught with challenges. Lack of consistency, incorrect formulas and well-publicised spreadsheet errors all conspire to give them a poor reputation for quality. Join us to hear from financial modeller Angela Collins to discuss the latest release of ICAEW’s (Institute of Chartered Accountants in England and Wales) well-known list of key considerations that could save you hours of effort or help prevent a career-ending spreadsheet catastrophe! Angela was one of the speakers at their recent re-launch and she’ll discuss why financial modellers should adhere to these important principles, and how to do so in practice. Register below to join live and receive a copy of the recording after the event. Check out other meetup events coming up soon: www.plumsolutions.com.au/meetup
#ICAEW: How to interrogate #spreadsheets
Up to 1 hour verifiable CPD
04 July 2024 10:00 - 11:00 BST
Zoom webinar
Ensuring that #auditors can confidently rely upon the data they have been given by management is crucial. Join ICAEW experts John Tennent and Jason Partington, as they explore:
Approaches auditors can take to interrogate spreadsheets.
The tools they can use.
Practical examples and commonly found errors.
Includes an opportunity to ask questions.
https://events.icaew.com/pd/29326
Up to 1 hour verifiable CPD
04 July 2024 10:00 - 11:00 BST
Zoom webinar
Ensuring that #auditors can confidently rely upon the data they have been given by management is crucial. Join ICAEW experts John Tennent and Jason Partington, as they explore:
Approaches auditors can take to interrogate spreadsheets.
The tools they can use.
Practical examples and commonly found errors.
Includes an opportunity to ask questions.
https://events.icaew.com/pd/29326
#Model #Risk #Management: Understanding the Bank of England’s Supervisory Statement
#ICAEW #Excel Community #BOE #financial #spreadsheet #audit
1 hour CPD
19 March 2024
10:00 - 11:00 GMT
Zoom webinar
Model risk is one of the most important risks in a financial institution. It impacts front office, operations, finance, internal and external audit. From 17 May, UK banks will need to comply with the Bank of England's Model Risk Management Supervisor Statement SS1/23.
Model Risk Management: Understanding the Bank of England’s Supervisory Statement
Model risk is one of the most important risks in a financial institution. It impacts front office, operations, finance, internal and external audit. This webinar provides a concise overview of the Bank of England’s requirements and how to apply them across the organisation.
Hari TulsidasThe Institute of Chartered Accountants in England and Wales (ICAEW) will train and educate its members on environmental, social, and governance (ESG) advocacy. This is part of its commitment to support the global transition to a low-carbon economy. The initiative aims to equip accountants with the skills and knowledge to advise businesses on ESG issues and reporting.
https://www.nst.com.my/business/2023/04/904269/icaew-train-educate-members-esg-advocacy
For #ICAEW members, my tips on the tricks needed to get some #Excel functions to handle arrays and ranges and return arrays, is live on the #ICAEW_Excel page. Requires member login.
https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2023/excel-tips-and-tricks-467
Excel Tips & Tricks #467 - Excel functions that are harder to get to return arrays or ranges
Such as AND, OR, and date functions like EOMONTH.
#msexcel #functions #tips #tricks #workarounds #dynamic #arrays