This course concentrates on simple ways to speed up your use of Excel including covering some important Excel settings and options and a range of keyboard shortcuts. We will also introduce some slightly more advanced features that will help you move on to the next level of the ICAEW Spreadsheet Competency Framework.
Learning some simple formula techniques can make it quicker to enter and copy formulas and can also ensure that you use the minimum possible number of different formulas promoting accuracy and making it easier to check and review a spreadsheet.
We look at formatting and see how formatting can make your spreadsheets clearer and more impactful. We examine the use of Excel styles to make formatting more efficient and more consistent, and we also introduce conditional formatting and the use of charts to present data.
To finish the entire set of course steps, you will learn some important techniques for dealing with common spreadsheet problems as well as helping to avoid them in the first place.
Get started with confidence. Lay the groundwork for confident AI adoption in your finance role. This course explains how large language models work, where they fit into the finance workflow, and why they’re different from traditional automation.
Covering sectors like financial services, retail, construction, healthcare, and more, you’ll learn how AI supports sector-specific finance tasks including credit scoring, VAT compliance, asset depreciation, and capital planning.
Strengthen oversight and accountability with the power of AI. This course is designed for CFOs, audit committee members, and finance leaders who want to embed GenAI into governance and assurance frameworks.
Simplify the complexity of compliance. This course shows how AI tools can review disclosures, detect errors, and flag missing or misclassified items across IFRS standards, tax filings, and ESG reports.