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.