Course Description

Course Title : Excel / Spreadsheets Intermediate

Pery Square Business College



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

Limerick City, Limerick, Ireland
College Name Pery Square Business College
Course Category Computers & IT (Information Technology), Microsoft Excel
Course Type Classroom Based
Course Location Limerick City, Limerick, Ireland
Course Start Date 27th August 2018
Course End Date 27th August 2018
Course Fee 150.00
Course Duration One Day
Course Times 10am - 5pm
Entry Requirements You must have completed the Introduction to Spreadsheets Course or have good basic working Knowledge of Spreadsheets / Excel.
For information about Pery Square Business College, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

Pery Square Business College



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

Map