Participants will recap the intermediate and learn the advanced functions of Microsoft Excel and know their use in practice.

After completing the course, participants will know how to:

• perform intermediate operations on copying and pasting data
• protect cells, sheets and workbooks
• use data filter and subtotals
• use advanced filter
• perform operations on dates and hours
• use text conversion functions
• use logical functions with multiplied conditions
• use nested functions
• insert data from other applications
• analyse data using goal seek and solver add-in
• analyse data using pivot tables and charts
• consolidate data from different source files
• record macro and review the VBA code