Excel Series Module 5: More advanced formulas and functions and protecting your spreadsheets

Excel Series Module 5: More advanced formulas and functions and protecting your spreadsheets

CPD hours: 2.00

.

You will start to look at some more advanced and complex Excel functions and formulas, including working with dates and financial functions. You will also learn how to make sure that your formulas are as efficient, robust and simple as possible. Having created the perfect formula, you will see how to prevent someone else changing it by using cell locking and worksheet protection.

This step of the Excel six pack covers key topics in the Creator level of the ICAEW Spreadsheet Competency Framework.

By completing this course, you can earn up to 2 CPD credits.

Learning outcomes

  • How to use some specific Excel functions of particular use to those working with financial data
  • How to work with dates and date-related functions and formulas
  • How to keep formulas consistent and track down inconsistent formulas
  • How to design a spreadsheet to facilitate locking and protection
  • How to lock cells
  • How to protect the contents of a worksheet
  • How to protect the structure of a workbook
  •  

    NOTE:

    ICAEW members and ICAEW Excel Community members benefit from a 30% discount. ACA Students benefit from a 10% discount.

    The discount will be automatically applied upon logging into your account. Login in the top right corner to update the price before adding to your basket.

    Cost: £30.00
    Quantity: