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 Dec

Intermediate Excel Spreadsheets 1 Day Course
Times: 10am to 5pm
Tuesday 10th December 2019
Small group size & limited places
Course Date 10-12-2019 10:00 am
Individual Price €150.00
€150.00 7

Intermediate Excel 1 Day Jan 2020

Intermediate Excel Spreadsheet 1 Day Course
Times: 10am to 5pm
Tuesday 21st January 2020
Small group size & limited places
Course Date 21-01-2020 10:00 am
Individual Price €150.00
€150.00 8
Pery Square Business College & Staff Agency.
4 Pery Square, Limerick, Ireland.
Telephone: +353 (0)61 310155
Email:
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)