Excel – Level 3 Advanced

Start date: 13 May 2020

Duration: 1 Day (9:15am - 4:30pm)

Location: Dundalk

Certificate: N/A

Cost: €99 (€139 for Non Chamber & Non Network Members)

Course code: N/A

Programme overview

Microsoft Excel allows you to manipulate, manage and analyze data assisting in decision making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal database and expenses, Microsoft Excel gives you the right tools to enable you to accomplish all your needs.

This workshop will introduce the knowledge and skills to use Excel at an advanced level, it will introduce the more advanced features of Excel and build on existing skill levels.

Learning Outcomes

Upon satisfactory completion of this workshop:

Participants will be introduced to the more advanced Excel functions and given an opportunity to practise their new skills using example files provided on the day.

Areas covered include:

  • Create a PivotTable
  • Create a PivotChart
  • Create a Macro
  • Use Goal Seek
  • Use Scenarios
  • Use Solver
  • Audit Worksheets
  • Protect Worksheets and Workbooks
  • Use Consolidation
  • Apply Conditional Formatting
  • Apply Data Validation
  • Import and Export information

Who Is This Course For?

Intended for people who already have a good knowledge of Excel at an intermediate or advanced level and want to develop their skills further.

Modules

  • Create a PivotTable
  • Create a PivotChart
  • Create a Macro
  • Use Goal Seek
  • Use Scenarios
  • Use Solver
  • Audit Worksheets
  • Protect Worksheets and Workbooks
  • Use Consolidation
  • Apply Conditional Formatting
  • Apply Data Validation
  • Import and Export information

Book Now To Guarantee a Place

Book Place(s)

Applications Closing on 18/09/2019

Enquire Now