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.

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

    Related Courses

    Excel Series Module 1: Speeding up the basics
    Excel Series Module 1: Speeding up the basics    		Excel Series Module 2: Good formula foundations
    Excel Series Module 2: Good formula foundations    		Excel Series Module 3: Efficient formatting and introduction to other charts and graphics
    Excel Series Module 3: Efficient formatting and introduction to other charts and graphics    		Excel Series Module 4: Features that go beyond the general user level
    Excel Series Module 4: Features that go beyond the general user level    		Excel Series Module 6: Using data and knowing if and when to use macros
    Excel Series Module 6: Using data and knowing if and when to use macros