Course Description

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

College Name Pery Square Business College
Course Category Computers & IT (Information Technology), Microsoft Excel
Course Type One-To-One Coaching
Course Qualification Certificate of Attendance
Course Location Limerick, UK
Course Start Date 14th June 2021
Course End Date 22nd June 2021
Course Fee 180.00
Course Duration One Day or 1 hourly sessions
Course Times This course is currently run online through Zoom with Tutor 1 Day Course from 10am to 5pm (or 2 half days or 1 hourly sessions) Individual and Small group size only
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 www.nightcourses.co.uk by clicking here.

Course Provider

Pery Square Business College



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

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to Pery Square Business College.
Captcha code        I confirm I have read the Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map

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