Advanced Microsoft Excel

SKU: GEN2/C/018

Course Aim

This course is designed to provide course delegates with the skills to use the advanced features within Microsoft Excel such as forms, filters, pivot tables and graphics.

Course Duration

1 day

Target Group

This course is designed to follow on from the previous Microsoft Excel Level 1 course. It aims to build on the skills and techniques covered in that course and will introduce some of the more advanced spreadsheet features available
in Excel. It is therefore aimed at those users who have attended the first course or who have been using Excel for some time and wish to use it more effectively and efficiently.

Qualification Gained

On successful completion delegates will receive a Gen2 Microsoft Excel - Intermediate / Advanced Certificate.

By the end of the course the participants will be
able to:

• Utilise the Database features including forms and filters
• Analyse and summarise data using Subtotals, Pivot tables and “What if “ data tables
• Utilise advanced spreadsheet features such as Forecasting, Scenarios, Solver and Goal seeker
• Protect worksheets and link and protect workbooks
• Use graphics and interrogate with other applications

This course can be delivered from any of the following Gen2 Training Centres:

  • Gen2 Lillyhall Centre
  • Gen2 Energus Centre
  • Gen2 Carlisle Centre
  • Gen2 Furness Centre

website ofsted footerwebsite footerISOCyber Essentials