Course Description

Excel / Spreadsheets Intermediate

Pery Square Business College


This course will build on your Basic Spreadsheets / Excel skills and cover more complex formulas, building formulas across worksheets, linking data, charting data and also protecting your sheets and workbooks.

Recap on the Basics

  • Absolute & Relative Cell References
  • Basic Calculations
  • Inserting and Deleting Sheets
  • Inserting/Deleting Workbook Sheets
  • Page Layout View
  • Getting Help
  • Inserting Files
Naming Cell Ranges

  • Naming Individual Cells
  • Naming Range of Cells
  • Deleting and Amending Named Ranges
  • Using Named Ranges in Formulas & Functions
Linking Sheets and Files

  • Inserting/Deleting Workbook Sheets
  • Linking Sheets in the same file
  • Linking different Excel files
  • Using Edit, Links
  • View Different Files on one Screen
  • Window Split
  • Freeze Panes
Conditional Functions

  • IF Statements
  • Nested IFs
  • Sum IF
  • Average IF
  • Count IF
  • Nesting IF, WITH, AND, OR
Basic Lookup Functions

  • Vertical Lookup (Vlookup)
  • Horizontal Lookup (Hlookup)
Essential List Management

  • Sorting Data, Multi Column Sort
  • Filter, Multi Column Filter
  • Advanced Filter, Adding Subtotals
  • Group and Outline
  • Data Form

Limerick, Ireland
College Name Pery Square Business College
Course Category Computers & IT (Information Technology), Microsoft Excel
Course Type Classroom Based
Course Qualification Certificate of Attendance
Course Location Limerick, Ireland
Course Start Date 24th March 2020
Course End Date 24th March 2020
Course Fee 150.00
Course Duration One Day
Course Times 10am - 5pm
Title of Awarding Microsoft Office Intermediate Spreadsheets
Entry Requirements You must have completed the Introduction to Spreadsheets Course or have good basic working Knowledge of Spreadsheets / Excel.
Career Path For those who need excel skills for their work or want to have an edge over others. Learn about processing data, using spreadsheets or compiling data for records. Useful for jobs in Human Resources, Accounting, Finance or Research and Development. Further training will allow you to be able to run data analysis.
For information about Pery Square Business College, please visit our college page on by clicking here.

Course Provider

Pery Square Business College

4 Pery Square, Limerick City, Limerick, Republic of Ireland


Pery Square Business College
4 Pery Square, Limerick City, Limerick, Republic of Ireland