Back to All Events

Advanced Microsoft Excel

  • 5 CPD Hours Apex Building, Blackthorn Road Sandyford Business District Dublin 18 (map)

Microsoft Excel is the most commonly used spreadsheet application, and learning how to use Excel is an investment in both your personal and professional life. If utilised correctly, the benefits of Microsoft Excel cannot be overstated. Due to the program’s capability of formatting data, performing calculations, analyzing data and integrating information, a working knowledge of Excel is vital for most office based professionals today. This course will show you how to take your existing knowledge to the next level, to help you fully utilise this highly useful application.

It is ESSENTIAL to bring along your own laptop with the required software installed (Microsoft Excel 2013).

Course Content Includes:

Using Lookup Functions

  • Use VLOOKUP
  • Use HLOOKUP
  • Use PMT
  • Use Data Validation
  • Use Named Ranges

Working with Advanced Functions

  • The SUMPRODUCT function
  • Use INDEX and MATCH
  • Deal with Errors

Working with Macros

  • About Macros
  • Recording Macros
  • Running Macros
  • Editing Macros in the VBE
  • Assigning Macros to Buttons

Auditing Worksheets

  • Find Referenced Cells
  • Trace Cells
  • Troubleshoot Errors in Formulas
  • Troubleshoot Invalid Data and Formulas
  • Watch and Evaluate Formulas
  • Find Formulas that Refer to a Cell

Working with PivotTables

  • Create PivotTables, Editing PivotTables
  • Update Information in a PivotTable
  • Add Fields to a PivotTable
  • Remove Fields from a PivotTable
  • Change the Layout of a PivotTable
  • Modify PivotTables
  • Group PivotTable Data
  • Understand Calculated Fields
  • Display Page Fields on Separate Sheets
  • Create PivotCharts
  • Create Slicers

Organizing Worksheet and Table Data

  • Create and modify Tables
  • Format Tables
  • Sort and Filter Table data
  • Calculate data in a Table

Who Should Attend?

This course would be ideal for those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use Excel at a more advanced level.

Certification

On completion, you will receive your CMG MasterClass Certificate as well as your CPD Certificate containing 5 Structured CPD HoursPlease note certificates are issued only at the end of the training course to participants who complete the full five hours.

Cost

This course costs €375 (early-bird) per person – normal rate €425. and includes course documentation and light refreshments. While the course fee does not include lunch, we do provide freshly made sandwiches,  coffee and a range of teas and fresh juice for those who require a light lunch. Alternatively you can avail of the local food stores and coffee shops opposite the training centre for hot food or alternative lunch options.

Later Event: November 14
People Management Skills