Course Description

Excel / Spreadsheets Introduction

Pery Square Business College



This course is designed for new users of Spreadsheets/Exel and those who have been Self Taught.  We cover all areas of creating a spreadsheet including entering Excel formulas.  Can be used in preparation for MOS Excel Core Exam or ECDL Exel Test.

Excel Basics

  • Introducing the Ribbons
  • Workbooks, Worksheets, Rows, Columns, Cells
  • Selection Techniques & Mouse Shapes
  • Saving, File Types, Compatability
  • The File Tab
  • Page Layout View
  • Getting Help
  • Inserting Files
Entering, Selecting & Editing Data

  • Entering, Editing, Deleting Data in Cells
  • Using the Fill Handle
  • Inserting/Deleting Rows, Columns & Cells
  • Insert/Deleting/Moving/Renaming/Copying Sheets
  • Creating Custom Lists
Creating Formulas and Functions

  • Creating/Editing/Copying Formulas
  • Using AutoSum
  • Common Basic Functions
  • Using the Formula Tab
  • Relative and Absolute Cell References
Formatting Cells, Rows, Columns & Sheets

  • Formatting Cells Options
  • Applying Borders and Shading
  • Changing Column Widths
  • Changing Row Heights
  • Clearing Formats
  • Using Format Painter
Charts, Graphs and Data Sort

  • Create Simple Charts
  • Editing Charts
  • Formatting Charts
  • Sorting Data
  • Auto Filter
Printing

  • Print Preview & Page Orientation
  • Adding Headers and Footers
  • Printing a Selection & Setting a Print Area
  • Adjusting Page Breaks using Page Break Preview
  • Changing Margins
  • Centre on Page

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 11th February 2020
Course End Date 11th February 2020
Course Fee €150
Course Duration 1 Day
Course Times 10 am to 5 pm
Title of Awarding Microsoft Office Introduction to Spreadsheets
Entry Requirements You must have good basic knowledge of a computer and good working Knowledge of Word Processing.
Career Path For those who need excel skills for their work or want to have an edge over others. Learn about creating & editing spreadsheets & entering data for records. Useful for jobs in Human Resources, Accounting, Finance or Research and Development.
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