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

Array

Array
Limerick City

Limerick, UK

View Phone Number

Book Course

Enquire for Info

View College Details Reviews

Add to Favourite

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	7th June 2021
Course End Date	14th June 2021
Course Fee	€180
Course Duration	1 day - 10am to 5pm 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 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.