Join itag

Loading Events

« All Events

  • This event has passed.

Excel Advanced

December 11, 2018 @ 9:30 am - 4:30 pm



If you are attending the Advanced Excel course, the following knowledge is assumed (i.e. it WILL NOT be covered on the course)

  • Using basic formulas: plus, minus, add, subtract, using brackets
  • How to fix a cell, a row, a column, (using F4…i.e. $a$1, A$1, $A1)
  • How to use Autosum, Max, Min, Average, Count, CountA
  • How to create a basic vlookup
  • How to create a basic if function
  • Sorting and filtering a list in Excel


  • Data Consolidation
  • Data Entry Validation
  • Goal Seek and Solver
  • Using the Scenario Manager
  • Left, Right, Mid Text Function
  • Using Database Functions (DSUM, DAVERAGE)                         
  • If, And, Or, IfError
  • Vlookup and Hlookup
  • Adding a Calculated field to a pivot table
  • Creating a Pivot Chart
  • Index
  • Forecast
  • The Frequency Function
  • Watch and Evaluate Formula
  • Formula Auditing
  • Creating Macros
  • Editing Macros
  • Assigning a Macro to the Quick Access Toolbar

To book your place email


December 11, 2018
9:30 am - 4:30 pm


PFH Galway
Kingsvalley, Merlin Park
Galway, Ireland
+ Google Map