Search
Excel Series Module 1: Speeding up the basics
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 series starts to move beyond the General User level of the ICAEW Spreadsheet Competency Framework towards the Creator level.
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.
Excel Series – Corporate
Purchasing this set will grant you access to all six courses within the series.