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

.

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.

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
  • Cost: £30.00
    Quantity: