Intermediate Excel

75.00

To allow candidates to build on their existing skills and introduce the learner to more complex functions in Excel.

SKU: G1320519 Category: Tags: , ,

Description

To allow candidates to build on their existing skills and introduce the learner to more complex functions in Excel.

Learning Outcomes

  • Revision of Quick Access Toolbar
  • Revision of use of absolute and fixed cells references
  • Be able to insert and delete rows and colums
  • Be able to centre across columns
  • Be able to use the protection facility on a sheet and workbook
  • Insert, rename, move, copy sheets within and between spreadsheets
  • Set up a list, do a simple and more complex sorting
  • Applying and using filters
  • Copy and paste filtered records
  • Use basic If function
  • Introduction to Conditional Formatting
  • Set the Print Area and use all options from the Print menu
  • Introduction to VLookup function
  • Time Permitting: Introduction to Countif/Sumif

Who Should Attend This Course

Participants who have completed the Beginners training course or have gained sufficient experience to be familiar with the the topics that are covered in the Beginners training.

Event Details

Day 1: May 30, 2019

Start time: 09:30 a.m.

End time: 16:30 p.m.

Venue: ICE Group, Centrepoint Business Centre, Liosban, Tuam Road, Galway, H91 RYD2