Intermediate Excel Spreadsheets Course ( 2 Courses ) See Dates/Register  

  • Intermediate Spreadsheets

    Intermediate Spreadsheets (Microsoft Excel)

    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
  • 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 may allow you to be able to run data analysis.

  • You must have completed the Introduction to Spreadsheets Course or have good basic working Knowledge of Spreadsheets / Excel. 

Intermediate Excel 1 Day Course

This course is currently run online through Zoom with Tutor
1 Day Course from 10am to 5pm (or 2 half days)
Individual and Small group size only
Course Date To be confirmed
Individual Price €150.00
€150.00 6

Intermediate Excel Half Day Course

This course is run via remote training through Zoom
Half Day Course in Excel 
Individual Training - one to one with tutor
Course Date To be confirmed
Individual Price €120.00
€120.00 7
Pery Square Business College & Staff Agency.
4 Pery Square, Limerick, Ireland.
Telephone: +353 (0)61 310155
Call or Email to discuss the right course for you.
European Computer Driving Licence, ECDL
Irish Computer Society
Microsoft Office Specialist Certification
Quality and Qualifications Ireland (QQI)