All Courses
Conducting Effective Appraisals
- Online
- Start today
Explore skills to run and enhance the appraisal processes.
Corporation Tax Losses
- Online
- Start today
Learn about corporation tax losses and how companies can use them strategically.
Cyber Security: Managing Digital Risk for Accountants and Business Leaders
- NEW!
- Start today
This course provides a practical guide to modern cyber threats and how accountants and business leaders should manage cyber risk, controls and governance.
Deciphering Company Analysis
- Online
- Start today
Gain the expertise to evaluate a company’s financial health and market position.
Excel Series Module 1 - 6: Total Skills Pack
Purchasing this set will grant you access to all six courses within the series.
Excel Series Module 1: Speeding up the basics
- Discover the full series
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.
Excel Series Module 2: Good formula foundations
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.
Excel Series Module 3: Efficient formatting and introduction to other charts and graphics
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.
Excel Series Module 4: Features that go beyond the general user level
This step of the Excel series starts to move beyond the General User level of the ICAEW Spreadsheet Competency Framework towards the Creator level.
Excel Series Module 5: More advanced formulas and functions and protecting your spreadsheets
This step of the Excel six pack covers key topics in the Creator level of the ICAEW Spreadsheet Competency Framework.
Excel Series Module 6: Using data and knowing if and when to use macros
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.